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.

Regards,

Dheeraj kumar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Feb 11, 2017 at 12:41 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 11, 2017 at 02:15 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded