How to remove or add measure from table in SAC Analytics designer.

[samindersingh2317]

How to remove or add measure from table in SAC Analytics designer. For removing measure from charts we have the removemeasure. How can we do that in case of tables

[chia-yu_wu · Accepted solution]

Hi Saminder,

to remove measure you could try this:

Table.removeDimension(Alias.MeasureDimension); Table.getDataSource().removeDimensionFilter(Alias.MeasureDimension);

to add a particular measure it is a little bit tricky:

Table.addDimensionToColumns(Alias.MeasureDimension); Table.getDataSource().setDimensionFilter(Alias.MeasureDimension,"Id of the measure");

*you could also type ctrl plus space to enable to library, in case you dont know your id of the measure.

hope this helps you out.

Greets,

Chia-Yu

[samindersingh2317 · Accepted solution]

Thanks Chia.

It works.

[beatrizvik · Accepted solution]

Hello,

I was wondering if its possible to add multiple measures at the same time, if so how could you do it? Just adding more lines of code with the different measures?

I'm trying this, but I don't see both 

Table_Elim01.addDimensionToColumns(Alias.MeasureDimension);
Table_Elim01.getDataSource().setDimensionFilter(Alias.MeasureDimension,"AMOUNT_GC");
Table_Elim01.getDataSource().setDimensionFilter(Alias.MeasureDimension,"ABS_OVERRIDE");

Best, 

Beatriz