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

Tree Prompt

Started by OPERA-CRN, 22 Feb 2012 12:14:19 PM

Previous topic - Next topic

OPERA-CRN

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

jagannath.paru

Can you be little bit clear about your query for analysing....