Drill Down option not working correct

[Former Member]

Hello Everyone,

I am working on a requirement where in we need drill down. I followed the steps mentioned in the following video.

Web Intelligence 4.0: Drill down into a table

However, when I select scope of Analysis it does not add Month and Day but something else with year.

Am I missing something in here.

We get Date from Database and I am extracting month and Year from the date at Universe level.

Please help.

Shirley

[former_member190895 · Accepted solution]

First you need to create a hierarchy in IDT/UDT. Then only you can use scope of analysis.

Please refer below link to create a hierarchy in IDT.

[Former Member · Accepted solution]

Yeah..I did not do that...Thanks!