EazyBI : Can not create logic/query when theres [ ] symbol on the Status.

[Rizky.Tuasikal]

I have two statuses. 
1. Status : Completed

2. Status : "[WBS01] Prepare WBS"

 The question is, when we used this query, we success the process:

[Status].[Completed]

But, when we try to using this query:

[Status].[[WBS01]Prepare WBS]

We cant see the result of this query.


Can anyone help me solving this?? What should I do?

Especially, when trying to use status with the [ ] symbol on it.

[Gerda Grantiņa]

Hi @Rizky.Tuasikal ,

If your dimension name contains square brackets, the correct expression is this:

[Status].[[new]] status]

best,

Gerda

[Rizky.Tuasikal]

It works. Thanks Gerda. Help me a lot!!!