Skip to Content

Bex Report requirement

Jan 30, 2017 at 02:01 PM


avatar image

Dear All,

We have an infocube and a masterdata (with customer information like CITY)

In the report i need to diplay the customers data from the infocube after checking if the respective customer is having CITY information exists in the master data. If yes, i need to display the respective information from the infocube in the report. Else i need to display a message that no CITY data exists.

This is like a validity check in master data table.

Kindly suggest on this.


Dheeraj kumar

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Cornelia Lezoch Jan 30, 2017 at 03:44 PM

Hi Dheeraj,

messages are not possible with a simple reporting query.

You would have to impleemnt a plannign solution and run a planning funtion type fox or exit.

This on ecould check on the master data and through the message if it is missing.

but I really doubt, that such a message is worth that much effort.

I would only implement the query which is selected to City not #

and then put a standard comment into my frontend (workbook or web template or whatever you use) that in case no data is shown it might be due to missing city information.



Show 1 Share
10 |10000 characters needed characters left characters exceeded

ah sorry, just got another idea - implement a variable exit in step 3 whih is taking the selected customer, reading the master data and if it is missin g- give out the message and don't let the report run ...