cancel
Showing results for 
Search instead for 
Did you mean: 

Data not display in one of the field of Multiprovider

Former Member
0 Kudos

Hello Gurus

I am using two cubes 0PY_C02 and ZIC_DESG and create Multiprovider ZMPAYDESG.

The Characteristics of ZMPAYDESG are 0EMPLOYEE,0PERSON,ZHRDESG,0COUNTRY_ID,0WAGETYPE.

Time Characteristics of ZMPAYDESG is 0CALMONTH.

Key Figure of ZMPAYDESG is 0Amount.

I checked Identification.

Now my problem is the values in Deminsion are there for Desg. But when I run the query vlues for desg show #.

Does anyone have the idea what might be the reason?

Thanks and regards

Minaxi Shah

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Did you load data for desig ?

Did you map the update rules for designation?

Do you have proper identification in the multi cube?

Ravi Thothadri

Former Member
0 Kudos

Hi Ravi,

Thanks for reply.

Yes, I had Load the data for Designation and also execute queries depend on

Infocube ZIC_DESG. They are working fine.

But in Multicube the data not display using LISTCUBE.

minaxi shah

Former Member
0 Kudos

Hello Gurus,

As per Your reply I Checked the data in multicube using LISTCUBE, but the data for DESG not shown. So I had enhanced 0Emlyoee_ATTR by adding DESG by append structure.

Load the data sucessfully in 0Emplyoee_ATTR. The data display in attruibutes of 0emplyoee master data. But when I run the query desg is display as #.

Minaxi Shah

Former Member
0 Kudos

Hi,

You misunderstood the Multi provider concept.

For general info about the concept of Multi provider working:

Take DESG characterstic into the cube 0PY_C02 also.in the update rule(of cube) for this Infoobject take Master data lookup concept.

Make the Identification mapping for the IO DESG of Multiprovider iwth the chacterstic DESG of both cubes .

Then activate the Master data 0Emlyoee_ATTR.

Reupload the data into 0PY_C02.

With rgds,

Anil Kumar Sharma .P

Message was edited by:

Anil Kumar Sharma

Former Member
0 Kudos

Hi Anil,

Thanks for your quick reply. Really you are guru of BW.

Sir, I add Desg in infocube 0PY_C02 and activate it. But I don't follow regarding update rule of infocube of 0PY_C02.

Could you give me clear picture regarding this.

Thanks in advance and reagrds,

Also congratulaion for getting lot of points.

edited

Hello Anil,

I am little bit confuse. Please clear it.

1) when I create a multi provider ZMPAYDESG using cubes 0PY_C02 and ZIC_DESG. I have to add Zdesg infoobject in 0PY_C02 cube and then activate the update rules ?

or

2) Drop down the idea of multi cube and enhance 0EMPLOYEE_ATTR AND load the data in 0EMPLOYEE. and add zdesg in 0py_c02 and activate both ic and update rules?

Please reply.

Minaxi shah

Message was edited by:

Minaxi shah

Answers (6)

Answers (6)

Former Member
0 Kudos

Hi all,

Thanks for supports.

The problem is solved.

Regards

Minaxi shah

Former Member
0 Kudos

Look into the basic cube for data and not the multi provider.

Follow the sequence for loading.

1. Load master data, texts , activate and apply change run.

2. Then load the transaction data.

Give a check of the multi provider definition and ensure proper mapping of the info objects in the basic cubes.

Ravi Thothadri

Former Member
0 Kudos

please mark unanswered.

Former Member
0 Kudos

Hi,

Did u load master data or not,plz check it once

Former Member
0 Kudos

Hi Minaxi,

For multiprovider queries. follow the checklist.

1. all the characateristics which are in rows in the query should be available in both the cube.

2.characteristics on which restriction/filter is created, should be available in both the cube.

Hope that helps.

Regards

Kapadia

***Assigning points is the way to say thanks in SDN.***

Former Member
0 Kudos

Hi,

Check the output in the transaction LISTCUBE it will give you better picture of the data coming in the multicube.

Check whether the char in the rows of the report is coming from one of the cube only and the key figure which you are looking is coming from different cube.

Also check for the selections on the report if the selection variable is on a char having identification from only of the cube.

this can cause the filtering of data from one of the cube and you will get all the value as # for that particular field.

Thanks

Former Member
0 Kudos

Hello Ajeet,

Thank for replay. In TCode LISTCUBE the data for desg and person are not coming.

Actually DESG belongs to ZIC_DESG and other fields belong to 0PY_C02.

The key figure belongs to 0PY_C02.

Minaxi Shah