Skip to Content
Former Member
Sep 12, 2014 at 04:51 AM

Hierarchy drill down


Hi Guys,

I have a Webi Report (Cross Tab) with the following columns - Dept Number, Employee Name, Month & Employee Hours.

Currently, the hierarchy defined in the Universe is - "Dept Number, Dept Name & Employee Name". These objects cannot be removed from the "Scope of Analysis" panel.

Now, I want to drill down from "Year" to "Month" and "Month" to "Week"

So, my question is - do I create a new hierarchy in the Universe with the 3 objects (Year, Month & Week) or make changes to the existing hierarchy?

Could anyone please answer this question for me?