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 through from Cube to Relational data

Started by ravindravoggu, 15 Feb 2010 05:01:23 AM

Previous topic - Next topic

ravindravoggu

Hi All,

I have parent report which is based on Cube and child report based on realtional report.Here i have prompts in main report are Entity: 105,106,107..etc; and Account : 4000001 ABLP Consolidate.. etc.. and From date and To date in the format Jan 09, Feb 09, Mar 09 etc.. So when i am drill throughing from Parent report to Child report then i have passed the parameters as Account, Entity, and they are working fine but when i am passing Date parameters the data is not filtering in the child report based on Date range in the main report. I have Posting-yr and posting_pd in the child report. Where posting_pd : 1,2,3,4..etc..(months). posting_yr:2007,2008,2009..etc.. so i have hard coded to get the when postin_pd=1 then 'Jan' like all the months. and added one data item and made substring((posting_yr),2,4) where it shows like 09,08,07..etc. And i have concatenated with the Month and Year data items that i have created ,manually and passed the parameter to this data itmes but it is not filtering the data in the child repor, Any one who had faced this issue could you please suggest me. Thank you.

Regards,
Ravindra.

MFGF

Hi,

Assuming the source report based on the cube is filtering on members from a Time Dimension, your drill-through target report should filter on a single date-time relational value using the 'between' operator.

MF.
Meep!