Sure I have a question , I use Planning Analytics 2.0 on a Windows OS.
Recently I have a problem Suppose I have dimension contains categories just (Consolidated elements), These consolidated elements will contains childs, These childs will be entered at run time through a TI process BUT they related to a another specific elements.
Suppose Dimension called Projects_Categories has the following:
+Development
+Exploration
+Design
+Digging
Suppose Dimensions called factory contains our factories names has the following:
Zalaia
Verich
Zefta
At run time I will add new projects specific to Locations under Projects_Categories. So I will insert new projects:
Zalaia --> Development --> P1
Zefta --> Development --> P2
Verich --> Design --> P3
Verich --> Exploration --> P4
Zalaia --> Exploration --> P5
When selecting Zalaia from factory filter, Cube Viewer should present the following:
-Development
P1
-Exploration
P5
+Design
+Digging
When Selecting Verich from factory filter, Cube Viewer should present the following:
+Development
-Exploration
P4
-Design
P3
+Digging
And So on...
I'm using Attribute to maintain the relationship between factory and Projects.
My Question is How can I make this view I searched and I found that we can use MDX in subset expression, I tried to do this
Code: Select all
{FILTER({TM1SubsetAll([Projects_Categories])}, [Projects_Categories].[Code] = [factory].[Code]}
1- I can't show Parents such as Development with childs such as P1 in a right way,
I see P1
-Developemt
P1
2- When I need to rolling up or drilling down subset changes automatically.
Please I want Help..
Thanks a lot,
Best Regards,
Hector.