How to add script variable array to Table SAP Analytic application

[Dhiraj_G]

Problem Statement:- Trigonometric functions are not available in "Calculated measures"

So I read a measure from table using Table.getDataSource().getResultSet() and calculated the new array with trigonometric functions like "Math.cos(array_1).

This calculated array is stored in new script variable.

Now How can I add this Script variable (type= Array) to the table?

Or How can I convert this Script variable (type= Array) to new Measure?

[Dhiraj_G]

nikhil_1486 Thanks for the reply, This is a very good example for using script variable in the calculated measures, I will use it .

The Original Problem reformatted as below:

I have a column B in the table with some numbers and I want to use column C as cos(column B), as Trigonometric functions are not available in calculated measures(Analytics Application) I am reading column B using onInitialization script

var arr = Table_5.getDataSource().getResultSet({"@MeasureDimension": "*******);

and then calculating the Cos function using below script

var value = ArrayUtils.create(Type.number);

var Cos = ArrayUtils.create(Type.number);

for (var k=0; k<arr.length;k++)

var string = arr[i][Alias.MeasureDimension].formattedValue;

var number = ConvertUtils.stringToNumber(string);

Cos[k] = Math.cos(number);

}

And now I want to add this variable Cos ( type:Array) to the column C in the original Table., or How can I use this variable Cos as measure for other charts ?