ASO drill down duplicates members
Dear all,
We are facing a situation where a Smat View drill down to bottom level in an ASO cube returns 2x the bottom level members.
Se we have a dimension like this:
MySparseDim
Total1
SubTotal1
Mbr1
Mbr2
Mbr3
SubTotal2
Mbr4
Mbr5
If we drill down Total1 to next level we get:
Total1
SubTotal1
SubTotal2
That's ok.
Now, if we drill down Total1 to bottom level in SmartView, we get:
Total1
Mbr1
Mbr2
Mbr3
Mbr4
Mbr5
Mbr1
Mbr2
Mbr3
Mbr4
Mbr5
That's not ok.
The same goes if we drill down to bottom level from SubTotal1. In this case we get: