Want to build a Webi on MultiProvider/InfoSet or Query of MultiProvider

[Former Member]

Hi Experts,

I want to build a Webi Report on MultiProvider/InfoSet or Query of MultiProver/InfoSet.

I think that this is not possible with Universe.

It is possible through BVM.

I am not able to connect to SAP BI through BVM using the following steps;

Data Connection

Dynamic Data Connection

Data Foundation

Business Element

Business View

List of Values

Please help me how to connect to MultiProvider.

Thanks in Advance.

Regards,

Rafi

[former_member142702]

You can build a universe on top of a BEx query that accesses a multiprovider.

Business Views are only usable in CRystal Reports. Still if you want to build a CR report on an SAP BW data source you should use the BW MDX driver, which is delivered when installing the integration Kit for SAP solutions.

The integratzion Kit for SAP solutions is also required if you want to build a universe on top of a BEx query.

Regards,

Stratos

[Former Member]

Hi Efstratios Kara,

I have created Webi Reports using Universe on InfoCube and Query of InfoCube and Query of DSO.

Now i want to create a Report on MultiProvider and InfoSet.

Please tell me how can i create a Webi Report based on MultiProvider/InfoSet ?

Regards,

Rafi

[former_member142702]

1) Build a BEx query on your multiprovider

2) Build a universe based on the BEx query created in step 1.

3) Build your WebI report based on the universe created in step 2.

Regards,

Stratos

[Former Member]

Hi Efstratios Kara,

I already tried these steps what you told me.

I created a MultiProvider and then created Query on that MultiProvider.

But i am not able to connect to it through Universe.

Please tell me you have done this.

Regards,

Rafi

[former_member142702]

What is the exact problem. DO you get an error when you try to create a universe or are n't you able to see the query at all when you try to create your universe? If the query is not visible make sure you set the "Allow external access" option by opening the query in the BEX Query designer.

Regards,

Stratos

[Former Member]

Hi Efstratios Kara,

"Allowed External Access" in the Query.

When creating Universe at the final stage, i am getting a problem.

The exact message i will post you tomorrow because i don't have access in the office.

The message is " Internal Problem ".

I will go home and post you the exact message tomorrow.

Anyhow thank you for your communication.

Regards,

Rafi

[Former Member]

Hi Efstratios Kara,

I have created a WebI Report on MultiProvider's Query.

Cannot we access MultiProvider/InfoSet directly to Universe ?

I tried to connect MultiProvider/InfoSet to Universe but at the end when i say "O.K".

It is giving me message "Connecting Error"

Anyhow thaks for your communication and assigning you points

Regards,

Rafi

[former_member142702]

You can build a universe either on top of an infocube or a BEx query.

Please note that SAP recommends to build universes on top of BEx queries.

Regards,

Stratos