Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

String encapsulation with GetFieldSelections?

Is there a better way to use GetFieldSelections in an Set Analysis than this:

{<dimension_id={$(='"'&GetFieldSelections(possible_dimension_id,'","',2)&'"')}>}

All the '"'& is a bit ugly in my opinion, but it works.

Cheers

Karl

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

* Try to put the double-quote around the $(...) :

{<dimension_id={"$(=GetFieldSelections(possible_dimension_id,'" ,"',2))"}>}

* Your value separator is "," and not , ?

View solution in original post

2 Replies
Not applicable
Author

Hi,

* Try to put the double-quote around the $(...) :

{<dimension_id={"$(=GetFieldSelections(possible_dimension_id,'" ,"',2))"}>}

* Your value separator is "," and not , ?

Not applicable
Author

Thanks for the reply,

I haven't tried your answer, because I ended up with a different solution. Forgot the set is applied for the entire HyperCube and not by rows.

I used '","' to get the result of "DimValue01","DimValue02". It worked, but wasn't pretty.