Hi All,
Can someone please explain the solutions for following scenarios (Cognos 11.0.11) :
#1 :
How to handle drill through from analysis studio to report studio for a date dimension. Is it mandatory to create one parameter each for Year, Quarter , Month , Week and Day in the child report ?
#2:
How to handle the mapping when drill through is on Summary row?
Ex : For "Production" dimension , when clicked on summary row, text "Product" is passed as parameter value.
Quote from: bwalikar on 30 Nov 2018 05:24:47 AM
Hi All,
Can someone please explain the solutions for following scenarios (Cognos 11.0.11) :
#1 :
How to handle drill through from analysis studio to report studio for a date dimension. Is it mandatory to create one parameter each for Year, Quarter , Month , Week and Day in the child report ?
#2:
How to handle the mapping when drill through is on Summary row?
Ex : For "Production" dimension , when clicked on summary row, text "Product" is passed as parameter value.
Hi,
When you drill through from a PowerCube date dimension, the value passed in the drillthrough is actually a date range - regardless of what level you are drilling through from. The target report needs to have a filter expression in the form [your date item] in_range ?your parameter?
The item in the target report needs to be a real date item, not a character field or a numeric field.
Cheers!
MF.
Thank you for your response MF.
To confirm my understanding.
If we have a real date data item in the child report then we can use IN_RANGE with just one parameter.
Any suggestion on question #2?
Quote from: bwalikar on 03 Dec 2018 02:36:30 AM
Thank you for your response MF.
To confirm my understanding.
If we have a real date data item in the child report then we can use IN_RANGE with just one parameter.
Any suggestion on question #2?
Hi,
For the second question, you could modify the filter in the target report to accommodate drilling through from the root member, eg
[your Product item] = ?Your parameter? or 'Product' = ?Your parameter?
Cheers!
MF.
Thank you so much !