TM1 Forum

Hi guys

I am trying to create an Active Form, by browsing the cube and then selecting the 'Active Form' option from the menu. Once I click Active Form option, the view that is imported into Excel sheet is different from the view in TM1, lik, if i had 5 dimensions in the cube, and two were title, 2 were in row and one in the column, it would put 3 dims in title and one each on row and column. How can I produce the exact same view in Excel like I have in TM1?

Thanks

kaazimraza wrote:Hi guys

I am trying to create an Active Form, by browsing the cube and then selecting the 'Active Form' option from the menu. Once I click Active Form option, the view that is imported into Excel sheet is different from the view in TM1, lik, if i had 5 dimensions in the cube, and two were title, 2 were in row and one in the column, it would put 3 dims in title and one each on row and column. How can I produce the exact same view in Excel like I have in TM1?

Thanks

Are you sure? Absolutely, positively sure? Because that would be pretty unusual.

Yes, absolutely sure. One of my colleague suggested that we cannot have more than one dimension on rows. I do remember in 9.5.1 or 9.5.2 we did come across such an issue but cannot recall how did we get round it.

If I do a 'Slice' it would give me the dimensions in correct arrangement but the slicing process is too, too damn slow.

Any suggestions?

Slicing an active form behaves the same as slicing a slice. You can have nested row dimensions. Are you sure you are not accidentally changing the selected view?

If I do a 'Slice' it would give me the dimensions in correct arrangement but the slicing process is too, too damn slow.

Slicing an active form won't be faster than a classic slice, in fact it will be slower. If it is slow what in fact are you trying to slice (how many rows?)

I thought the same that may be I am selecting different view, or its going object oriented way and inheriting one of the views that had similar dimension arrangements, so I actually deleted all the views, and now there's this one View in the cube.

Well, performance is a potential issue, be it a classical slice or a regular active form or simply taking a snapshot, but that's step 2. I am stuck at step 1 itself where I ain't getting the required output in Excel.