SAP Knowledge Base Article - Public

2326746 - Dynamic Column header/names

Symptom

When updating certain Column Header(s) in the source file:

Ex:changing from 2014 to 2015

- Roambi will either not recognize or will even cause report to no longer work

(This is fine however in some views, ie Layers)

Environment

  • SAP Roambi Business
  • All Web Browsers (Mac/PC)

Cause

The different various views available in Roambi work differently with respect to 'column names'.
The Pulse view uses the concept of 'Dimensions'.

When a column is selected (ex: Year = 2014) as a dimension and you create RBI, metadata sees that 'column = 2014' is a dimension.
When you edit the column name to be 2015, metadata doesn't find any dimension with the name = 2015, hence it will remove all the data and present a blank RBI.

In case of Layers, Roambi doesn't use the concept of dimensions. It is a list view and that's why it works for Layers.

Keywords

dynamic column header names Roambi cloud , KBA , BI-ROM-CLD-PUB-BI , Roambi Cloud publishing clients – BI, Cognos & SSR , How To

Product

SAP Roambi Cloud all versions