SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How to get Name override value from dashboard designer KPI using code


How to get Name override value from dashboard designer KPI using code

Author
Message
foldyman
foldyman
Grasshopper
Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)

Group: General Forum Members
Points: 18 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.
foldyman
foldyman
Grasshopper
Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)

Group: General Forum Members
Points: 18 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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search