Symptom
With SAC Import job from BW, if the hierarchy changes on BW side, SAC is not able to detect the hierarchy change automatically
Environment
- SAP Analytics Cloud
- SAP Business Warehouse
Reproducing the Issue
- Create an Import Job in SAC against a BW datasource
- Select the Hierarchy
- Change the drill level to 3
- Save the import job
- In BW the Hierarchy is changed to 4
- When you then edit the Import Job to use the 4 drill levels, the maximum value is still 3 as SAC does not allow for Hierarchy Level to be updated in the existing import jobs
Resolution
Development is working on this as part of overall BW Hierarchy import improvements
The only current workaround is to create a new import job which will then be able to take advantage of the additional Hierarchy level that has been added on the BW datasource
Keywords
Hierarchy BW SAC levels , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem
Product
SAP Analytics Cloud 1.0