Change dataprovider on webi report - SDK

[Former Member]

Hello, in a nutshell, is it possible to change the dataprovider of a webi report through the .NET sdk? I have read on the forum it is only possible with the JAVA SDK? I can readout all information of the webi report datasource/dataprovider, but it is readonly.

Can somebody confirm or better tell me how to it with the .net sdk

Regards Ingmar - bilifecycle.com

[ted_ueda · Accepted solution]

ReportEngine .NET (RE.NET) SDK does not have the functionality.

ReportEngine Java (REBean) SDK does.

Sincerely,

Ted Ueda

[Former Member · Accepted solution]

Ted, thank you for your answer. After doing some testing it seems that Webi can change the universe itself?

Scenario:

1.In Development is a webi report: webireport1

webireport1is linked to universe1, which is also in development.

2. You export universe1 to Test. (The result is that universe1 is a new universe with a new ID)

3. You copy webireport1 from Development to Test (The result is that webireport1 is a new report with a new ID)

4. If a User, only member from Test, refreshes webireport, it use universe1 in Test.

Is this way how BO should work?Can you confirm this?

Regards Ingmar

[ted_ueda · Accepted solution]

Web Intelligence wid files references Universes in two ways - by the Universe CUID value (SI_CUID when you query for the Universe InfoObject), or by the Universe short name (SI_SHORTNAME).

The SI_ID of an Universe changes, but migrating a Universe (not just redeploying to a different Enterprise deployment) keeps the SI_CUID value the same.

If a Universe with the SI_CUID value is not available on the system, the it picks a Universe with the same SI_SHORTNAME.

You can determine if the Universe is being referenced by CUID or Shortname by querying for the Universe in Query Builder, and seeing if the SI_UNIVERSES property is filled. If that property is empty, then the Shortname is being used. Referencing Universes by shortname is dangerous, since you won't know which Universe is being used.

Sincerely,

Ted Ueda

[Former Member · Accepted solution]

Very good comments! I have some additional info >>

Web Intelligence wid files references Universes in two ways - by the Universe CUID value (SI_CUID when you query for the Universe InfoObject), or by the Universe short name (SI_SHORTNAME).

Ok

The SI_ID of an Universe changes, but migrating a Universe (not just redeploying to a different Enterprise deployment) keeps the SI_CUID value the same.

Ok

If a Universe with the SI_CUID value is not available on the system, the it picks a Universe with the same SI_SHORTNAME.

Ok, perfect. Tha't solves my problem! In practice, an user sould only be able to access 1 universe at a time avoiding conflicts. Like ZABO in BO 6 couldn't handle access to e.g. acceptance and production universe at a time. It would give an error. The fullclient however gives you at least the option to choose...

You can determine if the Universe is being referenced by CUID or Shortname by querying for the Universe in Query Builder, and seeing if the SI_UNIVERSES property is filled. If that property is empty, then the Shortname is being used. Referencing Universes by shortname is dangerous, since you won't know which Universe is being used.

Like explained above, we always make sure an user has only access to 1 version of an universe and report. Please let me know your thoughs if you have doubts or comments about this construction!

Sincerely,

Ted Ueda

Thank you for explaining how the process works! Regards Ingmar