Skip to Content
0

Bex Report requirement

Jan 30, 2017 at 02:01 PM

36

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.

Regards,

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
0

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

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

0