Hi TM1 Experts, I am building a PAW dashboard in that I am keeping the cube view for user inputs. also, I have user selections as "year", "Version", and "Department" in the top context. when a department user login to the dashboard then he can see user corresponding departmental view, which means that we have the index dimension in the cube view, the index dimensions is the following
Hierarchy: 2023-Total-MEH
2023-MEH- D1
2023-MEH-D1.1
2023-MEH-D1.2
2023-Total-TPH
2023-TPH- D1
2023-TPH-D1.1
2023-TPH-D1.2
..etc
(pls find the attachment hireracy format).
when the user login, the user should see only their corresponding department index. so I need to build the mdx subset and the mdx subset should be parameterized based on the department, year selection on the top (context). could you please do let me know if that's possible in PAW Cube or Dimension mdx subset.
PAW mdx subset
-
- Regular Participant
- Posts: 155
- Joined: Fri May 20, 2011 8:17 am
- OLAP Product: Applix,Cognos TM!
- Version: applix9.0Cognos tm1 9.5.1
- Excel Version: Excel 2010 2007
PAW mdx subset
- Attachments
-
- Picture1.png (12.51 KiB) Viewed 231 times
-
- MVP
- Posts: 3126
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: PAW mdx subset
It’s not very clear to me but hopefully I get it right.
The cube on which you have a view, doesn’t it have dimensions year / version / department ? Why would you be creating concatenations of these in another dimension ? I expect to see these 3 dimensions and the }Clients dimension and possibly a few other dimensions. Un thaï case it just boils down to usine MDX for the currently logged in client and that’s it.
The cube on which you have a view, doesn’t it have dimensions year / version / department ? Why would you be creating concatenations of these in another dimension ? I expect to see these 3 dimensions and the }Clients dimension and possibly a few other dimensions. Un thaï case it just boils down to usine MDX for the currently logged in client and that’s it.
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly