Now you can set up criteria as a dimension member range on hypothetical, non-existing dimension members. E.g. you could set up a criteria with an Account dimension member range from account number 8000 to account number 8999.
At the time of setting up the criteria, the account numbers '8000' and '8999' did not exist in your system, but you could anyway insert them as custom values. As you, in your accounting system, add more accounts in the range 8000 to 8999, they would automatically be picked up by this criteria range.
Comments
I'm not able to select Custom Values. I will only see the list by default ... ? Is something changed or is there a simple reason for this ?
Hi Michael,
Your dimension members must be text or strings.
If your dimension members are e.g., dates og integers, you will not be able to select Custom Values.
BR / Ole
Hello:
Is it possible to create custom values that use a wildcard? For example, I am trying to display all business units that end in "OR". This should include 00.OR and 01.OR, but not 00.XX.
Thanks!
Hi there,
Is there anyway we can create a custom criteria with constant value but changeable?
Example: ETA (days) with default value 5.
Thanks you. :-)
Hi Peter,
You may create a User Dimension with a single member where ETA=5.
This user dimension, with the single member selected as a criteria, can be used as a global or local filter in as many dashboards as you like.
At any point you can centrally edit your User Dimension, e.g., change to ETA=10. Then this change will be applied to all dashboards where the user dimension has been used as filter.
See this Tips & Tricks article/video: https://community.targit.com/hc/en-us/articles/8130301074973-December-8th-Use-a-User-Dimension-to-replace-global-criteria-in-multiple-documents
BR / Ole
Hi Ole,
Why are numerical data types and dates not eligible for custom values?
This makes the user dimension applicability inconsistent across the data model, and thereby reduces adoption across our user base. Our current workaround is to add a sentinel row with the criteria boundaries, but this thereby slows down our ability to respond to customer requests.
Please sign in to leave a comment.