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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
7 | |
4 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
2 | |
2 |