If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to create a alternate drill down to tiem dimension.

Started by jd, 10 Dec 2009 10:26:47 AM

Previous topic - Next topic

jd

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.

atnaatna

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)