About amrita_goswami

amrita_goswami

Hello SAC Experts,Looking for guidance regarding adjusting Rounding differences in our data pre and post allocation.For example, our preallocation data is something like this: AccountProductEntityDateValueQuantitySparkling Water#Dec.2018210Post Alloc...

amrita_goswami

Hi All, We are looking to Integrate SAC Excel Add-In with Live data from S/4 system for Reporting. Please let me know if this is supported yet. I found some documentation which mentions this-https://help.sap.com/docs/SAP_ANALYTICS_CLOUD_OFFICE/c6...

amrita_goswami

Hi All, We need to pull the Planned depreciation values from S/4 into SAC. We are using S/4 on Premise - S4CORE 107. The API FAA_ASSET_DEPRECIATION_LIST_SRV has been activated for this purpose. This API has an entity set - C_FixedAssetDepreciatio...

amrita_goswami

Hi All, I need to use the Days in Previous Month in a calculation. For this I have written the following code: MEMBERSET [d/Date] = [d/Version].[p/StartMonth] TO [d/Version].[p/EndMonth]<br>INTEGER @DSO1 = 0<br>INTEGER @DSO2 = 0<br>INTEGER @DS...

amrita_goswami

Hi All, I am using an Advanced formula to calculate Salaries for Employees. Start and End Month are maintained as attributes of Version. Now there are some Employees whose Hire Date is later than the Version Satrt Month. For example, Budget Star...

amrita_goswami

Hi Alex, We have been using SAC Excel Workbooks to input and publish data. However over the past 2/3 weeks we noticed that in one of our Workbooks the Publish Button is greyed out after 'Process Data' button is clicked. The underlying Role has the f...

amrita_goswami

Thanks for confirming Steffen!We are hoping SAC Add in will soon support more Live Datasources for reporting.

amrita_goswami

Hi Jessica,Sorry for posting late on this thread, I am trying to use API_FINPLAN_COSTESTIMATE_ITEMS_SRV to extract Product Cost to SAC. However the Import job does not execute. Do we need to have a dedicated OData service for this API ? Do any Parame...

amrita_goswami

Thank you for the detailed explanation Nikhil.Since we need to use the variables @Rev and @ Vol in this case, it would also make it necessary to use a For loop so that data for all Periods or all Profit centers does not get aggregated. Is there any ...

amrita_goswami

Thanks for the help Nikhil. To answer some of your questions - I had changed the Account Numbers while posting the code. The IF statement is done because I am trying to sum up the data in all Accounts under Net-Rev and Price should get posted in the ...

User Statistics

User Activity

SAC Adjusting for Rounding Difference

SAC Excel Add In with Live Data

Pulling data from API- FAA_ASSET_DEPRECIATION_LIST_SRV

SAC calculate Days in Previous Month in Advanced Formula

Comparing Dimension attribute with Date

Re: Designer / viewer rights in SAP Analytics Cloud, add-in for Microsoft Office

Re: SAC Excel Add In with Live Data

Re: API_FINPLAN_COSTESTIMATE_ITEMS_SRV not on API Business Hub

Re: SAC Advanced Formula dividing Revenue by Volume

Re: SAC Advanced Formula dividing Revenue by Volume