Showing results for 
Search instead for 
Did you mean: 

How to design BEX Query senario??

0 Kudos

I have a senario in BW Query designing

  ID              DESC

1:10             Dealer-New

2:11             Dealer-refinance

3:20             Direct-New

4:21             Direct-refinance

5:30             Franchise-New

6:31             Franchise-refinance

We have developed this BW Query

Now main problem in we need output as bellow

  ID              DESC

1:1            Dealer

2:2             Direct

3:3             Franchise

How to design BEX Query  above senario

Accepted Solutions (0)

Answers (3)

Answers (3)

Active Contributor
0 Kudos

Hi Mahantesh,

You have a few options:

a) As Cornelia Lezoch has mentioned, create a hierarchy on your DESC characteristic (or whatever the actual characteristic is).  A hierarchy nodes will be Dealer, Direct & Franchise and the characteristic values will be entered in each of the relevant nodes.

b) You can create a selection for each of the Dealer, Direct and Franchise values in your query and select each of the characteristics in each selection

Dealer =    1:10             Dealer-New     &    2:11             Dealer-refinance

Direct =   3:20             Direct-New   &    4:21             Direct-refinance

Franchise = 5:30             Franchise-New   & 6:31             Franchise-refinance

From a performance, maintenance and flexibility perspective, the hierarchy would be the better options.

c) The other route is data modeling changes - we would need to know more info though before progressing that one.

With regards

0 Kudos

Thank you

Active Contributor
0 Kudos

Hi Mahantesh,

What is the relation between the ID´s you are showing?

Looks to me as you will need to have a hierarchy on your char.



Active Contributor
0 Kudos

Hi mahantesh,

i am looking these objects i didn't understand

please explain?

which one char and KF are using your query.