Active Form- View problem

[kaazimraza]

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

[lotsaram]

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.

[kaazimraza]

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?

[lotsaram]

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?)

[kaazimraza]

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.