Bex Query Result

[Former Member]

Hello, I have a query regarding a BEX output. i want to print out a results some where in the query. for example:

Customer     Quantity

101                    100

102                    150

104                    200

the total is : 450.

How can I capture it in a formula or something like that?

Thanks.

[yasemin_kilinc · Accepted solution]

Hi Venkat,

Add a RKF where you select Quantity and add customer as constant selection.

Regards

Yasemin...

[Former Member · Accepted solution]

Hi Yasemin ULUTURK            ,

Constant selection of RKF might lead to wrong display.

Ex:

In above scenario output will be like this:

Customer  Quantity

101               450

102               450   

103               450

Result           450

Without constant selection it will display like this:

Customer  Quantity

101               100

102               150   

103               200

Result           450

[yasemin_kilinc · Accepted solution]

Hi Jalpesh,

Venkat has already stated that he doesn't want to see as a result row. since he is going to use it in some formula he will need that in every row, that is why I suggested that.

regards

Yasemin...

[Former Member · Accepted solution]

Hi Yasemin,

Yes, you are right. It was my mistake. If i don't want to display result row in report than what should i do?

Best,

Jalpesh (Jk)

[Former Member]

hi venkat sharma,

For that you will have to create calculated key figure in your Query Designer.

To do so, follow the steps:

1. Go to Key Figures tab in left side of Query Designer. Go to Calculated Key Figure then right click on it and add new calculated key figure.

2. Give Proper name to calculated key figure. Click on edit and make your formula on key figure.

    For example: I want to create Total Price.
     Choose Quantity and Unit Price and multiply them in calculated key figure. It will generate new  column in Query for Total Price.

[former_member182997]

Hi Venkat,

using the setting result row---> always display  for customer will give the overall result for the Keyfigure quantity.
Go to query designer, select the characteriestic customer after you have clicked row/column tab and then on the right panel you will see properties of the characteristic, click display tab and use the above setting.
thanks

[Former Member]

I know the result row. but i want to store is somewhere in Bex.

Thanks.