TM1 Forum

Hi! I would like to know if any of you guys have tried using Cognos Report Studio to do complex reports using TM1 Cubes? Especially considering the use of the attributes.

Which version of BI?

Cognos 10 BI.

I want to create a report where I have a prompt where the user needs to choose the current month from a prompt. Then the report would show comparison of previous full year, the current actual YTD chosen from another prompt and the proposed budget for the upcoming year.

I cant use the Year or YTD month in the query cause it would make the other column useless. I need to have the prompt value be the element used in the report and that query will be based on the column content.

Is my understanding of your report correct?
You have 2 prompts: a month prompt where the user simply chooses 1-12; and an actual YTD balance (e.g. Phone Expenses, Utility expenses, Travel expenses, …..)
Then, assuming the user selects month 6 and Travel expenses your report displays:
For June 2012:
YTD Travel Expenses for 2011: XXXXXXX
YTD Travel Expenses for 6/2012: XXXXXXXX
Budget of Travel Expenses for 6/2013: XXXXXXX

You can certainly create a prompt for the month using a variable with assigned static values. Then, based on the value selected (in this case Month = 6) use this to select the appropriate balance after the user has selected the appropriate account (in this case Travel Expenses). How best to do this will depend on how your data for the balances is stored.