- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 67 Insurance
- 536.8K On-Premises Infrastructure
- 138.4K Analytics Software
- 38.6K Application Development Software
- 5.9K Cloud Platform
- 109.5K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
OBIEE; Parent-child level 0 members in analysis
We are suing OBIEE 22.214.171.124 and we are sourcing data from Essbase.
I want to query all level 0 members in an analysis and bring back the parents in one column and the level 0 member in another column.
I can filter on the level 0 members using selection steps but splitting it into parent in one column and level 0 member name in another column is my challenge.
I presume I need to do this with MDX code. We prefer not include extra columns in the repository as it is only a requirement for one analysis.