BPC DataManager Success, but no data is loaded to the BPC Cube

[Former Member]

Dear All,

We ran our DM Package to load transaction data from BW cube and the status was successful and below you can find the details of the records that were submitted.

/CPMB/LOAD_INFOPROV_UI

Task name CONVERT:

No 1 Round:

Reject count: 0

Record count: 11940

Skip count: 292

Accept count: 11648

Task name LOAD INFOPROVIDER:

Aggregate count: 20

Submit count: 11628

Reject count: 0

Package status: SUCCESS

However, when we checked in the BPC backed cube the data is not submitted but the fact table of that particular cube is being updated with number of records. I even tried with epm input forms and sent some data and submitted the data successfully but when i refresh the report the data is vanished.

1) Checked the process chain everything is green no logs.

2) Could not find any changes in the data audit

Need your help.

Thanks,

Surya

[Former Member · Accepted solution]

Dear All,

At last we have solved our issue by doing the below execution.

Enter RSRV transaction and navigate as follows:

>> Tests in Transaction RSRV

>> All Elementary Tests

>> Transaction Data

>> Foreign key relationship between dimension and SID table:

Enter the following Parameters:

InfoCube = /CPMB/*******

Char. = /CPMB/*******

Dimension = /CPMB/*******

Execute the test and verify if there are any inconsistency between the infocube data and its SID’s.

If you find any errors between the data and SID’s then this error cannot be repaired automatically.

The infocube data is not consistent anymore and this can be repaired only by a new reload.

As ours is a consolidation cube and there is no plan data and only actuals are there, we have deleted last few requests in this current month which were loaded and reloaded the data for the periods for which we have deleted and this solved our issue.

Thanks for all your support.

Best Regards,
Surya Nallamolu

[former_member186338]

Sorry, but looks like you are using some wrong report to check the data... If it's submitted then you have to see figures in EPM report.

Vadim

[Former Member]

Hi Vadim,

As expected you replied first Thank you for the response

Now, i created a input form to load the data and did check the edit option "use as input form" from epm and that is the issue that we cannot see the data even though it was submitted.

Thanks for the help

Regards,

Surya

[former_member186338]

And what about data upload from BW? Have you found it in some report?

[Former Member]

We ran a process chain which will bring data from ecc to staging to bpc, this creates a new request id for bpc cubes however, when we check the request id to display data there is no data. But the fact table as been updated with the number of records which were loaded.

Let me know if i can provide you more details.

Thanks,

Surya

[Former Member]

Hi Surya,

Do you have anything in default logic?  If so have you tried commenting it out and re-running?  Can you provide a sample of data you are loading too?

Regards,

Di~An

[former_member186338]

Please test data upload using EPM report with the proper scope!

[Former Member]

Hi Surya,

Make sure you switch back the BPC cube to planning mode once you ran your custom process chain.

Andy

[Former Member]

Hi Surya,

Can you please provide details how you checked that the last request has no data? And how did you see number of records in it?

Regards,

Gersh

[Former Member]

Hi Vadim,

We have tested several reports to input data with proper scope, After saving the data 10 records the message says submit count = 10 and accept count =10 however, when i refresh after the submitting the data the sheet is empty, there are no values in the filed where i have entered.

Thanks,

Surya

[Former Member]

Hi Gersh,

Thanks for the reply, i have checked the data by below steps

Before data Loading:

Goto RSA1 in the backend BW --> Right click on the BPC Destination cube --> click on Manage --> goto Contents Tab --> Click on the Fact Table --> Click on Number of entries

Records: 4,454,449

After data Loading:

Goto RSA1 in the backend BW --> Right click on the BPC Destination cube --> click on Manage --> goto Contents Tab --> Click on the Fact Table --> Click on Number of entries

Records: 4,458,837

But when we check in display data in the BPC Backed Cube wit the loaded period there is no data

To check the request, go to request tab in manage and select the latest request which was loaded, copy the request id and right click on the bpc cube select the display data, select all the characteristics and select the required field selection you want and paste the request id and execute.

Thanks,

Surya

[Former Member]

Hi Andy,

Thanks for the reply

The process chain which we are using is /CPMB/LOAD_INFOPROV_UI ; we have a mega chain which will bring the data from ecc to staging to bpc but the chain will trigger bpc dm chain when loading into BPC cubes; its the same as loading the data from epm dm packages; the only difference is we are triggering it from backend.

For this the BPC will be in BPC cube --> planning mode only; the second option only

Thanks,

Surya

[Former Member]

Hi Di~An,

Thanks for the reply, we even tested omitting the default logic and work status; several combinations; all these result in the success of the load however, when we try to pull the data with the same combinations as we loaded we cannot see any data and we even checked it from the backedn with the combination of periods and still we cannot find the data; on the other hand we check the last request from the backend to see data and i cannot find any data:

Our data is vanilla data without any complex conversions just that we skip some entities but there is data with the entities which are not being skipped. So as a result we expect the data to be posted in bpc cube.

Thanks<
Surya

[Former Member]

Hi Surya,

I agree with the 1st step - it shows that you loaded 4K+ records.

Can you try displaying data differently? Make same steps you did to count records, but instead of selecting Content Table choose name in the Dimension column for Request ID. Copy that name, open another session and go to t/a SE16. Paste that name and replace CPMB with B28 and insert D after 2nd /. Press Enter, put Request ID in SID_REQID field and display selected record. Now copy value from DIMID field; go to your original session and click Fact Table. Paste in the first field value you copied from DIMID and execute.

You should see records you've loaded. You'll recognize only /B28/S_DATA field because all members are replaced by their SIDs.

Please let me know if you can see those records.

Regards,

Gersh

[Former Member]

Hi Gersh,

Thanks for the valuable input.

I did find data in the Fact table with the DIMID; and my question to you why am i not seeing data when displaying through the Display Data on the cube.

Is there any thing am i missing in displaying or loading the data?

Appreciate your data.

Thanks,

Surya

[Former Member]

Hi Surya,

I'd think that this proves that there is no issue with the load - data is in the cube. There is an issue with the display of data. Can you try displaying it using LISTCUBE or Manage -> Contents -> InfoCube Content?

Regards,

Gersh

[Former Member]

Hi Gersh,

I tried displaying through Infocube Content, however, i am not able to see any data; could you please provide any helpful information if you have any idea, why data cannot be displayed.

Thanks,
Surya

[Former Member]

Hi Surya,

It's hard to imagine what can be wrong there; I never saw such thing happening.

If you have some quiet time in the Model can try the following: make all requests green in the Model; compress all requests; load your file; check Cube Content with Req # <>0. Let me know if it shows anything.

Regards,

Gersh

[Former Member]

Surya - Are you sure you don't any BADI or Default Logic which does data manipulation?

There is no other reason that you can't see data in list cube except you are transforming data and looking for data at wrong intersection.

[Former Member]

Please check out the authorisation . Atlease are you able to see some data in the InfoCube.