Hi All,
I am creating a report in excel using the SAPGETDATA formula. I'm getting a #VALUE! error on refresh but when I click into the formula itself and click out the formula displays the correct value although if I refresh the workbook again, the...
Hi All,
I am trying to export data from an SAC model to S4 with a Week Granularity date dimension to ACDOCP but it fails displaying this error before showing errored records.
If I change the model back to a "non" week model then it works fine....
Hi All,
Using the new SAP.GETDATA function in the SAC Microsoft excel Add-In, it is possible to define a date for Period = 202201 (Jan 22) , Quarter = 20221 (Jan 2022, Feb 2022, Mar 2022), Year = 2022 but is there a way to show Half Year?
Even be...
Hi All,
I am trying to create a simple copy data action using a date dimension with week granularity. I have created two parameters "FROM" & "TO" to allow the user to define what data they would like to copy/to.
I'm getting an error which looks ...
Hi Nikhil,I hope you are well? I am using the Forecast Layout without any issues but I have a requirement for a 10 year forecast and it seems the max amount of months available is 100 rather than 120. Do you know if this is a known limitation? I cann...
Hi Derek,
Thanks very much for this post. I have a question specific to Data Action scoping slightly different to Jef.
For script Data Actions, it's possible to restrict the planning horizon using memberset with start / end dates on the version dim...
Hi Johannes,
Thanks for the blog. One follow up question: Is it possible to apply the same styling rules to multiple tables? Not, styles, but the rules.
Seamus