Skip to Content
author's profile photo Former Member
Former Member

update from various sources to same cube

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 29, 2011 at 07:19 PM

    HI,

    1.Yes It will aggegate the data from the values coming from both the data sources matching their corresponding characteristic.

    2. As per SAP Extended Star Schema; query generally looks for the value in the fact table first and then takes the corresponding characteristic or Master data from the SID table and dimension table. So in this case OLAP processor will first look for KF4 value in the cube and then its corrsponding characteristic from the cube.

    Navesh

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      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.

      Yes, data will be displayed based on DS1 and DS2 as both of them 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)

      Olap will generate sql statement based on your query. As you query is having only X, then it will search all the entries for X in KF4 and display the values.

      Thanks

      Srikanth

  • Posted on Sep 30, 2011 at 05:51 AM

    Hi,

    It depend on many things. Which are the fields and charateristics avauilable. Since you have mentioned char X means I am assuming char are same in both the cubes.So in your case

    1. KF1 will get aggregated. You can use Infoprovider object if possible which can be drilled down to see how much value belongs to which Infoprovider.

    2. You can also have source system object defined and can be used in quiery to distinguish on KFS values from different Infoproviders.

    3. Fact table normally contains the data record with char and key figure value record. And this Char is related to Dimension Char object with Dim ID and it keep on looking up these joins like DIM ID and SID ID to retrieve the values in the report.

    Thanks and regards

    Kiran

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 29, 2011 at 02:42 PM

    Hello,

    1. Yes, it will aggregate data for both DS for X. It works like this simplified command: SELECT sum (KF1) FROM CUBE GROUP BY X.

    2. It generates SQL command and it depends on SQL server beneath how it is calculated. It seems illogical to select result first by key figure (since it is not indexed) and than by indexed characteristic. However SQL evaluating algorithms are quite sophisticated so you may want to look at them.

    BR

    Ondrej

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.