Skip to Content
Author's profile photo Tammy Powlas

Cleansing Data in Lumira using Calculations

This past week Cindi Howson said this: “Data prep / business ELT in Lumira was always ahead of competition, but SAP doesn’t emphasize, so wrangling a headline for others”

So when a question came through on the discussion about how to cleanse data if a row met multiple conditions, I thought I would try it out.  See Cleaning Data – How to change content of a column based on values in another column

First, I copied the data to the clipboard and used that as a data source:


Then I “trimmed spaces”:


I selected Delimited By tab and you can see the data here:


This is the grid view of the data:


You can see the code column has many different values.  The conditions are if the Name is XYZ, the color is black, and the size is 39, I change the code.


To do this I create a calculated dimension shown above.


Now I have a new column, “CleanCode”

See the video below of the steps:


Sign-up now for hands-on sessions at SAP TechEd && d-code Las Vegas.  Here is the link to all the sessions mentioning Lumira

Stay Ahead : Attend TechEd && d-code – Win Big SAP BI BusinessObjects HANA Hands-on Sessions

This week, ASUG has 2 webcasts featuring Lumira:

September 30: BI with Lumira Roadmap Update – the Future of BI with BusinessObjects

October 2: ASUG Lumira Influence Council Launch

SAP Statement of Direction on BI Solutions

The SAP Lumira Roadmap – ASUG BusinessObjects Conference

Join SAP at the end of October for Reporting & Analytics 2014 INTERACTIVE conference – register here

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.