First, my simple workaround proposal:
1. Define a text attribute (e.g. Type) for the dim you want to filter on.
2. Create a rule in Control Object Cube that stores those attributes values where you calculate element type (C or N).
3. Expand your filter by level = 0 MDX with filter by attribute where 'Type' = 'N'.
Second, with my whole respect, I dare to disagree with lotsaram's statement
I used consolidations with no children in one project and found it very useful.
It was a dimension where every department had potentially two types of projects it could budget.
Sometimes departments had no projects of one or both types, so it looked like this:
Code: Select all
- All projects
- Dep A
- Dep A Projects X
Project 1
Project 2
- Dep A Projects Y
Project 3
- Dep B
+ Dep B Projects X
- Dep B Projects Y
Project 4
In the above example Dep B had no projects of type X, but still it was very helpful that such an element (Dep B Projects X) existed (we could use it in many reports, TI, dynamic subsets, parallel hierarchies and technical consolidations). It was also very useful, that no one could write into it, because it was a consolidation.
Regards,
