Question Re: SAC Upload data to a parent node in Technology Q&A

SAC Upload data to a parent node

borabt — Wed, 17 Aug 2022 17:54:00 GMT

Hi,

I want to upload data to a parent node in a parent child hierarchy. Is it possible and can it behave as if I input this data from an input template i.e. disagregate with standard methods ?

The current use case is that some users are planning unit cost at brand level where brand is Level 2 in product hieararchy. Base level is product. When they plan unit cost we copy this to all base levels via standard disagregation features ( unit price is an account dimension member with exception aggregation average per product).

However, actual unit cost is not avaialble in source system and they also need to upload this information. But when I upload this data it got rejected with 0 records in rejection summary. Validations also successfull at last step. I upload 2 records where the only difference is 1st one is base level and the 2nd one is level 2 product .first one goes successfully so I am pretty sure this is the only problem.

Can there be a workaround? I know in other planning tools you can't do that either e.g. in BPC classic neither embedded without an end routine or upload badi interface but wondered how it is the case in SAC.

Re: SAC Upload data to a parent node

N1kh1l — Wed, 17 Aug 2022 18:34:31 GMT

borabt

SAC only stores data at leaf members. You can create alternate hierarchy where in your parent nodes from the first hierarchy are leaf members. Then its Its possible to enter plan data at nodes and then disaggregate it to child members. See the link below for more details of how it can be setup.

Please note whether it will allow to still load data at node is something you need to check. But you can manually plan through stories at nodes.

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/1679129715024574b7bbb4a611471765.html

Another approach can be you create dummy members (look alike ) to actual nodes in alternate hierarchy and then use either Allocation or Advanced formula to spread it to leaf members. This is similar to the approach in BPC.

Please upvote/accept if this helps.

Regards

Nikhil

Re: SAC Upload data to a parent node

marcelo_portella76 — Wed, 17 Aug 2022 18:53:03 GMT

There is an option during the data preparation:

Settings / Validation settings / Conditional validations

You can turn this setting on, and unflag the dimension/hierarchy you want to upload to a node.

It will not disaggregate though but upload to the node itself.

Hope that works for you.

Cheers!

Re: SAC Upload data to a parent node

swaroop_p — Mon, 20 Mar 2023 12:33:53 GMT

@Nikhil Anand,

Please let me know if there is any workaround to upload the data file to a parent node?

Regards,

Swaroop

Re: SAC Upload data to a parent node

N1kh1l — Mon, 20 Mar 2023 13:12:21 GMT

swaroop_p

Please follow the process explained by Marcelo.

Nikhil