Sap BO multisource universe

[Former Member]

Hi,

What is multisource universe??.

in the case of one BW cube source and another one is Hyperion datasource??

how we can create universe based on these two data sources,

Thanks in Advance.

[TammyPowlas · Accepted solution]

Please see this tutorial on multi-source universes

http://scn.sap.com/docs/DOC-22055

Also, I recommend in the future posting this in the Semantic Layer space at http://scn.sap.com/community/semantic-layer

[Former Member]

Hello Nitin,

We can create multisource universes only on Relational datasource.
In your scenario both of your datasources are OLAP cubes(SAP BW& Hyperion ) . So we can not create a multi source universes based on these two datasources.
We can create multi source using SAP BW using relational JCO connection with any other relational datasource.

hope this will helps you

Thanks,
Pramod.

[Former Member]

Thanks Pramod,

Can we create universe based on two or more info cube(sap bw),two dso, two or more multiprovider?????

Thanks in Advance.

[Former Member]

Hi Nitin,

Yes we can create a universe based on two or more infocube, two dso, or two multiprovider.

Steps:

1.Login to IDT and create a session to your BOE Server.

2.After the session is established, right click on 'Connections' folder and select 'Insert Relational Connection'

3.Click on 'Next' and select 'SAP JCO Connector' as your middleware and provide your BW credentials.

4.Test the connection.

5.Select the 'infocube', 'dso', or 'ultiprovider' and select 'finish'.

6.Create one more connection by following the same steps from step 2 to 5 in Repositary Resources.

7.Create Shortcut of these two connections in local project.

8.Create a new data foundation and select 'multi source' and click on 'next' and select the two created relational connections.

9.Create the data foundation by keeping all the default options selected(recommended)

10.Create a new business layer on top of this data foundation by keeping all the default options selected(recommended)/

11.You can publish this to the repositary and use the unx for reporting.

Thank you

Hyder

[Former Member]

Hi,

What if my data source is just a Multi Provider from SAP BW..

Should I go with OLAP or Multi Source Connection

we are on sap bi 4.0 and sap bw 7.3

regards

Rajeev

[bharathsap]

Hi Rajeev,

You should go with OLAP connection.

Regards,

Bharath