About james_lim

james_lim

There is a blog about running QTD and YTD that is posted by @Sefan_Linders https://community.sap.com/t5/technology-blogs-by-sap/running-year-to-date-ytd-on-fiscal-periods-with-sap-datasphere/ba-p/13580611My customer wants to implement this on top of ...

james_lim

Maybe many users know how to do this but I just want to share it.In our planning process, we need to prepare the Budget for the next year (2026) and Long Range Planning (LRP) for future years (2027, 2028, 2029, and beyond). Consequently, the column w...

james_lim

Before we start discussing, I would like to let you know that you can get a 30-day trial instance of SAP Datasphere and access basic SAP Datasphere trainings here. https://developers.sap.com/tutorial-navigator.htmlAs an SAP Analytics Cloud (SAC) con...

james_lim

One of my customers tried to show the Planning Periods in their story but they could not do it using dynamic text in the SAC story because cannot access that attribute object using SAC script.Fortunately, we can do it using the 'Planning Models' Obje...

james_lim

SAC Date format is YYYYMM like 202201 and it has a property MonthDesc that has values Jan, Feb and so on. ACDOCP Date for Fiscal Period should be MM like 01,02... 12. When we run the retraction from SAC to S/4HANA, there is no way to manipulate ...

james_lim

@William_Yu Thank you!For someone who wants to know the comment of William, here is the URL of SAP Help site.https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/18850a0e13944f53aa8a8b7c094ea29e/4aa51e93f8804d2188c8ef034819ec73.html?locale=en&version=2024....

james_lim

@CinziaL Here are a couple of screenshots of Account Dimension. As you can see it, it has only 4 attributes for making it simple.'Hier' attribute has the information of the parent node.I hope it helps you.

james_lim

@JefB I searched the Customer support tickets those were opened last November and Contacted the support team member who worked for supporting it.The issue was resolved last November BUT API document and SAP Note clearly says it is not working officia...

james_lim

@JefB I checked that note but it works well in SAC version 2024.15.5. (2024.Q3 release)Please check it from your side and let me know if it still does not work because API docs are updated quarterly. I do not get any error and it returned correct val...

james_lim

Thanks for making it clear!

User Statistics

User Activity

Running QTD, YTD in SAP Datasphere using SQL View

SAC - Filtering Column Dimension Member Combinations to Hide Unnecessary Combinations

SAP Datasphere - How to flip sign the Measure value by GL Account type like SAP Analytics Cloud.

How to show the Planning Periods(Start Date,End Date) those are defined in the Version Dimension?

When you export SAC Planning data to ACDOCP.

Re: SAC - Filtering Column Dimension Member Combinations to Hide Unnecessary Combinations

Re: SAP Datasphere - How to flip sign the Measure value by GL Account type like SAP Analytics Cloud

Re: How to show the Planning Periods(Start Date,End Date) those are defined in the Version Dimension

Re: How to show the Planning Periods(Start Date,End Date) those are defined in the Version Dimension

Re: How to integrate SAP Analytics Cloud for planning with SAP S/4HANA for group reporting