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.

thank you 

[Fabian Lim]

Hi @Rizky.Tuasikal

The square bracket is a special syntax in eazybi. I would recommend removing then from the status. You must he a sys admin to rename statuses.

Regards

[Mārtiņš Vanags]

Hi,

That is right, eazyBI doesn't process correctly member names with these special symbols in the member name. But this is being fixed in eazyBI version 6.4.0 which is about to be released very soon.

Try bookmarking these members from the dimension and then select them from the root list instead of manually typing member names in the formula editor.

Martins / eazyBI