cancel
Showing results for 
Search instead for 
Did you mean: 

'No Applicable Data Found'

Former Member
0 Kudos
61

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 ...

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

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

Answers (1)

Answers (1)

Ashwin
Active Contributor
0 Kudos

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