Skip to Content
0
Former Member
Feb 20, 2011 at 06:52 PM

infocube -data update

35 Views

Hi

I have few questions about how data will be updated into a cube...I assume that I have 'Addition' as update....

1.Suppose I have following infoobjects in cube where char1,char 2 are characteristics and KF1,KF2,KF3,KF4,KF5 are keyfigures...Char1,Char2 are keys also....

and cube is getting updated by two DSOs....so I have two requests from these two DSOs in Manage tab of Infocube...

in Request 1 from DSO1,we are getting data for Char1,Char2,KF1,KF2 of cube(as the transformation is like that between them) and in Request 2 from DSO2,we are getting data for Char1,Char2,KF1,KF3,KF4,KF5(AS the transformation is like that between cube and DSO2)....so how will the data be in cube if the Char1 and Char2 values are same..will it be like below:

ReqID Char1 Char2 KF1 KF2 KF3 KF4 KF5

Req1 x1 y1 1 2

Req2 x1 y1 2 3 3 3

what value will be there in cube in cases where any keyfigure is not updated?

2.Suppose I run a query ,with ReqID,Char1,Char2 in rows panel and KF1,KF2,KF3,KF4,KF5 in columns panel...will the result be like below?...

ReqID Char1 Char2 KF1 KF2 KF3 KF4 KF5

Req1 x1 y1 1 2 0 0 0

Req2 x1 y1 2 0 3 3 3

3.If I run a query with only Char1,Char2 in rows panel and KF1,KF2,KF3,KF4,KF5 in columns panel,....will the result be like below

Char1 Char2 KF1 KF2 KF3 KF4 KF5

x1 y1 3 2 3 3 3

4.will the data look like in point 3) if I compress the data in infocube(as I heard compression sets ReqID to 0 for all request IDs)?

Thanks for your answers.