Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ASO drill down duplicates members in Smart View

edited Jul 8, 2020 1:17PM in Planning 4 comments

Summary

Drill down to bottom level on an ASO cube in Smart View returns duplicate members

Content

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!