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

Analytical View

Hi All

Just a couple of questions hit my mid why creating the analytical views.

In the data foundation, am able to add only the table but not the attribute views and in logical view, am able to add attribute view but not tables.

1. Am just assuming that, this is because in the data foundation view we can add only tables which are physically existing and in the logical view we can only logical tables i.e. Attribute view. Just correct me if am wrong ?

2. Out of this two which one will have better performance and how ? I mean, if we create a analytical view with no logical view in it ( mean that am using the direct master data tables in the data foundation and linking them to the fact table) or if we create a analytical view with logical view ( i.e. create a attribute view for the master data tables and use this in logical view while designing the attribute view and linking to the fact table ). Out of these two which one will have better performance.

Regards

Prashanth

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jun 02, 2013 at 08:33 PM

    Hi Prashanth,

    My two cents highlighted in blue:

    Prashanth Reddy wrote:

    Hi All

    Just a couple of questions hit my mid why creating the analytical views.

    In the data foundation, am able to add only the table but not the attribute views and in logical view, am able to add attribute view but not tables.

    Yes, that is how it is supposed to behave and designed.

    1. Am just assuming that, this is because in the data foundation view we can add only tables which are physically existing and in the logical view we can only logical tables i.e. Attribute view. Just correct me if am wrong ?

    Correct, the data foundation can contain physical tables and not objects like views. The views can be added to the logical view.

    2. Out of this two which one will have better performance and how ? I mean, if we create a analytical view with no logical view in it ( mean that am using the direct master data tables in the data foundation and linking them to the fact table) or if we create a analytical view with logical view ( i.e. create a attribute view for the master data tables and use this in logical view while designing the attribute view and linking to the fact table ). Out of these two which one will have better performance.

    The joins defined in the data foundation for physical tables of attribute view or Logical view for attribute view itself defines the performance. In most of the cases, these are referential joins or left outer joins (depending on the functional requirement).

    The main reason for defining the "Attribute View" is for re-usability. The defined attribute view can be used in the given format, encapsulating the underlying joins for the text tables and language dependency in the attribute view.

    You can join all these tables used in the attribute view definition even in the data foundation, but you will have to use them in each and every Analytic view data foundation where ever the attribute view tables are required. This adds to development effort and eventually has high impact on maintenance. In case, a new attribute column needs to be added, then it will have to be added to all the data foundations in all the Analytic views. If you use the attribute view, then the change needs to be done only at one place.

    Regards

    Prashanth

    Regards,

    Ravi

    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.