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

Drill thru on multiple years

Started by cognostechie, 10 Mar 2011 01:18:43 PM

Previous topic - Next topic

cognostechie

I have a summary report made from a cube. The layout is like this:

Crosstab -

Rows - Country
Columns - Quantity, Revenue

There is a multi-select prompt in the summary report to choose Years. So if I select 2010, then the Crosstab would show Quantity and Revenue for all Countries but only for 2010. If I select 2009 and 2010, then the Crosstab would show Quantity and Revenue for all countries for both the years - so the Quantity column for USA would show summed up Quantity for 2009 and 2010. This is working fine because I have a slicer in the summary report to work with the Prompt. -   set(#promptmany('pYear','memberuniquename','[Date]')#) .  The [Date] is a data item which points to the highest level member of the Time Dimension heirarchy so the children of this are all the years, so by default the report will run for all years if the user does not select anything from the Prompt.

I have a drill-thru on the Rows of the Crosstab (Country) and I am passing the parameter value of the Years prompt and the Country Data Item. The detailed report has filters like this:

cast(extract(year,[Business Layer].[Orders].[OrderDate]),char(4)) in ?pYearD?

[Business Layer].[Customers].[Country] = ?pCountryD?

I put Layout calculation to dispplay the parameter values and it is showing :

2009, 2010 (There is a blank between comma and 2010)
Argentina

The detailed report comes out blank because the years do not work. If I select a single year when I run the summary report and then drill thru it works perfectly !

Now here is the dilemma - If I use a Detailed filter in the summary report instead of a slicer and use expression like [Date] in ?pYear?, it works ! When the same parameter value is passed to the detailed report, it doesn't. In the summry report, there is also a space between comma and 2010 but it works !

Any ideas, specially PAULM ??