Yeo Hui Fang

Below is a replicable pattern when a new hierarchy is added to multilevel hierarchy, follow by switch in axis. 

Hi @tibdex, sorry for the delay. Please see the attached zip. [medium.zip](https://github.com/atoti/atoti/files/6209682/medium.zip) I don't think I have the exact examples anymore. I tried to replicate it in the last cell....

sorry I missed this ticket. I have a smaller example here: [measures_examples.zip](https://github.com/atoti/atoti/files/8057653/measures_examples.zip) I have full running dates:  However, once I have the embedded condition, only 1 row is returned....

Hi @bloussou / @Acriss, I found the root of the issue. It's a matter of UI / MDX use problem: __Scenario 1__: `Date parts` hierarchy not expanded. Since the `where`...

Then again, this problem seems a bit different from the initial reported issue.

Yes, I agree it's more of a UX issue that can result in users missing values unknowingly if they do not understand how MDX functions in accordance with the expandable...

> Note that in SQL, a query like SELECT value.SUM WHERE Quarter == 1 AND DAY == 1 OR 15 wouldn't show any result either. Try running the below two...

It would be nice if the chart can auto-detect that it's a date hierarchy and manage the display:  In this case, I'll need to insert the `Month of Year`...

Could you help to explain how the "-1D" works? If we look at the previous day plus current day, then on 2021-09-06 (blue), we should be having 3 and not...

Hi @tibdex, sorry for the delay: [Untitled.zip](https://github.com/atoti/atoti/files/7600852/Untitled.zip)