Hierarchy drill down

Joel

what is the key for this level in your hierarchy? Is it based on the "BXYZ" column? Is the value unique at this level? If not, then that's your problem.

Robert Angel

Was exactly going to be my next advice, if multi-table source then join your tables as they are defined to join by the physical joins and check that the key is always populated / is always at the most granular level for the level of detail in question...

+1 to Joel

Hesh

Hi Joel, Robert,

you are correct this is not Time Dimension, this is different dimension. There are no keys for BXYZ column, only values are used for that column.

And there is no one to one relation between BXYZ and next RXYZ columns...  like below.. for one BXYZ column values there are many RXYZ  values..

One more thing is unlike the Time Dimension issue you are referring.. where the drill is showing multiple 'rows' ....in my issue , the drill is going to a different 'column' .. should need  different thoughts required to look for?

Regards

Hesh

Robert Angel

Hi,

have you checked this with a new analysis, to rule out corruption with a particular analysis / existence of other drill functionality overlayed above and beyond the business model drill behaviour?

have you also double checked the keys down your hierarchy are exactly what you think they are - looking into the physical source for the key?

have you tried bypassing the cache to see if this makes a difference?

Robert Angel

One more thought, is your hierarchy skip level or ragged hierarchy?

Hesh

Hi Robert,

I have tried with a new Analysis and also with DISABLE_CACHE_HIT=1 but still the same results.

But interestingly  when I rerun ts working fine in the original report and when I check again with a new report its working fine as well. But issue is back with when I run wiht Disable Cache Hit !

Regards

Hesh

Hesh

Nothing specified about the type

Robert Angel

This sounds like one to clear your log files, ramp your diagnostics to max, run your analysis with no other users on the system, get your log files, log an SR with My Oracle Support, though review your logs first it may give you a clue.

Also look at the physical sql that is invoked for the drill action.

I would also check your logs generally to see if you have any other errors that could be contributing to the problem.