Ever wondered how to set up a dynamic solution for inventory snapshots—whether you’re looking at cumulative or non-cumulative stock? Curious about how this is done in S/4HANA’s VDM? If so, you’ve landed on the right post.Let’s talk about what you nee...
Consider a scenario where planning data needs to be compared to actuals, and the actuals include adjustments (i.e., Actuals = Actuals + Adjustments). Depending on the input control selection, it may be necessary to exclude certain periods from these ...
As an SAC Planning Developer, you might need to run some custom code or Data Actions before or right after the user clicks the Publish Data button. I would like to highlight two possible solutions for this use case:If your Story is relatively small a...
Hi,
I have been looking at the Datasphere / Standard Application Roles, and it looks like
DW Viewer - Can view objects in spaces of which they are a member and view data output by views that are exposed for consumption in these spaces.
This ro...
Hello,
I am seeking advice on optimizing the process of using a large table without a key defined for reporting. (DWC)
I happen to have a 1bln+ and a quickly growing table needed for reporting. It has about 16 columns. There will be an archiving ...
Hey @JefB, I am considering this approach. Could you please tell me how you automatically fill out the attributes of the copy-pasted versions in each model from the public dimension?
Hi, It should be easier as it's cloud to cloud so you don't need to care about the firewalls. In DSP, you whitelist the IP (unless it's same platform then most likely you don't need to) and provision a DB user and password of the space with CRUD auth...
Yes, thanks, the question is if the persistence of AND "[delta_field]" >= ( SELECT "DATE" FROM "[DELTA Table]" WHERE "EXTRACTOR" = '[extractor_name]' ) was pushed down through the remote table (or its persistence in the view)#2 View uses an SDA/Remot...
Thank you for the blog, It gives me a new level of appreciation of the 'snapshot' ADSO feature in BW/4HANA A neat touch with the binary conversion and generating hashes. Out of curiosity, how often did you update the source table, and through which...
Thanks for the blog!I think the question was if your data flow was capable of pushing down the following SQL:AND "[delta_field]" >= ( SELECT "DATE" FROM "[DELTA Table]" WHERE "EXTRACTOR" = '[extractor_name]' )through the remote table to the source sy...
