Transpose in CMS Query Builder 1.3

In a standard database, each field of a row contains a single value. This is not the case for BO CMS database. A property can have a quite complex structure. A simple example is SI_DSL_UNIVERSE property for Web Intelligence documents that indicate what Unx universes are used by the document.

SELECT si_name, si_universe, si_dsl_universe
FROM ci_infoobjects
WHERE si_kind = 'Webi'
AND si_instance = 0
AND si_name = 'Customer Profitability Comparison, by Customer'

The result in the SAP BO Query Builder will look like:

Exporting metadata for such object using “Include containers” in Biclever CMS Query Builder will create a single row and the fields for the property will be SI_DSL_UNIVERSE.1, SI_DSL_UNIVERSE.2, SI_DSL_UNIVERSE.3, SI_DSL_UNIVERSE.SI_TOTAL

The wide format is sometimes inconvenient. “Transpose” will create a row for each value of each array.

CMS Query Builder 1.3

This version includes the following improvements:

  • Undo with Ctrl-Z, Redo with Ctrl-Y.
  • Execution of the query in the selection.
  • Possibility to create new, edit and delete templates from the Template menu.
  • Corrections in the default templates.
  • Tool tip for column names.
  • Perceiving of the value type in Excel (previously dates were exported as strings)
  • Possibility to select Name when selecting an object (previosly ID and CUID were only possibilities. Name is useful for names of groups and users etc)
  • A new transpose feature for exporting containers.