If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Need Help

Started by fshahul, 16 Feb 2010 10:44:40 PM

Previous topic - Next topic

fshahul

Hi,
I'm having Crosstab report to display forecasting values for the selected Accounts and Time periods (for Quarters Q1, Q2, Q3, Q4). I'm having prompts for accounts and Quarters (Q1, Q2, Q3, and Q4).
Currently data are not available for Q1, Q2, Q3 and Q4 so the report is displaying blank. Now my requirement is "If I'm selecting Q1 in the prompt page, values for August month should display in the report for Q1 field and values for November month should display in the report for Q2, values for February month should display in the report for Q3 and values for May month should display in the report for Q4".
I'm using Cognos 8.2 version. Can anyone help me on this?

Thanks in advance

Regards,
Fatima S.

paddhu

If the quarter has been modelled in the package itself, then you can't modify it to change months dynamically.
Instead, you must design a new calculated member that gives the appropriate combination.

fshahul

Hi,
In my package, I'm having one query item: Period which contains Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec, Q1, Q2, Q3, Q4, and Full Year. Currently data is not available for Q1, Q2, Q3, and Q4. One of my reports is to show data only for Quarters. So I want to display Aug value for Q1, Nov values for Q2, Feb values for Q3, and May values for Q4. How can I do that?
Thanks,
Fatima S.

paddhu

Create a Calculated query item in your report, with a case construct on Month. This will look something like the following...
case [Month]
when "August" then "Q1"
when "November" then "Q2"
....
end

Then pull in this new query item into your report. Once data is made available for the Q1, Q2, .. in the package, you can replace these query items to your Period query item itself.