Skip to Content
1
Aug 03, 2023 at 06:54 PM

SAC Live Data connection to HANA with hierarchies and data load restriction

145 Views

Hi All,

We have a scenario for creating internal order reporting for specific group (hierarchy),where we are building a calculation view with 2 hierarchies Cost element & Internal Order. One restriction that we saw was that when the join is full outer with the hierarchy and the data coming from COVP the hierarchy works in SAC otherwise it does not. With full outer join we are facing the issue of additional data record coming in the extract.

eg. Internal order A is part of the hierarchy and Internal Order B is not, but because of Outer join both the values are being flown to SAC resulting in inflated data for the associated cost centers.

We also had an option of restricting the COVP data to the number of internal orders in the hierarchy but it will be a very crude way of filtering as every change in the Internal order grouping or cost element grouping needs to be reflected in the Calculation views.

Second topic :

We have experienced data error when the number of records that are exposed is huge meaning same calculation view when restricted to 1 month of data works correctly but multiple periods leads to error. Is there a limitation on the data being exposed ?