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

Passing date parameter through a drill-through in Report Studio

Started by davephall, 03 Aug 2009 10:00:57 AM

Previous topic - Next topic

davephall

Hi, I'm using a PowerCube in ReportStudio 8.3 and am trying to pass a date parameter through a drill-through. On some reports, this works fine, passing the parameter and receiving it in the child report as:

[HHG Finance Cube].[Period].[Period].[Month].[Month - Long Name]=?Month?

but on others it gives the error 'QE-DEF-0260 Parsing error before or near position: 9 of: "2009/Jun" '

The reports it fails on are pretty much identical to the reports it passes on, just with a few more parameters in the query. I've tried passing (and receiving) the following fields:

[HHG Finance Cube].[Period].[Period].[Month].[Month - Long Name] (Which evaluates to 2009/Jun)

[HHG Finance Cube].[Period].[Period].[Month] (Which evaluates to 2009/Jun)

[HHG Finance Cube].[Period].[Period].[Month].[Month â€" Category Code] (Which evaluates to ("2009-06-01","2009-06-30"))

But all give a similar error. Has anyone come across a similar problem before? And if so, have you found a way round it? Thanks in advance.

Dave.

uttam.mistry

i had similar problem...
than i realized that report was passing caption, while target report was expecting MUN...
to resolve this issue I used function rolevalue() to get MUN for the data item I wanted to pass in drill through and used that MUN to map in drill through

i also tried few other things but it was giving me error like, package does not exists or you dont have permission (whereas i was admin & report was executing fine individually)

hope this helps!!

davephall

Hi Uttam,

Thanks for this, it's definitely got me a bit further. It feels like it's something to do with passing the MUN, but using roleValue('_memberUniqueName',[HHG Finance Cube].[Period].[Period].[Month])=?Month? which comes through as [HHG Finance Cube].[Period].[Period].[Month]->:[PC].[@MEMBER].[20090601-20090630] in both parent and target (or just passing to target, leaving caption on parent) returns no data in my parent list.

Looking through the manual on the rolevalue function, I also tried the following filters:

roleValue('_businessKey',[HHG Finance Cube].[Period].[Period].[Month])=?Month?

roleValue('_memberCaption',[HHG Finance Cube].[Period].[Period].[Month])=?Month?

caption([HHG Finance Cube].[Period].[Period].[Month])=?Month?

But all of these returned the original parsing error.

Strange huh? This one’s got me confused.

Dave.

uttam.mistry

i think you got me wrong!!

say your parent report has columns
Month = [HHG Finance Cube].[Period].[Period].[Month]
Country = [HHG Finance Cube].[..].[..].[Country]
Sales = [HHG Finance Cube].[Measures].[..].[Sales]

now you want to use drill-through on Month
create another column
MUNMonth = roleValue('_memberUniqueName',[Month])

define drill through
say you want to pass Month to prompt parameter 'p_Month' of target report
map MUNMonth data item to 'p_Month'

Now in target report you have below columns
Month = [HHG Finance Cube].[Period].[Period].[Month] -> ?p_Month?
Product = [HHG Finance Cube].[..].[..].[Product Name]
Date = [HHG Finance Cube].[Period].[Period].[Date]

or
you can put slicer as [HHG Finance Cube].[Period].[Period].[Month] -> ?p_Month?

another way will be to pass Month in drill through (and not MUNMonth)
and in target report use caption([HHG Finance Cube].[Period].[Period].[Month])=?p_Month?

hope this helps!!
(well, I am not expert in using cubes in report studio(I started learning it a month ago), if you like send me an example of your report (may be based on sample database) i will try to have a look if got time)

davephall

Hi Uttam, that looks like it might have worked, thanks for your help on this.

Dave.