Skip to Content

Bex Report requirement

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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.



    Add comment
    10|10000 characters needed 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 ...