About PS_1978

PS_1978

Hello - I understand that, we can use multi-action starters in SAC Stories. When we click on the starter, the system prompts a pop-up to fill parameters before running.Is there anyway that we can pass values to these parameters dynamically (using scr...

PS_1978

Hello Team,I request some help with a requirement to incorporate YTD Gross values from external files into tax calculations. Currently, YTD values are derived from monthly wages in the system, but we now need to use the YTD from the file for the last...

PS_1978

Hello Team - We have import job (to a model) scheduled as a calendar even in our SAP Analytics Cloud tenant. The import job has a few rejected records and the rejected summary has a message, "Data Access Control violation" for all the records. I have...

PS_1978

Hello Gurus - I have a requirement to exclude a few records from file while loading into SAC Public Dimension (NOT into MODEL). I don't see any option while doing transformation (mapping). Is there a way to exclude them?For Example:Dimension Name: WB...

PS_1978

Hello Team – I have a requirement to calculate "Salary %" as % of days an employee has spent in their 1st or last month of their employment.For example, In working forecast, if an employee’s last day of the employment is 26th June 2025, I want their ...

PS_1978

Thanks for your response, @William_Yu. Yeah, that is what I have implemented. Thought it would be great if we can pass parameters dynamically to multi action starter. Regards, Phani

PS_1978

Sorry, I couldn’t explain it clearly. However, I have maintained the company code in the dimension and used it in resultlookups. I didn't want to follow this approach and wanted to use it as a last option.Could you help me understand how to use a “re...

PS_1978

Thanks @William_Yu for your response.Background:We use annual salaries from SF (loaded as Actuals) and split them into monthly forecasts using SAC Data Actions to calculate future YTD values.New Requirement:Use external YTD values for the last month ...

PS_1978

It looks good now. I haven't done any thing (like re-saving the schedule). I just navigated through the dimension and model. The latest load completed successfully without any warnings. Thanks, Phani

PS_1978

Hello @N1kh1l - Yes I read this in a OSS Note. However that was applicable for an import job scheduled in the model - data management. Mine is a calendar event with multi action. Do you think it will still help? I will give a try though. Thanks, Phan...

User Statistics

User Activity

Multi-Action Starter in a Story (ODE) - Populate parameters dynamically

Updating Dimension Attributes in a model

Rejected Records with Issue - "Data Access Control violation" in a model Import Job

SAC Master Data Loads - Exclude few records

Calculate Salary % in Advance Formulas Step in DataAction

Re: Multi-Action Starter in a Story (ODE) - Populate para...

Re: Updating Dimension Attributes in a model

Re: Updating Dimension Attributes in a model

Re: Rejected Records with Issue - "Data Access Control vi...

Re: Rejected Records with Issue - "Data Access Control vi...