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

 

Drill through from Analysis Studio to Report Studio - Date Dimension

Started by bwalikar, 30 Nov 2018 05:24:47 AM

Previous topic - Next topic

bwalikar

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.

MFGF

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.
Meep!

bwalikar

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?

MFGF

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.
Meep!

bwalikar