Data not showing in the BEx

[Former Member]

Hi All,

Data not showing in Bex report where as it is there in Cube level.it is multiprovider.

Please suggest.

Vijay

[Former Member]

maybe you are using filters from two different infoproviders in the same column......i had the same problem i wanted to calculate some value from two different infosources so i create a multiprovider and i create a column and i aggregate the charateristics selection for both infoproviders at the same time and it returned no data every time....then....i create two columns one for each infoproviders in order to not mix the filters of different infoproviders and finally a column where i sum both values...and it works...i hope this help you

Regards

Message was edited by:

Oscar Díaz

[Former Member]

validate your data in the data target as per your report design. then you may come to know what wrong with report.

regards,

vsn

[Former Member]

whats the msg in Bex when u run the query? - does it say "no applicable data"?

go to tcode LISTCUBE and pass the same variables you are passing in query on multi provider to see if the is available on multi provider level

[Former Member]

Hi,

Check if there are any Aggregates on that cube, if there just roll up the request and run the query on Bex.

Thanks,

Debasish

[Former Member]

There are no aggregates for this cube.

VJ

[Former Member]

Why dont you check the query in RSRT and choose debug by clicking on multiprovider+Explain..

it shd give you fair idea...why it is not showig records.

[Former Member]

Thanks for your reply.

I checked in RSRT too by selecting what you said, but still it is not showing.

Please sugggest more option.

VJ