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

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
    ACCEPTED ANSWER

    Re: YTD and Prior Year Calculations

    ‏2013-02-03T22:22:09Z  in response to SystemAdmin
    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
      ACCEPTED ANSWER

      Re: YTD and Prior Year Calculations

      ‏2013-02-12T14:05:38Z  in response to SystemAdmin
      I have smiler question. Do you have any tips to write rule for YTD for TM1 cube?
      Since I could not write it.

      Thanks!