cancel
Showing results for 
Search instead for 
Did you mean: 

Doubt on OLAP Business layer

former_member187092
Participant
0 Kudos

Dear Experts,

I am new to IDT. I have started getting the concepts.

My doubt is, OLAP Business layer will created without using Data foundation.

In this case, don't we need schema for the relevant tables huh? . How the normalization of tables and joins will be handled? .

can anyone please explain me ?..

Thanks in Advance!

Bala Krish

Accepted Solutions (1)

Accepted Solutions (1)

former_member4998
Active Contributor
0 Kudos

Hi

while creating universe you have two options to select the connections

  1. OLAP Connection
  2. Relational Connection

As per your requirement you have chosen OLAP Connection i think.

So OLAP connections to connect to an SAP NetWeaver BW data source based on a BW server, a cube, and a BEx query.

If your backed as BW ...then No business layer or universe is required to access BEx queries. We can directly select the BEx query as a data source.

You can do all the calculations & data restriction (CKF, RKF, Filters and Variables) and use Bex Q as direct source.

Please find the below link. To know the difference b/w OLAP and Relational connections and what are the advantages using the OLAP connection.

SAP BW is an OLAP vs. Relation connection

http://scn.sap.com/community/semantic-layer/blog/2014/04/14/sap-bw-is-an-olap-vs-relation-connection

Answers (1)

Answers (1)

Former Member
0 Kudos

For OLAP Business layer, we use OLAP connection to info providers in SAP BW. Hence the structure is directly referenced from the structure of providers in SAP BW.