Page 1 of 1

TM1 Applications Custom Views

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

Re: TM1 Applications Custom Views

Posted: Tue Jun 12, 2018 2:14 pm
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.

Re: TM1 Applications Custom Views

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

Re: TM1 Applications Custom Views

Posted: Wed Jun 13, 2018 11:02 am
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)}

Re: TM1 Applications Custom Views

Posted: Wed Jun 13, 2018 12:00 pm
by Salma
Hello. That's exactly what i needed. THANKS A LOT