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 ...
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
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...
Hi Nikhil,In the formula, with standard Date dimension, as it is an existing model,IF(ISNULL([d/CALMONTH].[p/CALQUARTER] ) ,0 ,IF(ISNULL([d/CALMONTH].[p/CALMONTH]),[ACC4]/4,0))We have updated with one more running total for Year, let's ACCT5, and got...
Hi All,Just an update. Solved it by creating a new account Acct2_Report and wrote the following member formula, but hard coded. Need to make this parameterized. Can anyone suggest the solution where it does it for every quarter with corresponding shi...