Hello everybody!
I've got a DMR package, based on a Transformers cube, and a relational report with details. I've created Drill Through definition for the package, and I've got an issue with passing parameters from a source reports to the target.
It is required to choose a value when I run drill through reports.
Please can someone help me, or try and point us in the right direction.
Thanks a lot!
Target Settings
Quote from: Kezya on 26 Oct 2015 05:43:22 AM
Hello everybody!
I've got a DMR package, based on a Transformers cube, and a relational report with details. I've created Drill Through definition for the package, and I've got an issue with passing parameters from a source reports to the target.
It is required to choose a value when I run drill through reports.
Please can someone help me, or try and point us in the right direction.
Thanks a lot!
Hi,
What you need to understand here is that both Year and Quarter are members of a single time dimension in your Powercube. When you pass members from the time dimension of a Powercube via a drill-through to a relational report, you end up passing either dates or date ranges. You should be able to see this in your target report by temporarily adding a couple of layout calculations to the page header to display the passed parameter values
eg paramValue('pYear') to see the year parameter. You will end up seeing a value such as 2015-01-01.
This means you need to filter your target reports based on dates being passed, eg
[Year] = extract(year, ?pYear?)
Cheers!
MF.
I'm sorry for insufficient detailed an error.
Date values pass absolutly correct, I've got an issue with DataArea values
There are two hierarchies in the dimension DataArea
Hi,
Ok - so using the layout calculation technique I outlined earlier, what is getting passed to the target report in the DataArea parameter? Does it match the value you are filtering on?
MF.
Hi!
Passed values are in the attached screenshot.
I want to use a dynamic filtering, therefore the name of the filter in the target report is the same as the name of the hierarchy in the Dimension
I found the same problem (http://www.cognoise.com/index.php?topic=17685.0)
Found out that values don't pass from source to target reports.
That's what I did:
1) Change filter usage type from Required to Optional
2) Add to page Reports Expression ParamDisplayValue('DataArea')
The reports displayed with nullable param values :(
Quote from: Kezya on 26 Oct 2015 10:11:32 PM
Hi!
Passed values are in the attached screenshot.
I want to use a dynamic filtering, therefore the name of the filter in the target report is the same as the name of the hierarchy in the Dimension
Hi,
So from the image you attached, the report is passing the MUN (Member Unique Name) of the chosen DataArea member from your cube. I'm guessing you want to pass the Business Key or the Member Caption instead of the MUN. Try changing the "Source metadata item properties" setting in your drillthrough definition to pass one of these two, rather than leaving it as "Default".
MF.
Hello everybody!
The problem was the lack of the necessary context. I tried to pass the value which wasn't in the source report!
It was my inattention :(
Thanks a lot!
Hi Kenzya,
I have a prompt with billdate below that i have a radio button prompt beside to that i have taken another value prompt and set it to check box group if user want to to tick the check box it should display another prompt page . In that prompt page there are 6 filters
can u please suggest me to do it