place multiple active forms horizontally

[iesak]

In the 9.4 MR1 reference guide said
"If a worksheet already contains one or more Active Forms, you can insert a new Active Form above or below existing forms. Each form uses its own title, row, and column dimensions"

is there any workaround to insert a new active form next to existing forms ?

[lotsaram]

No.

The reference guide and help are pretty clear on this. As each active form "owns the rows" on which it is positioned it is not possible to have active forms side by side. It is also a good idea not to place any objects next to an active form (such as charts, graphics, etc) rather they are best positioned either above or below the active form.

[kennyyeung]

How about slice ?Can it work to place two cube data horizontally?
If not ? Is there any method to place two cube data into a template horizontally as follow?

[Martin Ryan]

Yes, with a non-dynamic slice, this is no problem, you can set up two slices next to each other. Because the DBRW formula are just plain Excel formulae, they can reference cells anywhere.

You can try it by slicing to two different worksheets, then cut and paste (not copy and paste) one of them onto the other sheet.

Martin

[pratik.gangadia]

Is there any documentation or material available, which can provide the information on how to place data from two cubes in a single active form horizontally. Either by calling two cubes directly or by slicing or any other better way ?

Your assistance will be greatly appreciated.

[lotsaram]

I don't think you will find any "official documentation" on this as the user guide just covers slicing an active form out of the cube viewer and changing formats. But it is pretty simple to do - the data from the 2nd cube just needs its own server:cube reference cell (preferably with VIEW formula) and the DBRW formulas need to point to that reference and not the TM1RptView cell, and of course both slides need to have common rowsets. Not to oversimplify but that's it really.

[pratik.gangadia]

@ lotsaram : Thanks for your reply. I did it based on your advice.

Is there any limitation on slicing the numbers of dimensions as I was getting "Key_Error" when I was calling 5 dimensions, but when I have called just two dimension, it was working fine.

[Wim Gielis]

There is no real limitation, it should just work.
I bet you have a typo or any other error, such that the element cannot be found in the respective dimension.
Slice a cube view to an empty sheet and compare the DBRW's with their arguments.