Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
* Try to put the double-quote around the $(...) :
{<dimension_id={"$(=GetFieldSelections(possible_dimension_id,'" ,"',2))"}>}
* Your value separator is "," and not , ?
Hi,
* Try to put the double-quote around the $(...) :
{<dimension_id={"$(=GetFieldSelections(possible_dimension_id,'" ,"',2))"}>}
* Your value separator is "," and not , ?
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.