BusinessObjects Query builder – Exploring Visualization Objects

[former_member182521]

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

To get the list of available Flash objects

      SELECT * FROM CI_INFOOBJECTS WHERE SI_KIND='Flash'

Query Builder Blog series

Basics

             BusinessObjects Query builder - Basics

               BusinessObjects Query builder – Best practices & Usability

Sample Queries

             BusinessObjects Query builder queries

               BusinessObjects Query builder queries - Part II

               BusinessObjects Query builder queries - Part III

               BusinessObjects Query builder queries - Part IV

               BusinessObjects Query builder – Exploring Visualization Objects

              BusinessObjects Query builder – Exploring Monitoring Objects

              BusinessObjects Query builder - Exploring Lumira & Design studio Objects

Use cases

               BusinessObjects Environment assessment using Query builder

               BusinessObjects Environment Cleanup using Query builder

               BusinessObjects Query builder – What's New in BI 4.0