Skip to Content
0
Former Member
Jun 02, 2014 at 05:29 AM

Migrate the WEBI report from one CMS to another

72 Views

Steps :

  1. We have create a Universe (Universe_1) and Export into CMS_1.
  2. Logon to Webi rich client using CMS_1 credentials, select Universe_1 and create a report.
  3. Save as this Report (WebiReport_1) into file system with advanced option (Sava for All User, Remove Document Security).
  4. Migrated Universe_1 from CMS_1 to CMS_2 (Using our tool). Same connection is available on CMS_2 also that is used by universe_1. Now Universe_1 is working perfectly fine on CMS_2.
  5. Opened Webi Report (WebiReport_1) in Webi Rich Client and saved into CMS_2.
  6. Now when we opened the Webi Report we gets below mentioned errors.

"You do not have right to access data returned by this Universe. (WIS 00505)"

Please look into Figure 1 and Figure 2 in attached screenshot.

This can be fixed from rich client by change source option, as mentioned below.

Please look into Figure 3 in attached screenshot.

Here are the issue details which we want to discuss with you.

Actually our requirement is we need to achieve above mentioned functionality by SAP SDK. We are trying to fix this error using SAPBI 4 Restful Service. Below are the steps which we have tried to resolve this issue.

Request (Changing the data provider for Report imported in CMS_2)

GET http://<serverName>:6405/biprws/raylight/vx/documents/{documentId}/dat

aproviders/mappings?originDataproviderIds={DP1Id}&targetDatasourceId={DatasourceId}

Response:

<error>

<error_code>999</error_code>

<message>Internal error (RaylightAction)</message>

</error>

Expected response

<mappings>

<content>

<mapping status="Ok">

<source>

<id>DS0.DO12</id>

</source>

<target>

<id>DS1.DO12</id>

</target>

</mapping>

<mapping status="Ok">

<source>

<id>DS0.DO13</id>

</source>

<target>

<id>DS1.DO13</id>

</target>

</mapping>

</content>

</mappings>

As we are not getting the expected response, we are not able to post the change and update the mappings.

Request (Getting the details of a data provider)

GET http://<serverName>:6405/biprws/raylight/vx/documents/{documentId}/dataproviders/{dataproviderId}

Response:

<error>

<error_code>999</error_code>

<message>Internal error (RaylightAction)</message>

</error>

Queries

  1. Changing the data provider for Report is not working in multi CMS scenario. This works fine in single CMS
  2. How can we achieve this mapping change in case of multi CMS using restful services?
  3. Is there any other way around to achieve this functionality using .NET SDK?
  4. We are also not able to get the response for data provides details using restful service by passing {dataproviderID}.

Error screenshots are attached.

Attachments

Figure 2.png (12.6 kB)
Figure 3.png (82.1 kB)
Figure 1.png (11.1 kB)