Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Trend indictor in SSAS 2008 showing wrong Expand / Collapse
Author
Message
Posted Wednesday, September 07, 2011 4:21 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 2:38 AM
Points: 32, Visits: 161
Hi,
I am defining a KPI. For the trend indicator it will show a green arrow when I have a lower value for the KPI Value current month compared to previous month. As I have interpreted when creating trend indicators, the value 1 means green colour.

Because the value for the trend indicator should have a lower value I want no have the reversed arrow (a green arrow directing downwards). But when I have the value 1 the arrow is showing red colour and directed downwards.

I am using excel 2010 when accessing the cube. Is there anyone who knows anything about this? Is there a bug in Excel 2010?

// Niklas H
Post #1170954
Posted Tuesday, June 04, 2013 5:26 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 22, 2013 1:13 AM
Points: 350, Visits: 474
Dear,

I recently had a similar issue.
I could solve it by applying the StrToValue function to the KPIValue("myKPI") variable in the KPI Status calculation.

Franky


Franky L.
Post #1459677
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse