BusinessObjects Query builder – Exploring Visualization Objects

In this blog I have explored the visualization objects that are exported to businessObjects repository. Visualization objects includes objects created in Explorer and Xcelcius applications. Here we go.

Explorer Objects

To get the list of available Explorer Information Spaces

SELECT * FROM CI_INFOOBJECTS WHERE SI_KIND=’DATADISCOVERY’

By referencing the SI_DATASOURCEID field we can Identify the data source of Information space. If it is just displaying objects CUID (something like value=”AUmNQF0NW55Klxms83RxePY”) then the data source will be an universe. If it represents value like (value=”Spreadsheets|AY7BRSQ_frBPlWcpxJth2cI”) then it is clearly evident that the data source is an Spreadsheet.

SI_DATASOURCEID VALUE	DATA SOURCE
value=”AUmNQF0NW55Klxms83RxePY	Universe
value=”Spreadsheets\|AY7BRSQ_frBPlWcpxJth2cI”	Spreadsheet

To get the list of available Exploration Viewsets

SELECT * FROM CI_INFOOBJECTS WHERE SI_KIND=’DataDiscoveryAlbum’

Xcelcius Objects

To get the list of available Xcelcius dashboards

SELECT * FROM CI_INFOOBJECTS WHERE SI_KIND=’XL.XcelsiusEnterprise’

We can get the canvas size of the dashboard using the file SI_CANVAS_SIZE. Please note the individual component levels canvas properties cannot be extracted from repository.

Type of device compatibility can be referenced from SI_DEVICE_TYPE property.

SI_DEVICE_TYPE	DESCRIPTION
1	Desktop Only – Compatible only while accessing from Desktop
2	Mobile Only – Compatible only while accessing from Mobile device
3	Desktop and Mobile – – Compatible for both Desktop & Mobile