TM1 Forum

HI All,
I am creating an Active Form report in TM1 Perspective version 10.2.2.
My Active Form reports looks like below.
My issue is specific to drilldown/Expand feature. When I expand All Cost Center just for 41 element, then it behaves weird. It expands All Cost Center for all the elements of Region dimension.
So It looks like below.
Ideally Cost Center hierarchy should have been expanded for Element 41. but in my case Cost Center hierarchy is expanding for all the elements of Region Dimension.
Same is the case with ALL ITEMS hierarchy. if I expand just for a specific combination then it expands for all.

For more information I am attaching the TM1RPTROW for all 3 dimensions below.
=TM1RPTROW($B$9,"SERVER:Regions","",'{AR}01'!$B$17,"Long Name",0)
=TM1RPTROW($B$9,"SERVER:Cost Centers","",'{AR}11'!$C$17,"",0)
=TM1RPTROW($B$9,"SERVER:Items","",'{AR}21'!$D$17,"",0)

Please let me know how could I stop expanding hierarchy for other than clicked consolidation.

Thanks a lot!!

This might be "weird" (to you) but it is "expected behaviour" to anyone who has worked with TM1 for a while. Unfortunately all native TM1 interfaces such as the cube viewer and active forms do not support asymmetric slices/views.

Basically you need to live with this limitation. Probably many people would support a request for enhancement to provide this feature though ...

lotsaram wrote:Unfortunately all native TM1 interfaces such as the cube viewer and active forms do not support asymmetric slices/views.

I don't know whether you consider Cognos Insight native, but that front end does support asymmetric slices/views.

Michel

Michel Zijlema wrote:I don't know whether you consider Cognos Insight native, but that front end does support asymmetric slices/views.

Once I would have considered EV a "semi-native interface" but alas no more and EV does support asymmetric drill-down. Probably "traditional TM1 interface" would be a better way to phrase it as I believe that CAFE will support asymmetric drill-down (if it doesn't do so already). It would definitely be a useful feature to have in the cube viewer and active forms.

lotsaram wrote:It would definitely be a useful feature to have in the cube viewer and active forms.

Seconded.

Michel

Thanks a lot Lotsaram and Michel for the responses. This really helps guys!!!