SAC Jump Target Report - Not able to pass fiscal year period range

[former_member781426]

From one SAC story we want to open another SAC story in another tab and pass the variables from the row/cell selected in the first SAC story. (Same Jump Traget functionality, which we have in SAP BW)

I can pass all required parameters/filters from the sourrce SAC story to the target SAC story as single value.

I want to pass fiscal year period as a range. I am not able to pass it to the target SAC report.

Please help me and let me know where I am getting wrong and how i can fix it.

I am attaching code below.

The below code is on table selection function

var selection = Table_1.getSelections();

if (selection.length > 0) {

Selected_CC = selection[0]["0COSTCENTER"];

// No need to convert to internal format because CC is already in internal format

Selected_GL = selection[0]["0GL_ACCOUNT"];

// The selection on GL is already in internal format compounded to Chart of Accounts

// This needs to be converted to the internal format for Cost Element, which is compounded to Controlling Area

Selected_CE_Int_Comp = ScriptObject_1.Get_Internal_Compound_CE();

Selected_Year_Var = Table_1.getDataSource().getVariableValues("ZMSYEAR01")[0];

switch (Selected_Year_Var.type) {

case VariableValueType.Single:

var singleValue = cast(Type.SingleVariableValue, Selected_Year_Var);

Selected_Year = singleValue.value;

Selected_Year_Int = ScriptObject_1.Get_Internal_Year();

break;

default:

break;

}

Selected_Year_Period_Int = Table_1.getDataSource().getVariableValues("ZMMPER005")[0];

switch (Selected_Year_Period_Int.type) {

case VariableValueType.Range:

var RangeValue = cast(Type.RangeVariableValue, Selected_Year_Period_Int );

// I am getting Fiscal Year Period Range in RangeValue2. How i can pass it to the code on button click

RangeValue2 = {

from: "V3"+ Selected_Year + RangeValue.from,

to: "V3"+ Selected_Year + RangeValue.to

};

console.log(RangeValue2);

debugger;

/*

RangeFrom = RangeValue.from;

Selected_Year_Period_From = ScriptObject_1.Get_Internal_Fiscal_Year_Period_From();

debugger;

console.log(RangeFrom );

console.log(Selected_Year_Period_From );

RangeTo = RangeValue.to;

Selected_Year_Period_To = ScriptObject_1.Get_Internal_Fiscal_Year_Period_To();

console.log(RangeTo );

console.log(Selected_Year_Period_To );

debugger;

*/

break;

default:

break;

}

}

Following code is on Go To button clickPopup_1.close();// Goto: Detailed Actual Report Including ProcurementNavigationUtils.openStory("C318C5834CCD55D17A4F8527B3AB0B78", "1", [UrlParameter.create("f01Model","t.7:Cth0ev1paocmuu2qa8disf5qd58"), UrlParameter.create("f01Dim", "0COSTCENTER"), UrlParameter.create("f01Val", Selected_CC), //UrlParameter.create("f01Val", "10000000101000"), UrlParameter.create("f01Op", "in"), UrlParameter.create("f02Model","t.7:Cth0ev1paocmuu2qa8disf5qd58"), UrlParameter.create("f02Dim", "0COSTELMNT"), UrlParameter.create("f02Val", Selected_CE_Int_Comp), //UrlParameter.create("f02Val", "10000000011050"), UrlParameter.create("f02Op", "in"), UrlParameter.create("f03Model","t.7:Cth0ev1paocmuu2qa8disf5qd58"), UrlParameter.create("f03Dim", "0FISCYEAR"), UrlParameter.create("f03Val", Selected_Year_Int), //UrlParameter.create("f03Val", "V32012"), UrlParameter.create("f03Op", "in"), UrlParameter.create("f04Model","t.7:Cth0ev1paocmuu2qa8disf5qd58"), UrlParameter.create("f04Dim", "0FISCPER"), UrlParameter.create("f04Val", " V32012001"), (At present I have just given single value not variable as range is not working here) What should i do to pass range here. //UrlParameter.create("f04Val", "V32012001"), UrlParameter.create("f04Op", "in") ], true);

[mfoeken · Accepted solution]

Hi Hardeep,

I think that passing a range is not supported at the moment. At least what I can see from the documentation is that only single and multiple values can be passed as a filter: Filter Parameters.

Kind regards,
Martijn van Foeken | Interdobs

[RUI_LIU · Accepted solution]

Hi Expert,

If the Datasphere can use "jump to" function now?