Answer Questions

• Joel Harris Cubes

  Hi, I have two Data Sources from two different servers.. Using that i have created two cubes namely HostCube and Applications Cube..Now i need to link the two cubes based on host name.. Host name is present in Host cube and Site name is present in Application cube.. I need to link these both and get the keywords, referal page, number of applications running and number of visits. Am not able to link two cubes and get the result.. I tried using Virtual Cubes, but it just takes dimensions from both the cubes and gives the result.. Can anyone help me out in this please. Thanks in advance.. I would guess you are trying to use AS 2000 to solve the problem. You should be way better off using AS 2005 that ...Show All

• dbaf Report Server Cannot Open Connection to Report Server Database

  Hi, I got consistent error of the following: ReportingServicesService!runningjobs!13!1/3/2007-10:45:21:: e ERROR: Error in timer Database Cleanup (NT Service) : Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to ...Show All

• nadasurf2 How to modify the query string of a dataset?

  Hi, I have a few questions. Suppose that i have a report based on this sql: Select * from table1 Now I want to be able to add a Where clause on that sql command programmatically. Like: Where name = 'Max' How can I do that should read set @sSql = @sSql + " Where somevalue = '" + @column1 + "'" I don't exactly got your point, however, it sounds like you want to create some parameters. Charltonn How are you determining whether or not to add the "where" You can however build dynamic SQL query statements to resolve your issue. Ham Listen Ham, May be I wasn't clear about my concern. I'm us ...Show All

• A..K Can't Create cube

  Is there is a way to create cube against database which tables get new records every few seconds I get these errors Thanks in advance Warning -2128674815 : Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_Log, Column: InsertDate, Value: 2/23/2007 9:22:32 AM. Thanks in advance Thank you guys. I will have to carefully review all the options. Thank you for all suggestions. Best Regards, You'll need to update the time dimension and your data incrementally and "lock" the database updates while the update is being performed (to maintain consistency). This'll take some careful consideration of your partitioning scheme, to make sure you maintain a reponsive system. H ...Show All

• jcninwisc how to get a variable value return back from a child package ?

  I have a parent package (i.e. P) and a child package (C). I was able to easily pass a variable value from P to C. And C did computations and get a result (i.e. integer) and stored this integer to a variable (x). Now I want the value of "x" to be passed back to P and store in P's variable (say Px). Anyone knows how to Thanks Steve Thanks for helpful info. Now, if I want to write a dynamic query for the sqlStatementSource expression of "Execute SQL Task" and wish to use a user-defined variable (i.e. User::Age) inside the child package, I must define/add this "Age" variable into the child package. For instance, I have this query: " select * from Employee where age = " & [Use ...Show All

• LotusExigeS1 Possible to make "Detail View" default in Report Mgr?

  Is there a config file where this can be modified such that the views in http://SomeWebServer/Reports will be Details view by default Still wondering about this. I reviewed the CSS one day for the site, but didn't see this in there. ...Show All

• lympanda selecting a LIST of parent objects with the TOP ONE child object (each)

  My dillema is this. I have a table with the simplified sturcture like this: Teacher TeacherID Name Etc... YearlyTeacherRecord TeacherID Year Phone Number blah blah I need a list of teachers with their most recent yearly teacher record. How would I do that Stephen, If your using sql 2005; a common table expression is the best way to go. WITH TREE ( COMMENT , PARENT , CHILD , MYOBJECT , LEVEL , PATHSTR ) AS ( SELECT COMMENT , ICTE , CHILD , [OBJECT] , 0 , CAST ( 'ALL' AS NVARCHAR ( MAX )) FROM #CTE_TABLE WHERE CHILD IS NULL UNION ALL SELECT T . COMMENT , T . ICTE , T . CHILD , T . [OBJECT] , C . LEVEL + 1 , C . PATHSTR + '\' + T . [OBJECT] FROM #CTE_TABLE T INNER ...Show All

• HairyDan How to pass values to multi value parameter

  Hi, I am trying to pass a url which can run my multi value parameter report. I have done similar thing for single value parameter and it worked but I don't know how should I pass more than 1 value to my parameter. Please help!!! -Rohit Have a look at this ariticle this should solve you problems http://www.codeproject.com/sqlrs/SQLRSViewer.asp OK, you want to pass companyID = 1234 and Region=Kent and Currency=GBP you would do http://reportserver/report companyID=1234&Region=Kent&currency=GBP Its a while since i did this and dont have a test to run here on that so it may be you need to remove the Companyid= sections and just pass parameters, something tells me it ...Show All

• bmtpfgh SQL Timeout through ADO but not from Query Analyser

  I have a strange problem running a stored proc in SQL 2000. The proc returns XML and I'm using ADO to call the proc and return the data as a stream. When I call the proc through ADO, it times out because it is taking 40 seconds to run and my command timeout is set to 30. I can increase this no problem but the strange thing is that when I run the same proc from within query analyser, it completes in under a second. I put profiler on it tracing the command start and finish events and it's definitely taking 40 seconds between start and finish. The proc is used with various input parameters and the timeout is only occurring for some combinations of inputs, but it always seems to take much longer than it does when run from query analyser. Can ...Show All

• Tsur CE support from ASP.Net 2.0

  MS states that CE does not work with ASP.Net applications 'by default'. What is needed to change this default Bascially, my desktop app. is configured from a browser app. (ASP.Net 2.0) and I want to use CE as the datastore for the application. Thanks. On a hosted website often one doesn't have a choice over the database. .mdb works fine for me on my relatively low access site. As OLEDB and SQL Server were not possible then there are few choices. Perhaps MySQL is another option. What programming language are you using to access the database Perl/python/Php I don't think this is such a good idea. SQLCe is not designed for this type of application and while it can be adapted for use wit ...Show All

• Buddhist Installation and licencing about MSSQL 2005 Standard edition and clustering mode

  Hi, I have a question about using MSSQL server 2005 standard edition in Clustering mode. I would like to build a msql cluster with only 2 servers (2 nodes). I read here -> http://www.microsoft.com/downloads/details.aspx FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en page 5 that you can use MSSQL server 2005 standard edition in Clustering mode with 2 nodes. But my question is : Can I use windows 2003 standard edition (Clustering mode managed ) or I only can use windows 2003 enterprise edition J. Windows 2003 Standard supports a 2 node cluster and SQL Server 2005 Standard also supports a 2 node cluster, so yes. ...Show All

• Michael Pritchard Microsoft SQL Server 2000 Reporting Services

  I understand that this is available for free but I have not been able to find it for downloading. Can anyone point me in the right direction for this Do you know does it really require alot of resources like I have been reading. People recomending a seperate SQL box just for thes reporting services. Please advise. Thank you.... but my understanding was that I could get a regular copy vs. evaluation copy for free. Microsoft was letting SQL 2000 users have the reporting services until they upgraded to SQL 2005 which would have it in it. Do you know where you can get a regular copy I am curious where this was mentioned. As far as your performance question, it is true that p ...Show All

• rcurrie SSIS Port

  Hi: Just wanted to find out what port does SSIS utilizes when communicated with a remote SQL Server. Is it 1434, 1433 or something I have a SSIS Package on Server 1, which which does inserts on SQL DB on Server 2. I think between Server 1 and Server 2, some ports are being blocked because the 2 servers are separated by a firewall. When SSIS makes connection to Server 2 (SQL), what ports does it use Also, any other tips would also help. Here is the error I am getting: Cannot connect to 10.xx.xx.xx. =================================== An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not al ...Show All

• George Waters Split Function

  Is there any split function in sql server 2005. I just want to pass a string to a stored procedure. it should split that string when it encounters a space. for ex, consider the string " the intel mother board" it should give "the,intel,mother,board" as result. Thanks man. thanks for the reply. Actually i don't want to replace the "space" with "comma". i want to take each word separately from that text. i.e "The intel mother board" to The intel mother board Thanks pal....That was good. You are probably going to need to be more clear. Technic ...Show All

• bob26 Windows integrated security issue

  I have two SQL 2005 server ServerA hold the database ServerB hold the report server. While I using "Credentials stored securely in the report server" option in the data set the report generated without a problem while I'm using "Windows integrated security" in the dataset I'm getting error message An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'MYDB'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errors In the ServerA (SQL databse) I see event log Event ID 18456 Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. I configure ServerB (Report Server) com ...Show All