Skip to Content
avatar image
Former Member

Lumira Calculated dimensions

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?

Add comment
10|10000 characters needed 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.

  • Get RSS Feed

0 Answers