Skip to Content
Author's profile photo Tammy Powlas

Lumira Practice: Custom Calculations using Date Math and Aggregations

In this “how-to” I am creating a “days to ship” calculation with the following steps:

1) use a “datediff” calculation to calculate the difference between shipping date and order date

2) change the aggregation to from sum to average

3) create a visualization by country

4) for interactivity, create a storyboard

5) share to Lumira Cloud

First I create a calculated dimension as the dates are “dimensions” in the dataset.

/wp-content/uploads/2014/02/1fig_388805.png

Here is the calculation:

3calc.PNG

I have to convert it to a measure.

/wp-content/uploads/2014/02/4fig_388807.png

Then I change the aggregation from sum to average:

/wp-content/uploads/2014/02/5fig_388808.png

Here is the visualization of average by country:

6geo.PNG

Then the storyboard – I include controls for interactivity by continent:

7storyboard.PNG

Then share to Lumira Cloud:

8share.PNG

Then I logon to Lumira cloud at cloud.saplumira.com to interact with the storyboard:

/wp-content/uploads/2014/02/9lumiracloud_388813.png

Lastly, I can “explore” the dataset, taking a look at the “Did you know” area:

/wp-content/uploads/2014/02/10didyouknwo_388814.png

You can see more of Lumira at BI 2014 next month in Orlando (snow-free).

Assigned tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Florian Henninger
      Florian Henninger

      Hi Tammy,

      like the blog. Is there a Howto-Guide out there? I'm looking for a "Wiki" which I can use to introduce others to Lumira.

      Such examples like yours above.

      ~Florian

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hi Florian - this isn't a blog, but a document, and the intent is to show an informal "how-to"

      See Sharing Knowledge Is Not That Hard - Jive Documents

      I like the tutorials at sap.com/LearnBI to help introduce others to Lumira.

      I'll look for a Wiki next.

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      I am afraid there is not much in the Wiki area on this:

      SAP Lumira Desktop - Business Intelligence (BusinessObjects) - SCN Wiki

      I am not using any templates which is why I created a document.

      Author's profile photo Henry Banks
      Henry Banks

      Hi,

      if you're looking for calculation help, please check this document here: SAP Lumira – Calculation and Formulae best practices

      regards,

      H

      Author's profile photo Florian Henninger
      Florian Henninger

      Hi Tammy,

      thanks for your time. Document or Blogs doesn't make a huge different, it just depends on the content. I'm sorry, for calling you document a blog, sure, I just had to take a look on top 😐

      Have a nice sunday

      Florian