on 11-19-2007 7:43 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Do you have aggregates,if yes have they been rolled up?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
debug our query in RSRT with Multiprovider+ Explain option , you shd be able to figure it out.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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...
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.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.