cancel
Showing results for 
Search instead for 
Did you mean: 

Multiprovider Issue

Former Member
0 Kudos

Hi Guys

We have one cube (A) which is coming out of 2 LO Cockpit data sources (VAKON and VAITM)

Another cube (B) which is purely coming out of VAKON.

We have a multiprovider with this 2 cubes...

Now When we created a query on this multi provider and bring some KFs from Cube A (KF1, KF2, KF3) and Some From Cube B (KF4, KF5,KF6) , we are not able to see the values for Cube B KeyFigures..Its always showing 0

I checked in Cube B data my manage and those KeyFigure values are coming perfect....But why the query is not showing those values ? where as Cube A's Key Figures are showing correctly in the Report...Is there any reasons for this..Any one has any idea...Help will be apprecicated

Regards

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Check following:

1) Aggregates on cube B: rolel dup or not...any red req..

2) Check Multiprovider definition: whether KF have been selected from cube b or not...

If nothing is working -> then go to RSRT : Run> KF explain..

Hope it helps

--SA

Former Member
0 Kudos

Do you have aggregates,if yes have they been rolled up?

Former Member
0 Kudos

debug our query in RSRT with Multiprovider+ Explain option , you shd be able to figure it out.

Former Member
0 Kudos

HI,

Check identifcation tab in multiprovider, u are using correct joining conditios.......???

Former Member
0 Kudos

Thanks Manga

I got the point , but Iam not getting how to fix this problem. According to RSRT , I came to know that the message nr DBMAN 135 is my query problem...i.e,

DBMAN 135:The key figure either does not exist in the

InfoCube/InfoProvider mentioned or it is not selected for the

MultiCube/MultiProvider at least.The partial query will therefore

not read any values for this key figure.

Now in my Infocube the keyfigures from Cube B (KF4, KF5, KF6) which am mentioning before are not existed at all in Cube A. The desing was made by some one else and now I need to fix this issue.Do you think , I need to include the Key Figures in my Cube A as well in order to get those values?

FYI at the same time , KF1 , KF2 ,KF3 from Cube A is also not available in Cube B.Then why the report is showing these Key figure values correctly ?

Please advice

Regards

Former Member
0 Kudos

To simplify all these just click <b>ALL</b> when Identifying Chars and Keyfigures and make sure you have dragged all keyfigures into the MP ( on to right handside from Cubes )

Former Member
0 Kudos

Hi Jerome and Gaurav

Thanks for the inputs

I have no aggregates on this cubes...also I check the multiprovider and kF1, KF2,KF3 are assigned to Cube A...where as KF4,KF5,KF6 are assinged to cube B

When I checked in the manage tab, both the cube's requests are having tickmark for compression status...

any advices...

Former Member
0 Kudos

Check the report definition..any filters...restricted KF?

Also update DB statistics and then try running query again..

--SA

Former Member
0 Kudos

Check the definition of your Multiprovider , for cube B fields that are joined with cube A and check those records are matching..

If you are leaving your query wide open and you dont see any reocrds coming from Cube B then you might have to check your MP definition and how you have choosen your fields.