04-08-2022 10:08 AM - last edited on 05-02-2023 10:29 AM by JackLacava
Hi,
I have a list of "segments" in the text 2 property for each Entity. For each Entity I would need to see these "segments" as columns in a cube view, so I need to return a "member list" however these "segments" are separated with a pipe ("|") delimiter in the text 2 property.
The above "segments" in the Text 2 line are already defined as UD2 members in the Dimensions section.
I was investigating the use of an XFBR formula however I can only return the first member list in the Text 2 property and not a list.
Any advise would be helpful.
Thanks
04-11-2022 11:21 AM - edited 04-11-2022 12:06 PM
Do you just need to replace "|" with ","? You you don't know how to loop thru the delimited list?
it's a vb for both. String.Replace ("old value","new value") and for the array you should go with array syntax:
Dim arrValues As String() = text2.Split(New Char() {"|"c})
Then loop thru it as For each val in arrValues...
04-14-2022 08:14 PM
Hi Whenderson: something similar can be achieved using standard Member Filter .Where(TextN Contains Filter) capabilities. However, you'll need to invert how you've done the tagging.
In your UD2, Text2 field: add the entity names that correspond to the segments. Comma delimited or pipe delimited should both work. You can now retrieve these members using a simple Member Filter as such:
Similar example about usage in a dashboard: here
Cheers,
-DB