Get selected value from filter:
var getPeriod=InputControl_2.getInputControlDataSource().getActiveSelectedMembers();
console.log(getPeriod[0].id);
console.log(getPeriod[0].description);
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"];
InputControl_23.getInputControlDataSource().setSelectedMembers(versionsel);
}
else if(dd===2)
{
versionsel=[yy.toString()+"-"+mnth+"-02",yy.toString()+"-"+mnth+"-01"];
InputControl_23.getInputControlDataSource().setSelectedMembers(versionsel);
}
else if(dd===3)
{
versionsel=[yy.toString()+"-"+mnth+"-03",yy.toString()+"-"+mnth+"-02",yy.toString()+"-"+mnth+"-01"];
InputControl_23.getInputControlDataSource().setSelectedMembers(versionsel);
}
else if(dd===4)
{
versionsel=[yy.toString()+"-"+mnth+"-04",yy.toString()+"-"+mnth+"-03",yy.toString()+"-"+mnth+"-02",yy.toString()+"-"+mnth+"-01"];
InputControl_23.getInputControlDataSource().setSelectedMembers(versionsel);
}
else if(dd===5)
{
versionsel=[yy.toString()+"-"+mnth+"-05",yy.toString()+"-"+mnth+"-04",yy.toString()+"-"+mnth+"-03",yy.toString()+"-"+mnth+"-02",yy.toString()+"-"+mnth+"-01"];
InputControl_23.getInputControlDataSource().setSelectedMembers(versionsel);
}
else if(dd===6)
{
versionsel=[yy.toString()+"-"+mnth+"-06",yy.toString()+"-"+mnth+"-05",yy.toString()+"-"+mnth+"-04",yy.toString()+"-"+mnth+"-03",yy.toString()+"-"+mnth+"-02",yy.toString()+"-"+mnth+"-01"];
InputControl_23.getInputControlDataSource().setSelectedMembers(versionsel);
}
else if(dd===7)
{
versionsel=[yy.toString()+"-"+mnth+"-07",yy.toString()+"-"+mnth+"-06",yy.toString()+"-"+mnth+"-05",yy.toString()+"-"+mnth+"-04",yy.toString()+"-"+mnth+"-03",yy.toString()+"-"+mnth+"-02",yy.toString()+"-"+mnth+"-01"];
InputControl_23.getInputControlDataSource().setSelectedMembers(versionsel);
}
else if(dd===8)
{
versionsel=[yy.toString()+"-"+mnth+"-08",yy.toString()+"-"+mnth+"-07",yy.toString()+"-"+mnth+"-06",yy.toString()+"-"+mnth+"-05",yy.toString()+"-"+mnth+"-04",yy.toString()+"-"+mnth+"-03",yy.toString()+"-"+mnth+"-02",yy.toString()+"-"+mnth+"-01"];
InputControl_23.getInputControlDataSource().setSelectedMembers(versionsel);
}
else if(dd===9)
{
versionsel=[yy.toString()+"-"+mnth+"-09",yy.toString()+"-"+mnth+"-08",yy.toString()+"-"+mnth+"-07",yy.toString()+"-"+mnth+"-06",yy.toString()+"-"+mnth+"-05",yy.toString()+"-"+mnth+"-04",yy.toString()+"-"+mnth+"-03",yy.toString()+"-"+mnth+"-02",yy.toString()+"-"+mnth+"-01"];
InputControl_23.getInputControlDataSource().setSelectedMembers(versionsel);
}
else if(dd===10)
{
versionsel=[yy.toString()+"-"+mnth+"-10",yy.toString()+"-"+mnth+"-09",yy.toString()+"-"+mnth+"-08",yy.toString()+"-"+mnth+"-07",yy.toString()+"-"+mnth+"-06",yy.toString()+"-"+mnth+"-05",yy.toString()+"-"+mnth+"-04",yy.toString()+"-"+mnth+"-03",yy.toString()+"-"+mnth+"-02",yy.toString()+"-"+mnth+"-01"];
InputControl_23.getInputControlDataSource().setSelectedMembers(versionsel);
}
else if(dd===11)
{
versionsel=[yy.toString()+"-"+mnth+"-11",yy.toString()+"-"+mnth+"-10",yy.toString()+"-"+mnth+"-09",yy.toString()+"-"+mnth+"-08",yy.toString()+"-"+mnth+"-07",yy.toString()+"-"+mnth+"-06",yy.toString()+"-"+mnth+"-05",yy.toString()+"-"+mnth+"-04",yy.toString()+"-"+mnth+"-03",yy.toString()+"-"+mnth+"-02",yy.toString()+"-"+mnth+"-01"];
InputControl_23.getInputControlDataSource().setSelectedMembers(versionsel);
}
else if(dd===12)
{
versionsel=[yy.toString()+"-"+mnth+"-12",yy.toString()+"-"+mnth+"-11",yy.toString()+"-"+mnth+"-10",yy.toString()+"-"+mnth+"-09",yy.toString()+"-"+mnth+"-08",yy.toString()+"-"+mnth+"-07",yy.toString()+"-"+mnth+"-06",yy.toString()+"-"+mnth+"-05",yy.toString()+"-"+mnth+"-04",yy.toString()+"-"+mnth+"-03",yy.toString()+"-"+mnth+"-02",yy.toString()+"-"+mnth+"-01"];
InputControl_23.getInputControlDataSource().setSelectedMembers(versionsel);
}
else if(dd===13)
{
versionsel=[yy.toString()+"-"+mnth+"-13",yy.toString()+"-"+mnth+"-12",yy.toString()+"-"+mnth+"-11",yy.toString()+"-"+mnth+"-10",yy.toString()+"-"+mnth+"-09",yy.toString()+"-"+mnth+"-08",yy.toString()+"-"+mnth+"-07",yy.toString()+"-"+mnth+"-06",yy.toString()+"-"+mnth+"-05",yy.toString()+"-"+mnth+"-04",yy.toString()+"-"+mnth+"-03",yy.toString()+"-"+mnth+"-02",yy.toString()+"-"+mnth+"-01"];
InputControl_23.getInputControlDataSource().setSelectedMembers(versionsel);
}
else if(dd===14)
{
versionsel=[yy.toString()+"-"+mnth+"-14",yy.toString()+"-"+mnth+"-13",yy.toString()+"-"+mnth+"-12",yy.toString()+"-"+mnth+"-11",yy.toString()+"-"+mnth+"-10",yy.toString()+"-"+mnth+"-09",yy.toString()+"-"+mnth+"-08",yy.toString()+"-"+mnth+"-07",yy.toString()+"-"+mnth+"-06",yy.toString()+"-"+mnth+"-05",yy.toString()+"-"+mnth+"-04",yy.toString()+"-"+mnth+"-03",yy.toString()+"-"+mnth+"-02",yy.toString()+"-"+mnth+"-01"];
InputControl_23.getInputControlDataSource().setSelectedMembers(versionsel);
}
else if(dd===15)
{
versionsel=[yy.toString()+"-"+mnth+"-15",yy.toString()+"-"+mnth+"-14",yy.toString()+"-"+mnth+"-13",yy.toString()+"-"+mnth+"-12",yy.toString()+"-"+mnth+"-11",yy.toString()+"-"+mnth+"-10",yy.toString()+"-"+mnth+"-09",yy.toString()+"-"+mnth+"-08",yy.toString()+"-"+mnth+"-07",yy.toString()+"-"+mnth+"-06",yy.toString()+"-"+mnth+"-05",yy.toString()+"-"+mnth+"-04",yy.toString()+"-"+mnth+"-03",yy.toString()+"-"+mnth+"-02",yy.toString()+"-"+mnth+"-01"];
InputControl_23.getInputControlDataSource().setSelectedMembers(versionsel);
}
else if(dd===16)
{
versionsel=[yy.toString()+"-"+mnth+"-16",yy.toString()+"-"+mnth+"-15",yy.toString()+"-"+mnth+"-14",yy.toString()+"-"+mnth+"-13",yy.toString()+"-"+mnth+"-12",yy.toString()+"-"+mnth+"-11",yy.toString()+"-"+mnth+"-10",yy.toString()+"-"+mnth+"-09",yy.toString()+"-"+mnth+"-08",yy.toString()+"-"+mnth+"-07",yy.toString()+"-"+mnth+"-06",yy.toString()+"-"+mnth+"-05",yy.toString()+"-"+mnth+"-04",yy.toString()+"-"+mnth+"-03",yy.toString()+"-"+mnth+"-02",yy.toString()+"-"+mnth+"-01"];
InputControl_23.getInputControlDataSource().setSelectedMembers(versionsel);
}
else if(dd===17)
{
versionsel=[yy.toString()+"-"+mnth+"-17",yy.toString()+"-"+mnth+"-16",yy.toString()+"-"+mnth+"-15",yy.toString()+"-"+mnth+"-14",yy.toString()+"-"+mnth+"-13",yy.toString()+"-"+mnth+"-12",yy.toString()+"-"+mnth+"-11",yy.toString()+"-"+mnth+"-10",yy.toString()+"-"+mnth+"-09",yy.toString()+"-"+mnth+"-08",yy.toString()+"-"+mnth+"-07",yy.toString()+"-"+mnth+"-06",yy.toString()+"-"+mnth+"-05",yy.toString()+"-"+mnth+"-04",yy.toString()+"-"+mnth+"-03",yy.toString()+"-"+mnth+"-02",yy.toString()+"-"+mnth+"-01"];
InputControl_23.getInputControlDataSource().setSelectedMembers(versionsel);
}
else if(dd===18)
{
versionsel=[yy.toString()+"-"+mnth+"-18",yy.toString()+"-"+mnth+"-17",yy.toString()+"-"+mnth+"-16",yy.toString()+"-"+mnth+"-15",yy.toString()+"-"+mnth+"-14",yy.toString()+"-"+mnth+"-13",yy.toString()+"-"+mnth+"-12",yy.toString()+"-"+mnth+"-11",yy.toString()+"-"+mnth+"-10",yy.toString()+"-"+mnth+"-09",yy.toString()+"-"+mnth+"-08",yy.toString()+"-"+mnth+"-07",yy.toString()+"-"+mnth+"-06",yy.toString()+"-"+mnth+"-05",yy.toString()+"-"+mnth+"-04",yy.toString()+"-"+mnth+"-03",yy.toString()+"-"+mnth+"-02",yy.toString()+"-"+mnth+"-01"];
InputControl_23.getInputControlDataSource().setSelectedMembers(versionsel);
}
else if(dd===19)
{
versionsel=[yy.toString()+"-"+mnth+"-19",yy.toString()+"-"+mnth+"-18",yy.toString()+"-"+mnth+"-17",yy.toString()+"-"+mnth+"-16",yy.toString()+"-"+mnth+"-15",yy.toString()+"-"+mnth+"-14",yy.toString()+"-"+mnth+"-13",yy.toString()+"-"+mnth+"-12",yy.toString()+"-"+mnth+"-11",yy.toString()+"-"+mnth+"-10",yy.toString()+"-"+mnth+"-09",yy.toString()+"-"+mnth+"-08",yy.toString()+"-"+mnth+"-07",yy.toString()+"-"+mnth+"-06",yy.toString()+"-"+mnth+"-05",yy.toString()+"-"+mnth+"-04",yy.toString()+"-"+mnth+"-03",yy.toString()+"-"+mnth+"-02",yy.toString()+"-"+mnth+"-01"];
InputControl_23.getInputControlDataSource().setSelectedMembers(versionsel);
}
else if(dd===20)
{
versionsel=[yy.toString()+"-"+mnth+"-20",yy.toString()+"-"+mnth+"-19",yy.toString()+"-"+mnth+"-18",yy.toString()+"-"+mnth+"-17",yy.toString()+"-"+mnth+"-16",yy.toString()+"-"+mnth+"-15",yy.toString()+"-"+mnth+"-14",yy.toString()+"-"+mnth+"-13",yy.toString()+"-"+mnth+"-12",yy.toString()+"-"+mnth+"-11",yy.toString()+"-"+mnth+"-10",yy.toString()+"-"+mnth+"-09",yy.toString()+"-"+mnth+"-08",yy.toString()+"-"+mnth+"-07",yy.toString()+"-"+mnth+"-06",yy.toString()+"-"+mnth+"-05",yy.toString()+"-"+mnth+"-04",yy.toString()+"-"+mnth+"-03",yy.toString()+"-"+mnth+"-02",yy.toString()+"-"+mnth+"-01"];
InputControl_23.getInputControlDataSource().setSelectedMembers(versionsel);
}
else if(dd===21)
{
versionsel=[yy.toString()+"-"+mnth+"-21",yy.toString()+"-"+mnth+"-20",yy.toString()+"-"+mnth+"-19",yy.toString()+"-"+mnth+"-18",yy.toString()+"-"+mnth+"-17",yy.toString()+"-"+mnth+"-16",yy.toString()+"-"+mnth+"-15",yy.toString()+"-"+mnth+"-14",yy.toString()+"-"+mnth+"-13",yy.toString()+"-"+mnth+"-12",yy.toString()+"-"+mnth+"-11",yy.toString()+"-"+mnth+"-10",yy.toString()+"-"+mnth+"-09",yy.toString()+"-"+mnth+"-08",yy.toString()+"-"+mnth+"-07",yy.toString()+"-"+mnth+"-06",yy.toString()+"-"+mnth+"-05",yy.toString()+"-"+mnth+"-04",yy.toString()+"-"+mnth+"-03",yy.toString()+"-"+mnth+"-02",yy.toString()+"-"+mnth+"-01"];
InputControl_23.getInputControlDataSource().setSelectedMembers(versionsel);
}
else if(dd===22)
{
versionsel=[yy.toString()+"-"+mnth+"-22",yy.toString()+"-"+mnth+"-21",yy.toString()+"-"+mnth+"-20",yy.toString()+"-"+mnth+"-19",yy.toString()+"-"+mnth+"-18",yy.toString()+"-"+mnth+"-17",yy.toString()+"-"+mnth+"-16",yy.toString()+"-"+mnth+"-15",yy.toString()+"-"+mnth+"-14",yy.toString()+"-"+mnth+"-13",yy.toString()+"-"+mnth+"-12",yy.toString()+"-"+mnth+"-11",yy.toString()+"-"+mnth+"-10",yy.toString()+"-"+mnth+"-09",yy.toString()+"-"+mnth+"-08",yy.toString()+"-"+mnth+"-07",yy.toString()+"-"+mnth+"-06",yy.toString()+"-"+mnth+"-05",yy.toString()+"-"+mnth+"-04",yy.toString()+"-"+mnth+"-03",yy.toString()+"-"+mnth+"-02",yy.toString()+"-"+mnth+"-01"];
InputControl_23.getInputControlDataSource().setSelectedMembers(versionsel);
}
else if(dd===23)
{
versionsel=[yy.toString()+"-"+mnth+"-23",yy.toString()+"-"+mnth+"-22",yy.toString()+"-"+mnth+"-21",yy.toString()+"-"+mnth+"-20",yy.toString()+"-"+mnth+"-19",yy.toString()+"-"+mnth+"-18",yy.toString()+"-"+mnth+"-17",yy.toString()+"-"+mnth+"-16",yy.toString()+"-"+mnth+"-15",yy.toString()+"-"+mnth+"-14",yy.toString()+"-"+mnth+"-13",yy.toString()+"-"+mnth+"-12",yy.toString()+"-"+mnth+"-11",yy.toString()+"-"+mnth+"-10",yy.toString()+"-"+mnth+"-09",yy.toString()+"-"+mnth+"-08",yy.toString()+"-"+mnth+"-07",yy.toString()+"-"+mnth+"-06",yy.toString()+"-"+mnth+"-05",yy.toString()+"-"+mnth+"-04",yy.toString()+"-"+mnth+"-03",yy.toString()+"-"+mnth+"-02",yy.toString()+"-"+mnth+"-01"];
InputControl_23.getInputControlDataSource().setSelectedMembers(versionsel);
}
else if(dd===24)
{
versionsel=[yy.toString()+"-"+mnth+"-24",yy.toString()+"-"+mnth+"-23",yy.toString()+"-"+mnth+"-22",yy.toString()+"-"+mnth+"-21",yy.toString()+"-"+mnth+"-20",yy.toString()+"-"+mnth+"-19",yy.toString()+"-"+mnth+"-18",yy.toString()+"-"+mnth+"-17",yy.toString()+"-"+mnth+"-16",yy.toString()+"-"+mnth+"-15",yy.toString()+"-"+mnth+"-14",yy.toString()+"-"+mnth+"-13",yy.toString()+"-"+mnth+"-12",yy.toString()+"-"+mnth+"-11",yy.toString()+"-"+mnth+"-10",yy.toString()+"-"+mnth+"-09",yy.toString()+"-"+mnth+"-08",yy.toString()+"-"+mnth+"-07",yy.toString()+"-"+mnth+"-06",yy.toString()+"-"+mnth+"-05",yy.toString()+"-"+mnth+"-04",yy.toString()+"-"+mnth+"-03",yy.toString()+"-"+mnth+"-02",yy.toString()+"-"+mnth+"-01"];
InputControl_23.getInputControlDataSource().setSelectedMembers(versionsel);
}
else if(dd===25)
{
versionsel=[yy.toString()+"-"+mnth+"-25",yy.toString()+"-"+mnth+"-24",yy.toString()+"-"+mnth+"-23",yy.toString()+"-"+mnth+"-22",yy.toString()+"-"+mnth+"-21",yy.toString()+"-"+mnth+"-20",yy.toString()+"-"+mnth+"-19",yy.toString()+"-"+mnth+"-18",yy.toString()+"-"+mnth+"-17",yy.toString()+"-"+mnth+"-16",yy.toString()+"-"+mnth+"-15",yy.toString()+"-"+mnth+"-14",yy.toString()+"-"+mnth+"-13",yy.toString()+"-"+mnth+"-12",yy.toString()+"-"+mnth+"-11",yy.toString()+"-"+mnth+"-10",yy.toString()+"-"+mnth+"-09",yy.toString()+"-"+mnth+"-08",yy.toString()+"-"+mnth+"-07",yy.toString()+"-"+mnth+"-06",yy.toString()+"-"+mnth+"-05",yy.toString()+"-"+mnth+"-04",yy.toString()+"-"+mnth+"-03",yy.toString()+"-"+mnth+"-02",yy.toString()+"-"+mnth+"-01"];
InputControl_23.getInputControlDataSource().setSelectedMembers(versionsel);
}
else if(dd===26)
{
versionsel=[yy.toString()+"-"+mnth+"-26",yy.toString()+"-"+mnth+"-25",yy.toString()+"-"+mnth+"-24",yy.toString()+"-"+mnth+"-23",yy.toString()+"-"+mnth+"-22",yy.toString()+"-"+mnth+"-21",yy.toString()+"-"+mnth+"-20",yy.toString()+"-"+mnth+"-19",yy.toString()+"-"+mnth+"-18",yy.toString()+"-"+mnth+"-17",yy.toString()+"-"+mnth+"-16",yy.toString()+"-"+mnth+"-15",yy.toString()+"-"+mnth+"-14",yy.toString()+"-"+mnth+"-13",yy.toString()+"-"+mnth+"-12",yy.toString()+"-"+mnth+"-11",yy.toString()+"-"+mnth+"-10",yy.toString()+"-"+mnth+"-09",yy.toString()+"-"+mnth+"-08",yy.toString()+"-"+mnth+"-08",yy.toString()+"-"+mnth+"-06",yy.toString()+"-"+mnth+"-05",yy.toString()+"-"+mnth+"-04",yy.toString()+"-"+mnth+"-03",yy.toString()+"-"+mnth+"-02",yy.toString()+"-"+mnth+"-01"];
InputControl_23.getInputControlDataSource().setSelectedMembers(versionsel);
}
else if(dd===27)
{
versionsel=[yy.toString()+"-"+mnth+"-27",yy.toString()+"-"+mnth+"-26",yy.toString()+"-"+mnth+"-25",yy.toString()+"-"+mnth+"-24",yy.toString()+"-"+mnth+"-23",yy.toString()+"-"+mnth+"-22",yy.toString()+"-"+mnth+"-21",yy.toString()+"-"+mnth+"-20",yy.toString()+"-"+mnth+"-19",yy.toString()+"-"+mnth+"-18",yy.toString()+"-"+mnth+"-17",yy.toString()+"-"+mnth+"-16",yy.toString()+"-"+mnth+"-15",yy.toString()+"-"+mnth+"-14",yy.toString()+"-"+mnth+"-13",yy.toString()+"-"+mnth+"-12",yy.toString()+"-"+mnth+"-11",yy.toString()+"-"+mnth+"-10",yy.toString()+"-"+mnth+"-09",yy.toString()+"-"+mnth+"-08",yy.toString()+"-"+mnth+"-07",yy.toString()+"-"+mnth+"-06",yy.toString()+"-"+mnth+"-05",yy.toString()+"-"+mnth+"-04",yy.toString()+"-"+mnth+"-03",yy.toString()+"-"+mnth+"-02",yy.toString()+"-"+mnth+"-01"];
InputControl_23.getInputControlDataSource().setSelectedMembers(versionsel);
}
else if(dd===28)
{
versionsel=[yy.toString()+"-"+mnth+"-28",yy.toString()+"-"+mnth+"-27",yy.toString()+"-"+mnth+"-26",yy.toString()+"-"+mnth+"-25",yy.toString()+"-"+mnth+"-24",yy.toString()+"-"+mnth+"-23",yy.toString()+"-"+mnth+"-22",yy.toString()+"-"+mnth+"-21",yy.toString()+"-"+mnth+"-20",yy.toString()+"-"+mnth+"-19",yy.toString()+"-"+mnth+"-18",yy.toString()+"-"+mnth+"-17",yy.toString()+"-"+mnth+"-16",yy.toString()+"-"+mnth+"-15",yy.toString()+"-"+mnth+"-14",yy.toString()+"-"+mnth+"-13",yy.toString()+"-"+mnth+"-12",yy.toString()+"-"+mnth+"-11",yy.toString()+"-"+mnth+"-10",yy.toString()+"-"+mnth+"-09",yy.toString()+"-"+mnth+"-08",yy.toString()+"-"+mnth+"-07",yy.toString()+"-"+mnth+"-06",yy.toString()+"-"+mnth+"-05",yy.toString()+"-"+mnth+"-04",yy.toString()+"-"+mnth+"-03",yy.toString()+"-"+mnth+"-02",yy.toString()+"-"+mnth+"-01"];
InputControl_23.getInputControlDataSource().setSelectedMembers(versionsel);
}
else if(dd===29)
{
versionsel=[yy.toString()+"-"+mnth+"-29",yy.toString()+"-"+mnth+"-28",yy.toString()+"-"+mnth+"-27",yy.toString()+"-"+mnth+"-26",yy.toString()+"-"+mnth+"-25",yy.toString()+"-"+mnth+"-24",yy.toString()+"-"+mnth+"-23",yy.toString()+"-"+mnth+"-22",yy.toString()+"-"+mnth+"-21",yy.toString()+"-"+mnth+"-20",yy.toString()+"-"+mnth+"-19",yy.toString()+"-"+mnth+"-18",yy.toString()+"-"+mnth+"-17",yy.toString()+"-"+mnth+"-16",yy.toString()+"-"+mnth+"-15",yy.toString()+"-"+mnth+"-14",yy.toString()+"-"+mnth+"-13",yy.toString()+"-"+mnth+"-12",yy.toString()+"-"+mnth+"-11",yy.toString()+"-"+mnth+"-10",yy.toString()+"-"+mnth+"-09",yy.toString()+"-"+mnth+"-08",yy.toString()+"-"+mnth+"-07",yy.toString()+"-"+mnth+"-06",yy.toString()+"-"+mnth+"-05",yy.toString()+"-"+mnth+"-04",yy.toString()+"-"+mnth+"-03",yy.toString()+"-"+mnth+"-02",yy.toString()+"-"+mnth+"-01"];
InputControl_23.getInputControlDataSource().setSelectedMembers(versionsel);
}
else if(dd===30)
{
versionsel=[yy.toString()+"-"+mnth+"-30",yy.toString()+"-"+mnth+"-29",yy.toString()+"-"+mnth+"-28",yy.toString()+"-"+mnth+"-27",yy.toString()+"-"+mnth+"-26",yy.toString()+"-"+mnth+"-25",yy.toString()+"-"+mnth+"-24",yy.toString()+"-"+mnth+"-23",yy.toString()+"-"+mnth+"-22",yy.toString()+"-"+mnth+"-21",yy.toString()+"-"+mnth+"-20",yy.toString()+"-"+mnth+"-19",yy.toString()+"-"+mnth+"-18",yy.toString()+"-"+mnth+"-17",yy.toString()+"-"+mnth+"-16",yy.toString()+"-"+mnth+"-15",yy.toString()+"-"+mnth+"-14",yy.toString()+"-"+mnth+"-13",yy.toString()+"-"+mnth+"-12",yy.toString()+"-"+mnth+"-11",yy.toString()+"-"+mnth+"-10",yy.toString()+"-"+mnth+"-09",yy.toString()+"-"+mnth+"-08",yy.toString()+"-"+mnth+"-07",yy.toString()+"-"+mnth+"-06",yy.toString()+"-"+mnth+"-05",yy.toString()+"-"+mnth+"-04",yy.toString()+"-"+mnth+"-03",yy.toString()+"-"+mnth+"-02",yy.toString()+"-"+mnth+"-01"];
InputControl_23.getInputControlDataSource().setSelectedMembers(versionsel);
}
else if(dd===31)
{
versionsel=[yy.toString()+"-"+mnth+"-31",yy.toString()+"-"+mnth+"-30",yy.toString()+"-"+mnth+"-29",yy.toString()+"-"+mnth+"-28",yy.toString()+"-"+mnth+"-27",yy.toString()+"-"+mnth+"-26",yy.toString()+"-"+mnth+"-25",yy.toString()+"-"+mnth+"-24",yy.toString()+"-"+mnth+"-23",yy.toString()+"-"+mnth+"-22",yy.toString()+"-"+mnth+"-21",yy.toString()+"-"+mnth+"-20",yy.toString()+"-"+mnth+"-19",yy.toString()+"-"+mnth+"-18",yy.toString()+"-"+mnth+"-17",yy.toString()+"-"+mnth+"-16",yy.toString()+"-"+mnth+"-15",yy.toString()+"-"+mnth+"-14",yy.toString()+"-"+mnth+"-13",yy.toString()+"-"+mnth+"-12",yy.toString()+"-"+mnth+"-11",yy.toString()+"-"+mnth+"-10",yy.toString()+"-"+mnth+"-09",yy.toString()+"-"+mnth+"-08",yy.toString()+"-"+mnth+"-07",yy.toString()+"-"+mnth+"-06",yy.toString()+"-"+mnth+"-05",yy.toString()+"-"+mnth+"-04",yy.toString()+"-"+mnth+"-03",yy.toString()+"-"+mnth+"-02",yy.toString()+"-"+mnth+"-01"];
InputControl_23.getInputControlDataSource().setSelectedMembers(versionsel);
}
Cross filter Input Control between each page:
//get PA value from prompt
var getPA = Table_4.getDataSource().getVariableValues("APA_00")[0];
//get BA value from prompt
var getBA = Table_4.getDataSource().getVariableValues("ABU_00")[0];
if (getBA===undefined)
{
//set BA into input control
InputControl_3.getInputControlDataSource().setAllMembersSelected();
}
else
{ //get BA value
switch (getBA.type)
{
case VariableValueType.Single:
var BA=cast(Type.SingleVariableValue, getBA).value;
break;
default:
break;
}
}
if (BA==="BAVG")
{
InputControl_3.getInputControlDataSource().setSelectedMembers("[Product_Area].[Business_Area].&[BAVG]");
console.log("BAVG");
}
else if (BA==="BACP")
{
InputControl_3.getInputControlDataSource().setSelectedMembers("[Product_Area].[Business_Area].&[BACP]");
console.log("BACP");
}
if (getPA===undefined)
{
//set PA into input control
InputControl_1.getInputControlDataSource().setAllMembersSelected();
}
else
{
console.log(cast(Type.SingleVariableValue, getPA).value);
//assign value to PA variable
var PA=cast(Type.SingleVariableValue, getPA).value;
//set PA into input control
InputControl_1.getInputControlDataSource().setSelectedMembers(PA);
}
0 टिप्पणियाँ
Please do not enter any spam link in the comment box.