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 7, 2011 4:21 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 3, 2014 12:32 AM
Points: 32, Visits: 171
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 4, 2013 5:26 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, May 2, 2014 3:39 AM
Points: 350, Visits: 475
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