Topic
  • 2 replies
  • Latest Post - ‏2013-02-12T14:05:38Z by SystemAdmin
SystemAdmin
SystemAdmin
214 Posts

Pinned topic YTD and Prior Year Calculations

‏2013-01-27T18:04:48Z |
Dear friends,
I need to create YTD and Prior Year calculations. I know that there is a way to create it in framework but it's a relative approach. I need to create this calculations dynamically.

For example the DMR MDX functions works for this?
Regards,
PP
Updated on 2013-02-12T14:05:38Z at 2013-02-12T14:05:38Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    214 Posts

    Re: YTD and Prior Year Calculations

    ‏2013-02-03T22:22:09Z  
    Hi bi_cognos,

    If you are using TM1 (CXMD) as the datasource you can use rules and dimensions to generate these calculations. If you are using a relational source then you can potentially use functions in Framework Manager.

    Cognos Express installs some sample Framework Manager files into <Cognos Express install path>\webapps\p2pd\samples\models\great_outdoor_sales

    Hope this helps.

    Rod
  • SystemAdmin
    SystemAdmin
    214 Posts

    Re: YTD and Prior Year Calculations

    ‏2013-02-12T14:05:38Z  
    Hi bi_cognos,

    If you are using TM1 (CXMD) as the datasource you can use rules and dimensions to generate these calculations. If you are using a relational source then you can potentially use functions in Framework Manager.

    Cognos Express installs some sample Framework Manager files into <Cognos Express install path>\webapps\p2pd\samples\models\great_outdoor_sales

    Hope this helps.

    Rod
    I have smiler question. Do you have any tips to write rule for YTD for TM1 cube?
    Since I could not write it.

    Thanks!