Author Topic: Tree prompt  (Read 4373 times)

Offline szidane

  • Associate
  • **
  • Join Date: Jul 2007
  • Posts: 1
  • Forum Citizenship: +0/-0
Tree prompt
« on: 25 Jul 2007 11:40:04 pm »
Can someone please send me a document of how i create a Tree prompt in Report Studio.

For eg: I want to create a prompt that has 2 levels of hirerarchy: Region & sub-region....something like what is listed below:

East
    NY
    NJ
West
    LA
South
    FL

thanx


Offline ReportNet Addict

  • Global Moderator
  • Statesman
  • *****
  • Join Date: Sep 2005
  • Posts: 957
  • Forum Citizenship: +65/-41
  • Creator of the Impact Suite
    • The Impact Suite
Re: Tree prompt
« Reply #1 on: 26 Jul 2007 04:26:22 pm »
In ReportNet a tree prompt isn't possible...

Offline bdybldr

  • Global Moderator
  • Statesman
  • *****
  • Join Date: Oct 2005
  • Posts: 275
  • Forum Citizenship: +9/-1
Re: Tree prompt
« Reply #2 on: 19 Sep 2007 03:19:38 pm »
It can be done.  You have to create a query subject in Framework Manager that will hold the values.  Then create a prompt from that query subject.  You have to be a little creative but it can be done.  Here's the SQL from one query subject that I used as a "tree" prompt.  Also, see attached screenshot.

select
       MASD_SALES_ORG.L1_SALES_ID  as  SalesID,
       '- ' || 'Global User - Global User' as  SalesDescription,
        1 AS SalesLevel
from
       [MSDCOGN].MASD_SALES_ORG MASD_SALES_ORG
where
   MASD_SALES_ORG.SALES_FORCE_ID = 'S002.10.1007.US001' and MASD_SALES_ORG.CURRENT_FLAG = 'Y'
UNION
select
       MASD_SALES_ORG.L2_SALES_ID  as  SalesID,
       '---- ' || rtrim(MASD_SALES_ORG.L2_MGR_NAME) || ' / ' || rtrim(MASD_SALES_ORG.L2_SALES_DESC)  as  SalesDescription,
        2 AS SalesLevel
from
       [MSDCOGN].MASD_SALES_ORG MASD_SALES_ORG
where
   MASD_SALES_ORG.SALES_FORCE_ID = 'S002.10.1007.US001' and MASD_SALES_ORG.CURRENT_FLAG = 'Y'


UNION
select
       MASD_SALES_ORG.L3_SALES_ID  as  SalesID,
       '------- ' || rtrim(MASD_SALES_ORG.L3_MGR_NAME) || ' / ' || rtrim(MASD_SALES_ORG.L3_SALES_DESC)  as  SalesDescription,
       3 AS SalesLevel
from
       [MSDCOGN].MASD_SALES_ORG MASD_SALES_ORG
where
   MASD_SALES_ORG.SALES_FORCE_ID = 'S002.10.1007.US001' and MASD_SALES_ORG.CURRENT_FLAG = 'Y'

UNION
select
       MASD_SALES_ORG.L4_SALES_ID  as  SalesID,
       '---------- ' || rtrim(MASD_SALES_ORG.L4_MGR_NAME) || ' / ' || rtrim(MASD_SALES_ORG.L4_SALES_DESC)  as  SalesDescription,
        4 AS SalesLevel
from
       [MSDCOGN].MASD_SALES_ORG MASD_SALES_ORG
where
   MASD_SALES_ORG.SALES_FORCE_ID = 'S002.10.1007.US001' and MASD_SALES_ORG.CURRENT_FLAG = 'Y'

UNION
select
       MASD_SALES_ORG.L5_SALES_ID  as  SalesID,
       '------------- ' || rtrim(MASD_SALES_ORG.L5_MGR_NAME) || ' / ' || rtrim(MASD_SALES_ORG.L5_SALES_DESC)  as  SalesDescription,
       5 AS SalesLevel
from
       [MSDCOGN].MASD_SALES_ORG MASD_SALES_ORG
where
   MASD_SALES_ORG.SALES_FORCE_ID = 'S002.10.1007.US001' and MASD_SALES_ORG.CURRENT_FLAG = 'Y'
« Last Edit: 19 Sep 2007 03:32:05 pm by bdybldr »

Offline rajvivan

  • Full Member
  • ***
  • Join Date: Jan 2015
  • Posts: 32
  • Forum Citizenship: +1/-0
Re: Tree prompt
« Reply #3 on: 12 May 2015 05:43:59 am »
Search in the IBM website, They have described it very beautifully.

 


       
Twittear