'No Applicable Data Found'

[Former Member]

Hi guys,

I have data loaded in Info Cube <b>FIAP: Transaction Data</b> (<b>0FIAP_C02</b>)

Hence, I created a query using Business Explorer to output the following fields :-

0CREDITOR -> Vendor

0COMP_CODE -> Company Code

0CURTYPE -> Currency Type

0BALANCE -> Cumulative Balance

0CREDIT -> Total Credit Postings

0DEBIT -> Total Debit Postings

0SALES -> Sales for the Period

However, I get the message " 'No Applicable Data Found. " when I run this query.

Please assist ! I have even remove any restriction or filter values in my query ...

[Former Member · Accepted solution]

John,

Is the query released for reporting? Go to manage in the cube and check on the requests tab if all requests in the cube are in green status.

Aneesh

[Former Member · Accepted solution]

Thanks Guys,

I just set the QM Status of Request after Update to green(instead of yellow) and it worked!

However, I have another follow-up question.

I have Info Cube <b>FIAP: Line Item</b> that has <b>Info Source 0FIAP_O03</b> which is an ODS Object

So, my question in this standard Business Content scenario is that how do I get data updated to that Info Cube <b>FIAP: Line Item</b> from <b>Info Source 0FIAP_O03</b> ? Do I need to custom create an update rule ?

Thanks for your help

[Ashwin · Accepted solution]

Hi!

in the info sources tab you will find a infosource named 8FIAP_O03 .if you have alredy created update rules for loading from the ODS in to cube or if it is installed from content, you can create infopackage under this 8xxxxx infosource and load into the data targets.

you can also do it by selecting the upload into datatargets in th context menu of the ODS opbject if the update rules for loading into to cube are active.

with regards

ashwin

Message was edited by: Ashwin Kumar Gadi

[Ashwin · Accepted solution]

Hi!

always after loading the data into infocube check the data in it under the manage tab by checking the request status .

with regards

ashwin

[Ashwin]

Hi!

Have you checked the cube is all the data present. You can use transaction RSRT to debug your query. just check whether there is any data in the cube for the specified conditions in the query

with regards

ashwin