Bex reports

[Former Member]

Hi Gurus,

Please can you put light on my words, I will assign points .

I executed reports but shows -no applicable data to me., in the data target cube there is no data in it  , but in the dso data is resent.

so i have taken the variable from the dso and exicuted..but shown no data to me.

please help me.

regards

sanjeeve

[Former Member · Accepted solution]

Hi Sanjeeve,

Is your reported created using DSO or the cube which has no data. Data will only be returned for your query if it is created on a DSO or cube which has data in it.

Please make sure that query is create on the DSO or infocube which has data.

regards,

amit

[Former Member · Accepted solution]

Hi Amit,

Query is create on Cube,but there is no data in it,but the data is available in dso.

can i run the dtp on dso and cube ?

regards

sanjeeve

[Former Member · Accepted solution]

Hi Sanjeeve,

Yes please run the transformation and load data to cube from DSO.

Once data will be available in cube on which query is built, you will have the result on executing the query.

Please make sure that data is available in cube else you will get no applicable data found as data is in DSO and not in cube on which query is created.

Regards,

Amit

[Former Member · Accepted solution]

Hi Amit,

i attached the flow ...please advice me.

regards

sanjeeve

[sapna_jgurudutt · Accepted solution]

Hi Sanjeeve,

Can you please run DTP and load data from DSO to cube. Please check whether data if available in cube on which query is created. Also, please refer the SAP Notes and SAP KBA Notes which I mentioned in my previous reply and check whether it helps you.

Thanks & Regards,

Sapna

[Former Member · Accepted solution]

Hi Sanjeeve,

There are many SAP help documents available regarding the complete flow and how to proceed with each and every steps to load data. You will many SCN help link also how to load the data.

It will clear your doubts and will help you for this issue.

Regards,

Amit

[sapna_jgurudutt]

Hi Sanjeeve,

Can you please refer the following SAP KBA Notes and check whether it helps you:

2197626 - Query returns  'No  Applicable Data Found'

2232492 - "No Applicable Data Found" instead of "No Authorization" when the User does not

Have Enough Analysis Authorization

2125357 - HOWTO: How to use transactions RSRT/ RSRT2 to analyze unexpected query results

2142771 - HOWTO: Query displays unexpected data in RSRT except in "Safe Mode"

Also, please refer the following SAP Note and check whether it helps you:

2190789 - Query with replacement path variable on virtual provider doesn't show data

Thanks & Regards,

Sapna

[Former Member]

Hi,

I executed reports but shows -no applicable data to me., in the data target cube there is no data in it  , but in the dso data is resent.

Did you activate DSO request? have you ran DTP to load data from DSO to cube?