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

 

Parameter value is not updating while drilling down into a dimensional report

Started by Mauri, 27 Jun 2012 10:40:35 AM

Previous topic - Next topic

Mauri

Hi all, I'm new to building dimensional reports in RS and am having an issue w/ my parameter values.  Currently, i have a data item that is populated from values selected in a multi-select checkbox from a prompt page.  Here is the data item expression:  set( #promptmany('pPromptFilter', 'MUN' )# )

I can drill up and down on that data item on the report without any issue but I have a prompt button (finish)on my report that, when selected, resets the value in that data item to what is selected on the prompt page... not what is currently selected on the report.  For example, if I select ('A', 'B', 'C') on my prompt page, and then drill into 'A', i'd like my parameter value ('pPromptFilter') to be updated to 'A'  and not retain the values ('A', 'B','C').  Is this possible?  We pass parameters all the time with relational reporting (using js) but cube reporting is a completely different animal it seems.  I'm not opposed to using JS or anything that may get this to work.  Any suggestions would be greatly appreciated.

CoolP

Hi,

Why do you want to change the parameter value based on the drill selection? You have an inbuilt option to pass the current value of a hierarchy to a target report (if this is the intention).
By the way, which version of cognos are you using?

Thanks
Prasan
CoolP
Aspiring BI/Cognos Professional

Mauri

We have additional filter options on the report itself.  When any of those filter options are altered and the report is re-run (either by auto-submit or a finish button) the paramaters are reset back to what was selected on the prompt page and not what has been drilled down to.   I'm not trying to pass the value to another report but I would like to retain whatever level the user has drilled to when the report has been refreshed. 

We're using Cognos 10

CoolP

oki... In this case, I would say, create a drill through definition in the report and select the same report as target report and pass the 'column value' as the paramter to the target . select 'Run this Report' option.

Go to the Drill through defintion screen to get a better understanding of what i'm saying.

Thanks
Prasan
CoolP
Aspiring BI/Cognos Professional