BusinessObjects Board

Universe derived table @Prompt using QAAWS

other Xcelsius - Crystal Dashboard Design
#1

Hi there,

I am creating a derived table with unions and @prompts in the universe. I want to pass the parameter to QAAWS from my dashboard. But QAAWS unable to consume the prompt value. Below is my SQL iam using at the universe

SELECT
  BOBJDB.BOBJTable.EMP_NBR,
  BOBJDB.BOBJTable.EMP_NAME,
  BOBJDB.BOBJTable.MGR_SUPER_LEVEL,
  BOBJDB.BOBJTable.MANAGER_EMP_NBR
FROM
  BOBJDB.BOBJTable
WHERE
  (
 BOBJDB.BOBJTable.MANAGER_EMP_NBR  =  @prompt('Enter Manager Emp Nbr:','A','Reporting Hierarchy\Manager Emp Nbr',Mono,free,persistent)
   AND
   BOBJDB.BOBJTable.Contrac_FLG  =  'N'
  )
UNION  
SELECT
  BOBJDB.BOBJTable.EMP_NBR,
  BOBJDB.BOBJTable.EMP_NAME,
  BOBJDB.BOBJTable.MGR_SUPER_LEVEL,
  BOBJDB.BOBJTable.LVL2_MGR_NBR
FROM
  BOBJDB.BOBJTable
WHERE
  (
  BOBJDB.BOBJTable.LVL2_MGR_NBR  =  @prompt('Enter Manager Emp Nbr:','A','Reporting Hierarchy\Lvl2 Mgr Nbr',Mono,free,persistent)
   AND
   BOBJDB.BOBJTable.Contrac_FLG  =  'N'
  )
UNION  
SELECT
  BOBJDB.BOBJTable.EMP_NBR,
  BOBJDB.BOBJTable.EMP_NAME,
  BOBJDB.BOBJTable.MGR_SUPER_LEVEL,
  BOBJDB.BOBJTable.LVL3_MGR_NBR
FROM
  BOBJDB.BOBJTable
WHERE
  (
  BOBJDB.BOBJTable.LVL3_MGR_NBR  =  @prompt('Enter Manager Emp Nbr:','A','Reporting Hierarchy\Lvl3 Mgr Nbr',Mono,free,persistent)
   AND
   BOBJDB.BOBJTable.Contrac_FLG  =  'N'
  )

Any inputs please.

Thanks
Abhi

[Moderator Edit: Added code formatting - Andreas]

abhi234u (BOB member since 2007-02-12)