TM1 Forum

hi all.

i am the new face on the Cognos TM1. there are some questions in my work.

Q1: How can i control the "VUSLICE" Return Values start point in the Excel, it allways start from "A1" Cell.
Q2: How can i get the caculate value from the excel without use a VBA macro.

thanks.

Hello,

Q1: You can not change the start point. However, you can create a new workbook/sheet, call the function, use the ActiveSheet.UsedRange function to get whatever was produced and copy it somewhere else you like.

Q2: I don't get this. You'll need to explain a bite further - at least for me. (Like where do you want to have what data)

hi Lukas Meyer, thanks

about Q2:
At a Excel file i can carete a Command Button(ActionX Control Button) and coding in the button action use the "VUSLICE" macro get the caculate result . with out this way , hao can i get the caculate result from a Excel.

thanks.

Have you read the user guide manual? Any of it? I suggest you do.

You can slice a view out of the cube viewer, or even more simply you can have a report using a previously sliced out view with DBRW formulas (with whatever formatting you desire) as an Excel report and simply hit the Shift + F9 keys. Yes it is as simple as that, no really it is