TM1 Applications Custom Views

Post Reply
Salma
Posts: 3
Joined: Tue Mar 13, 2018 4:10 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: Excel 2016

TM1 Applications Custom Views

Post by Salma »

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 !!!!!!
User avatar
PavoGa
MVP
Posts: 612
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: Cleveland, Tennessee

Re: TM1 Applications Custom Views

Post by PavoGa »

Yes there is.

1) Build static views for each user (not optimum :D )

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
Salma
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

Post by Salma »

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.
declanr
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

Post by declanr »

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:

Code: Select all

{Filter({[Product].members},[Product].[BU]= [BU].currentmember.name )}
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

{TM1SubsetToSet([Product], [BU].currentmember.name)}
Declan Rodger
Salma
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

Post by Salma »

Hello. That's exactly what i needed. THANKS A LOT
Post Reply