TM1 Forum

Hello TM1-experts,

I'm not exactly sure how to explain the problem I'm facing, but I'll give it a try. I'm quite new to TM1 and I have taken over a project. TM1 9.5.1 & Excel 2010

In an excel file I have a cell filled with a TM1RPTVIEW function. Under this cell I have a table, and the dimension cells of this this table are filled with TM1RPTROW functions that point to the view I have created using the TM1RPTVIEW function. The result of these TM1RPTROW functions is currently as following:

elementDim1_A elementDim2_Total element_Dim3_A
elementDim1_A elementDim2_A element_Dim3_A
elementDim1_A elementDim2_B element_Dim3_A
elementDim1_A elementDim2_C element_Dim3_A
elementDim1_B elementDim2_Total element_Dim3_A
elementDim1_B elementDim2_Total element_Dim3_B
elementDim1_B elementDim2_A element_Dim3_A
elementDim1_B elementDim2_B element_Dim3_A
elementDim1_B elementDim2_A element_Dim3_B

In the first abd third column I'm referring to a dimension subset in which I have no consolidated element. In the second column I do have a consolidated element, but I also show the lower levels. But it gives the result as shown below and I'm expecting another result. I'm expecting the following result:

elementDim1_A elementDim2_Total element_Dim3_A
elementDim1_A elementDim2_A element_Dim3_A
elementDim1_A elementDim2_B element_Dim3_A
elementDim1_A elementDim2_C element_Dim3_A
elementDim1_B elementDim2_Total element_Dim3_A
elementDim1_B elementDim2_A element_Dim3_A
elementDim1_B elementDim2_B element_Dim3_A
elementDim1_B elementDim2_Total element_Dim3_B
elementDim1_B elementDim2_A element_Dim3_B

I hope somebody knows what I mean because I'm not explaining it very good. But I hope the example makes it more clear.

Thank you in advance.

Your "examples" are some of the worst examples I've ever seen. Why is it that people seem inclined to turn real life scenarios into Dim1Element2, Dim2Element4......? No one can follow that, it's all too much alike. Why not just give us the real thing to look at? Nevertheless, it appears you are having a problem with the order of the elements in an active form (deduced from the title of your post, not the examples). The ordering of the elements in the columns of an active form report are controlled by the subset(s) referenced in the TM1RPTROW formulas. If no subsets were referenced then the elements will be on a hidden tab in your workbook. So, either change the subset ordering, or change the elements in the hidden tab(s).