Active Form Drill down help
-
- Posts: 124
- Joined: Tue Jun 13, 2017 3:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Active Form Drill down help
Hi All,
I have a question about drill down of an active form.
I want to restrict users drill down to a specific level - say descendants below level 4 of hierarchy. Is there a function that I can use?
Any ideas on how to restrict users not to drill down below a certain level or descendants below level 4.
The dimension is available to users
1. In perspectives for drill down to the lowest level
2. in contributor is used for approval hierarchy.
I found function 'TM1RptRow', but does not look useful.
We use 10.2.2 FP7 version.
Any idea is greatly appreciated.
Thanks,
Paul.
I have a question about drill down of an active form.
I want to restrict users drill down to a specific level - say descendants below level 4 of hierarchy. Is there a function that I can use?
Any ideas on how to restrict users not to drill down below a certain level or descendants below level 4.
The dimension is available to users
1. In perspectives for drill down to the lowest level
2. in contributor is used for approval hierarchy.
I found function 'TM1RptRow', but does not look useful.
We use 10.2.2 FP7 version.
Any idea is greatly appreciated.
Thanks,
Paul.
-
- Community Contributor
- Posts: 248
- Joined: Tue Nov 01, 2011 10:31 am
- OLAP Product: TM1
- Version: All
- Excel Version: All
- Location: Manchester
- Contact:
Re: Active Form Drill down help
AFAIK it is only possible to restrict dimension security between TM1 front ends via contributor applications
I would question why? (Performance? Usability? Asthetic?) But it could be achieved by generating a replica dimension to the required level. This obviously brings a level of additional maintenance which may not outweigh the benefits you are looking for.
I would question why? (Performance? Usability? Asthetic?) But it could be achieved by generating a replica dimension to the required level. This obviously brings a level of additional maintenance which may not outweigh the benefits you are looking for.
-
- MVP
- Posts: 2831
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Active Form Drill down help
You can do it through element level security. Create an }ElementSecurity_YourDimName cube for the dimension you are talking about and write a rule that only gives READ/WRITE to the elements you want via a rule and ELLEV. In order to work properly you MAY need a balanced hierarchy though. With a ragged hierarchy the same thing may be on different levels. For example, if you roll cost centers to managers, then regions, then countries, etc., and for a specific country you slip in another level, like sub-region, or something like that then your higher levels are no longer the same level number in TM1. Think about it.
-
- Community Contributor
- Posts: 248
- Joined: Tue Nov 01, 2011 10:31 am
- OLAP Product: TM1
- Version: All
- Excel Version: All
- Location: Manchester
- Contact:
Re: Active Form Drill down help
My interpretation was that users have access to all levels of dimension through perspectives but the requirement was to restrict access in active forms.
If it is across the model then element security as per Tomok's suggestion would work.
However I'm still not convinced this isn't a question relating to drill through rules or navigating the hierarchy?
If it is across the model then element security as per Tomok's suggestion would work.
However I'm still not convinced this isn't a question relating to drill through rules or navigating the hierarchy?
-
- Posts: 124
- Joined: Tue Jun 13, 2017 3:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Re: Active Form Drill down help
Thanks all for the advises.
Sorry, it's not drill down, but restrict navigating down hierarchy to lower levels in active forms. The dimension is ragged and is used across as the model as approval hierarchy.
We are collecting attributes at a particular level and we are interested restricting users go to a lower level and input.
Please let me know if there are any alternate methods.
Thanks,
Paul.
Sorry, it's not drill down, but restrict navigating down hierarchy to lower levels in active forms. The dimension is ragged and is used across as the model as approval hierarchy.
We are collecting attributes at a particular level and we are interested restricting users go to a lower level and input.
Please let me know if there are any alternate methods.
Thanks,
Paul.
- Steve Rowe
- Site Admin
- Posts: 2415
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: Active Form Drill down help
A solution
If you gave every element you want visible in the active form an available flag and then put MDX referencing this in the report row formula and disabled drill down in the report row formula then you would get close to this. Report would need to have all rows expanded to the level of interest all the time though.
If you gave every element you want visible in the active form an available flag and then put MDX referencing this in the report row formula and disabled drill down in the report row formula then you would get close to this. Report would need to have all rows expanded to the level of interest all the time though.
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
- Posts: 3
- Joined: Tue Jun 23, 2015 7:18 am
- OLAP Product: tm1
- Version: 10.2.2
- Excel Version: 2013
Re: Active Form Drill down help
Hi Paul,
create an additional dimension and insert all elements the user should be able to see.
After this open your active form and change the dimension in the rtprow-function to the new one. This should work:)
Best Regards
TheBestschen
create an additional dimension and insert all elements the user should be able to see.
After this open your active form and change the dimension in the rtprow-function to the new one. This should work:)
Best Regards
TheBestschen
-
- MVP
- Posts: 2831
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Active Form Drill down help
Have you actually tried this? I'm not saying it won't work, I'm just skeptical that you can reference a dimension that is not in the cube in a TM1RPTRPW formula. That would be a great solution if it does work.thebestschen wrote: ↑Wed Oct 04, 2017 6:26 pm create an additional dimension and insert all elements the user should be able to see.
-
- Community Contributor
- Posts: 292
- Joined: Tue Sep 06, 2016 7:55 am
- OLAP Product: TM1
- Version: 10.1.1
- Excel Version: Excel 2010
Re: Active Form Drill down help
So intrigued by this was IHave you actually tried this? I'm not saying it won't work
That I decided to test and to my
Disappointment it didn't work
And the server went down
But maybe it was me!
I am sure that thebestschen will have tested this before offering the advice? On that score do we have guidelines for those giving the advice?
-
- Posts: 3
- Joined: Tue Jun 23, 2015 7:18 am
- OLAP Product: tm1
- Version: 10.2.2
- Excel Version: 2013
Re: Active Form Drill down help
Oh sorry
I mixed something up. Sorry for that.
But I have a second idea: You can create a new Cube with the new high level dimension. Create an active form and join the values from your original cube with an additional view. Maybe you can try this.
I mixed something up. Sorry for that.
But I have a second idea: You can create a new Cube with the new high level dimension. Create an active form and join the values from your original cube with an additional view. Maybe you can try this.