What is difference between a Relational and an OLAP connection?

1.	What is difference between a Relational and an OLAP connection?
Answer» The idea is basically if you need to access data from a table and regular RDBMS then your connection should be a relational connection but if your source is an application and data is stored in cube (multidimensional like Info cubes, Information models) then you would use an OLAP connection. Relational connection can only be created in IDT/UDT. OLAP can be created in both IDT and CMC. Another thing to note is relational connection (including HANA) will always produce a SQL statement to be fired from report while OLAP connection normally create a MDX statement.

Answer»

The idea is basically if you need to access data from a table and regular RDBMS then your connection should be a relational connection but if your source is an application and data is stored in cube (multidimensional like Info cubes, Information models) then you would use an OLAP connection.

Relational connection can only be created in IDT/UDT.

OLAP can be created in both IDT and CMC.

Another thing to note is relational connection (including HANA) will always produce a SQL statement to be fired from report while OLAP connection normally create a MDX statement.

Discussion

No Comment Found

Related InterviewSolutions

How do you hardcore values in a data model in Dashboard?
What are the different data connections that are supported in Dashboard Designer?
If you want to use same layout, appearance for all the data models in Dashboard designer, how you can do this?
What are the default template categories in Dashboard data model?
What is query refresh or query prompt under Universe component?
What is web connectivity components? What are the different component types?
What is the use of single value component? What are the different styles of single value component?
What is selector component? What are the different types of selector component?
What is a container component? What are the different types of Container?
What are the different chart types available in Dashboard?