on 08-03-2015 2:58 PM
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
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.
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.
4) Why some BI tools can only access OLAP connections and do not access universe, for example, analysis for office and analysis for OLAP?
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Amit
Thank you for the information, especially regarding the BO BW SSO authorization.
Thanks,
Emerson
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Using OLAP or relational database is a wider questions than using BW or relational universe but you can start from here :
Dimensional Relational vs. OLAP: The Final Deployment Conundrum - InformationWeek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.