Issue with webi report on BEx query

[former_member204024]

Hi,

I have created a universe on top of Bex query. There is no issue in creating and exporting the universe. But when I try to create a webi report out that BEx query, I am not able to see the values. Say if I have a column called "Company" I am getting the value as "All Company" and so on. What will be the issue?

But when a report is generated out of BEx analyser they are able to see the values properly.

Same user credentials are used in both the places (Importing the query into universe, Connecting to BEx Analyser) .

Thanks & Regards,

Subbu S

[IngoH · Accepted solution]

Hi Subbu,

the universe will generate a L00 item and a L01 item. The L00 item shows the All member of the characteristic in the case of a flat list and the Top level nodes from a hierarchy. the L01 item should give you what you looking for.

Ingo

[adil_madid]

It sound like you are looking at the L00 value. Have a look at L01 for instance, do you still see "all company" or the actual data?

Adil