.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Dashboard Designer: KPI's - Scoring Pattern "Decreasing is Better" returns confusing values

Posted By:      Posted Date: September 13, 2010    Points: 0   Category :SharePoint
Good day, I started using Sharepoint a few weeks back. I jumped straight into PerformancePoint Services, and have now now gotten the hang of it, r at least I think. Far from mastering anything though. Problem is: I have a table with three fields, namely ProjectName, ProjectBudget and ProjectCost put very simply. Say for example I have these records... ProjectName ProjectBudget ProjectCost Project A 15 000 20 000 Project B 10 000 20 000 Project C 15 000 15 000 Project D 15 000 10 000 Using ProjectBudget as my Target and ProjectCost as my Actual. How can I ensure that Project A and Project B are displayed as off target, while Project C and D are displayed as on target. Lastly, the percentages that are referred to in the "Thresholds" section, what are they referring to? Please let me know, if I need to provide more info. Thank you very much.  

View Complete Post

More Related Resource Links

Use Dashboard designer in Sharepoint Foundation 2010

Hi, I want to Install Dashboard Designer in Sharepoint Foundation 2010(WSS 4). I can only find articles on insatllation in Sharepoint Server 2010..like this one.. http://blogs.msdn.com/b/performancepoint/archive/2009/11/24/deploying-performancepoint-2010-soup-to-nuts.aspx?wa=wsignin1.0 Can you please let me know how I can use Performance Point in Sharepoint Foundation?   Thanks  

How to deploy dashboards made in dashboard designer to diferent site collections?

Hi I just migrated from sharepoint 2007 to 2010. We used to have performance point dashboards spread across libraries in subsites all across our primary site collection "Http://server:x" after I migrated I understand that I must migrate all performance point content to a new site or site collection made with the business intellingence template. I created a new site collection with this template (Http://server:x/sites/pps) and succesfully migrated all performance point content. Now I want to redeploy all the dashboards to their respective subsites in the  "Http://server:x" site collection so that everything looks exactly as it did when we where using SharePoint 2007. But when I try to deploy to a site I only get the option to deploy it to the ("Http://server:x/sites/pps") site collection and its respective libraries. I wish to manage all dashboard content centralized in (Http://server:x/sites/pps) but I want to deploy dashboards to libraries across  "Http://server:x" is this posible or how is Performance Point services supossed to work?   I also having trouble with DashBoard designer. I have everthing running on a Virtual Machine test enviroment. With windows server 2008 r2, 4 gb ram. Everything installed in one machine. And Suddently DashBoard Designer Crashes In the event log I get the error Dashboa

Hosted Designer fails to load workflow xaml that has InArguments with default values (xaml saved by

I have hosted the designer in our app. Using the hosted designer, workflows are saved as xaml to a database. When an end user wishes to edit a workflow the xaml is downloaded to a file and loaded into the designer via the .xaml file. The user can also associate assemblies with the workflow and there is a mechanism which makes sure that these assemblies are loaded into the appdomain and available. The problem we are hitting occurs when the top level activity (Sequence) has InArgument with default value. I create a simple Sequence, add InArguments (type of Int32 and String)  and set some default values. I save the workflow xaml to the database and close down the designer. When I wish to edit the workflow and try to load I get the following errors Could not find member '{clr-namespace:}_e905.argument3'. Could not find member '{clr-namespace:}_e905.argument1'. suggesting that some assembly/namespace missing. Here is the xaml I try to load: <Activity mc:Ignorable="sap" x:Class="{x:Null}" this:_e905.argument3="99" xmlns="http://schemas.microsoft.com/netfx/2009/xaml/activities" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:mva="clr-namespace:Microsoft.VisualBasic.Activities;assembly=System.Activities" xmlns:s="clr-namespace:System;assembly=mscorl

What is "semester" in Dashboard Designer?

I am setting time properties on an AS data source. When associating time members, I encountered "semester". Is this a 4-month period (Jan-Apr and so on)? Thanks 

How do I get column values in Sharepoint designer so I can use them as a variable in code block?

The code below is in my EditForm.aspx and it works but instead of it outputting "This is just a test!" I need get a number that is stored in a column named Phone Number that has 5555555555 stored in it and have the line that says TD2.innerHTML = "This is just a test!"; ouput what ever number is stored in the Phone Number column. Here is the code that is in my EditForm.aspx <script type="text/javascript">function DisplayItemID(){       var TD1 = document.createElement("TD");       TD1.className = "ms-formlabel";       TD1.innerHTML = "<h3 class='ms-standardheader'>Test</h3>";       var TD2 = document.createElement("TD");       TD2.className = "ms-formbody";       TD2.innerHTML = "This is just a test!";       var IdRow = document.createElement("TR");       IdRow.appendChild(TD1);       IdRow.appendChild(TD2);       var ItemBody = GetSelectedElement(document.getElementById("idAttachmentsRow"),"TABLE").getElementsByTagName("TBODY")[0]; 

Dynamic member selection filters in Dashboard Designer/PPS2010

Question regarding member selection filters in Dashboard Designer (PPS 2010): When selecting the filter members, is there any way to make them dynamic? I.e. when a new member is added (e.g. a new year when we enter one), can it be included without having to manually add them in the filter? Thanks.

How do I nest dimensions in scorecards in Dashboard Designer?

I have a scorecard where I have a KPI on columns and a dimension on rows. That works fine. I can also add another dimension on rows and add it as a parent for example. The only thing I miss is a drilldown "+". What I see is basically a scorecard showing all possible rows, while I want one where I can drill down (or through) and expand rows if I want. How do I get the parent to be expandable? Thanks

How to change the size (width) of scorecard columns in Dashboard Designer?

Is there any way to change the size (width) of scorecard columns in Dashboard Designer?

new with regex. returns no values. please help.

I have to pull out the content between(and including) every set of curly braces in a DownloadString. This is one sample that only has one set  of braces.[{"post_id":7046,"post_date":"2010-09-10 09:25:55","title":"Braking News: Keep Your Stopping Power","content":"<p>\r\n<object width=\"400\" height=\"320\" data=\"http:\/\/autonettv.com\/media\/mediaplayer.swf\" type=\"application\/x-shockwave-flash\">\r\n<param name=\"flashvars\" value=\"file=http:\/\/autonettv.com\/media\/BrakeService_Brittani_ChromaKey_Report_v3.flv&amp;image=http:\/\/autonettv.com\/media\/thumbs\/BrakeService_Brittani_ChromaKey_Report_v3.jpg&amp;autostart=false\" \/>\r\n<param name=\"src\" value=\"http:\/\/autonettv.com\/media\/mediaplayer.swf\" \/>\r\n<param name=\"AllowScriptAccess\" value=\"always\" \/>\r\n<\/object>\r\n<br \/><br \/> Richard Petty once told AutoNetTV, &ldquo;You&rsquo;ve gotta have good brakes. If you&rsquo;ve got good brakes you can keep yourself out of a lotta trouble.&rdquo; <br \/><br \/> That&rsquo;s why a regular brake inspection is on every San Francisco car&rsquo;s maintenance schedule. An inspection at <a title=\&

Updating list item values in SharePoint Designer using code

Is it possible to programmatically modify the SharePoint objects using SharePoint Designer Object Model. By that I mean coding in SharePoint Designer (not Visual Studio). For example, can we access the list items of a list programmatically and change their values? I can do all this in Visual Studio using SharePoint Object Model but I don’t find a way of achieving this by using programming in SharePoint Designer. I searched through http://msdn.microsoft.com/en-us/library/bb208639(office.12).aspx but no success. If the answer is yes. Can someone please give example(s) or point to some articles etc? Thanks in advance.

SharePoint 2010 - Performance Point & Dashboard Designer

We have successfully installed SharePoint 2010 onto our dev machine; we have also followed the documented steps for configuring Performance Point; http://blogs.msdn.com/b/performancepoint/archive/2009/11/24/deploying-performancepoint-2010-soup-to-nuts.aspx.  All seems fine however we do not seem to be able to create a connection from Dashboard designer back into SharePoint.  When we check the logs we get the following error Critical   An unexpected error occurred.  Error 5678.  Exception details: Microsoft.SharePoint.Upgrade.SPUpgradeCompatibilityException: There is a compatibility range mismatch between the Web server and database "WSS_Content_PerformancePoint_1", and connections to the data have been blocked to due to this incompatibility. This can happen when a content database has not been upgraded to be within the compatibility range of the Web server, or if the database has been upgraded to a higher level than the web server. The Web server and the database must be upgraded to the same version and build level to return to compatibility range. We have a farm config on a single 64 bit box and SQL Server 2008 loaded.  We have un-installed and re-installed the site collection. Does anyone have any ideas? Eddie Barrett

Dashboard Designer Connection Errors

Hi,SharePoint 2010 single box deployment on my laptop running Server 2008 R2 and SQL 2008 R2.I can access the SharePoint BI site just fine and can launch the dashboard designer with no problems.   When I try to create a KPI, indicagtor or dashboard I see the following error:***The list no longer exists or you do not have permissions to view it.  The dashboard cannot be saved.  Additional details have been logged for your administrator.***I look in event viewer and see:***The user "SHAREPOINT\system" attempted to save an item in the following location: http://alanserver/sites/BI/Lists/PerformancePoint Content Verify that the location exists and that the user has the "Add Items" permission.Exception details:Microsoft.PerformancePoint.Scorecards.BpmException: An unexpected error occurred. Error 16858. Additional details have been logged for your administrator. at Microsoft.PerformancePoint.Scorecards.BIMonitoringServiceApplicationProxy.ExecuteOnChannel(CodeBlock codeBlock)at Microsoft.PerformancePoint.Scorecards.BIMonitoringServiceApplicationProxy.GetSettingValue(String key)at Microsoft.PerformancePoint.Scorecards.ServerCommon.AppSettings.GetValueAsInt(String key)at Microsoft.PerformancePoint.Scorecards.Store.SPFcoCache.Add(Guid webSiteID, RepositoryLocation location, FirstClassElement element, SPListItem item)at Microsoft.PerformancePoint.Scorecards.Store.Dao.

Runtime filter values differ from values setup in designer. SQL server 2005



I am confused as i have setup values for the filter criteria for company as 'JTWO' & 'STOC' in design mode of report builder however when i access the report from report manager the values that prompted  @ runtime are AARFT05F and ARRTUEID'.

any reason why report builder should change the filter criteria @ runtime.








Questions about creating a class that returns multiple values


Hey all,

I am a little stumped, been trying to find some references to this but I am coming up with more confusion than anything else.lol

Here is my scenario using asp.net and VB.

I have an aspx page with about 10 label controls on it and a couple of image controls. Their data will be all populated dynamically by a single URL query string that is passed to a 3rd party url query string that retrieves an xml document with all of the information on it. I am currently just using the page load event and from that I can get everything I need and populate the page elements no problem with all of the code existing on the aspx.vb page.

However I thought for this project as I go forward I would like to create a vb class that handles all of the work instead of using the code behind page which has become quit convoluted.

I am not completely new to creating classes, I've done them before, and some pretty complex however this one is new due to the fact that I want to return multiple values.

So my thought is to approach it this way.

1.       On the page load event I grab the URL query string, and pass it to the vb class to begin the process.

2.       In the class I create a function that loads the xml document into memory.

3.     &n

GridView Rowupdating Returns old Values


Haii all, my gridview row updating events return old values.. edititem templatefield gets its old value on row updation.

My code is as follows :-

      protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)

        TextBox tb1 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txt3");
        TextBox tb2 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txt4");
        TextBox tb3 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txt5");
        TextBox tb4 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txt6");
        TextBox tb5 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txt7");

        string s1 = tb1.Text;
        string s2 = tb2.Text;
        string s3 = tb3.Text;
        string s4 = tb4.Text;
        string s5 = tb5.Text;

        string qry="Update SparePartsStatus set Equipment='"+s1+"',Location='"+s2+"',TotalQuantity='"+s3+"',DateofDelivery='"+s4+"',Balance='"+s5+"' where (SpareName='"+Session["partno"]+"')";
SqlCommand com=new SqlCommand(qry ,con);
        int d = com.ExecuteNonQuery();


SharePoint 2010: PPS Dashboard Designer cannot retrieve application. authentiation error


I am getting this error when I try to open the dashboard designer in Sharepoint 2010/PPS.  This is from the out of the box site collection found under http://mywebsite/site/Pages/ppssample.aspx

This used to work.  Whare are the best ways to go about troubleshooting this?

one note? i can connect great via my web server (remote desktop/locally on server) but not from my laptop from my desk.

 Following errors were detected during this operation.
 * [9/28/2010 3:41:01 PM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
  - Downloading https://mywebsite/_layouts/ppsma/1033/designer.application?Operation=OpenWebsite&SiteCollection=https://mywebsite/sites/myApp&SiteLocation= did not succeed.
  - Source: System.Deployment
  - Stack trace:
   at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
   at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
   at System.Deployment.Application.FileDownloader.Download(Subsc

Background in PPS2010 Dashboard Designer



When creating Analytical Charts using Dashboard Designer in PerformancePoint Services 2010, there are 3 regions where I can drag and drop field form cube - Series, Bottom Axis, Background. I understand the first two, but what is Background meant for? Can anyone please advise? Thanks in advance.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend