Data Action publishing issue.

[vijaykumar108]

• we are running Data action.Its failing in final step that is Publish step. we have validation rule for this model for profitcenter and company code.
• Error :The results of the data action ABC could not be published on version EFGHIJ ,you can still try do a partial publish manually.only data changes on valid dimension combinations can be published.

[William_Yu1]

What exactly result are you expecting?

[N1kh1l]

vijaykumar108

Your data Action is generating records on invalid combination. When Data Action is run, it creates an implicit private version and stores all generated records in data action in this version. Then this private version is published to the public version (target version) where all kind of checks (validation/access ) is done. If any check is violated you get this publish error. Now you have the option to do partial publish (all records passing validation will get published). To analyze invalid combination I would suggest you limit your scope of records by key dimension especially the ones used in validation and see what records you are generating. You can run a trace to analyze the result.

Sime links which might be helpful

3008956 - Data Action Publishing Issue in SAP Analytics Cloud (SAC) - SAP for Me

3314948 - How to avoid "Some of your data changes can't be published because of validation rules. Th...

https://blogs.sap.com/2023/02/09/introduction-to-data-action-tracing/

Hope this helps !!

Nikhil

[sgodfree]

Just to add to this, we have an enhancement planned for our Q3/2023 release that will allow the Data Action itself (via the trigger button) to automatically perform a partial publish. Please see:

https://roadmaps.sap.com/board?BC=6EAE8B27FCC11ED892E91C2A1DFA40CC⦥=CURRENT-LAST#;INNO=AF740456A03F1...

[JefB]

sgodfree can't wait to see that in action!

What would really help users is insight into the exact granular records and reasons why publishing failed for them.
Is there anything coming in that perspective?