topic How to use Alternate state in master dimension? in Integration, Extension & APIs

How to use Alternate state in master dimension?

sangeetha29 — Fri, 17 Nov 2023 16:47:14 GMT

Hi,
I've created master dimension by
={[Alternate State Name]} Field name

Used the master dimension in chart, when I try to select any values in the master dimension it is not getting associated with other normal dimensions.

Please suggest any solution on this.

Thank you.

Re: How to use Alternate state in master dimension?

vincent_ardiet_ — Fri, 17 Nov 2023 16:54:39 GMT

I don't think you can associate a master item to an alternate state. You can only do this at visual object level like a table, a chart, a filter...

Re: How to use Alternate state in master dimension?

MatheusC — Fri, 17 Nov 2023 17:32:07 GMT

@sangeetha29

Just like @vincent_ardiet_ also didn't understand about the alternative state and the master dimension.

Now associating that the alternative state is in a graph, for example if your filter fields have no impact with the alternative state, what you can do is insert $* into your expression. As an example below:

Sum({$*<YOUR_DIMENSION>}YOUR_MEASUREMENT)

Re: How to use Alternate state in master dimension?

anat — Fri, 17 Nov 2023 21:52:43 GMT

you can refer the attached qvf file.