Hello
Using a tree prompt and here is the in my dimession hierrarchy:
ENTITY HIER
Level 1-> Company
Level 2 -> Region
Level 3 -> Country
Level 4 -> Organisation
I use the filer below in my query.
[ENTITY HIER].[ENTITY HIER]= #Prompt('P_Entity','memberuniquename','[ENTITY HIER].[ENTITY HIER].[ENTITY HIER(All)]->[all]')#
I can validate the report and he query whenI run the report I get to prompt page and select any levels I do get error" The member XXXXX does not belong to [ENTITY HIER].[ENTITY HIER].
I can see from my dimession the value I've selected is in the hierarchy.
Can you please advice what I m doing wrongly.
Using Cognos 8.4
Many thanks in advance
OPERA_CRN
Can you be little bit clear about your query for analysing....