Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

OLAP connection or Universe?

Hi People

I would like to understand what is the best strategy to implement a new BI enviroment.

We just have to acquire the BI plataform and we have doubts if you have to develop the reports using universe or BW queries.

We don't have HANA yet, only the ERP with relational database, we have configured two connections to ECC in BI platform: OLAP and Relational connection.

1) What is the advantages and disadvantages of each type of connection (OLAP and Relational)?

2) Is the universe the best approach? Do we have to stop creating BW queries and start to work only with universes?

3) I also have doubts how to apply a security police in OLAP connection since the user name and password is configured in the connection. Does the BI platform check the BW authorization from the user that is accessing the report? We have a cost center report to develop, but the users can only access the information for the cost center he is authorized to. Is it possible to restrict this access in a OLAP connection?

4) Why some BI tools can only access OLAP connections and do not access universe, for example, analysis for office and analysis for OLAP?

Thank you,

Emerson

Former Member
replied

Hi,

1) What is the advantages and disadvantages of each type of connection (OLAP and Relational)?

See attached link to understand the  BICS vs universe.Certain features are only available via BICS. BEx query Calculated /Restricted KF's variables.

When to use BICS

•Designed cube, queries and elements like variables, restricted/calculated key figures.

•re-use of BEx Queries just by a single click.

•No need of manually maintain/create universes. Any changes in BEx query will reflect in the web intelligence without any click.

When to use Universe.

•combine data from different sources (SAP or non-SAP)

•Detail level reporting.

•Self-service reporting

There are certain webi features which are not available with BICS connection.

•Add a combine query

•Retrieve duplicates reports checkbox

•No webi query filters on BEx navigation attributes

•OR condition between the prompts

•Matches Pattern in Prompt

•Object from this query

•Result from another query

•Is Null and Not Null in Prompt

There are certain workarounds can implement for these function in report level but workarounds are depend on the complexity/functionality of report.


BICS vs BAPI vs DF Relational Connection

2) Is the universe the best approach? Do we have to stop creating BW queries and start to work only with universes?



This based on the requirement.

•For customers who have already invested heavily in SAP BEx queries, SAP recommends using direct access on SAP BEx queries (no need for universes).

•For new customers or new projects, SAP’s suggestion is to evaluate both SAP BEx query and multi-source enabled universe solutions based on the business needs and IT constraints.


3) I also have doubts how to apply a security police in OLAP connection since the user name and password is configured in the connection. Does the BI platform check the BW authorization from the user that is accessing the report? We have a cost center report to develop, but the users can only access the information for the cost center he is authorized to. Is it possible to restrict this access in a OLAP connection?


For this you can enable the BO BW SSO for data level authorization.

How to setup SSO against SAP BW with SAP BO BI4.0 Common Semantic Layer (UNX) or BICS - Business Intelligence (BusinessO…


4) Why some BI tools can only access OLAP connections and do not access universe, for example, analysis for office and analysis for OLAP?


BICS vs BAPI vs DF Relational Connection


Amit



1 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question