Skip to Content
0
Former Member
Sep 29, 2011 at 12:05 PM

update from various sources to same cube

15 Views

Hi ,

I have one basic question about data in infocube and how OLAP processor picks data from cube and shows in report?

Lets consider I have three different datasources DS1,DS2,DS3 and these datasources are connected to cube through three seperate transformations and data is being updated to cube from these sources.

Cube has following fields:

Characteristic: X

Keyfigures: KF1,KF2,KF3

Datasource DS1 is connected to cube through transformation and updates X,KF1,KF2

Datasource DS2 is connected to cube through transformation and updates X,KF1,KF3

Datasource DS3 is connected to cube through transformation and updates X,KF4

Now my doubts are:

1.If I run a query on X and KF1 using query designer,will it show values of KF1 from both sources DS1,DS2 aggregated together as both DS1 and DS2 are updating KF1.

2.If I run a query on X,KF4 using query designer,how does the OLAP processor really works in background?

-


Does it first look for keyfigure KF4 in cube and pick the corresponding Characteristics X or will it go and look for X in dimension table and pick the corresponding KF4 from fact table?(I generally thought it picks first characteristics from dimension table and then corresponding keyfigures from fact table but I noticed some places where its working otherway round)

Thanks for your input.

Regards.....