About skcpaleti65

skcpaleti65

Hi Experts, In the story screenshot below, I am using the below data action code to get the period total redistributed to all of its' weeks equally, either to 4 or 5 of them, based on the 4-4-5 pattern, for a range of periods. But, it's not working. ...

skcpaleti65

Hi Experts,In SAP SAC, how we need to define the properties of a dimension, i.e., as text or integer to use it as a date, e.g., as shown below to be used in the commission calculation:EmpID start_date sales_start_dateEmp1 02152021 ...

skcpaleti65

Hi All, We are getting an error on our model: 'Currency Conversion metadata cannot be retrieved'. Nothing changed except that the SAC got upgraded with the latest release as per SAP's quarterly schedule for SAC. Thanks, -SP

skcpaleti65

Hi All, We have two Accts. Acct1 and Acct2, and Date: 2022 to 2023. We need member formula where prior periods have to be read. It has to be repeated for each Quarter in the similar manner as shown below. Date: 202212 202301 202302 202303 2...

skcpaleti65

Will try that, William_Yu. Once done that, I will mark this as the solution. Thanks.

skcpaleti65

Hi William_Yu, even if I enter data for one week of a period, it is dividing it equally for all the 104 weeks (2 years) + '000000' week. How to fix this to work for respective periods only. Thanks.

skcpaleti65

William_Yu, if we pass the year in the parameter, then the solution would work for the entire year, period by period at once, correct? If so, then why do we need call the data action one period by one period. Thanks

skcpaleti65

Thanks William_Yu. Yes, we need to do this for multiple periods (18 periods) at one shot. What is the Memberset of the Date that you have set in the beginning of the code? I really appreciate it. Can you please write the blog on this or white paper o...

skcpaleti65

Thanks @N1kh1l

User Statistics

User Activity

In SAC, how to redistribute the period totals to all of its' weeks equally using a data action?

SAC: Do we need to define the properties of a dimension as text or integer to use it as a date?

Model Error: Currency conversion metadata cannot be retrieved

How to read the prior period values of Acct1 in Acct2

Re: In SAC, how to redistribute the period totals to all...

Re: In SAC, how to redistribute the period totals to all...

Re: In SAC, how to redistribute the period totals to all...

Re: In SAC, how to redistribute the period totals to all...

Re: SAC: Do we need to define the properties of a dimensi...