Bex Report requirement

[jack_sd]

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.

Regards,

Dheeraj kumar

[cornelia_lezoch]

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.

regards

Cornelia

[cornelia_lezoch]

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