does SetDimensionFilter Change table calculated measures dynamically using script?

[rahulkumarsap]

Hi Folks

SetDimensionFilter APIs - Does it work for calculated Measures? Although it lists down in member selector. However it seems, it consider only pre-defined measures only.

Table_1.getDataSource().setDimensionFilter(Alias.MeasureDimension,"16768693-b899-314727663853");

[former_member542603]

Hi Rahul,

We have done this in one case and it works for us, based on a dropdown the user was able to change the measure including the ones created in the Application level.

- Sathya

[rahulkumarsap]

Hi Sathya

If possible could you please share code here ? and did you use in the same way as mentioned in the question here?

Also please mention you SAC version.

- Rahul

[former_member542603]

Hi Rahul,

It is similar to what you have mentioned.

var measure=Dropdown_1.Getselectdkey();//Stored the Measure Ids in the key
Table_1.getDataSource().setDimensionFilter(Alias.MeasureDimension,measure);

- Sathya

[rahulkumarsap]

Hi Sathya

is your datasource live model or import data connection?

have you created the new calculated column at model level if import data connection? because I am referencing the calculated column at story/application level.

Just checked its still not working.

Regards

Rahul Kumar

[former_member542603]

Hi Rahul,

It is an imported model (Planning) and the calculated column is in the story.

can you let me know what happens when you select the dropdown?

- Sathya

[rahulkumarsap]

Hi Sathya

After selection of calculated column from dropdown, there is no measure in table and hence no row or column except header is shown.

This I have verified with a simple excel based data with one dimension and two measures and third one calculated measure at story/application level (not model level)