Skip to Content
author's profile photo Former Member
Former Member

Migrate the WEBI report from one CMS to another

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.

Figure 2.png (12.6 kB)
Figure 3.png (82.1 kB)
Figure 1.png (11.1 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jun 09, 2014 at 12:55 PM

    Hi Andre,

    Can you try migrating the report and universe using Import Wizard and check if it works fine?

    Regards,

    Yuvraj

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.