Skip to Content

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:

/wp-content/uploads/2014/09/1copyfromclipboard_551263.png

Then I “trimmed spaces”:

/wp-content/uploads/2014/09/2remove_551288.png

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

/wp-content/uploads/2014/09/3delimit_551289.png

This is the grid view of the data:

/wp-content/uploads/2014/09/4viewdata_551290.png

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.

/wp-content/uploads/2014/09/5cleancodeformula_551291.png

To do this I create a calculated dimension shown above.

/wp-content/uploads/2014/09/6results_551292.png

Now I have a new column, “CleanCode”

See the video below of the steps:

Related:

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

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply