Rerun Reports Based on Year/Month

[kgcognos]

Hi,

We have standard reports that shows Current Month TY, Current Month LY, YTD TY, YTD LY. We are using the Relative Time Categories from our Sales Cube as our columns. This works fine for the current month lookup only.

We want users to be able to rerun the report based on specific year and month.
I just want to know of different ways or any suggestions on how to set the report up. Can this only be done using Report Studio or is there a way to set something up in Transformer??

Thank you in advance.

[cognos810]

Hello kgcognos,
I do not think you can pass anything back to transformer as a parameter and have it recompute the categories. For anything this dynamic in nature you will have to rely on report studio and MDX functions to work with the Month-Year member selected by the user in a prompt.

Let me know if you need assistance with the MDX expressions for each of the categories.
-Cognos810

[kgcognos]

Thank you for the response. Yes if you could give some documentations on MDX that will be great.