How to filter space without specific key?

Questions & Answers
1

We have a lot of space and want to create some filter to list for spaces excepting for specific key.

For example, create “Define new calculated member” in Space dimension as

[Space].[selected space]
= [Space].CurrentMember.Key <> ‘some space key’

This failed as “Expected value of type STRING; got value ‘0’ (NUMERIC)”

I’d appreciated any advice.

Thanks

2

Hi @1116,

When creating a calculated member in the Space dimension, you would Aggregate(…) some filtered members of the Space dimension. For example

Aggregate(Filter(
  [Space].[Space].Members,
  [Space].CurrentMember.Key <> "some space key"
))

Lauma / support@eazybi.com

3

Lauma
Thank you.

With your advice, we solved the error “Expected value of type STRING; got value ‘0’ (NUMERIC)” but eazyBI report shows Space that key is “filterd”. For example, we set “AIT” as “[Space].CurrentMember.Key <> “AIT”” in it, but space with spacekey “AIT” is still diplayed on report.

Any way to hide that space?
Regrads.

5

001
001544×549 9.97 KB

6

Hi,

I am wondering if there is some additional or hidden value in the key, e.g., space? For me to investigate further, I would need to see the report definition (you can send it to support@eazybi.com)

Another way of writing more advanced regular expressions would be to use the MATCHES function. Would you please try the following:

Aggregate(Filter(
  [Space].[Space].Members,
  NOT [Space].CurrentMember.Key MATCHES ".*AIT.*"
))

Lauma / support@eazybi.com

7

Thank you for your support and kindness.
With new filter as you described, I can hide some Space in my report.

Best regards,

1 Like