InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 00:34:36 GMT20http://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 GMTavishainhttp://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 GMTmbrady5http://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 GMToertelhttp://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 Leeuwerckhttp://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 GMTYearMonthDayhttp://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 95744http://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_pkhttp://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 GMTchrisreillyhttp://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 GMTmshparberhttp://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 GMTjjturnerhttp://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 GMTmikeyd26http://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 GMTDaveDBhttp://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 GMTgramoshttp://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 GMTfoldymanhttp://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.ahttp://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_nikolaihttp://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 GMTtandreihttp://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_20032004http://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_262http://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) --> for actual values and 150 % ( 50+50+50) --> 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 GMTnavbingo20http://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.saxena67http://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.giorgiohttp://www.sqlservercentral.com/Forums/Topic1192726-2796-1.aspxHi, I have a analytic grid hooked to a filter. When I filter member it's all ok...but if I drill up and down a member in the grid I lose the filter and I see again all the member even if the filter is not changed.Why!!????ThanksGiorgioWed, 19 Oct 2011 04:05:33 GMTstefani.giorgiohttp://www.sqlservercentral.com/Forums/Topic1164589-2796-1.aspxHiI am a Perfomance Point Newbie and have built a score card based on a SSAS cube and have imported the KPI's but I can't seem to figure out how to filter the KPI using time intelligence. I simply want yeartodate. Is there any way to do this?Kind RegardsPaulWed, 24 Aug 2011 05:57:48 GMTPugMasterhttp://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 60963http://www.sqlservercentral.com/Forums/Topic1095540-2796-1.aspxDear,I want to define a KPI that measures the relative amount of freight costs to the amount sold.The target is to limit this percentage as much as possible, so "decreasing is better".Let's say that in most cases the freight cost is below 10%.The best case would be 0% (but unrealistic).A "good" situation is where we have 5% freight costs.Bad sales are sales with freight costs above 15%.What this the best way to model this KPI ? Use a normalized methode, or absolute ? What is the "worst value" ? ..FrankyTue, 19 Apr 2011 05:58:33 GMTFranky Leeuwerckhttp://www.sqlservercentral.com/Forums/Topic994167-2796-1.aspxMany thanks to [b]Steve Jones[/b] for promoting the idea of having a seperate forum for Business analytics and related technologies.[hr]The major issue that I wish this forum to undertake are as follows:1.Need of Business Analytics 2.Generations and current trend in the area of Business Analytics3.Understanding of various terms that make Analytics as it should be such as KPI(Key Performance Indicators), Measures, Scorecards and Dashboards4.Scalability and future trendsHappy learning!!:-):-)Mon, 27 Sep 2010 21:55:54 GMTRaunak Jhawarhttp://www.sqlservercentral.com/Forums/Topic1086530-2796-1.aspxI am using an Analysis Services cube as the data source and creating an analytic chart in PerformancePoint.  I have a hierarchy that has perhaps 4,000+ items.  Although it is military based, it would be the equivalent of State|Store|Department where in any state are many stores and many departments in any store.  Because PerformancePoint can’t seem to display that many items in a dashboard filter, I think my next best option is to create three separate filters that are dependent on one another.  For instance, if I click on Alabama in the State filter, I want only the stores in Alabama to show in the Store filter.  Then when I click store 403, I only want the departments in store 403 to show in the Department filter.  Then when I click on Electronics in the department filter, the analytic chart will display for Electronics in store 403 in Alabama.  Is there a way to do this in PerformancePoint? Wed, 30 Mar 2011 15:02:50 GMTmdennisonhttp://www.sqlservercentral.com/Forums/Topic1074523-2796-1.aspxCan anyone suggest a website where to learn how to use PerformancePoint to build rich dashboards?I'm not sure how I can use it with SharePoint to build dashboards with a heavily customized presentation.Mon, 07 Mar 2011 15:39:57 GMTlixavosyquqexonahttp://www.sqlservercentral.com/Forums/Topic1082626-2796-1.aspxHi, everybody! A lot of questions, so happy there is a place to ask!I'll begin with the filter. I have Time filter built on hierarchy Year->Period Type -> Period, it is MembersSelection, where I choose "All descendants" for every year. In my cube I have the first period of current year as a default member in dimension. but I can't get this value as a default in my filter. Really I tried also Named Set also without success. HELP!!!Wed, 23 Mar 2011 06:13:30 GMTtatyanaahttp://www.sqlservercentral.com/Forums/Topic1062490-2796-1.aspxHi,As part of one requirement in my project, client has requested for a chart as shown in image file attached. Please let me know if this kind of chart is possible in Performance Point. The values inside the bubbles will change dynamically based on the value in the cube. Also the color of the bubble has to change dynamically based on the value.Fri, 11 Feb 2011 05:37:59 GMTMitra_Misra