InstantForum.NET v4.1.4SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 17 May 2008 09:18:22 GMT20http://www.sqlservercentral.com/Forums/Topic501633-147-1.aspxI have created some KPI's in my cube (SSAS2005) and now I need to serve them dashboard/scorecard style. The company is using Excel 2003 for the client, and I don't see the KPI's in the Pivot table control that connects to the cube. All I see is the dimension attributes and the measures. In Excel 2007 I would see the KPI's in this control, so my question is whether I can get to the KPI's in some other way in Excel 2003 or if this is even possible. If this is not possible is there some other nifty way of delivering scorecards that you know of?I guess a third part application is not out of the question, but if you have any recomendations it would have to be something slim and scorecard centric. This client is not interested in any new platforms or frameworks, so it would have to be a simple "widget" like app that can connect to SSAS cubes.ThanksThu, 15 May 2008 14:35:51 GMTTobi Whitehttp://www.sqlservercentral.com/Forums/Topic502367-147-1.aspxHi Everyone,I have searched through the forum, found some examples and couldnt get them to work. Below is what my current query returns. Please see the attachment if the table below doesnt make sense.IssuedDateTime SurveyName Question DisplaySequence Response4/29/2008 Survey1 FPS/Flow 2 2524/29/2008 Survey1 GPM 0 384/29/2008 Survey1 Level/IN 3 634/29/2008 Survey1 Daily Reading 1 1846854/30/2008 Survey1 FPS/Flow 2 1154/30/2008 Survey1 GPM 0 364/30/2008 Survey1 Level/IN 3 244/30/2008 Survey1 Daily Reading 1 195486 I would some how like it to convert like this:IssuedDateTime GPM Daily Reading FPS/Flow Level/IN4/29/2008 38 184685 252 634/30/2008 36 195486 115 24I'm new to SQL and any advice would be greatly appreciated. Thanks--williaal@msoe.eduFri, 16 May 2008 14:49:15 GMTwilliaalhttp://www.sqlservercentral.com/Forums/Topic500878-147-1.aspxSo, I'm an intern trying to figure out SQL. My question is... how do I find the DTS jobs in SQL? I expanded management, legacy, then DTS, however, I'm not sure if those are the jobs listed.Wed, 14 May 2008 14:01:14 GMTBrad Davishttp://www.sqlservercentral.com/Forums/Topic502218-147-1.aspxHi,I am getting this error when I am trying to update a column from a table which has a unique non clustered index on it.After going through the Microsoft website I found that the fix for this problem is 'obtain the latest service pack for Microsoft SQL Server 2000'.But I have a question , we will be upgrading the servers to 2005 and wanted to know whether this issue will be resolved automatically when the same query is run on the new 2005 box.Fri, 16 May 2008 10:04:34 GMTVJhttp://www.sqlservercentral.com/Forums/Topic501159-147-1.aspxHi!I want to schedule a job and I want it to run in the last week of every month, every 7 days. The solution I created was to make 7 different schedules for the last days of every month. For example, "last monday of every 1 month". So far so good, but the problem is that 6 of them are enabled but the sunday scheduled isn't. I've tried to enabled it but with no success. Is there other way to do this type of schedule or, in my solution, is some sort of clash?Thanks.Thu, 15 May 2008 05:00:48 GMTrui_frohttp://www.sqlservercentral.com/Forums/Topic500254-147-1.aspxKindly provide me the paths for Dumps where i can get MCTS Exam 70-445Wed, 14 May 2008 03:04:29 GMTpavan.sunkarahttp://www.sqlservercentral.com/Forums/Topic501826-147-1.aspxI have a SSIS package which imports data from a flat (CSV) file into SQL database. During the import I need to add 6 days to a column called Date.I have added a derived column transformation and entered the expression:DATEADD(day, 6, Date) but it doesn't like it - 'attempt to find the input column "day" failed'Is there something wrong with the syntax? Is this the right way of doing this or is there a better way?Fri, 16 May 2008 01:56:28 GMTPaul Manninghttp://www.sqlservercentral.com/Forums/Topic501446-147-1.aspxHi,Have a created job which contains n number of steps. Have also created a database mail and an operator. In the operator am able to set only one email id for the 'To' Address.But,I would like to send a mail notification to more than one email id.Could someone please tell how to send the email to more than one id?Thanks in advance!Thu, 15 May 2008 09:31:19 GMTjananikhttp://www.sqlservercentral.com/Forums/Topic493146-147-1.aspxHas anyone had experience limiting the available values on a datetime parameter and having the date picker still be displayed? I would like to ultimately use a query to return a list of available date and have the date picker shade all the unavailable dates when viewed so it's obvious to the user that only certain dates are available...When I try to do this now I get a drop down list of the available dates rather than a date picker for the parameter...Anyone?Wed, 30 Apr 2008 11:22:23 GMTBen Sullinshttp://www.sqlservercentral.com/Forums/Topic499161-147-1.aspxThis is a two-part plea for help ... Im trying to debug some errors with a Cube processing job, the AS instance is on the same box as the SQL instance where the job runs.I'm currently capturing SQL Trace data and Perfmon counters, but I need to capture AS Trace data as well. As this is a production SQL box, I am starting and stopping all the data collection in job steps, so they only run when the Cube is processing.(1) I have scripted the default AS Profiler Trace in XMLA, but I'm getting an error, and I dont know enough about XMLA to debug ...Error:[code]Executing the query ...XML parsing failed at line 7, column 53: A text/xml declaration may occur only at the very beginning of input..Execution complete[/code]XMLA (I removed all the Events / Columns except one, so it would be shorter, the result is the same though):[code]&lt?xml version="1.0" encoding="utf-8"?&gt&ltBatch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"&gt &ltCreate xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"&gt &ltObjectDefinition&gt &ltTrace&gt &ltID&gtOLAP_Errors_OLAP_Trace&lt/ID&gt &ltName&gtOLAP_Errors_OLAP_Trace&lt/Name&gt &ltEvents&gt &ltEvent&gt &ltEventID&gt15&lt/EventID&gt &ltColumns&gt &ltColumnID&gt28&lt/ColumnID&gt &lt/Columns&gt &lt/Event&gt &lt/Events&gt &ltFilter&gt &ltNotLike&gt &ltColumnID&gt37&lt/ColumnID&gt &ltValue&gtSQL Server Profiler - 54043a84-7877-4b36-b048-e70f72bf42cf&lt/Value&gt &lt/NotLike&gt &lt/Filter&gt &lt/Trace&gt &lt/ObjectDefinition&gt &lt/Create&gt&lt/Batch&gt[/code](2) How can I turn the AS Trace off after the Cube has processed?TIA ...Mon, 12 May 2008 15:07:35 GMTSimon Facerhttp://www.sqlservercentral.com/Forums/Topic501594-147-1.aspxHi,I migrated a DTS package to SSIS and I am facing an issue. The package makes use of the 'Send mail task' which doesnt seem to work. The same package when run as a DTS package in 2000 box is able to send the mail when given the destination address , but the SSIS doesnt.In SSIS I am asked for the name of the server and the 'From' and 'To' addresses to whom the mail should be sent, which is different from DTS where I have to provide just the 'To' address. I am sure that I gave the correct exchange serer name but the task doesnt seem to work.The send mail task never completes and stays red in colour..... Any suggestions???I have made sure that the 'Enable DB mail' is checked in surface area configuration.Thu, 15 May 2008 13:07:17 GMTVJhttp://www.sqlservercentral.com/Forums/Topic501649-147-1.aspxI have a weekly report in which I would like to change the parameters in the selection box to show the week number + the first day of the week. So it would look something like Week 1 - Jan. 1, 2008. Right now, it just shows the week and once you get into the middle of the year, that doesn't help much. The query for the parameter that RS created is:WITH MEMBER [Measures].[ParameterCaption] AS [Dim Date].[Week Num].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS '[Dim Date].[Week Num].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[Dim Date].[Week Num].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Dim Date].[Week Num].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@DimDateFiscYearNum, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [Dim Ops Organization].[Level2].&[1] } ) ON COLUMNS FROM [Sales DM]))I have tried change the parametercaption member but can't seem to figure out how to add the first child to it. I guess firstchild doesn't work with currentmember.Thanks in advance.Thu, 15 May 2008 14:57:45 GMTBill Whisnanthttp://www.sqlservercentral.com/Forums/Topic498623-147-1.aspxHi,i am starting my first BI project i have a Suggestion Scheme Database of my organization and managers wants to some BI reports from that system for this i need to develop a system using BI and using Analysis Services of SQLanybody help me how to start my project and any helpful material from where i can start my first projectthanksAhmer AliMon, 12 May 2008 03:29:22 GMTsh_ahmer_alihttp://www.sqlservercentral.com/Forums/Topic489758-147-1.aspxHi there!I made a ssis package and it's running great! I wanna know how do i schedule a job. Is it in VS or in SQL Server? i want it to run at the end of each month. Thanks for any help (Obrigado)!!Thu, 24 Apr 2008 03:56:38 GMTrui_frohttp://www.sqlservercentral.com/Forums/Topic501568-147-1.aspxI have a report that returns multiple tables in a group. I'm grouping by project manager which has multiple projects, each project contains data in a table. My problem is that when I print, my tables are being cut off so that the headers and first few rows are on one page and the rest of the table and totals are on the next page. There was a command in access that would allow me to keep my tables together so that if a table wouldn't fit on a page it would move the whole table to the next page. No table is larger that a page, but I'll get 2 and 1/2 tables on page 1 and 3 and 1/3 on the second page, I'd like to have 2 on the first page, move table 3 to page 2 and move on from there. Is this possible?? Thanks for any help you can give me.Thu, 15 May 2008 12:26:03 GMTmquinnhttp://www.sqlservercentral.com/Forums/Topic501287-147-1.aspxHi,I have a report with a subreport. It will display and export properly in the dev environment but will only display from the Report Manager. When I try to export it from the Report Manager I get an error. If I remove the subreport from the main report it displays and exports with no errors from the Report Manager. Here is the error I get.'An internal error occurred on the report server. See the error log for more details.'I checked the error log and did not see any detail to help me resolve the issue.Any ideas?Thanks,RonThu, 15 May 2008 07:23:55 GMTRon Frosthttp://www.sqlservercentral.com/Forums/Topic501115-147-1.aspxHi,We have a solution where we from a Windows application (using the report viewer control SP1) display some reports. Some of the reports uses a custom report item to display some graphics. This works fine on a lot of different installations, but now (for some reason) we have a problem at one customer.We get strange GDI and transport errors when rendering these reports:"Unable to read data from the transport connection: The connection was closed."or"Remote GDI stream version: 10.0.1. Expected version 10.0.1. Offset and length were out of bounds for the array or count is greater than the number of elements from the index to the end of the source collection."These report work fine when you run them in the browser, but they never work in the report viewer control...Please provide some help.Kind RegardsSuneThu, 15 May 2008 03:02:42 GMTskehttp://www.sqlservercentral.com/Forums/Topic443115-147-1.aspxHi All,i am pretty good at SSRS and Report Builder and my boss wants to explore this tool PerformancePoint. it's another BI Tool by Microsoft.has anyone worked with it before? can you please share some info/leads, opinion, anything you want to say :-), if you a Developer and not a Sales Person, i'd like to hear what you think :-), please.i just want to know if it's worth spending $$ on it for the reason other than me learning a new Tool :-) which i like doing anyway.Cheers + thanks in advance for writing me back.Maya.Tue, 15 Jan 2008 09:49:49 GMTmaya potiyevskayahttp://www.sqlservercentral.com/Forums/Topic499811-147-1.aspxI have written several reports that report off of an AS cube. The time dimension that the cube is using is:Fiscal YearFiscal QuarterFiscal PeriodFiscal WeekDateI have been able to figure out how the make the daily reports default to yesterdays date. I am having problems figuring out how to get the weekly reports or higher default to the correct period. For example, I would like for the weekly reports to default to the week that yesterday's date is in.Any suggestions?Thanks.Tue, 13 May 2008 10:24:52 GMTBill Whisnanthttp://www.sqlservercentral.com/Forums/Topic500748-147-1.aspxI have a report that currently performs a calculation in which the delta between two values separated by time are compared to determine the percentage increase or decrease from the prior time periods value. The problem I have is what to do when the prior time periods value is zero and thus resulting in a divide by zero error. I've included some custom code to default this to zero but my question is more about what logically to display for the percentage. Example:Week 1 - 0Week 2 - 5(0 - 5) / 0 = UndefinedThere is definitely a difference between zero and five but the challenge here is how to quantify that percentage...Any ideas?Wed, 14 May 2008 11:09:36 GMTBen Sullinshttp://www.sqlservercentral.com/Forums/Topic498576-147-1.aspxHi,I have a SSRS report that has two report date parameters: Start date and End date. I would like to know if it is possible in SSRS to set maximum and minimum values for these report date parameters.Any help much appreciated.Mon, 12 May 2008 01:02:26 GMTuma thttp://www.sqlservercentral.com/Forums/Topic500032-147-1.aspxI am passing in two parameters in the URL to my report. They limit the selections in one dataset that is used to populate a drop down list of report parameters (in this case 'Regions'). The url parameters are Region and Role. If the role is a manager, they can see a larger selection of regions, if they are not a manager, they see only their region as an option in the dropdown. Please don't be confused by the fact that the dropdown is showing a selection of regions, while at the same time the URL is passing in a 'Region' parameter -- there is a reason for this but it doesn't relate to this issue.The URL parameters are used in a dataset (running a stored procedure) that expects the two parameters. The parameters are used nowhere else in the report. Under the report parameters definition tab, I have the url parameters at the top of the list (as I understand it, this forces the report to evaluate them first). When I run the stored procedure in SSMS, it functions as expected -- both when I pass in 'Manager' or 'SalesRep' as role. When I pass in 'Manager' in the url, it functions as expected (that is, the drop down shows all the expected selections). When I pass in 'SalesRep', the drop down list is empty -- which to me suggests that the sproc is not returning the filtered dataset. When I preview the report in BIDS, manually typing in various values for the parameters that would otherwise be passed in in the URL, the report runs as I expect. Also, as I mentioned above, in SMSS the sproc runs fine. Any thoughts anyone? many thanks. DavidTue, 13 May 2008 15:52:31 GMTDavidLhttp://www.sqlservercentral.com/Forums/Topic497288-147-1.aspxIf I wanted to add a calculated measure that calculated a count of items against a customer where the customer.code was in the item.codes (for instance a customer may be code "x" and an item has a codes column of "xyz"), is there a way to do this?Thu, 08 May 2008 11:21:07 GMTRaconteurhttp://www.sqlservercentral.com/Forums/Topic499325-147-1.aspxhi,i tried to create an action..and i set action content as url but it was not working ..can anybody help me ..'thanksmaryMon, 12 May 2008 23:55:19 GMTmary.sindhurahttp://www.sqlservercentral.com/Forums/Topic499799-147-1.aspxHi Experts. I want to show the monthly trends of $deposit amounts by the number of customers.My first "Y" shows the $$ of deposits. i would like to add another "Y" that will show me the number of customers. My "X" shows the months.anyone has any leads and/or ideas?thank you very much!Tue, 13 May 2008 10:14:58 GMTmaya potiyevskayahttp://www.sqlservercentral.com/Forums/Topic495127-147-1.aspxI want to [b]show (print) parameters on the print of the Reports, not on the Preview/Excel/Screen.[/b]Example: User Selected From and To date for report. I am not showing From and To dates on the screen, but when I click on print and printing report then I want to print From and To date on paper.Is it possible in SSRS without using .net?Mon, 05 May 2008 11:07:29 GMTdeeptiomrayhttp://www.sqlservercentral.com/Forums/Topic498862-147-1.aspxIn the cube design view under the Calculations tab I have several calculated members that I have created. Each of these are dollar amount fields for which I have defined a Format String property as follows:Format String: "$#,##0;($#,##0);;\N\/\A"This format correctly handles my positive value, Negative value and my NULL value the way I want. However I need to deploy this cube on one of my UK severs and I don't want the $ but instead I would like the pound sign without having to recreate this entire project to do so. I have tried the following syntax but it is incorrect.Format String "Currency;;;\N\/\A"Can someone help me with the correct way to code the property so that I can get my currency symbol based on the regional setting as well as handle my NULL values.ThanksMon, 12 May 2008 08:53:22 GMTleeroysonhttp://www.sqlservercentral.com/Forums/Topic496204-147-1.aspxHi!In my dtsx, I make lookup's to several tables to see if some values exists there. In order to update my destination table, I use derived column and I've edited like this:Derived Column Name: fieldexistsDerived Column: replace "fieldexists"Expression: ISNULL([OutputLookup]) ? "False" : "True"Data Type: Boolean [DT_BOOL]The package runs smoothly and does what I want but the problem is that de field "fieldexists" is updated with the "True" value whenever is true, but whenever is false, it is not updated (it remains null).Thanks for any help.Wed, 07 May 2008 05:16:49 GMTrui_frohttp://www.sqlservercentral.com/Forums/Topic498652-147-1.aspxHi,I have craated an interface for generating the rdl file through c# (User will select some fields for group and some for details and report will be generated accordingly). I am generating the XML for the rdl according to the schema. And the report is running fine in my local system where i am using sqlexpress but is not working in production. The problem is coming with the datasource as follows.An error has occurred during report processing. Cannot create a connection to data source 'SOP'. Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connectionI am using Integrated Authentication, below is the datasource code generated by c# When i am pasting the RDL xml to my BI project's Report it is giving preview properly, but after deployment it is not coming. I have tried with SQL Authentication also by removing the IntegratedSqcurity element and changin g the connection string to add "sa" userid, but still it doesn't run and gives the same error and if i refresh the report with the refresh button of report viewer, it shows some Wrong String Format error.When i am editing the dataset in the report designer(BI Project), the connection string is not storing password and username info in the xml of the rdl, i read somewhere that it stores these values in VS2005 and reporting service database with some encryption and don't keep in the xml. So it is seeming to me that i am not sending these credentials to reporting service while deployment through my c# code. Below is my deployment codebyte[] byteRDL;System.Text.UTF8Encoding encoder = new UTF8Encoding(); byteRDL = encoder.GetBytes(reportDefination);Property[] rsProperty = new Property[10];//Property property = new Property();Warning[] warnings; warnings = rs.CreateReport(reportName, "/QuoteReports", true, byteRDL, null);But i have no idea why it is not even running with Windows Authentication also. I am in big trouble guys. Pls help. I have to show it to my client..Mon, 12 May 2008 04:43:54 GMTaalokitoaamihttp://www.sqlservercentral.com/Forums/Topic448940-147-1.aspxI have been trying to use BIDS to build an SSAS database and cannot deploy the database if there is a cube attached. If I have just a data source and data view the database will deploy and as soon as I build and add a cube and try to deploy the application hangs. I have also tried to build the database with BIDS online connected to the server and have had a similar result. I think I have a security problem but I have been unable to figure it out.I'm running SQL Server 2005 and Visual Studio 2005 on the same machine. OS = Windows XP.Thanks in Advance for any assistance you may have.Tue, 29 Jan 2008 09:16:47 GMTDan Baksahttp://www.sqlservercentral.com/Forums/Topic496132-147-1.aspxHi! There Please help with the query below, I would like to draw 12 months data using the query below please help.......SELECT dbo.Clusters.Cluster, dbo.Consolidates.Consolidate, dbo.Level3.Level3, dbo.Divisions.Division, dbo.Regions.Region, dbo.Areas.Area, dbo.Branches.Branch, dbo.Positions.Position, dbo.[Grade Grouping].[HC Cat1], dbo.Positions.BranchID, dbo.Staff.TransType, dbo.Positions.PosID, dbo.Staff.STAFFNOFROM dbo.Clusters INNER JOIN dbo.Consolidates ON dbo.Clusters.ClusterID = dbo.Consolidates.ClusterID AND dbo.Clusters.Period = dbo.Consolidates.Period INNER JOIN dbo.Level3 ON dbo.Consolidates.Period = dbo.Level3.Period AND dbo.Consolidates.ConsolidateID = dbo.Level3.ConsolidateID INNER JOIN dbo.Divisions ON dbo.Level3.Level3ID = dbo.Divisions.Level3ID AND dbo.Level3.Period = dbo.Divisions.Period INNER JOIN dbo.Regions ON dbo.Divisions.Period = dbo.Regions.Period AND dbo.Divisions.DivisionID = dbo.Regions.DivisionID INNER JOIN dbo.Areas ON dbo.Regions.Period = dbo.Areas.Period AND dbo.Regions.RegionID = dbo.Areas.RegionID INNER JOIN dbo.Branches ON dbo.Areas.Period = dbo.Branches.Period AND dbo.Areas.AreaID = dbo.Branches.AreaID INNER JOIN dbo.Positions ON dbo.Branches.BranchID = dbo.Positions.BranchID AND dbo.Branches.Period = dbo.Positions.Period LEFT OUTER JOIN dbo.Staff ON dbo.Positions.Period = dbo.Staff.Period AND dbo.Positions.PosID = dbo.Staff.PosID LEFT OUTER JOIN dbo.[Grade Grouping] ON dbo.Staff.Grade = dbo.[Grade Grouping].GradeIDWHERE (dbo.Clusters.Cluster = 'Retail') AND (dbo.Positions.Period = 200803) AND (dbo.Positions.Deleted = 0)Wed, 07 May 2008 02:22:56 GMTthatokhttp://www.sqlservercentral.com/Forums/Topic496186-147-1.aspxHi,I'm fairly new to Analysis Services, but I have an issue with connecting to an Analysis Services cube stored in the database.When using SSRS model designer I can connect to the cube no problem. But when I try and access the cube in Excel (using the Manage connections). I get the error Cannot connect to server x the server is either not started or busy.I have installed the following on the machine that has Excel ...http://www.microsoft.com/downloads/details.aspx?FamilyID=DAE82128-9F21-475D-88A4-4B6E6C069FF0&displaylang=en http://www.microsoft.com/downloads/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en http://www.microsoft.com/downloads/details.aspx?FamilyID=993c0bcf-3bcf-4009-be21-27e85e1857b1&displaylang=en Any help, very much appreciated.ThanksPeter GadsbyWed, 07 May 2008 04:45:24 GMTPeter Gadsbyhttp://www.sqlservercentral.com/Forums/Topic497225-147-1.aspxHi!Can anyone help me with the syntax of this expression:((OutputSalesHeaderStatus == 1) ? TRUE : FALSE )It doesn't catch the FALSE statement.Maybe some brakets are missing or something else...ThanksThu, 08 May 2008 09:56:23 GMTrui_frohttp://www.sqlservercentral.com/Forums/Topic497907-147-1.aspxI have created a report using SQL Reporting Servieces. That report is working fine. It Contains two parameters FromDate and ToDate i am usign the Datatype as Datetime and in the Default value i am Specifying today(). Iam getting the today date and beside it a calendar control is also there where we can change the date.I have deployed the report in the report server.I have developed a ASP.NET Application which conatins ReportViewer Control. I am passing the url of the reportserver and reportpath it is working. But the Calendar Control is not working. if any body know help meFri, 09 May 2008 08:04:45 GMTsista.raohttp://www.sqlservercentral.com/Forums/Topic497776-147-1.aspxHello,I am using SSIS to update database. We have parent package which calls five child packages.All the packages share single configuration file i.e single connection string.The parent package works fine without transaction. The parent package also has a stored procedure which uses the context connection.When we introduced transaction by setting Transaction on parent & child by setting properties (Required & Supported), the package is getting hanged. SP2 is installed on the machine, we are using sql server evaluation copy.Can we use RetainConnection property in this scenario? Will the child packages & parent packages use same connection?If we use transaction property, then do we have to do MSDTC related settings?Can anyone tell us how to put transaction ?Failure of the package or task in parent packages should rollback complete parent package related data.Regards,AratiFri, 09 May 2008 06:02:18 GMTarati.bargalehttp://www.sqlservercentral.com/Forums/Topic496050-147-1.aspxMemory error: The operation cannot be completed because the memory quota estimate (4095MB) exceeds the available system memory (1996MB). Been stuck with the error for a few days now ..... could really use some help.The error occurs when processing a vldm in SSAS , have tried different process methods add , update , full (was performed quite some time back) SQL Server 2005 32 bit , sp 2 with /3gb switch and AWE enabled in OS and SQL. Total RAM is 8 GB and perfmon counter show atleast 3.5 GB RAM available throughout the processing . The Dimension has 2 columns with varchar(2000) and the underlying table is 17GB in size with approx 33 mil records. SQL Server max memory has been set to everything from running vakues to max of 4 GB. Also tried using a Warm and Cold cache before processing. other SSAS propeties like memory limit enabled is set to false and buffer limit is set 60 % any other suggestions that might help would really be appreciated.I am fairly confident I have read every post and article on Perfomance tuning of SSAS and this particular issue, so I really have run out of options :-( Tue, 06 May 2008 22:09:58 GMTJaykayhttp://www.sqlservercentral.com/Forums/Topic497291-147-1.aspxHi All,Mind if you help look at this familiar problem, I installed a new sharepoint on server A, and database engine on server B and Analysis services on Server C.Am trying to do PPS and Sharepoint Integration? I got this url on web for the manual integration -http://blogs.msdn.com/performancepoint/archive/2007/11/12/how-do-i-deploy-the-monitoring-web-part-on-a-separate-sharepoint-web-application-on-the-same-sharepoint-web-server.aspxKindly check below the error displayed after following the steps adviced on the page:"An error occurred during the processing of /ceo/CEO DashBoard/Dashboard - CEO/Landing Page.aspx. Unknown server tag 'PPSWebParts:ScriptManagerLoader'.Troubleshoot issues with Windows SharePoint Services. "Please Note: I dont have PPS and Sql Server installed on the Sharepoint Server, can that be the reason am having installation issues?Thanks All,abacusThu, 08 May 2008 11:28:31 GMTOlalekan Adewalehttp://www.sqlservercentral.com/Forums/Topic497285-147-1.aspxHi there,I have a table for Items, which has a size column. There are 5 possible values for size, and any given Item can be in one or more sizes.I am trying to model inventory assortment of items by various dimensions, including size.Currently I have a FactShop table which has nothing but FKs to DimCustomer and DimItem. There is a many-to-many relationship that joins Customers to Items via FactShop so I can see how many people have a given Item, and see how many Items a given Customer has.I need to add in this size data for further detail, and am wondering if it makes sense to add it to the dimension table (which would mean I would have multiple rows for a given item where it fit more than one size), or if it should become a Fact.Thanks!ChrisThu, 08 May 2008 11:19:05 GMTRaconteurhttp://www.sqlservercentral.com/Forums/Topic494013-147-1.aspxHi gang,I am hoping one of the kind uber-brains here will be able to point me in the right direction.I am building a DW that primarily needs to count rows. At this current juncture, there is no data to be summarized. However, I am having a tough time bending the examples to do what I need.Here is what I have:We have customer data and item data. I have the customer data broken-up and flattened into a Dim and a Fact. In the FactCustomer table is a customer_id that points to the id of the DimCustomer table. That all works fine. My problem is with the Item data. A customer has a proprietary code, which is one of 7 characters. An item is also coded with the same value but an item can have one or more of the 7 codes.What I am interested in is the number of items that match a person by the code. So if I have two customers, one with code "A" and the other "B", and I have three items, one with "A", one with "AB" and one with "ABCD", I want to report the number of items. The columns would be the codes themselves, and the rows would be the customers, and the data in the middle is the quantity of items. Something like this: A B C DCust 1 3 - - -Cust 2 - 2 - -It seems to me that I may not need a Fact table at all, or perhaps the Item table is both Fact and Dimension... I am just not sure how to make this happen. The OLTP data is WAY over-normalized and too granular, so I have a bunch of SSIS packages to aggregate and flatten it into OLAP-structured tables. Point being, I can modify the organzation of the data however it will be most beneficial.Can someone walk me through this, or at the very least, point me in the right direction? As always, this was due yesterday, and people are already asking for changes.Thanks a MILLION for any input!Cheers,ChrisThu, 01 May 2008 20:49:44 GMTRaconteurhttp://www.sqlservercentral.com/Forums/Topic497150-147-1.aspxFolks,I have been using Reporting services for the last few years within an intranet environment which meant that I could manage all aspects of the configuration and deployment. I would build and deploy the reports from a VS studio installation on the RS server.Sometimes I had instances where datasources would suddenly stop working and I would have to rebuild the reports with newly created datasources.Other times I would deploy reports from my workstation and the datasources would not work on the server.I am starting a project with a client whereby I will not have control of the reporting server and will only be able to deploy remotely. I am a bit worried about this given my past experience of datasource problems and I am wondering what options I have in deploying reports without recording the datasources within SQL Server. Is it possible to store the datasource info within the RDL? Any advice appreciated.CheersKThu, 08 May 2008 08:46:04 GMTmick L