Zero records in Local Providers

[praveen_kumar334]

Hi team,

I have created a local providers(ZRC_L_001) with source as flat file which has 5 records. The below is the flat file data, and when the local provider gets activated, the table gets generated in HANA studio, but when i check the contents of table in HANA studio , i am getting zero records. I have attached the screenshot. Please advise on what might be the issue.I am working on 1709 version.

local-provider-data.jpg

local-provider-structure.jpg

local-provider-structure-hana.jpg

Regards,

Praveen.

[former_member186338]

But how this question is related to BPC tags?

And using "Insert File" makes your question unreadable! Use correct "Insert Image"!

[gregor_dieckmann]

Hi Praveen,

I am not sure what the question is. It seems that you have created a local provider based on an uploaded file. Now what is the question

1 the local provider was created but is empty

2 the local provider was created, records exists but all key figures values are 0

3 the local provider was created, records are ok and can by displayed using BW tools but not with HANA Studio

You can check and display all details of local providers using transaction RSWSP; BPC Embedded uses BW Workspace technology for local providers. In the above cases 1 or 2 the file upload might be the problem: maybe the mapping of the file columns to BW InfoObjects was not complete or there is a bug in the file upload. In the latter case you should open a ticket.

For case 3 you might use the wrong tags.

Regards,

Gregor

[damovand]

Hello,

That information about DSO was from a project I did two years ago and it was for BPC on BW (not S4HANA). It may be different now. We usually get details like server side providers and tables during further training or BPC courses.

Please let me know if you have already seen this Working with Local Providers (Embedded only) while I check if we have any existing issue reported.

Best Regards,

Leila

[praveen_kumar334]

Lapin,

I have followed the procedure in the above link, still unable to view the data in the the local providers table in SAP HANA. 😞

Regards,

Praveen.

[damovand]

Hello,

As far as I know local providers do not save their data in the central tables used for BPC but rather in a DSO that is created only for the local provider. Can you confirm if you are checking the correct tables? Furthermore, please confirm if you have configured your BPC based on RTC or if you are just using the embedded BPC in S4HANA system. Thank you

Best Regards,

Leila

[praveen_kumar334]

Hi Leila,

1. As far as I know local providers do not save their data in the central tables used for BPC but rather in a DSO that is created only for the local provider.

==> When we create a local providers( let say ZLP01) two tables will be generated in SAP HANA system( in my case it got generated in SAPABAP1 schema ). one table with name fact(ZLP01:CUBE~TABLE:~FACTS ) and the other table with authorization (ZLP01:CUBE~TABLE:~AUTHORIZATION) . Fact table contains entries of the local provider and autorization table is related to authorization.

==> I have never heard of data getting loaded to DSO, if this is the case then in which DSO it will be loaded ?

2. Can you confirm if you are checking the correct tables?

==> Yes, I have checked the correct tables only.

3. Please confirm if you have configured your BPC based on RTC or if you are just using the embedded BPC in S4HANA system.

==> I am using Embedded BPC in S4HANA.

Do we need to make any settings to load the data to table in SAP HANA system. Please advise.

Thanks & Regards,

Praveen.