Fields getting disappeared from the Measures folder when we create a KPI using that measure

Answered

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:

  1. Transaction: (fields: Sales Amount, Commission Amount, cost and unit).

 
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
 

9 answers

Public
Tanya Gryshko Flexmonster 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

Public
Vinothkanna 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

Public
Dmytro Zvazhii Flexmonster 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

Public
Vinothkanna 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.
 

Public
Dmytro Zvazhii Flexmonster 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

Public
Vinothkanna 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

Public
Dmytro Zvazhii Flexmonster 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

Public
Vinothkanna May 28, 2018

Hi Dmytro,
 
Here In this I have attached the log file of my accelerator.
 
Thanks & Regards
Vinothkanna AR

Attachments:
flexmonster.log.txt

Public
Tanya Gryshko Flexmonster 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

Please login or Register to Submit Answer