Cognos Report Studio reporting using TM1 Cubes
-
appleglaze28
- Regular Participant
- Posts: 269
- Joined: Tue Apr 21, 2009 3:43 am
- OLAP Product: Cognos TM1, Planning
- Version: 9.1 SP3 9.4 MR1 FP1 9.5
- Excel Version: 2003
Cognos Report Studio reporting using TM1 Cubes
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.
-
jim wood
- Site Admin
- Posts: 3961
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Cognos Report Studio reporting using TM1 Cubes
Which version of BI?
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
appleglaze28
- Regular Participant
- Posts: 269
- Joined: Tue Apr 21, 2009 3:43 am
- OLAP Product: Cognos TM1, Planning
- Version: 9.1 SP3 9.4 MR1 FP1 9.5
- Excel Version: 2003
Re: Cognos Report Studio reporting using TM1 Cubes
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.
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.
-
appbussys
- Posts: 1
- Joined: Fri Jan 20, 2012 7:15 pm
- OLAP Product: PowerPlay, Analysis Studio
- Version: None
- Excel Version: Excel 2010
Re: Cognos Report Studio reporting using TM1 Cubes
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.
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.