SAC Scripting

Filter main table based on commenting model page filter:

function onSelect() : void

//on Input Control select

var BA = InputControl_3.getInputControlDataSource().getActiveSelectedMembers()[0];
console.log(BA.displayId);

var chk = InputControl_3.getInputControlDataSource().isAllMembersSelected();

if (chk===false)
{
//apply BA filter
Table_4.getDataSource().setVariableValue("ABU_00",BA.displayId);
console.log(chk);
}

if (chk===true)
{
// clear BA filter
Table_4.getDataSource().setVariableValue("ABU_00",[]);
console.log(chk);
}

Get all dimension info:

//on page initialize

var xyz=Table_3.getDataSource().getDimensions();
console.log(xyz);

Show/hide table tab on switch button toggle:

//on switch button

if (SWH_TogglePCodes.isOn()){
TABS_IS.setSelectedKey("With_Exclusion");
Application.showMessage(ApplicationMessageType.Info,"IPR is excluded");
} else {
TABS_IS.setSelectedKey("Without_Exclusion");
Application.showMessage(ApplicationMessageType.Info,"IPR is included");
}

Pre filled page filter (Quarter & Month)

//on page initialize
//get Fiscal Year from prompt

var p1=Table_1.getDataSource().getVariableValues("V_FPER")[0];

switch (p1.type) {
case VariableValueType.Single:

var singleValue = cast(Type.SingleVariableValue, p1);
//console.log("Fiscal Year");
//console.log(singleValue.value); // can access the 'value' property now
//console.log(p1);

Text_13.applyText(singleValue.value);
var cy=Text_13.getPlainText();
var yy=(cy.substring(0,4));
var mm=(cy.substring(5,7));

break;

case VariableValueType.Multiple:

var multiValue = cast(Type.MultipleVariableValue, p1);
console.log(multiValue.values); // can access the 'values' property now

break;

case VariableValueType.Range:

var rangeValue = cast(Type.RangeVariableValue, p1);
console.log("from");
console.log(rangeValue.from); // can access the 'from' property now
console.log("to");
console.log(rangeValue.to); // can access the 'to' property now

// further range properties: 'less', 'lessOrEqual', 'greater', 'greaterOrEqual'

break;
default:
break;
}

//console.log(mm);
//console.log(yy);
//remove 0 from month

if(mm==="01"){
mm="1";
}else if(mm==="02"){
mm="2";
}else if(mm==="03"){
mm="3";
}else if(mm==="04"){
mm="4";
}else if(mm==="05"){
mm="5";
}else if(mm==="06"){
mm="6";
}else if(mm==="07"){
mm="7";
}else if(mm==="08"){
mm="8";
}else if(mm==="09"){
mm="9";
}else if(mm==="10"){
mm="10";
}else if(mm==="11"){
mm="11";
}else if(mm==="12"){
mm="12";
}

//prefix 0 in quarter

if(mm==="1" || mm==="2" || mm==="3"){
var qtr="01";//+mm.toString();
}else if(mm==="4" || mm==="5" || mm==="6"){
qtr="02";
}else if(mm==="7" || mm==="8" || mm==="9"){
qtr="03";
}else if(mm==="10" || mm==="11" || mm==="12"){
qtr="04";
}

var mnth2=mm;

//quarter filter

InputControl_1.getInputControlDataSource().setSelectedMembers(yy+qtr);
console.log(yy+qtr);

//month filter

InputControl_2.getInputControlDataSource().setSelectedMembers(mnth2);
console.log(mnth2);

Filter table & comments based on page Quarter filter:

//Month
var getMonth=InputControl_2.getInputControlDataSource().getActiveSelectedMembers();
console.log("Month:");
console.log(getMonth[0].id);
console.log(getMonth[0].description);
//Year
var getYear=InputControl_1.getInputControlDataSource().getActiveSelectedMembers();
console.log("Year:");
console.log(getYear[0].id);
console.log(getYear[0].description);
var yy=(getYear[0].id.substring(0,4));
console.log("yy:");
console.log(yy);
//refresh table
if(getMonth[0].id === "10"){
Table_1.getDataSource().setVariableValue("V_FPER", yy+"0" + getMonth[0].id);
console.log("yy:"+"single zero");
}
else if(getMonth[0].id === "11"){
Table_1.getDataSource().setVariableValue("V_FPER", yy+"0" + getMonth[0].id);
console.log("yy:"+"single zero");
}
else if(getMonth[0].id === "12"){
Table_1.getDataSource().setVariableValue("V_FPER", yy+"0" + getMonth[0].id);
console.log("yy:"+"single zero");
}
else
{
Table_1.getDataSource().setVariableValue("V_FPER", yy+"00" + getMonth[0].id);
console.log("yy:"+"double zero");
}

Filter to Exclude Product codes 1:

//apply on switch button

var ExcludePCodes = ArrayUtils.create(Type.string);

//Current set of p-codes needed to exclude/include - 5000,5001,72,72A,72CL,72I,72NW

ExcludePCodes = ["5000","5001","0072","72A","72CL","72NW","72I"];

if(Switch_1.isOn()===true)

{

// Get selected members from Input Control

// Apply background filter to Table

console.log(ExcludePCodes);

Table_30.getDataSource().removeDimensionFilter("CFIREPCOD");

Table_30.getDataSource().setHierarchy("CFIREPCOD",'__FLAT__');

Table_30.getDataSource().setDimensionFilter("CFIREPCOD",{values: ExcludePCodes, exclude: true});

Table_48.getDataSource().removeDimensionFilter("CFIREPCOD");

Table_48.getDataSource().setHierarchy("CFIREPCOD",'__FLAT__');

Table_48.getDataSource().setDimensionFilter("CFIREPCOD",{values: ExcludePCodes, exclude: true});

Table_49.getDataSource().removeDimensionFilter("CFIREPCOD");

Table_49.getDataSource().setHierarchy("CFIREPCOD",'__FLAT__');

Table_49.getDataSource().setDimensionFilter("CFIREPCOD",{values: ExcludePCodes, exclude: true});

Table_50.getDataSource().removeDimensionFilter("CFIREPCOD");

Table_50.getDataSource().setHierarchy("CFIREPCOD",'__FLAT__');

Table_50.getDataSource().setDimensionFilter("CFIREPCOD",{values: ExcludePCodes, exclude: true});

console.log("True");
}

else

{

Table_30.getDataSource().removeDimensionFilter("CFIREPCOD");

//Table_30.getDataSource().refreshData();

Table_48.getDataSource().removeDimensionFilter("CFIREPCOD");

//Table_48.getDataSource().refreshData();

Table_49.getDataSource().removeDimensionFilter("CFIREPCOD");

//Table_49.getDataSource().refreshData();

Table_50.getDataSource().removeDimensionFilter("CFIREPCOD");

//Table_50.getDataSource().refreshData();

console.log("False");

}

Filter to Exclude Product codes 2:

//apply on switch button

// write below code on switch to call method:
Methods.FilterPCodes([Table_48, Table_30, Table_49, Table_50],"CFIREPCOD",Switch_1.isOn());

// create a method & write below code in it to filter in/filter out:
var ExcludePCodes = ArrayUtils.create(Type.string);

//Current set of p-codes needed to exclude/include - 5000,5001,72,72A,72CL,72I,72NW
ExcludePCodes = ["5000","5001","72","72A","72CL","72NW","72I"];

/*
var counter = 0;
var bool = 0;
if(gNewPCodes.length<1){
for (var l=0; l<gPCodes.length;l++){
bool = 0;
for (var k=0; k<ExcludePCodes.length; k++){
if ( (ExcludePCodes[k] !== gPCodes[l]) ){
bool = bool+1;
}
}
if (bool === ExcludePCodes.length){
gNewPCodes[counter] = gPCodes[l];
counter++; }
}
}
console.log(gNewPCodes);
*/

var len = TableNames.length;

if (OnOrOff){
//console.log("true");
for(var i=0;i<len;i++){
TableNames[i].getDataSource().setHierarchy(DimensionName,'__FLAT__');
TableNames[i].getDataSource().setDimensionFilter(DimensionName,{values: ExcludePCodes, exclude: true});
}
Application.showMessage(ApplicationMessageType.Info,"This might take some time as P-Codes: \"5000,5001,72,72A,72CL,72NW\" are being excluded from the data.");
} else {
//console.log("false");
for(var j=0;j<len;j++){
TableNames[j].getDataSource().removeDimensionFilter(DimensionName);
}
Application.showMessage(ApplicationMessageType.Info,"All P-Codes are now included in the data.");
}

Get selected value from filter:

var getPeriod=InputControl_2.getInputControlDataSource().getActiveSelectedMembers();
console.log(getPeriod[0].id);
console.log(getPeriod[0].description);

Get model id:

//get model id
var tt=Application.getInfo();
console.log(tt);

// get fiscal year
var p1=Table_WorkingCapital.getDataSource().getVariableValues("V_FPER")[0];
console.log(p1);

var xx=Table_30.getDataSource().getDimensions();
console.log(xx);

// set story filter & refresh table
Table_WorkingCapital.getDataSource().setVariableValue("V_FPER",yy+"00"+mnth2);

//Application.getFileDataSource("B9006B832A7049795432AB51DEFB002D").setVariableValue("V_FPER",p1);
Table_WorkingCapital.getDataSource().refreshData();

Select All members in page filter:

var IC_DATA = InputControl_5.getInputControlDataSource().getActiveSelectedMembers(1000);
console.log(IC_DATA);

if(Switch_1.isOn()===true)
{
InputControl_5.getInputControlDataSource().setSelectedMembers(["31","72"]);
}
else //if (Switch_1.isOn()===false)
{
InputControl_5.getInputControlDataSource().setAllMembersSelected();
}

Month to Date selection on page filter:

// approach with millisec

var current_date = new Date(Date.now());

var date_new_millisec = current_date.setDate(current_date.getDate() - 0);

var new_date = new Date(date_new_millisec);

var date_new_format = new_date.toJSON().slice(0,10);

//now I have YYYY-MM-DD change format to DD.MM.YYYY

//var dd = date_new_format.slice(8,10);

var dd = ConvertUtils.stringToInteger(date_new_format.substring(8,10));

//var mm = date_new_format.slice(5,7);

var mm=ConvertUtils.stringToInteger(date_new_format.substring(5,7));

var yy=ConvertUtils.stringToInteger(date_new_format.substring(0,4));

console.log(date_new_format);

console.log(dd);

console.log(mm);

console.log(yy);

//prefix 0 in month

if(mm<=9){

var mnth="0"+mm.toString();

}else{

mnth=mm.toString();

}

if(dd===1)

{

var versionsel=[yy.toString()+"-"+mnth+"-01"];