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 link Year and Month prompt to get a cube member

Started by kgcognos, 17 Sep 2014 09:24:24 PM

Previous topic - Next topic

kgcognos

Our Time dimension is
  - Fiscal Year (This is displauing 2014,2013)
  - Quarter (This is displaying 1, 2, 3, 4)
  - Fiscal Month (this is displaying JANUARY for 2014 then another JANUARY for 2013...)
Then we have a month name heirarchy which displays JANUARY to DECEMBER months.

I set up a separate Year Prompt using the Time dimension Fiscal Year.
Also, a separate Month prompt using the month name heirarchy (This only displays unique JANUARY to DEC months). We have Fiscal Month in the dimension but I cannot use it as a prompt since it is displaying multiple months(like JANUARY JANUARY FEBRUARY FEBRUARY ...) in drop down.

My prompts are working fine but it is getting an error when I use parallelperiod function.
I want user to select a year and month to get the YTD periods for the selected year then base on that get the YTD period from last year.

How do I get the parallelperiod to work based on a selected Year and month?
I somehow need to get the the correct member to fill the third parameter of the parallelperiod function. 
How do I connect the selected year and month to derive the member needed for the parallelperiod function?

Thank you in advance.













Francis aka khayman

yup that double display of months is initially annoying... until you use dimensional functions and you'll realize its value.

anyway you need to construct the MUN of the chosen member. hopefully the information of the selected year and month are enough to create it.

check this link out how to manually create a MUN

http://cognosm.fm3online.com/dimensional/dimensional-current-month/