Skip to Content
0

Bex Report requirement

Jan 19, 2017 at 10:38 PM

74

avatar image
S D

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.

2 Answers

Abhishek Shanbhogue Feb 11, 2017 at 12:41 PM
0

Dheeraj - If I understand your question then Customer is already in the Info Cube and City is a attribute of Customer. All you need to to make this filed as attribute (Navigational/Display) to enable it to reporting

Thanks

Abhishek Shanbhogue

Share
10 |10000 characters needed characters left characters exceeded
Rama Chandra Rao Feb 11, 2017 at 02:15 PM
0

Hi Dheeraj,

Please, apply a field level routine during a master data load, saying that

if source_field-city is initial

Result = no CITY data exists,

else

Result = source_field-city

endif.

so, same will be visible in Report, when you are using City as an navigational attribute at BEX Query designer.

Thanks & Regards. SRI.

Share
10 |10000 characters needed characters left characters exceeded