SDK Code for bulk opening of Webi reports and Save

[Former Member]

Hi,

Is it possible to bulk open webi reports using SDK and save it again.

Thanks,

Chandra

[Former Member · Accepted solution]

Hi Chnadra,

This is still possible thorugh the Report Engines SDKs in BI 4.x.

Please use the attached script to open all the web intelligence documents present in the repository & saves it back to enterprise.

Hope it helps!

Thanks,

Shailendra

fixWebi.txt.zip

[Former Member · Accepted solution]

Thanks Shailendra for the reply. Can you let me know if this can handle prompts if the report is refresh on open?

Regards,

Chandra

[Former Member · Accepted solution]

Hi Chandra,

No, This script is for only opening the webi document & saves it back to enterprise without any processing.

If your webi document have the refresh on open & last prompt value selected properties checked then you don't have to modify the code.

If you want to handle the prompt as well, then you have to modify the code & write the application flow like below:-

1. Logon to enterprise.

2. get infostore service.

3. get all the webi documents into infoobjects collection

4. get engines services.

5. load document instance.

6. clear the prompt values & set it with new value.

7. saves the report back to enterprise.

The 6th point is mossing from the script. You can add that piece of code in the attached script also you can take help from the sample codes & Developer guide & API references.

Thanks,

Shailendra

[DellSC · Accepted solution]

You can also take a look at the new RESTful web services for this process.

-Dell

[Former Member]

Thanks much guys....very helpful. I will let you once I complete my testing.