Skip to Content

Analytical Reporting BI4.2, Not able to add Query and datasource usind rest SDK

Jun 27, 2017 at 05:40 AM


avatar image
Former Member

We are migrating BOXI3 to BI 4.2 for the reporting application. Earlier we used the Analytical component to pre select the universe, but in bi 4.2 to we are not able to add an universe (pre selected universe to the document using rest api) in the query panel.

could you please suggest alternative to solution to pre select the universe while creating new webi document.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Manikandan Elumalai Jun 27, 2017 at 02:08 PM

Could you please elaborate this bit more?

10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jun 28, 2017 at 04:16 AM

I have created report document using rest api and it got created successfully.

(post url to create document : http://{0}:6405/biprws/raylight/v1/documents

Xml to post : <document><name>Some unique report name</name><folderId>13025</folderId></document>)

My requirement is, When we open new report, we do not need to select universe again.

We try to use data provider api to add data source like below :

api to call : http://[server ip]:6405/biprws/raylight/v1/documents/15698/dataproviders

post xml format : <dataprovider><name>[i put universe name here]</name><dataSourceId>[i put here universe id]</dataSourceId></dataprovider>

After calling api to add data provider, got its result like

The resource of type "Data provider" with identifier "DP0" has been successfully created.

But when I open report , I always need to choose universe.

I do not want user to choose universe as it already set in data provider.

I want user only needs to add query.

Please let me know if any information.

Thanks in Advance.

10 |10000 characters needed characters left characters exceeded