About Freddie

Freddie

Hi all,I have some booked values stamped on [d/func_area] = # and the correct [d/gl_account] and [d/cost_center].I can derive the actual functional area by concatting two properties from [d/gl_account] and [d/cost_center].My question is, if it is pos...

Freddie

Hi all,I have a uploaded data via a csv file on FUNC_AREA = "#" and PLANT = "#" on an upload version. The rest of the dimensions is placed on the correct members.I need to transfer these numbers to an budget version, however it should post on the val...

Freddie

Hi SAC community,Is it possible to set story filters based on input control selections in a prompt when opening the story?If yes, can you please provide an example code?Best regards,

Freddie

Hi all,I want to implement the following logic: Write a "1" to Measure = Mismatch_Indicator for every member in "Site" Dimenstion if sales are above zero in Version = Public.Z AND there are no sales in Version = Public.X. The idea is to flag this sit...

Freddie

Hello,I am working on a script to change a property from a SAC story.The idea is that the planner can click on the property in the table (It displays both ID and the property), and then clicks on a button "Update Property". Then a popup opens, where ...

Freddie

@N1kh1l do you have a suggestion to do this with Javascript?

Freddie

Nice! Do you have any examples of how to?

Freddie

Hi @William_Yu1My idea was to filter a table on those two dimensions = "#". Then make an "on button click" script in an optimized story to do as explained in original post. As I can, string manipulations is available from there? However not sure if I...

Freddie

Hi William_Yu! It worked by multiplying with ((RESULTLOOKUP()/RESULTLOOKUP())+1). Thanks!

Freddie

Thanks alot, JefB. However, the story popup won't open in view mode even though I have StoryPopUp_1.open on init page...

User Statistics

User Activity

Concat two dimension properties and pass it to booked dimension values (Script)

Data Action - Place Dimension = # on the valid combination from booked data

Set story filters api based on input control

Nested IF Statement Comparing Versions

Change a property from SAC story script

Re: Concat two dimension properties and pass it to booked dimension values (Script)

Re: Concat two dimension properties and pass it to booked...

Re: Concat two dimension properties and pass it to booked...

Re: Data Action - Place Dimension = # on the valid combin...

Re: Set story filters api based on input control