Answer Questions

• epsilon_ro what microsoft tool to use for join 2 fact table by more then 2 dimensions in ad-hoc

  Hi I have 2 fact table Sales and Invoices and 3 shared dimensions (time,product,customer) Sales -> time <-Invoices and Sales ->product <- Invoices and Sales->Customer<-Invoices I can't find a tool, a microsoft tool to give the end user the capabilities to build a report that is selection of Sales fact (values) , Invoices fact (Values) by date(Time dimension) , Product (Product Dimension), Name (Customer Dimension). If I' am work in sql 2005 the report builder cant navigate form one fact table by more then one dimension at the same time In analysis server 2005 if you do a cube wity 2 fact tables ( a susbtitute for virtual cube in analysis server 2000), in report builder you if you chose a measure from ...Show All

• MARCOSEDRALIN Edited

  edited edited ...Show All

• Fairfax Unable to install SQl Server 2005 SP2 - Unexpected error

  I am trying to install SQl Server 2005 SP2 but it was throwing an unexpected error when trying to install "setup support files". O/s: Windows Server 2003 SP1 Product: SQL Server 2005 Standard Edition Log file shows: +++++++++++++++++++ === Verbose logging started: 2/20/2007 16:05:42 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: F:\SQL2005sp2\hotfix.exe === MSI (c) (74:68) [16:05:42:635]: Resetting cached policy values MSI (c) (74:68) [16:05:42:635]: Machine policy value 'Debug' is 0 MSI (c) (74:68) [16:05:42:635]: ******* RunEngine: ******* Product: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi ******* Action: ******* CommandLine: ********** MSI ...Show All

• Awais786 Databases Progress

  How Can connect tha Progress Databases in DTS Google gave me this list: http://www.sqlsummit.com/oledbVen.htm of companies that offer OLE DB connectors for various systems. 2 of them offer something for progress. -Jamie Progress have their own ODBC driver, which may be accessed using the .Net Data Reader source in SSIS, and the ODBC .Net Framework Data Provider See http://www.psdn.com/library/servlet/KbServlet/download/1102-102-905/odr.pdf Donald ...Show All

• Inmon Getting Status/History Info. from .exe that is Run by a Job

  Hello. We're using SQL Server 2005 and SQL Server Agent to run some jobs. These jobs execute a custom .exe program (written in C#). What we're wondering is, is there any way to send status/history information from the custom .exe back to the job that kicked it off We're trying to provide execution info. to show if the job succeeded or if some error occurred in the .exe (thus the job didn't complete successfully). Thanks! ...Show All

• Brandon Tucker Dynamic view

  Is it possible to create dynamic sql views in Sql Server 2005 I have a requirement of having to change the Sql View depending on the user selection criteria. Is it possible No but you can create a stored procedure with dynamic sql kludge If you would change the view (with an alter view statement) what would happen when 2 users would hit the view at the same time (problem) sp with dynamic sql is your best bet (probably including a temp table, I don't know your requirements so that's tough to answer) Denis the SQL Menace http://sqlservercode.blogspot.com/ No, A "view" is always the same list of fields. Also, if you create a view whic ...Show All

• RizwanSharp SQL 2005 Equivalent of SQL 2000 TaskPad VIew

  Hi, u all know that there is a TaskPad view available in SQL 2000 , which provides quite useful GUI about u r server. Is there any equivalent in SQL 2005 http://www.sql-server-performance.com/faq/viewfaq.aspx faqid=141 fyi. ...Show All

• Tom_Liu Mirroring gives me the error 1418 and in the server log gives the error 10054

  Hi, I am trying to mirror the databse with a witness server. I have sql server 2005 with SP1 or both my mirror and principle and sql express on my witness. The problem is when I click start mirroring, I get the following error The server network address"TCP://serveraddress:7026" can not be reached or does not exist. Check the network address name and that the ports for the local and remote epoints are operational. (Microsoft SQL server, error:1418) I have pinged the address it works fine . The telnet comes up with a blank screen. When I look at the the server log file viewer, I get the following message An error occured while receiving data: 10054 (An existing connection was forcibly closed by the remote host) ...Show All

• sashag JOIN Filters and Non-numeric Keys

  I expect that this is not possible but: I've created a initial filter on our tblLocation. I've created a join filter on the header table for our inventory data. I've create a join filter on the header table for our inventory detail data. The joins between the inventory header table and the inventory details table is on a three field key which are of type nvarchar. When I try to sync a subscription, I receive an error which indicates that it cannot bulk copy into the inventory details table on the subscriber because it would create duplicate keys. There isn't any duplication at the publishing server so, I expect this has something to do with the data type of the key/join fields. Am I correct If so, is there a workaround. ...Show All

• Okay How to use same connection manager in different packages

  We want to use a single connection manager in different packages. IS there a way to do it We tried copying the same connection manager in different package, but it makes a copy of the same in different package, so any change in the connection manager doesnt gets reflected in other package. IS there a way to make all the different packages use the same connection manager Connection manager belong to every package hence any change need to be aplied to a every package. But is there when package configuration come to the rescue. There are a lot of threads addressing that issue. This is an articule that may help you understanding it: http://www.sqlis.com/ 26 ...Show All

• Milad.a.p SaveAs/Export

  Is there away with the reports to code to have them export into a excel template (a specific one) and have each report go into a different tab When I run the reports manually I can save to excel put not a pre-existing template. Each report has 3 to 12 stored procedures it needs to run so I am just not sure how to accomplish this task. Thanks in advance! Stokh okay now that I have a clear mind. I will give each step Files are sent over from Mainframe out to a location they are just .txt files. scheduled task will run DTS when the mainframe program finishes generating the files DTS package fires, itirates through the folder and imports all the .txt files into SQL Database Scheduled task/Bat file/subscrip ...Show All

• kimhoskin Accumulated values in analysis services

  Hello, I'm making a report where I have a matrix showing the weeks of a month in the columns and certain data. The user selects a month and I use it as a parameter to show all the calculations from a cube. I already have all the data needed for the matrix, the problem is that I need an accumulated value in the last row that sums the first week's accumulated value and the second week's value and so on (the month can have 4 or 5 weeks). The first week's accumulated value is the data itself since there is no previous value. week1 week2 week3 .... data x1 x2 x3 ... accumulated value x1 x1+x2 x1+x2+x3 ... I don't know if I can do this from the cube using ...Show All

• MA2005 MDX Statement create CalcMemebers

  Hello together, I want to get the value (Measure) of a Cube "4711", and this Value I want to display in an other Cube "XY" as a CalcMember. Do you have an idea for the rigth syntax ...Show All

• kevin D. white Error when changing the length on DataReader Source

  Hi, I am trying to import data from Oracle RDB into SQL Server 2005 using SSIS. Created a ODBC data source to connect to Oracle and used DataReader Source component and ADO.net to connect to the ODBC data source. Under the Component properties tab, the SQL Command looks something like this. Select ID, ADDRESS, REVISED from ADDRESS The data type for the source columns are Integer, Varchar(30) and DATE VMS. Now when I look at the Input and Output properties window, The External columns has the following data types. ID - four-byte signed integer [DT_I4] ADDRESS - Unicode string [DT_WSTR], length = 0 REVISED - database timestamp [DT_DBTIMESTAMP] The Output columns has the following data types ID - four-byte signed integ ...Show All

• Yuhang Developer Edition vs Enterprise Edition

  Does anyone know why the same cube deployed on 2 different servers (one Enterprise Edition, the other a Developer Edtion) with the same MDX query would return 2 different Results MDX query I am using: WITH MEMBER [Measures].[TimeChargedToDate] AS 'SUM({NULL:[Timesheet].[Date].&[2006].&[9].&[15]},[Time Charged])' SELECT NON EMPTY { [Measures].[Time Charged], [Measures].[TimeChargedToDate] } ON COLUMNS , NON EMPTY { ( [Project].[Project Number].&[Z07600] * [Staff Member].[Staff Member Name].[Staff Member Name]. ALLMEMBERS ) } ON ROWS FROM ( SELECT {[Timesheet].[Date].[Year].&[2006].&[9].&[2] : [Timesheet].[Date].[Year].&[2006].&[9].&[15]} ...Show All