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!!
Active Form Drill Down
-
- MVP
- Posts: 3667
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Active Form Drill Down
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 ...
Basically you need to live with this limitation. Probably many people would support a request for enhancement to provide this feature though ...
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
- Michel Zijlema
- Site Admin
- Posts: 712
- Joined: Wed May 14, 2008 5:22 am
- OLAP Product: TM1, PALO
- Version: both 2.5 and higher
- Excel Version: 2003-2007-2010
- Location: Netherlands
- Contact:
Re: Active Form Drill Down
I don't know whether you consider Cognos Insight native, but that front end does support asymmetric slices/views.lotsaram wrote:Unfortunately all native TM1 interfaces such as the cube viewer and active forms do not support asymmetric slices/views.
Michel
-
- MVP
- Posts: 3667
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Active Form Drill Down
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.Michel Zijlema wrote:I don't know whether you consider Cognos Insight native, but that front end does support asymmetric slices/views.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
- Michel Zijlema
- Site Admin
- Posts: 712
- Joined: Wed May 14, 2008 5:22 am
- OLAP Product: TM1, PALO
- Version: both 2.5 and higher
- Excel Version: 2003-2007-2010
- Location: Netherlands
- Contact:
Re: Active Form Drill Down
Seconded.lotsaram wrote:It would definitely be a useful feature to have in the cube viewer and active forms.
Michel
-
- Posts: 13
- Joined: Thu Jan 08, 2015 6:15 am
- OLAP Product: TM1
- Version: 9.5.2 10.2.2 64 Bit
- Excel Version: 2010
Re: Active Form Drill Down
Thanks a lot Lotsaram and Michel for the responses. This really helps guys!!!