Answer Questions

• Rasmus Helwigh Running MDX with multiple levels in one hierarchy

  When I run a mdx that selects multiple levels in one hierarchy in management studio, the resulting table shows all the members in one column for that hierarchy. Is it possible to break down the hierarchy into two columns One for each level Similar to how when you browse a cube, you can drag expand a level and have two columns I am trying to display a cellset as a html table but when multiple levels are selected, it's hard to see the level breakdowns. Can you use the crossjoin of two attribute hierarchies, one for each level, instead of the multi-level user-defined hierarchy If you are generating the html table from code using an adomd cellset you should be able to ac ...Show All

• Ijaz Ali How to import Flat Files with single and double quotes imbedded in them?

  I've got a flat file data source, that is to large to edit with most Windows apps on my server that contains both single and double quote characters that I need to load in a varchar column. So I attempted to do it with a Replace in data transformation, but I can't get SSIS to allow me to use a variable or pair of single or double quotes within the replace. If I don't replace the single quote characters with a pair then the records containing these characters all end up in my failed records output file. Here are 5 example property legal descriptions from my FLAT FILE data source: COM 441'6" N OF SW/C OF NW4 OF SEC 22-29-20 ELY1340' N200' CROSSING THE CNTR OF TR AT 100 WLY1240' S200' TO POB CONTAINING 6 3/10 ACRE MOL N ...Show All

• Tom Frey Hypertext link in a report.

  hello : On a hypertext link in a report, how to open the link in a new window IE. Thank's. Thank's for your answer ; but Where what is that I have to put that I can't use the file .config Hi, Think in the Report Server also you can't get that link.You can do one think in the Web application,Drag ReportViewr control and put the report in the ReportViewr.Run that web application.Then you can get the link. Hope this helps You'll need to use the "Jump to URL" option instead of the "Jump to report" option and construct the URL using an expression e.g. ="window.open('" & Global ...Show All

• Michael Tripp YTD

  Hi, In my Time dimension, there are 8 different hierarchies exists, including calendar and fiscal calendars. There are Time utility functions created through BI wizard. { edited to incorporate drill down to lower levels of the hierarchy } But this is not working fine in all situations. if i apply 2 filters for week and year, the MTD and YTD shows N/A only. So my question is how to modify the MDX to handle all the scenarios. here is the code for YTD i have used.' ( [DIM CALENDAR].[Calendar DIM CALENDAR Calculations].[YTD], [DIM CALENDAR].[AS_OF_DATE]. Members , [DIM CALENDAR].[CY_YEAR].[CY_YEAR]. Members ) = Aggregate ( { [DIM CALENDAR].[Calendar DIM CALENDAR Calculations]. DefaultMember } * ...Show All

• Alessandro Camargo Copy Database Wizard - Error on Execute SQL Server Agent job

  I am trying to copy a database from our company's external SQL Server(production) to our local SQL Server(development). The Copy Database wizard fails on the step "Execute SQL Server Agent Job". The log gives me the following info... Could this have to do anything with the SQL Server Agent not being able run the SSIS package created by the Copy Database Wizard Please advise.. #Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message OnPreValidate,SERVERDEV,NT AUTHORITY\SYSTEM,CDW_MARATHONSQLHA_SERVERDEV_SQL2005_5,{D5E55BA7-919C-42F7-BA6D-8ACA0078417E},{EE201379-F597-48E8-9481-1C759E0F56D4},8/3/2006 8:31:43 AM,8/3/2006 8:31:43 AM,0,0x,(null) OnPreValidate,SERVERDEV,NT AUTHOR ...Show All

• adorer Error in Application Log

  The application log keeps generating this error message and I can't seem to find any information on it. Can anyone shed some light Event filter with query "select * from __InstanceModificationEvent within 10 where TargetInstance isa 'Win32_Service'" could not be (re)activated in namespace "//./root/Microsoft/SqlServer/ComputerManagement" because of error 0x80041010. Events may not be delivered through this filter until the problem is corrected. I did a quick search through the forums and here is a thread that suggests that it is could be "unisys sentinel script". Can you see if this applies to your environment and let us know I see a couple people have posted similar questions on the web and the ...Show All

• feiyu Converting milliseconds in hours

  Hi! I have the difference between two dates in milliseconds. I want to convert this difference to the format hh:mm:ss.mmm, without the date. So, if the difference is bigger then one day, I would like to show it like this, for example: 36:25:14.047 How can I do this Thank you! AnaC: Below is another alternative. Dave declare @1stDt datetime set @1stDt = '10/15/6' --declare @2ndDt datetime set @2ndDt = '10/15/6 01:02:03.006' declare @2ndDt datetime set @2ndDt = '10/16/6 12:25:14.047' declare @diff integer set @diff = datediff (ms, @1stDt, @2ndDt) select convert (varchar (13), @diff/3600000) + ':' + + right ( '0' + convert (varchar (2), (@diff % 3600 ...Show All

• sjb31988 How SQL Server2000 Client instance and Server instance works?

  Hi all, i have installed SQL client instance on my Desktop "Machine-A", and i used to connect to SQLServer2000 running on another "Machine-B" by using valid username and password. i created a DTS package and i used to run it. im very confused how the communication happens between the two machines and which process run where and which initiates which and which machine allocates waht resources. im really interested to know all these things. if any one know plz help me out. Thanks in advance. There is no such thing as "client instance" - there is only one client installation. You may install multiple SQL server, thus creating multiple "server instances". The DTS package runs in the process that started ...Show All

• Raoul_BennetH Enable Service Broker for DB Mail on SQL 2005 Cluster

  I'm having problems enabling service broker for DB Mail on a SQL 2005 cluster, when I try to execute this sql it just hangs. Any ideas USE master ; GO ALTER DATABASE AdventureWorks SET ENABLE_BROKER ; GO This as happened to me when using a disaster recovery procedure - reinstall sql_engine with start/wait setup.exe ... and restoring master from a previous backup So it seems that when using "proper procedures". the guid is not recovered correctly. Xavier You shouldn't have any problem from now on. You have now created new GUIDs, and the one in the database matches the one in the sys.databases. HTH, ~ Remus This did help me get past this part. Now I'm receivin ...Show All

• Asher Aslan Where the hell is LIMIT like in MySQL?

  If you ask ANY developer that has worked with both MySQL and MS SQL, every single one of them will say why hasn't microsoft given MS SQL the capability to do LIMITS as such in MySQL.  I'm not impressed by any of the stupid work arounds either... they run heavy and crapout under a large record load. Of course there are several other attributes that MS SQL has that MySQL can't offer, but again, MySQL is FREE and PAID tools should have all that a free competitor has plus some. Is there any planned action to remedy this absurd oversight Actually, no... this isn't a stored proc.  All of that code can be performed inline as ad-hoc SQL.  I believe the term for this is a "Common Table Expression".  You c ...Show All

• srem Indexing Question

  I am somewhat new to SQL and have an indexing question I have a table that consists of 60 columns of mostly numeric data. Included in the table are fields called Customerid, CustDate and CustTime. Every hour data is posted to the table with the current time and date as well as customerID. The table is about 6 million rows. I have a query that reads: SELECT CustomerID, custdate + custtime as date FROM Mytable WHERE CustID = 905 and (date between ‘1/1/7’ and ‘1/17/7). The query works but it takes longer than I would like so I am wondering if it’s an indexing issue. Currently my table is indexed as CustomerID + CustDate + CustTime. None of the fields are unique, but the combination of the 3 i ...Show All

• enric vives R how to add column header in a Matrix

  Hi, is there a way to add column header in a Matrix Thanks, Igor Igor, Thanks for the update. I'll take another shot at it and see if I can spuce it up a little. Ham it's a good solution, the only problem is that it doesn't look good when rendered to html. In excel it displayed at the bottom. what I meant was I want find out the way to add a column header to a group in the matrix. Is it possible Thanks, Igor Igor, Right Click in your Matrix data row, you can select "add column". Ham Igor, You can still use the same as a "Header", I create my column, drag ...Show All

• HopeDreamsComeTrue Radio button

  Hi, I have one report,in my report i need to display parameters like this: one radio button :Age and another radio button is Age Ranges For the Age,I have to dispaly like two text boxes named 'From' and 'To' For the Age Ranges,I have to display one drop down list contains values :20s,30s .. In Reporting Services,Putting the Radio button is not possible,i think,If possible how to achive this. Other workaround is i think Multivalued parameter which displays the Age and Age ranges When we click on Age we need to display 2 textboxes When we select Age Ranges we have to display Drop down list If we select both :both 2 text boxes and drop down list. Putting multi valued parameters for this requirement is not good a ...Show All

• El Gaseron MAJOR PROBLEM: New SQL2005 installation performance problem.

  We are experiencing a major issue since upgrading from SQL2000 to SQL2005 over the weekend. Starting today, it appears that the performance of SQLServer reaches a limit every 15 minutes. Our configuration is as follows: Window Server 2K3 x64 Enterprise SQLServer 2005 x64 Enterprise HP DL585 with 4 dual core Opterons 32 GB of RAM 2 TB EMC SAN At first, I thought there was a memory pressure problem, since I had the default max memory set. After changing the max memory to only 25 GB (out of 32 available), the issue went away temporarily. However, after 15-20 minutes, the number of batches/sec dropped in half, and remained after half until I changed the max memory setting again. Over the course of the day, I was able to fi ...Show All

• SachaVDK Can I build a cube using a SQL data source and a DB2 data source

  We are trying to build a cube using data from SQL and DB2. Is this possible and if so, how I'm getting the following error when trying to build the dimension from DB2: OLE DB error: OLE DB or ODBC error: Ad hoc access to OLE DB provider 'DB2OLEDB' has been denied. You must access this provider through a linked server.; 42000. Any thoughts I know I can build a cube using SQL as a datasource and Db2 as a datasource. What I need to know is whether or not I can build a single cube using a SQL datasource AND a DB2 datasource. In other words, can I have 2 datasources in the same AS project Sorry, I misunderstood your question :( In ...Show All