.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

cannot find PivotTable report tempalte in PerformancePoint Dashboard Designer

Posted By:      Posted Date: October 09, 2010    Points: 0   Category :SharePoint


I want to create PivotTable report in PerformancePoint Dashboard designer, as I checked in the link http://office.microsoft.com/en-gb/performancepoint-server/create-a-pivottable-report-by-using-performancepoint-dashboard-designer-HA010257416.aspx ,I should be able to do the following step:

{In Dashboard Designer, click the Create tab, and then click Other Reports. ClickPivotTable, and then click OK. The Create a PivotTable Report wizard opens.}

But I am not able to find PivotTable in 'Other Reports' in Create tab, could you please tell me is there any prerequisite need to be done before I start the above step?



View Complete Post

More Related Resource Links

PerformancePoint Services - Dashboard Designer won't launch from PerformancePoint Content library


There are a couple of ways to launch Dashboard Designer for PerformancePoint Services. One of them is to go to a BI Center site, than to the PerformancePoint Content library and click New Item on the Items tab of the ribbon. If you then select one of the items listed, eg a PerformancePoint KPI, Dashboard Designer should launch.

Now in my case, it doesn't. I get a popup titled 'Dashboard Designer Redirect' telling me 'Loading Dashboard Designer...', but when the popup disappears after a few seconds, nothing happens. In the SharePoint logs, I can find a few errors, listed below. What intrigues me here is that the problem seems to be caused by a resource file ppsma.Client.en-US.en-US.resx that cannot be found. Note the double en-US.enUS in there. I do see the resource file in the listed location, but it has en-US in it's filename only once.

This is not a serious problem as I do have other options to launch Dashboard Designer, like going to the Data Connections library, then select New Document - PerformancePoint Data Source, which will launch DD. Or go to the BI Center main page and select the 'Start using PerformancePoint Services' link and start DD from there, which also works. But I am just curious whether there is something wrong with my installation, or this is a bug I should report on MS Connect.

The errors in the log:

Search does not find text in Word document stored in document library on a Report Center site within



We have a document library on a site created off of the Report Center site template. We uploaded a Word 2007 document with the word zebra in the text. Using the search bar at the top of the page we selected This list: Our document library and searched for zebra. We received no results.

We tested the same thing on another site (site template Team site) within the same site collection and search worked fine.

Does the Report Center search function differently then the search functionality on the Team site?

Tamara Bredemus SharePoint Minion...working up to Maven

Find SQL Query when report is executed

Hi All, I am using SSRS 2008 R2 verison of reporting services. I have a report and the data source for this report is Oracle 10i, it takes around 2 mins to execute the report. I want to find out the query, which is sent by the reporting services to the Oracle. Is there a way to find it out. Please help me with this. Thanks Vineeshvineesh1701

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

How to get "Current Date" on SharePoint Designer for Invoice Ageing Data View Report??

Hi Experts, I would like to know how can i get/show "Current Date" in SharePoint Designer ?? Any good tutorial ? FYI, I need this "Current Date" for my Ageing Data View Report, Purpose To offset with "Invoice Receive Date" to get total days of payment payable for the invoice. Please assists, Thanks

PerformancePoint Dashboard Problems

I am having a few problems with a dashboard I am trying to create. The first problem, is that I have an analytical chart, that was working correctly before. It is just a line graph with numbers on the y axis, and date on the x axis. When I created the chart, the database only had entries for four days, all of which showed up.  Today, I updated the table to where it has 15 days of data now, but only the original four entries still show up. Secondly, I have created a time intelligence filter. The filter itself works fine when I preview it. The formulas are correct, and my hierarchy is correct. The problem comes when I try to create the connection between the filter and the chart.  On my available fields under the filter, I have, "display condition, time, display value, member unique name, formula, and the name of my data source. I obviously want the time filter to change the time field on my chart.  I dragged "formula" down to the chart, selected Time PK Date as the "connect to," and set formula to the source Value. I believe those should be the correct settings, yes? well when I deploy the dashboard to my sharepoint site, I get this error: "Error running data source query. Contact the administrator for more details."   Since I am the administrator, I checked out the event logs, and was given these errors: --------------

"designer" problem- can't find the files

i got a project (.NET website) from another developer, unlike my project, every page has three parts- the aspx page, the cs page and a "designer" page. i tried to run the web site but i get error problem- "could not load .... type", it looks like the builder can't connect the designer file to the right page. how can i solve the problem can i link the page and the designer...

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 

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?

CrystalReportsException: Load report failed - The system cannot find the path specified

I recently added a Crystal Report to a web application within Visual Studio 2010.  I'm using the Push method with a DataSet, and have a CrystalReportViewer control added to an aspx page.  When trying to test the report locally I'm getting an exception when performing the data binding on the CrystalReportViewer control...-----------------------------------------------------------------------------------------------------------------------------------Server Error in '/TestDevelopment' Application. The system cannot find the path specified. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Runtime.InteropServices.COMException: The system cannot find the path specified. Source Error: Line 7: Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Line 8: BindReport() Line 9: CrystalReportViewer1.DataBind() Line 10: End Sub Line 11: Source File: C:\Documents and Settings\acwhifield\Desktop\VS_Projects\TestDevelopment\TestDevelopment\a\CR_Rpt_SubSelNotes.aspx.vb Line: 9 Stack Trace: [COMException (0x80004005): The system cannot find the path specified. ] CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocumentClass.Open(O

PerformancePoint Dashboard using Excel Services - How to export or print?

I have a PPS dashboard in 2010 that has an Excel services report with a nice graph and grid.  I do not see an "export to Excel" toolbar or a print function.  In the old 2007 Sharepoint, the Excel services report had a menu which allowed the user to export to excel (copy / paste) or OPEN in Excel.  (actually open the pivot table) How do I expose that menu bar in 2010?  Thanks.

Performancepoint designer error - Update View Failed

I've created a scorecard that uses dynamic members.   I'm no longer able to design it. When I click on 'Update' to retrieve the scorecard I get the following error:   The last attempt to update this view failed. Try retireving the view again by pressing Update in the Edit tab. If you are still not able to retrieve it, contact your administrator. Error Details: An unexpected system error has occured. Additional details have been logged for your administrator.   The event log says: An unexpected error occurred.  Error 56822. Exception details: System.ServiceModel.CommunicationException: The maximum message size quota for incoming messages (100000000) has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the appropriate binding element. ---> System.ServiceModel.QuotaExceededException: The maximum message size quota for incoming messages (100000000) has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the appropriate binding element.    --- End of inner exception stack trace --- Server stack trace:    at System.ServiceModel.Channels.HttpInput.ThrowMaxReceivedMessageSizeExceeded()    at System.ServiceModel.Channels.HttpInput.GetMessageBuffer()    at System.ServiceModel.Channels.HttpInput.ReadBufferedMessage(Stream inputStream)    at System.S

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

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.  

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
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