Hierarchy drill down
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?