Author Topic: Drill through from Analysis Studio to Report Studio - Date Dimension  (Read 8395 times)

Offline bwalikar

  • Full Member
  • ***
  • Join Date: Mar 2015
  • Posts: 38
  • Forum Citizenship: +0/-0
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.

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,303
  • Forum Citizenship: +665/-10
  • Cognos Software Muppet
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!

Offline bwalikar

  • Full Member
  • ***
  • Join Date: Mar 2015
  • Posts: 38
  • Forum Citizenship: +0/-0
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?

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,303
  • Forum Citizenship: +665/-10
  • Cognos Software Muppet
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!

Offline bwalikar

  • Full Member
  • ***
  • Join Date: Mar 2015
  • Posts: 38
  • Forum Citizenship: +0/-0
Thank you so much !