- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 73 Insurance
- 537.3K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Heirarchy not working for one Dimension
I use Cloud PBCS.
I have set up my application to have cube MAIN (type BSO) where I load Trial Balance data, and cube VEHICLES (type BSO) where I load more detailed data including units sold and GP for each Salesperson.
So I have created a Dimension [Salesperson] that is only enabled for the VEHICLES cube and contains member "TOT_SP" as the parent of every salesperson. I load data for every salesperson, and "TOT_SP" is a dynamic calc to give the total of all Salespersons (see below screenshots for first salesperson only).
I have tested this in Smart View, and while the data for each Salesperson appears correctly, "TOT_SP" is showing as #MISSING.
What am I doing wrong? I have 2 other dimensions that have very similar format to [Salesperson] that work correctly.