SQLServerCentral.com / Data Warehousing / Performance Point InstantForum.NET v99.99.99SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 09 Dec 2016 18:08:19 GMT20PerformancePoint 2010 Drill-Down General Guidancehttp://www.sqlservercentral.com/Forums/Topic1114168-2796-1.aspxHi All, I'm new to cube development, and in particular trying to publish it to SharePoint via PerformancePoint. At this point I have a nice little cube and have created a fairly straight forward Analytic Grid Report. The last step that I need is to be able to click on the data cells, and drill-down to see the underlying values. The report is for a school system, and it's pretty straightforward: Passed FailedTest 1 10 3Test 2 9 4 Where the #s represent the students that either passed or failed. All of this is working great, but I'm not sure about the best way to go to drill down to see the students for each test that either passed or failed. I'm starting to look in multiple directions and it's really confusing me. For instance, going back to Visual Studio and creating an Action looks like that could work, except that Actions don't appear to get imported into the PerformancePoint app. And the Analytic Grid Report doesn't appear to let you click on the data cells, but only wants to let me drill down through the row members, and that just brings back both Passed & Failed since they are both on that row. I started to look at creating KPIs and a Scorecard, but before I go down that road wanted to ask and see if somebody can just tell me "focus on actions/kpi's/whatever"...I don't mind putting int he research on whatever area, but would just appreciate a nudge in the right direction :).Tue, 24 May 2011 09:47:07 GMTJames.Genslinger 60963Displaying Months As Series - Ordering by Month Numberhttp://www.sqlservercentral.com/Forums/Topic1736428-2796-1.aspxQ1 - Forcing the proper sequence of months in a chart ?From a cube holding a set of invoices, how - for a specific year - to show the total amounts in a chart for each month ? The chart shows up ordered as April, August, December, February ...Q2 - How to set the year filter ?I created a Date dimension linked to the Invoice Measure table. The Year field of the date dimension is the "Series" section for the chart (report in the sharepoint designer). It was not possible to enter the year field in the "Background" section of the chart report. I ended up creating an additional date dimension (I called it "FilterYear"). Was this really the only way to be able to do it ?RegardsFri, 13 Nov 2015 12:15:56 GMTj-1064772A newbie question about Data size and handlinghttp://www.sqlservercentral.com/Forums/Topic1736256-2796-1.aspxMoved --- sorryFri, 13 Nov 2015 03:08:06 GMTchristy-720576Cascading Date Filtershttp://www.sqlservercentral.com/Forums/Topic1729434-2796-1.aspxI've got a PPS BeginDate and EndDate filter (MDX filter) created. The source query is:[code="other"]NonEmpty( Hierarchize( Descendants( [Date].[Calendar Day].[All], [Date].[Calendar Day].[Year], SELF_AND_AFTER) ), [Measures].[Metric Quantity] )[/code]This allows the user to pick from any level of my date hierarchy: Year, Quarter, Month or Day.If the user selects at the Quarter level in the Begin Date, I only want quarter level values to appear in the End Date filter. Both of these MDX queries do that (bring back all values at the quarter level)[code="other"]SELECTDESCENDANTS ([Date].[Calendar Day].[Quarter].&[20143].Level, 0, SELF) ON ROWS,{} ON COLUMNSFROM [RoyaltyPMA];orSELECT[Date].[Calendar Day].[Quarter].&[20143].Level.Members ON ROWS,{} ON COLUMNSFROM [RoyaltyPMA];[/code]But when I try to implement this in the filter's connection formula (End date has a connection to Start Date's Member Unique Name)[code="other"]DESCENDANTS (&lt;&lt;UniqueName&gt;&gt;, 0, SELF)or&lt;&lt;UniqueName&gt;&gt;.Level.Members[/code]It still brings back all of values for all levels in the End Date filter.Any ideas?Thanks,RobTue, 20 Oct 2015 12:16:02 GMTrobert.gerald.taylorPerformance Point data sourceshttp://www.sqlservercentral.com/Forums/Topic1685866-2796-1.aspxHiI am trying to understand the Performance Point dashboards. I think Cube is the best data source to work withwe can also connect to various sources like Excel, SQL Server, Excel Services from SharePoint...etc.I don't see any use of the non-analytic data source, I cant create any thing with these.I see the report items are of Analytic Chart, report...etc. which I am not able to really tie the data source. Performance Point only works good for SSAS Cube only?Fri, 15 May 2015 06:49:05 GMTVRTDashboard Designer percentage calculationhttp://www.sqlservercentral.com/Forums/Topic1667931-2796-1.aspxHi,I wonder if anyone can help me.I have created a couple of grids which show percentage columns.However, the data is populated throughout the year and as there is no data as yet the calculation is effectively 0/0.But rather than displaying [i]0%[/i], the grid is displaying [i]-1.#IND[/i].Is there anyway to get the column to display 0%, when there is no data as yet?Thu, 12 Mar 2015 05:03:57 GMThex226PPS Time Intelligence Filter with LinkMemberhttp://www.sqlservercentral.com/Forums/Topic1633788-2796-1.aspxI have a PerformancePoint Service 2010 "start date" filter that is of Time Intelligence type. On my dashboard I link/connect it to my "Sales Order by Create Date" report and everything is fine (create date is default date dimension for sales order).On that same dashboard, I want to link/connect this start date filter to my "Sales Order by Schedule Date" report. Schedule date is a role playing dimension of the date dimension. I can use the LinkMember() function in the Connection Formula ([i]as described in URL below[/I]) if the filter is a MDX filter, but it doesn't seem to work when the filter is a time intelligence filter.[url]http://bennyaustin.wordpress.com/2013/02/04/performancepoint-using-connection-formula-to-pass-filter-values-to-report-having-role-playing-dimension/[/url][b]How do I use the LinkMember() function in the Connection Formula with a Time Intelligence filter?[/b]Thanks,Rob([i]edit: to clarify version of PPS[/i])Wed, 12 Nov 2014 06:03:43 GMTrobert.gerald.taylorIndexing Suggestion Needed for Performancehttp://www.sqlservercentral.com/Forums/Topic1628715-2796-1.aspxHi All.I have a query which say[b]Scenario 1 :[/b]select colmA from table1 where colmB = @colmB and ColmC=@columC and colmD= @colmDNow, here if I create a non clustered covering index for performance, what should it be like to avoid table scan?[b]Scenario 2 :[/b]select colmA from table1 where colmB = @colmB and ColmC=@columC and colmD&lt;&gt; @colmDNow,here is it possible to create proper indexing to avoi d a table scan when in &lt;&gt; operator is used in the query??Mon, 27 Oct 2014 04:44:33 GMTrollercoaster43PerformancePoint query takes too longhttp://www.sqlservercentral.com/Forums/Topic1562021-2796-1.aspxI am creating an Analytic Grid report form and Analysis Services Cube.The report will have two dimensions on Rows, 1 small dimension and 2 measures on Columns. and will be filtered by dateWhen I create the report by browsing the cube in Management studio my reports generate very quickly, but when I create the report on performance point, it takes forever and it returns an error. "The query for this report took too long to complete. Contact the administrator for more details"I am new to performancePoint and I am not sure how to troubleshoot this problem, or why would it time out in Performance Point but it would be so fast on management studio.I would appreciate any help or feedbackTue, 15 Apr 2014 12:48:09 GMTsandra pastranaAccessing Comments (annotations)http://www.sqlservercentral.com/Forums/Topic1553320-2796-1.aspxI have found the table that stores my PPS 2010 comments (PPSAnnotations) which shows me the comments, author, dates, slice.Does anyone know how I can link this information back to a Scorecard/KPI ?I'm assuming this links back to a sharepoint object somehow, but I have been unable to identify it myself and google has provided no joy.The only thing I have found is the MAUDF project (http://maudf.codeplex.com/)Any help would be greatly appreciated.ThanksSteveThu, 20 Mar 2014 23:35:33 GMTSteve HirthConverting Negative Numbers to Positive in PerformancePoint 2010http://www.sqlservercentral.com/Forums/Topic1544969-2796-1.aspxHow can I convert negative accounting numbers to positive to display in PerformancePoint 2010? I am using a Analysis Services 2008 Cube as a datasource. I can use drag and drop option to build my query and display all the data, but everything is in negative. I thought I can do it if I learn MDX. I spent a week learning MDX.I wrote the query in MDX, but ran into another problem: if I write a MDX query, I loose all the ability to drill down on details in PerformancePoint. Has this happened to anyone before?Tue, 25 Feb 2014 08:28:06 GMT//RaviIs SQL ENTERPRISE 2008 R2 required for Performance Point 2010?http://www.sqlservercentral.com/Forums/Topic1505697-2796-1.aspxMy company would like to try Performance Point 2010. We already have a large SharePoint 2010 farm.The SharePoint Administrator said he thought SQL [size="2"][b]"ENTERPRISE"[/b][/size] 2008 R2 maybe a requirement for Performance Point (or SSAS). Can anyone confirm or deny whetherSQL Enterprise is required - we just want to demo a few reports to Sales Team.SQL Enterprise is very expensive $30K. We would like to use either SQL Standard or SQL BI 2008 R2 rather than SQL Enterprise 2008 R2.The administrator told me to research. :cool:Thu, 17 Oct 2013 07:26:26 GMTbrucekoivuPerformancePoint 2010 limitations?http://www.sqlservercentral.com/Forums/Topic1538346-2796-1.aspxI have a couple of things I'm trying to do in my scorecard and absolutely cannot figure out and have found no help online. 1) I have a hierarchy with measures that drill down a couple levels. The top level heading I do NOT want totals and I can't figure out how to remove them.2) I also need to filter out a lower level measure and have done that....however the subtotal STILL includes the filtered amount.3) Worst child rollup is NOT working.Why is this product so hard to use?Any help or helpful sites to use for more advanced questions would be extremely appreciated!Wed, 05 Feb 2014 13:00:50 GMTnicole.willis-508955SQL Server Default Configurationhttp://www.sqlservercentral.com/Forums/Topic1530952-2796-1.aspxHi,We are running our sql server on default configuration as per below, I want to know whats changes we have to do for performance point of view on our Database server.Please give me some suggestion because its urgent requirement for our client.[b]name minimum maximum config_value run_value[/b]access check cache bucket count 0 65536 0 0access check cache quota 0 2147483647 0 0Ad Hoc Distributed Queries 0 1 0 0affinity I/O mask -2147483648 2147483647 0 0affinity mask -2147483648 2147483647 0 0affinity64 I/O mask -2147483648 2147483647 0 0affinity64 mask -2147483648 2147483647 0 0Agent XPs 0 1 1 1allow updates 0 1 0 0awe enabled 0 1 0 0blocked process threshold (s) 0 86400 0 0c2 audit mode 0 1 0 0clr enabled 0 1 0 0cost threshold for parallelism 0 32767 5 5cross db ownership chaining 0 1 0 0cursor threshold -1 2147483647 -1 -1Database Mail XPs 0 1 0 0default full-text language 0 2147483647 1033 1033default language 0 9999 0 0default trace enabled 0 1 1 1disallow results from triggers 0 1 0 0filestream access level 0 2 0 0fill factor (%) 0 100 0 0ft crawl bandwidth (max) 0 32767 100 100ft crawl bandwidth (min) 0 32767 0 0ft notify bandwidth (max) 0 32767 100 100ft notify bandwidth (min) 0 32767 0 0index create memory (KB) 704 2147483647 0 0in-doubt xact resolution 0 2 0 0lightweight pooling 0 1 0 0locks 5000 2147483647 0 0max degree of parallelism 0 64 0 0max full-text crawl range 0 256 4 4max server memory (MB) 16 2147483647 26624 26624max text repl size (B) -1 2147483647 65536 65536max worker threads 128 32767 0 0media retention 0 365 0 0min memory per query (KB) 512 2147483647 1024 1024min server memory (MB) 0 2147483647 0 16nested triggers 0 1 1 1network packet size (B) 512 32767 4096 4096Ole Automation Procedures 0 1 0 0open objects 0 2147483647 0 0optimize for ad hoc workloads 0 1 0 0PH timeout (s) 1 3600 60 60precompute rank 0 1 0 0priority boost 0 1 0 0query governor cost limit 0 2147483647 0 0query wait (s) -1 2147483647 -1 -1recovery interval (min) 0 32767 0 0remote access 0 1 1 1remote admin connections 0 1 0 0remote login timeout (s) 0 2147483647 20 20remote proc trans 0 1 0 0remote query timeout (s) 0 2147483647 600 600Replication XPs 0 1 0 0scan for startup procs 0 1 0 0server trigger recursion 0 1 1 1set working set size 0 1 0 0show advanced options 0 1 1 1SMO and DMO XPs 0 1 1 1SQL Mail XPs 0 1 0 0transform noise words 0 1 0 0two digit year cutoff 1753 9999 2049 2049user connections 0 32767 0 0user options 0 32767 0 0xp_cmdshell 0 1 0 0Wed, 15 Jan 2014 00:06:42 GMTD.K.MishraTime Intelligence (Week Issue)http://www.sqlservercentral.com/Forums/Topic1453122-2796-1.aspxI am working with performance point and I cannot get the week time period to correspond with the rest of my time periods. It must be something simple that I just can't put my finger on. Thanks for any help you can provide.[img]http://i1306.photobucket.com/albums/s580/mtb1973/Untitled_zpsfb0d7319.jpg[/img]Wed, 15 May 2013 08:22:11 GMTmbrady5Multiple Roles in one data connection (or duplicate reports instead)http://www.sqlservercentral.com/Forums/Topic1493466-2796-1.aspxHi, I have an SSAS cube with 2 roles- Agent Role- shows each sales agent his own deals onlyAfrica Role- shows only Africa deals (of all agents)PPS dashboard based on each of the above seperately works fine.We want certain sales agent to be able to see his own deals + all Africa deals. So we gave him permissions to both roles in the cube. When specifying both roles (with comma separation) in the same data connection, he is able to see all data!!What is the solution for this? Is there another way other than duplicating the whole dashboard and connecting the new dashboard to a different data connection with only single role? (it doesn’t sound good to duplicate items just for a different role connection).ThanksWed, 11 Sep 2013 00:53:34 GMTmayanStored Procedure Performancehttp://www.sqlservercentral.com/Forums/Topic1468108-2796-1.aspxI have one Stored procedure That takes around 2 hour to execute.it runs in 2 hours on server with 8 processors.and it runs in same time on server with 32 processors.is there any way we can make it utilize all the processors.or can we apply multi-threading so it can get executed faster.Thu, 27 Jun 2013 06:27:37 GMTamardesai89multiple connexions between filtershttp://www.sqlservercentral.com/Forums/Topic1463413-2796-1.aspxHi,I have the following issue:I display 3 filters: country, brand and presentation.I would like that once the user selected country and brand, Presentation filter contains only presentations for the country and brand selected.I have a measure in the cube which makes a link between theses 3 dimensions.For presentation filter I declared this measure as filter measure.I can make a connexion between country filter and presentation filter: it displays only presentations of the country but no restriction on the brandI can make a connexion between brand filter and presentation filter: it displays only presentations of the country but no restriction on the country.Do you know if it's possible to link my filter to both filters ?Or is it possible in mdx ?If anybody can help it would be great...Thanks in advanceFri, 14 Jun 2013 02:00:23 GMTlaurentfalcozHyperlink menu on hover on KPIhttp://www.sqlservercentral.com/Forums/Topic1460072-2796-1.aspxHi,I have a requirement to include a jQuery (or any other technology) menu when the user hovers a particular cell in a PerformancePoint 2013 KPI.Basically, we have a "More" column of type Hyperlink with a default value of, let's say, http://www.bing.com in our KPI (see picture attached).[img]http://social.technet.microsoft.com/Forums/getfile/293405[/img]The business requirement is to display a list of multiple hyperlinks when the user hovers over the "More" cell, but I'm not sure this is possible (by using jQuery or Javascript?)We have a SQL Server table containing all the hyperlinks for a specific ID so for example, if the user hovers over the line "Assets", the menu should be shown and display all the hyperlinks that are retrieved from the table.Can someone help me?Thanks in advance,OliverWed, 05 Jun 2013 02:11:50 GMTolivier.furnemontHelp with rendering an ssrs report within a dashboardhttp://www.sqlservercentral.com/Forums/Topic1453511-2796-1.aspxHello there,i got 3 reports: a,b,c.in each report i got a text box with an action ("go to a report") that bring me to a specific report that i choose .im using performance point 2010 as well and iv'e connected it to report A (so performance point only knows report A but i can still move from report A to B and C and back).the thing is, once i choose a parameter in the performance point- it renders report A and take it back to to initial status.for example,i start with report A and then click on the text box to move to report Bnow,i select a different time parameter and it renders it and takes me back to report A with the selected Parameter.i want to stay in report bis it possible? thank youThu, 16 May 2013 07:12:43 GMTavishainModify Color Palette of a PerformancePoint Services Analytic Charthttp://www.sqlservercentral.com/Forums/Topic1030580-2796-1.aspxHello,I'm searching for a solution to modify the colors of a PPS Analytic Chart. I'm using SharePoint 2010 with PPS and Dashboard Designer and built a dashboard that contains a bar chart about the revenues of several company departments. I need to change the colors because every department has it's own defined color all over the company.I tried already to modify the css-style information of the sharepoint site that contains the dashboard, to overwrite the colors after deployment. But I could'nt find any class that sounds like the one I need.Does anybody know if changing the color palette is possible or does anybody know a workaround to solve the problem?Thank you all for your answers. Any help would be appreciated!ConnyMon, 06 Dec 2010 06:58:26 GMToertelspecifying worst value in Decreasing is better - band by normalized valuehttp://www.sqlservercentral.com/Forums/Topic1096964-2796-1.aspxDear,I have a KPI that shows when an cost amount is good or bad : decreasing is better.When defining the KPI the worst value is set at 300000 $.In my scorecard the KPI the year dimension is added : all years show red, because the cost for each year is higher than 300000. However, when adding the semesters (or quarters ..) : all of them turn green, because the cost of each is lower than 300000.The color of the indicator depends on this worst value which is a fixed value. How can you specifiy this worst value to make it have sense for all periods ?Thu, 21 Apr 2011 07:16:27 GMTFranky LeeuwerckPerformance Point 2010 (Dashbaord Designer) - Report Center with browse error - Access Denied.http://www.sqlservercentral.com/Forums/Topic1397247-2796-1.aspxDear All,I have some access denies issues as below:-1. My SSRS (Native Mode) exist in server A (Admin login user name as domain\aaa)2. My performance point exist in sharepoint 2010 server B. I have configure the performance point app. pool login account and unattended account as domain\aaa. 3. I can launch the Dashboard Designer with create a Reporting Services report. - Server Mode : Report Center - Server Name : (reportserver URL to Server A)4. When I click Browse - I getting an error as 'Access Denied'I know is permission issues, How can I configure the 'domain\aaa' account to make this work?Thanks in advancedMon, 17 Dec 2012 07:04:57 GMTYearMonthDayProblem Connecting to SSAS Cubeshttp://www.sqlservercentral.com/Forums/Topic1437958-2796-1.aspxGreetings, all.I am working with two different SharePoint servers. With one, I configured the Secure Store service and Unattended Service account, and added the account used for the Unattended Service account as member of a Role in the cubes, and everything worked fine, I could connect to the cubes. With the other SharePoint server, the Secure Store service and Unattended Service account were already set up (in fact, there are 3 PerformancePoint target applications on that server), but no matter what I have tried, I cannot connect to the cubes. Always, the error appears "The data source cannot be used because PerformancePoint Services is not configured correctly." Examing the logs more closely, we have made sure the offending service account has been granted permissions to the cubes. One thing that's confusing to us, is that the offending account, is not the account associated with the Unattended Service account that SEEMS to be the active PerformancePoint target application. (Remember, I said that there appear to be 3 of them.) BTW I have added the supposedly-correct service account as a member of cubes also, but that doesn't resolve the situation.I am at a loss of what to try. Suggestions appreciated!Thanks,RandyTue, 02 Apr 2013 09:15:41 GMTrwitt 95744Excel Services Data Connection in PerformancePoint 2010 Issuehttp://www.sqlservercentral.com/Forums/Topic1430800-2796-1.aspxHi,I am new in Performance Point 2010 I make data connection using Excel Services as data source. I want to make Filter by using this connection and its not display when I am develop filter.What I am missing.MY scenario is that I made Pivot table report and Pivot Chart and they have filter also in excel 2010 and deploy this report in Performance Point 2010 I successfully deploy now I want to apply filter dashboard on these report.Need Urgent help! and thanks in advance.Regards,Naseer AhmedThu, 14 Mar 2013 01:50:53 GMTnaseer78_pkData Alignment in SharePoint 2010http://www.sqlservercentral.com/Forums/Topic1428626-2796-1.aspxWe are having alignment issues with our data using Performance Point in SharePoint 2010.In the sample data below it's quite noticeable that the Gross Rent figure in the Target Timed column is higher than the data in the Actual Timed column. [img]http://i981.photobucket.com/albums/ae297/dubcentral/PerformancePoint2010/TestData.jpg[/img]Has anybody else experienced this using IE9 or now any possible solutions?The alignment is fine in dashboard designer. (see below)[img]http://i981.photobucket.com/albums/ae297/dubcentral/PerformancePoint2010/TestData2.jpg[/img]Fri, 08 Mar 2013 08:58:08 GMTchrisreillyPPS chart not showing all the datahttp://www.sqlservercentral.com/Forums/Topic1388273-2796-1.aspxHi,I have a chart showing amount earned each day for 3 years periodWell it doesn't show me all the chart at once. Instead it shows me pieces - pages. Only when I click All - it shows me the whole pictureI actually don't care about dashboard designer, I just want my users to see all the information at once in SharepointMaybe there's a parameter such as &ShowAll=True or smthng you can add in Url?Please helpThanksMichaelhttps://docs.google.com/open?id=0BxwE8Gt6ONVtMGhNMHVfWnRPWUk[url=https://docs.google.com/open?id=0BxwE8Gt6ONVtMGhNMHVfWnRPWUk][/url]Fri, 23 Nov 2012 21:56:18 GMTmshparberpopulate strategy map shape data with scorecard KPI valuehttp://www.sqlservercentral.com/Forums/Topic1386513-2796-1.aspxHello Folks,I've ventured into trying to get a Strategy Map working and dynamically connected to a Scorecard. When I edit the SM, it lets me pick "Actual" as a data graphic data field, and even displays the correct value in the Shape Data window which is connected to the Scorecard cell... BUT...That cell value is not populating on the Data Graphic itself. Does anyone have a clue as to how the data gets driven between the Scorecard and the Shape Data on the Strategy Map? Do I need to define a data source on the Visio drawing or should it simply read-in the values from the Scorecard and populate the corresponding Data Graphic Data Field?Any tips or advice greatly appreciated!Thanks,JohnMon, 19 Nov 2012 11:17:25 GMTjjturnerPermissions to use "Save as Default" functionality in PerformancePoint 2010 sp1http://www.sqlservercentral.com/Forums/Topic1290803-2796-1.aspxHi allWe have implemented this service pack and created dashboards using the new "apply filters" and save as default functionality. Unfortunately there seems to be a specific permission required to use this that we can't quite figure out.Basically members of the site Owners group in Sharepoint can use it, but normal users cannot. It is simply greyed out.Does anyone know how to rememdy this? We have stopped inheriting the permissions from the site in the dashboard and have applied them specifically to the dashboard itself.I've attached screenshots of the option when a) the user is a part of the site owners group and b) when the user is in a specific group granted access to the dashboard (not inheriting) and given full control. It is greyed out when they are in the specific group and not when they are in the site owners.Any advice would be appreciated as I can't seem to find the common link here!ThanksMikeThu, 26 Apr 2012 08:41:06 GMTmikeyd26Add filter to only show countries that user has access (SSAS)http://www.sqlservercentral.com/Forums/Topic1330149-2796-1.aspxHello,I am new to performance point. I am using Performance Point as a reporting tool accessing an SSAS cube. I implemented data level security (by country), in the cube which works perfectly. The issue that I am having is that when a user logs into Performance Point they can see all of the countries BUT can only see data/measures that they have access to. So basically the data level security is working on the SSAS side, but Perforamnce Point is still showing all countries. I saw an area where I can place an MDX query in Performance Point. Is there an MDX query that I can use that will only display the countries the current user has access to?Thanks,DaveMon, 16 Jul 2012 08:31:23 GMTDaveDBTime Intelligence (Previous Year & Month to Date)http://www.sqlservercentral.com/Forums/Topic1326334-2796-1.aspxHello, this is a question regarding Time Intelligence in a PerformancePoint Dashboard. In the data connection of my Dashboard Designer i have defined a Time Dimension. I created also a Time Intelligence Filter to add these options: Day: TodayDay - 1: YesterdayMonth: Current MonthMonth - 1: Last MonthYear: Current YearYear - 1: Last YearMonthtodate: Month to DateYeartodate: Year to DateThis KPI was created with two records: Actual: In which the measure is a regular sum measure of one of my columns of my fact table ([Measures].[Total Consumptions]) Previous Year: This is related to a calculated measure in my SSAS Cube with this formula: (ParallelPeriod( [Dim Calendar].[Year - Month - Date].[Year] ), [Measures].[Total Consumptions]) These KPI are my two columns of a Scorecard. In the Dashboard I linked the Time Intelligence Filter and the Scorecard. The Scorecard works good except when I select Month to Date or Year to Date in my filter because my Previous Year shows an error. I am sure my problem is in my Calculated Measure but I don't know how to correct it. Do you have any thoughts? Thanks in advance, GabyFri, 06 Jul 2012 15:30:54 GMTgramosHow to get Name override value from dashboard designer KPI using codehttp://www.sqlservercentral.com/Forums/Topic1308879-2796-1.aspxHello All,I've been able to get kpi properties for a given scorecard using some .net code like this...[code="other"]Publisher.GetKpisFromScorecard(scorecard identifier)[/code]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.Thu, 31 May 2012 04:49:47 GMTfoldymanHow to add custom controls in ppshttp://www.sqlservercentral.com/Forums/Topic1294445-2796-1.aspxhi All,I have a requirement to create the Dashboard in pps , that should contains the expand and cllopase button to view the reports in dashboard , how we can achieve this ?Thanks & RegardsDeepak.AThu, 03 May 2012 03:54:38 GMTdeepak.aSSAS and Sharepointhttp://www.sqlservercentral.com/Forums/Topic1271286-2796-1.aspxWould like to access an SSAS cube from Performance Point or Sharepoint to create a Sharepoint version of a report. I have heard about webparts, would like to use them to make sharepoint report interactive. Can anyone assist or give me some pointers ?Thu, 22 Mar 2012 16:35:02 GMTkevin_nikolaiHow to recover lost master key?http://www.sqlservercentral.com/Forums/Topic1257874-2796-1.aspxHello,We have recently took up some new machines with SP and PP based solution. After a power outage... the server logs show up lots of errors like "PerformancePoint services was unable to retrieve the Unattended Service Account password from the Secure Store. Error Details:" and of course our BI page is down.Since I am a noob on this technology, I must get up the BI page asap.Until now I have tried:- create a new master key for secure service - failed with error Exception of type 'Microsoft.Office.SecureStoreService.Server.KeyManagement.InvalidMasterKeyException' was thrown.- unable to refresh the old master key, because the password is lost- set the unattended execution account for the PP service application - also unsuccessful because of the master key retrieve error.I have read MS article explaining how to get rid of the error, but noone tells you what to do if you don't have your initial phrase. Is it possible to delete this masterkey so I could create a new one, because I suspect one of the reasons I can't create a new one is that the prev. one still exists.I would appreciate your answers as situation began to escalate and mgmgt wants immediate results:)regards,andrei turcuBI developer HP SoftwareCluj, romaniaSat, 25 Feb 2012 15:20:17 GMTtandreiPrimary Key On Varchar columnhttp://www.sqlservercentral.com/Forums/Topic1257756-2796-1.aspxDear Sir,I am in confusion I want to build primary key index(clustered) on varchardata type column which length(6), but my some freinds told me to buld index on int. data type column for your sql performance so what i doplz. give me idea and why do it plz. explain me..thanks & regardsSat, 25 Feb 2012 01:29:37 GMTdeba_20032004Bulk Changing report paths in PPShttp://www.sqlservercentral.com/Forums/Topic1246603-2796-1.aspxFor a SharePoint 2010 environment with Performance Point 2010 with SSRS configured in integrated mode. The backend databases were transferred from once environment to another test environment. I was wondering if it is possible to bulk change SSRS paths in PPS via the backend databases?Fri, 03 Feb 2012 09:40:41 GMTmarks_262how to calculate % in PPS 2010http://www.sqlservercentral.com/Forums/Topic1226763-2796-1.aspxhi ,i have these columns in the table and made this table as the FACT table and also using time intelligence filter in the PPS2010..i have measures , sum (materials), sum (sales) and sum (material_%)in the PPS dashboard design i have included this cube and all the measures.. and using an analytic chart..i have developed separate graphs for each columns (material, sales, material_%)..for the sales and materials there is no problem , when i use the time filter in the material_% graph i used the time filter current quarter in months (showing three months ) shows the correct value..when i use the current quarter filter (sum of all the 3 months) its showing 146% (83 +33 +30) --&gt; for actual values and 150 % ( 50+50+50) --&gt; for target values actually it showed show me 46% for actual and 50% for target , it should be sum of material in all the 3 months / sum of sales in all the 3 months but its just calculating sum of material_% column of all the 3 months time filter : year :: Halfyear ::quarter:: Month::DayMonth Year Material sales Material_% [ material / sales] Jan_Act 2011 500 600 83 Jan_target 2011 400 800 50 Feb_Act 2011 300 900 33 Feb_target 2011 300 600 50 Mar_Act 2011 300 900 30 Mar_target 2011 300 600 50 ...... Jan_Act 2012 0 0 0 Jan_target 2012 600 1000 60............. Dec_Act 2012 0 0 0 Dec_target 2012 600 800 75please help me to sort out this issue ..Thanks n Regards T.NavinMon, 26 Dec 2011 23:53:48 GMTnavbingo20Table select statement performancehttp://www.sqlservercentral.com/Forums/Topic1236386-2796-1.aspxDear Friends,I am having two tables TB_PERSON_P and TB_PERSON_Rboth having a common column R_IDnow we can write two query:select R_ID from TB_PERSON_P P,TB_PERSON_R R where P.R_ID=R.R_IDandSelect R_ID from TB_PERSON_P P join TB_PERSON_R on P.R_ID=R.R_IDwhich would be faster among these two statement?Thanks!!Sun, 15 Jan 2012 22:48:37 GMTshubham.saxena67Time intelligence connection formulahttp://www.sqlservercentral.com/Forums/Topic1193877-2796-1.aspxHi,I have create a BI time connection formula filter and I have hooked a grid to it.In the grid I have a calendar hierachy on columns. The grid show average for year level. In the connection formula i wrote:"year-1, year-2,year,year.firstmonth:month"When i select, for example, '2011-04-30' in the BI filter, i would like to see the average value for 2010, average value for 2011 from january to april and the value on month level, but for 2011 I see the average value for all month (not only from jan to april).How can i do this?Thu, 20 Oct 2011 10:14:50 GMTstefani.giorgio