Question:
Hi BW Gurus,
We have loaded the HR data in 0PA_C01(Headcount and Personnel Actions) and HR Personnel Administration master data. When we run the Bex queries from 'Headcount and personnel actions' Cube we are getting the message 'no data available'.
Standard queries are also not showing any data.
However, we can able view the data from Master data-Manage and from Infoprovider-manage.
Any of you face this 'No data available' error. Thanks for any help in solving this error.
Kind Regards
Kk1
Answer:
You most probably forgot to activate the master data you just loaded.
In the RSA1 screen, use <CTRL>-<F9>
Ch
Answer:
hi KK1 ,
Can you check wheather ur Aggirigate is already executed or not & request is available for reporting or not .
if this & the CHC suggestion is already checked then It might be problem with your query structure , after all this check that also .
Regards,
[V]
Answer:
Try using LISTCUBE with very minimal restriction and see if yuo are getting data. \Also is the data available for reporting?
Answer:
Thanks a lot for your replies.
Still we are not able to get data in the queries(including std SAP queries).
We do not have aggregate. We tried to Roll up aggregate, the system shows the message 'roll up not possible since there is no aggregate'.
We are able to see the data in the transaction LISTCUBE.
Data is activated using <Ctrl>-<F9>.
We noticed the "Request for reporting available" is still Blank. Anybody help me on How to make it available for reporting, Please.
Thanks & Regards
KK1
Answer:
Hi KK1,
2 idea's
1. if you are working with an ODS, is this set for reporting?
2. sometimes I have to activate the request in the cube or ods manually (cube - context menu - manage).
see if this works.
mcteam
Answer:
Hi Mcteam,
The present case is for infocube (0PA_C01) only and not for a ODS.
Can you please tell me, How did you activated the request in the cube?
We have few requests for different range of selection parameters.
Thanks & Regards
KK1
Answer:
Hi All,
Thanks for your ideas and replies.
I have deleted the old unsuccessful requests. Now the data is available for reporting.
Thank you all for your time and reply.
Regards
KK1