How to create a alternate drill down to tiem dimension.
I have year->quarter->month.
I created the fiscal year as a alternate drill done to the year.
now I am trying to create the alternate drill down to the quarter but some how I could not ablt ot do
If anybody know about it please let me know.
The following are the general steps:
- ensure the Dimension Map is open
- drag and drop the date column from your data source and place it underneath the newly created fiscal year alternate drill down
- then open up the property sheet and you can name it "fiscal quarter"
- click on the Time tab and select "Calendar quarter" as the date function
(see page 59 in the "Step-by-step Transformer" document)