Symptom
You are creating a new key figure but on saving you face the following error:
Save failed
Instance with the same key already exists
Environment
SAP Business byDesign
Reproducing the Issue
- Go to the work center Business Analytics and the view Design Key Figures.
- Click New.
- In step 1, enter a key figure name and select the required data source.
- Choose the type "restricted key figure".
- Go to step 2 and enter your formula here.
- Click Save.
You get the above errors.
Cause
There is an issue in the parameter-handling, when a date-parameter is used multiple times.
For example, you may have used "Today" several times in your formula. This can happen with any date parameter.
Resolution
We are currently checking if / how this can be improved in future releases, however there is a workaround:
Create your key figure with a formula where the date parameter is used only once. Save this key figure.
When you edit it again, you can change the formula as required, i.e. the date can be used as many times as needed.
Keywords
key figure, business analytics, can't save, instance with same key already exists, reporting, save failed , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Product Enhancement