Why eazybi can't make correctly result?

[1115]

Hi
I don’t understand this.

I want make time from “Project Start” to “Project End”.
So I make [Time] Dimension like this.

[Time].[Start] → “2021-02-15”
[Time].[A] → “2021-04-15”
[Time].[B] → “2021-07-15”
[Time].[C] → “2021-11-15”
[Time].[End] → “2021-12-15”

And also I use this for my logic in [Measure] like this.

CASE
WHEN DateCompare([Time.Weekly].CurrentHierarchyMember.StartDate, DateParse([Time].[A])) <= 0
THEN 1
END

But EazyBI make error!
So I change it like this.

CASE
WHEN DateCompare([Time.Weekly].CurrentHierarchyMember.StartDate, DateParse(“2021-04-15”)) <= 0
THEN 1
END

It does not make error!
Does it look different to you?
Does it look different to EazyBI?
What is different? And how can I make correctly?
Is it really eazy? bi?

[janis.plume]

Hi,

There are two limitations:

1. The members created in the Time dimension must be an aggregation of the respective dimension members. The strings cannot be automatically converted to the time dimension members. The following should work:
   

   

2. The DateParse function requires the string for parsing the date. The Time member cannot be parsed. In your formula, you may try the following:

CASE
WHEN 
  DateCompare([Time.Weekly].CurrentHierarchyMember.StartDate, 
   [Time].[Start].StartDate) <= 0
THEN 1
END

Kindly,