Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
former_member182521
Active Contributor
28,700

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 VALUEDATA SOURCE
value="AUmNQF0NW55Klxms83RxePYUniverse
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_TYPEDESCRIPTION
1Desktop Only - Compatible only while accessing from Desktop
2Mobile Only - Compatible only while accessing from Mobile device
3Desktop 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   

1 Comment
Labels in this area