Fields are getting disappeared from the measures folder, when we create KPI using those measure value.
We have a cube with following measures:
When we create a KPI using the Sales Amount, then the Sales Amount field is getting disappeared from the Transaction folder.
After that it is getting displayed in the KPI folder, using of the KPI value is not a proper work around. Because there is variation between KPI value and Measure value.
Thanks & Regards
Thank you for writing to us.
We suggest creating KPI with a different name, other than Sales Amount. This should solve the issue. Please let me know if it helps.
The name of the KPI which I have created was “Revenue Variance” which is different from the actual name of the measure (i.e) Sales Amount. So the issue still exists.
Thank you for your feedback. Could you please provide us with the access to your environment? It will help us a lot in our further investigation. You can send all the information on our email:
Waiting to hear from you.