Answer Questions

• Steph_Job0 How to address cells in a calculation

  I have a calculation where I need to get the value of a certain cell in my cube. It looks like this: ([Measures].[Amount], [Table].[Table].&[{327365F8-F148-4C34-A749-D3F56FD3B8F6}], [Line].[Line].&[{2155F898-47EA-4269-B167-BE940C79E9F6}], [Column].[Column].&[{83435F85-93AB-48D1-B2F3-B5E0BAF62642}], [Currency].[Currency].&[{2FA606E1-0A20-4A21-B360-643A530C297B}], [Maturity].[Maturity].&[{188601ED-2E02-4883-9336-45BC831C5EE8}], [Region].[Region].&[{0712BAAF-FEE4-479E-8287-E75DAD405B40}], [Sector].[Sector].&[{E52C493D-6528-490E-BD63-4A0857F8B53F}], [PastDue].[PastDue].&[{524942A0-A1ED-4BF5-86D2-F8EF393F0004}], [Custom].[Custom].&[{7FCAB9D1-4D7B-48CD-8EEC-1AA47F5D9CD1}], [Sit ...Show All

• PlanetWilson Group Case Sensitive

  It appears that table grouping is case sensitive (for example, Re-Roof versus Re-roof appears to be causing a group break). I can't find a parameter to change this behaviour in Reporting Services. Can anyone verify that it is in fact case sensitive How to change I am running SQL Server 2000 and the database that I am querying is not case sensitive. Made the suggested change and it didn't affect the report grouping. After a little experiment, I can say the group break is definitely case sensitive. Just a clarification on what I have found in this case. Since DataRegion/DataSet/Grouing can be used for scoping puproses I thought it would be good to broaden this ...Show All

• Liston Index usage statistics report

  Has any body else had this problem. In SQL Server Management Studio in the report tab when I choose Index Usage Statistics all I get is just these messages and no info at all. Is this a bug. It does tell me the name of the database. Index Usage Statistics Shows how the users and system use the indexes. Index Operational Statistics shows details of the no. of operations performed on the indexes Many thanks. I usally use the system views to get the info I need. Please let me know when you hear anything from microsoft. You might try a DMV query, such as this to get useful index info -- Possible bad Indexes (writes > reads) DECLARE @dbid int SELECT @dbi ...Show All

• Eva Gonzalez SSAS 2005. x86. Memory Allocation Errors during processing.

  I have an AS2005 on x86 Box with 4Gb RAM with 2 Xeons 2,2Ghz. On the same box runs SQL Server - the data source for AS. If the cube is processed, i can't reprocess indexes and aggregation after dimensions update. I get permanent memory allocation error. The cube size is funny - only 3Mio rows in 13 artitions. Only thing what runs is to make cube unprocessed and full reprocess it. But it brokes one of the businnes requirements, that users can always query the cube with simple queries, though with 10% of performance. If this doesn't help, I would also suggest reviewing your dimensions structure. Do you have large attributes with a lot of members If so, you can consider disabling optimization for suc ...Show All

• mr4100 An error was encountered in the transport layer

  I am fairly new to SSAS 2005. I have just created one cube. I was able to create an Excel pivot table that connected to this cube and had all the funtionality that I expected. I then published the pivot table as a web page. When I view the web page on the server where SQL 2005 is loaded the web page comes up with all of the expected functionality. But when I try to view the web page from another computer on my network I gett the error The query could not be processed: An error was encounted in the transport layer The peer prematurely closed the connection. Any suggestions on how to proceed. You could try tracing the SSAS server while you try to connect to see i ...Show All

• ajay1007 SQL Express: Cannot Open User Default Database (error 4064)

  I've tried everything I've read that seemed applicable but still have a problem with the same error message, cannot open user default database. This started detaching the database. I'm using this connection string: connectionString = " Data Source=.\SQLEXPRESS;GC_CashBook.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True " It's a WinForms application. When I run in debug mode, I connect fine. I can do anything in the db in VisualStudio 2005. Then I open the SQL Management Studio, connect to Sql Express, try to open the same database and it can't open it. BUT... If I stop running the VisualStudio application (I can leave VS open, but not run the app I'm developing), and reopen SQL Management Studi ...Show All

• qrli Number of rows

  Hello! I try to figure out how to change the number of rows at each page, but I'm stuck. I have no page break , but I get a number of pages when I view my report. Is there any way to set the number of rows shown at each page //Cissi I solved the problem by changing the properties for the Report Viewer. I changed AsyncRendering to false. But I still dont know what to do with the row number. It works up to about 30 rows at each page, but I don't want any page break at all. The reason is that I use a report viewer which I have a link to from an asp page. In the report I have a "jump to url", which take a value back to the asp page. When I change page in ...Show All

• Tamiri Can't see property of SQL Server Agent

  Hello! I am working on Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2) and want just see properties of SQL Agent. What I do: Start Agent's service, right click on SQL Server Agent node(in Object Explorer) and select "Properties". All I get is: TITLE: Microsoft SQL Server Management Studio ------------------------------ Cannot show requested dialog. ------------------------------ ADDITIONAL INFORMATION: Property ErrorLogFile is not available for JobServer '[ASUS]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.S ...Show All

• BilalShouman Cannot set the ProfileName on a merge agent

  Hi, I am trying to create a new merge subscription using RMO on Sql 2005, but I want the new agent to use a non-default profile. I can set the ProfileName on the agent but it seems to have no affect. I was wondering, do I have the wrong Profile name This is the code I'm using subscription = new MergeSubscription (); subscription.ConnectionContext = conn; subscription.SubscriberName = server; subscription.SubscriberSecurity.SqlStandardLogin = sqlUserName; subscription.SubscriberSecurity.SqlStandardPassword = sqlPassword; subscription.SubscriberSecurity.WindowsAuthentication = useWindowsAuth; subscription.PublicationName = publication.Name; subscription.DatabaseName = publication.DatabaseName; subscri ...Show All

• Michael Vanhoutte SQL Server Migration Assistant for Oracle problem

  I'm trying to make the business case to move our business databases to SQL Server 2005 from Oracle 9i. The SQL Server Migration Assistant for Oracle will be absolutely necessary for this to happen. However, I am unable to launch the assistant. It tells me I have an old version of java installed - but I don't. It is a new XP machine and I downloaded and installed j2sdk-1_4_2_12-windows-i586-p.exe which did not help (I rebooted). Why does it think I have an old version and how can I get this assistant working. Any help would be much appreciated. Hi ferrethouse, I can give here some hints about the way SSMA works with Java runtime. When started, SSMA looks into the registry and tries to locate ...Show All

• lou_RUS Frequently update and select Table Locking Problem

  Hi guys,               I faced problem related to Locking and Isolation Level on Table(s).               My problems is there r some tables which r frequently updated, and I also want to fire select query over   those tables every 1 seconds and want to get only committed records.             In current scenario we start transactions with ReadCommitted Lock for updating records. But in this scenario I can’t get select query result because of some of recourses r used by transactions so after some time it gives Deadlock error .     ...Show All

• Shailesh Chaudhary Integration Services and Teradata as source

  Hi All, Please let me know whether we can use Teradata as Source in SSIS (Target is SQL Server 2005). ie. Do we have oledb driver for NCR Teradata to connect to it. Our SSIS will be hosted in 64 bit SQL, but for development we use 32 bit. Any inputs is really appreciated. Regards, kart HI Deniz and Daren, Thanks for the info. It would be helpful to me if you could provide some inputs on Cost Factor w.r.t ETI and iWay and any other implementation details. I assume, using ETI/iWay connectors is a better approach than using OLEDB Driver provided by NCR - as these improve the access performance. Regards Kart NCR provide an OLE-DB provider, so I would guess that would be your first option. Saying that I do no ...Show All

• SankaraNarayanan Nagalingam The Cost of a Trivial Join

  Hello- I was wondering what the performance implication and query plan is of a join to a very small lookup table. Specifically, I have a table of about a million records that is used for reporting purposes. Each record has a type (there are about 10 different types). The type has an ID and a few bits of information regarding how that type is handled. This is in a separate table right now. I can denormalize the data and put the fields from the type table into the large table to avoid a join, but my hunch is that a join to such a small table (10 records) is trivial for SQL Server to do, so there's no real need. Can anyone confirm or deny this Regards- Eric Depending on how you have indexes implemented. A table scan of the sma ...Show All

• John_Mac Is WITH / Common Table Expression a syntactic sugar?

  I tried to use WITH to factor out the shared star join portion from a sql statement as it's usually the most expensive part. However, examing the execution plan shows that the WITH clause is merely a syntactic suger that will internally be plugged back as derived tables where the same star join is executed repeatedly. Is the intermediate rowset produced by a WITH caluse ever shared during the query execution In SQL Server, CTEs are similar to views in that the definition or query expression is replaced inline in the query in all references. So you don't really get any results caching etc. You need to use temporary tables if you want to do that. Except for recursive CTEs, you can pretty much conve ...Show All

• Demix problem with reporting charts

  hello to everybody, well i have a problem. in order to display some values in a matrix i use the expression aggregate so i get the evolution of the values during the time. When i try to use the same function in a line chart with data for ex (aggregate.fields!budget.value) and as category the time, i dont get the line... it gives me zero values, while in the matrix i can see the numbers. What can i do ...Show All