Different Dimensions until today

Questions & Answers
1

Hello,
I am new here and this is my fist post so please dont be too harsh on me if this is not the right place for this question. I have the following problem in eazyBI and it drives me mad cause I absolutely do not understand this behaviour… So, I really need your help here :slight_smile:.

I can use the following formula if i want to combine issue type and open issues:
1:
([Measures].[Open issues],
[Issue Type].[Problem Report (PR)])

Problem here is that eazyBI draws the graph to infinity.
If i want to avoid this in other situations I use:
2:
CASE
WHEN dateCompare([Time].CurrentHierarchyMember.StartDate,‘today’)<=0
THEN [Measures].[Open issues]
END

And now if I try to combine 1 and 2 it says (_case Error)
CASE
WHEN dateCompare([Time].CurrentHierarchyMember.StartDate,‘today’)<=0
THEN ([Measures].[Open issues],
[Issue Type].[Problem Report (PR)])
END

Please help me :blush:

2

When you get “_case Error” this some kind of a limitation of EazyBI that it doesn’t recognize well enough the types of the result.

the workaround that works for me (until EazyBI will fix it) is to add *1 to the calculation (multiply by 1). This sorts out the type and makes it numeric.

Like that:
CASE
WHEN dateCompare([Time].CurrentHierarchyMember.StartDate,‘today’)<=0
THEN ([Measures].[Open issues],
[Issue Type].[Problem Report (PR)])*1
END

1 Like
3

@ran.lavi made a valid statement. The error indicates that result data type is not detected and you would like to set it explicitly.

While the multiplication by 1 works for numeric values, you can use any other way to set the data type:

You can use any function with determined result data type.

Here are typical functions you can use to explicitly set result data type:
Numeric values: NonZero() or Val() when zero values should be represented as well
Date: DateParse() for dates
Strings: Str()

You can use CAST as well for more complex cases.
CAST ( as string) , CAST( as Numeric )

Daina / support@eazybi.com