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

How to get Name override value from dashboard designer KPI using code Expand / Collapse
Author
Message
Posted Thursday, May 31, 2012 4:49 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, October 31, 2012 5:00 AM
Points: 10, Visits: 171
Hello All,

I've been able to get kpi properties for a given scorecard using some .net code like this...

Publisher.GetKpisFromScorecard(scorecard identifier)

from this I can get guid, name and properties etc but what I can't find is the value from the 'kpi view settings' name override facility.

Now hold on I know this isn't a .net forum but... since I haven't been able to get the name override value from code I thought I might be able to go to source.

Could it be sourced directly from the dashboard database? I've seen some xml stored in one the tables that defines the scorecard when it's published - but again the override is not with the kpi which sounds about right as it can be different on each card.

Does anyone have any ideas about where in the dashboard database this might be? It has to be in there somewhere shirley? I can't find much on the schema model.

Any pointers or ideas would be appreciated.
Post #1308879
Posted Thursday, June 7, 2012 1:10 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, October 31, 2012 5:00 AM
Points: 10, Visits: 171
Got it. For anyone else looking for a solution... xml to build the card lies in FCObjects. This could be parsed and updated directly but that would negate the versioning that happens when cards are updated using the front end. However it can also be got at through .net using the configuredviews properties.
Post #1312323
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse