Hyperion Planning (MOSC)

MOSC Banner

ASO drill down duplicates members

edited Aug 4, 2020 12:10PM in Hyperion Planning (MOSC) 3 commentsAnswered

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:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center