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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Drill through from relational report to dimensional

Started by velniaszs, 27 Dec 2013 04:18:58 AM

Previous topic - Next topic

velniaszs

Hello,

I am trying to drill through from relational report which is in one framework package to a dimensional report in another package with filter prompt.
I am using '[UKRBB_Think_Accuracy].[Hierarchy].[Hierarchy].[Region]->:[PC].[@MEMBER].['||trim([CHILD_ORG_ID])||']' as data item to pass (member unique name) from the relational report.
In the dimensional report the prompt data item is :
#prompt('Region','memberuniquename','firstChild([UKRBB_Think_Accuracy].[Hierarchy].[Hierarchy].[Hierarchy]->:[PC].[@MEMBER].[national_id])')#

For some reason the parameter does not get through.
Any ideas?

velniaszs

#1
As a test I did drilling from reports in same package and different with data item:
'[UKRBB_Think_Accuracy].[Hierarchy].[Hierarchy].[Region]->:[PC].[@MEMBER].[11]'

Drilling from same package works, if I try the same from different package it fails and does not pass any parameter at all.
Maybe anyone knows the reason behind such different behaviour?