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 » Tue Jun 12, 2018 11:25 am

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
Community Contributor
Posts: 206
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 FP7, PA2.0
Excel Version: 2013
Location: Cleveland, Tennessee

Re: TM1 Applications Custom Views

Post by PavoGa » Tue Jun 12, 2018 2:14 pm

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 » Wed Jun 13, 2018 10:43 am

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: 1587
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 » Wed Jun 13, 2018 11:02 am

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)}

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 » Wed Jun 13, 2018 12:00 pm

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

Post Reply