Hello Everyone. Is there a way to customize the subset displayed in tm1 applications view based on the node the user accesses to.
For example if i have in my approval hierarchy three nodes 'A', 'B' and 'C' i would like to display a different subset of another dimension of my cube in the view.
Anyway to do this !!!!!!
TM1 Applications Custom Views
- PavoGa
- MVP
- Posts: 617
- Joined: Thu Apr 18, 2013 6:59 pm
- OLAP Product: TM1
- Version: 10.2.2 FP7, PA2.0.9.1
- Excel Version: 2013 PAW
- Location: Charleston, Tennessee
Re: TM1 Applications Custom Views
Yes there is.
1) Build static views for each user (not optimum )
2) if you define the relationship between the approval hierarchy nodes/user/whatever and the elements in the other dimension, you can use an MDX subset to provide the desired elements. For example, a lot of our views will default the version element based on the version the user has selected to work in. Without more specifics on your particular issue, I would only be able to provide a generic MDX solution.
1) Build static views for each user (not optimum )
2) if you define the relationship between the approval hierarchy nodes/user/whatever and the elements in the other dimension, you can use an MDX subset to provide the desired elements. For example, a lot of our views will default the version element based on the version the user has selected to work in. Without more specifics on your particular issue, I would only be able to provide a generic MDX solution.
Ty
Cleveland, TN
Cleveland, TN
-
- Posts: 3
- Joined: Tue Mar 13, 2018 4:10 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: Excel 2016
Re: TM1 Applications Custom Views
Thank you for your answer.
In my case, it's the same user who accesses the nodes, and based on which node he selects on the BU dimension (Approval Hierarchy), he wants to see a different subset in the product dimension.
In my case, it's the same user who accesses the nodes, and based on which node he selects on the BU dimension (Approval Hierarchy), he wants to see a different subset in the product dimension.
-
- MVP
- Posts: 1815
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: TM1 Applications Custom Views
You can have an attribute in the product dimension that holds the name of the BU that you want to show it for and then put MDX like below in the product dimension:
In that example I have shown the Product dimension as being called "Product" the Business Unit dimension as being called "BU" and the attribute in the Product dimension also being called "BU."
It would rely on each product only being visible to 1 BU.
If you need each product to appear in multiple business units I would have subsets in the product dimension with the same name as the business unit.
Then create one additional MDX subset that utilises the name of the BU being viewed to pull the correct subset:
Code: Select all
{Filter({[Product].members},[Product].[BU]= [BU].currentmember.name )}
It would rely on each product only being visible to 1 BU.
If you need each product to appear in multiple business units I would have subsets in the product dimension with the same name as the business unit.
Then create one additional MDX subset that utilises the name of the BU being viewed to pull the correct subset:
Code: Select all
{TM1SubsetToSet([Product], [BU].currentmember.name)}
Declan Rodger
-
- Posts: 3
- Joined: Tue Mar 13, 2018 4:10 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: Excel 2016
Re: TM1 Applications Custom Views
Hello. That's exactly what i needed. THANKS A LOT