asked on May 10, 2018
Hi flexmonster,
Fields are getting disappeared from the measures folder, when we create KPI using those measure value.
Example:
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
Vinothkanna AR
⋅ May 11, 2018
Hello, Vinothkanna,
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.
Regards,
Tanya
⋅ May 11, 2018
Hi Tanya,
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.
Regards
Vinothkanna AR
⋅ May 14, 2018
Hello Vinothkanna,
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.
Regards,
Dmytro
⋅ May 22, 2018
Hi Dmytro,
As per our organization policy we will not be able to share any credentials of our environment. Below I will provide you steps to reproduce.
Step 1: Create analysis services cube with two measure value (testing) Eg: Revenue, cost
Step 2: Now create a KPI "Total Sales":
Value Expression:
[Measures].[Revenue]
Trend Expression:
Case
When IsEmpty
(ParallelPeriod
([Calendar].[My Calendar].[Month],1,[Calendar].[My Calendar].CurrentMember))
Then 0
When
KpiValue("Total Sales")>([Calendar].[My Calendar].PREVMEMBER)
Then 1
When
KpiValue("Total Sales")=([Calendar].[My Calendar].PREVMEMBER)
Then 0
When
KpiValue("Total Sales")<([Calendar].[My Calendar].PREVMEMBER)
Then -1
End
Step 3: Now deploy the cube.
Step 4: Access the cube using flexmonster.
Now you will not be able to see the Measure named "Revenue". Instead you will see that in the KPI folder.
My Concern is why it is getting disappeared from place where the measures are getting displayed.
Thanks & Regards
Vinothkanna.
⋅ May 23, 2018
Hello Vinothkanna,
Thank you for the example. If you are using Flexmonster accelerator tool the old state may have been cached. We recommend you restarting the accelerator after the schema was changed.
Please let us know if it works for you.
Regards,
Dmytro
⋅ May 24, 2018
Hi Dmytro,
I have stopped the service as well I have cleared my browser cache. Still I cant able to see the measure field getting listed with the other measure values. Only the KPI value is getting displayed
Regards
Vinothkanna AR
⋅ May 24, 2018
Hello Vinothkanna!
Is it possible to send me the log file of your accelerator?
I hope it will provide us some useful information.
Thanks,
Dmytro
⋅ May 28, 2018
Hi Dmytro,
Here In this I have attached the log file of my accelerator.
Thanks & Regards
Vinothkanna AR
⋅ May 30, 2018
Hello, Vinothkanna,
Thanks for providing the log file. We have checked but were not able to reproduce the issue on our side.
Could you please consider one of the following options:
1) provide us with the temporary access to your web application (not necessarily to the whole environment). The access can be limited and allowed only for our IP address.
2) provide us with the sample test cube where the issue is reproducible
This would greatly help us. Please let us know what you think.
Regards,
Tanya
