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?
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?