SAP Knowledge Base Article - Public

2469399 - Numeric Dimensions shows under Measures in Lumira

Symptom

  • Dimension appears as a Measure.
  • Numeric dimension converted to a measure in Lumira.
  • Why some Universe Dimensions displays as a Measures in Lumira? 

Environment

  • SAP Lumira Desktop 1.0
  • SAP Lumira Discovery 2.0

Reproducing the Issue

  1. In the Information Design Tool (IDT) create a Universe off any data source.
  2. Add at least one numeric dimension to the Universe.
  3. Publish the Universe to the SAP BusinessObjects Repository.
  4. In Lumira desktop, create a new document, and select the source: "SAP Universe Query Panel"
  5. In the "SAP Universe Query Panel", add the numeric dimension to the Result Objects for Query, and click "Finish"
  6. Notice the Numeric Dimension displays under Measures in Lumira.

Cause

  • To faciliate the creation of visualization in Lumira, all numeric database fields, or numeric dimensions, are displayed under Measures and Dimensions.

Resolution

  • If some of the numerical dimension are not meant to be used as a measure, remove it from the list of Measures by following the steps below:
       
    1. Open the document in Lumira desktop.
        
    2. In the left pane, under the Prepare or Visualise room, click on the option button for the measure you want to remove.
       
    3. In the Options menu list, select "Remove..."
       
      Lumira - MEasure.png

Keywords

LUM, UNX, UNV , KBA , BI-LUM-DIS , Lumira Desktop/Discovery , Problem

Product

SAP Lumira, desktop edition 1.0