SAC Story date Issue

[yoursraghu986]

Hi All

In our Sac Story Implementation,  we are using input control where we select Month( Oct-2024)

In Report Table :  in 1st column we need default data for Jan-2024 as per my input selection date(oct-2024)  I highlighted in yellow  , we need your help 

Based on Input control date selection (Oct-2024) we are able to display data, highlighted in Red 

Below image for Ref

Can someone  help its urgent 

[William_Yu1]

would you please rephrase your question a bit? It's difficult to understand.

[N1kh1l]

@yoursraghu986 

So If I understand this correctly, With Date IP control you have managed to show the column is red but you also want to show the yellow column which is January month Opening Balance. You can try the below with some scripting.

• Create a restricted measure calculation for the column in yellow. Use Input Control for restricting Date.
• Now you can use script to read the current Input control selection which will return 2024.10, Use script to manipulate this to create 2024.01 ( 01 is fixed, you just need to get year from date ip control selection). Store this in variable. Alternatively you can also read this from table if date member is available in axis or filter.
• Use this value to set the input control of restricted measure.

Useful API's

InputControlDataSource().getActiveSelectedMembers()

InputControlDataSource().setSelectedMembers()

Hope this helps !!

Nikhil

[yoursraghu986]

@N1kh1l Can you please elaborate in detail script implement