0sd_c03 cube fields are empty on report based on multi provider but 0fiar_c03 data are coming perfect at query.why?

[Former Member]

Hi  Experts,

I am using a multi provider and with two cubes(0sd_c03) from SD  and (0fiar_c03) cube from FI. all the required field  data is coming perfect and correct 1)PSA LEVEL 2)AT CUBE LEVEL 3)AT MULTI PROVIDER LEVEL.

When i am executing it at RSRT with specific fiscal year/period   and comparing with multi provider data then FI DATA LIKE CREDIT AND DEBIT AMOUNT IS COMING ACCURATE.

But NET VALUE,BILLING TYPE AND REGION (0REGION) FIELD  is empty and no data.

I am not able to understand the mistake ,I tried my best to resolve but I do not have any solution for this.

Please guide me what can i do for this problem.I was about to move TR TO PRODUCTION SYSTEM but this problem happened.

I am waiting for the reply.

Thanks and regards,

jyotsna singh

[former_member241863 · Accepted solution]

Hello jyotsna singh,

Few things to check -

1) Check, both the cube having Data and there must be a relation between them. Like Document number and Fiscal periods.

2) As you know Multiprovider works as Union. Be sure the Common field are Assign Correctly in Multiprovider.

3) In Multiprovider based query, there are option in RKF to restrict the data based on Infoprovider filter. make sure, there should not be any such filter other then your requirement.

Thanks

Pratyaksh Jeet

[Former Member · Accepted solution]

Hi pratyaksh jeet,

I will do the analysis step by step as you suggested me and get back to you.Thanks alot for your reply .

Thanks and regards ,

Jyots

[Former Member · Accepted solution]

Hi  Pratyaksh jeet ,

1) I checked both the cube data is having same fiscal periods .

2)I checked identification at multi provider its correct ,bec i can find correct data at multi provider level.

3) In Multiprovider based query, there are option in RKF to restrict the data based on Infoprovider filter. make sure, i dint use any restriction here.

Please guide me still my problem is same .I am waiting for your reply.I have to move to production.

Thanks and regards,

jyotsna singh

[former_member241863 · Accepted solution]

Hello jyotsna singh,

Can you share the Query screen shot and Please pick up some common records (5 records max) from both the Cube and put it in Excel and share here.

And also share multiprovider fields assignment of common fields of the cubes.

Thanks

Pratyaksh Jeet

[Former Member · Accepted solution]

Hi Pratyaksh jeet,

I am attaching the screenshot ,below one is at analyser

[Former Member · Accepted solution]

These are common identification from both the cubes and i am attaching to have better clearity

[former_member241863 · Accepted solution]

Hello jyotsna singh,

Thanks for sharing the screenshot..

1) First check in Multiprovider - below fields should be assigned to fields in both the cubes.

Fiscal period

Sold to party

Region

Country

Document type

Billing type

As i know Document belongs to SD Document type in cube 0sd_c03 and Billing Type belongs to AC billing document 0fiar_c03.

2) Remove all the characteristics from query except Fiscal Period. Now you will see data will come in all the Key Figures (If Fiscal period is assigned to fiscal periods in both the cubes).

3) Check if data available in cube 0fiar_c03 for Customer 40071. If the data is coming, check Fiscal period from that data and put in query filter. Now you will be able to see data in all key figures. (Only Customer 40071 in Filter and other filters should be blank).

If point 2 should be as expected, do analysis for other fields also and let me the result.

Thanks

Pratyaksh Jeet

[former_member241863 · Accepted solution]

Hello ,

Thanks for sharing the Screenshot.

You can see the Region is only assigned to 1 Cube (1 to 1 assignment). Region will come only for assigned cube.

Check the Billing Type also. I think it also assigned to 1 Cube.

Thanks

Pratyaksh Jeet

[Former Member · Accepted solution]

Thanks alot Pratyaksh jeet for your quick reply ,really appritiated.

I am following all your points step by step ,will let you know as soon as i get any result.

Thanks and regards,

jyotsna singh

[Former Member · Accepted solution]

Hi Pratyaksh jeet,

I got all data for billing type, region and net value as i followed all your suggestion it was so clear and helpful,thanks alot.

now, i am having only one problem (0region) key i got but its text is not coming .at 0region datasource i dropped data and loaded again in DEVELOPMENT but no change.no text is there for region .

I am attaching screenshot for you.

Thanks and regards,

jyots

[Former Member · Accepted solution]

Please check region data and suggest me what can i do to get correct region key and text.Also how can i remove # from region key.I am waiting for your reply.

[former_member241863 · Accepted solution]

Hello,

Check the Data (Region = 07 and Country = IN) in Table /BI0/TREGION.

If this record having entry in Short Description (Region Text).

Then check the display properties of 0Region in BEx.

OR

You can change the InfoObject Properties in Analyzer also.

Thanks

Pratyaksh Jeet