Get Webi Report Column Details using SDK

[Former Member]

Hi,

Is it possible to extract the variable/formula used for each of the report block in Webi Intelligence report?We can get the objects used in WEBI report using Java SDk in 3.1.But we need to get details of only those variables/formulae which are used in the report blocks

[Former Member · Accepted solution]

Hello Dipanjan,

You cna get this information using the report engine sdks of BusinessObjects which is specific to webi reports.

Please refer to the link to download the dev guide and api referrence for XI 3.1

Refer to the Report Engine Java SDK dev guide and api referrence.

Go through the dev guide in detail and you would be able to use the report engine sdks as per your needs.

Additional Note: There have been changes in report engine sdks from XI 3.1 to BI 4.0 and you would not be able to get all the features available in XI 3.1 report engine sdks in BI 4.0.

Hope this helps.

Thanks,

Prithvi

[Former Member · Accepted solution]

Hi Prithviraj,

Thanks for your reply.But I really did not get any API which can directly map to the report column.Did anyone else try this out?

[Former Member · Accepted solution]

Hi Dipanjan,

You can read the report structure of a WebI report.  (method getStructure() in DocumentInstance).

You iterate the ReportElement(s) and analyse the element type. You can identify the type (e.g. free cell, report block, report cell ...).

A report block can be a cross-table, form, graph, simple-table, table or table-form-base.

When you know the type you read the CellMatrix and iterate the table cells. In the cells you find the report expression which can be a formula, a variable, a link or a data provider expression.

Thanks,

Bernd