Skip to Content

Lumira Calculated dimensions

Sep 15, 2017 at 06:29 PM


avatar image
Former Member

I'm using Lumira 1.3 and sourcing my dataset from one of our SAP BI Platform universes, which is sourced from Oracle. In Oracle an effective end date field will have the value, 12/31/4712 when the end date is open/unended.

In WebI reports I can easily write a variable to convert this value to a blank field - which helps reduce the confusion with end users. I'm trying to do the same in Lumira... not sure if this is possible.

In Prepare I am trying to create a calculated dimension using if/then but it doesn't like my 'incompatible types'... date vs double or date vs string

Any solutions?

10 |10000 characters needed characters left characters exceeded
Former Member

I should have added, I do not have access to modify within the universe, so any solution to that effect is not an option. I am looking for a solution within the Lumira desktop application.

* Please Login or Register to Answer, Follow or Comment.

0 Answers