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:
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.