Answer Questions

• Chardiot KPI Trend depending on last 4 months

  Hi! I've created a KPI. My problem is on the creation of the MDX trend expression. I'd like trend to depend on last 4 months. I wrote this query which works fine in SQL Server Management Studio : WITH MEMBER [APPEL].[Hierarchy].[My4Months] AS Aggregate( lastperiods(4,[APPEL].[Hierarchy].[ANNEE APPEL].&[2006].&[02]) ) SELECT [APPEL].[Hierarchy].[My4Months] ON COLUMNS, KPIValue("Pourcentage de respect") ON ROWS FROM [Amon] I'd like to obtain the same result in SSAS. So i created a calaculation nammed My4Months with the expression : Aggregate(lastperiods(4,[APPEL].[Hierarchy].CurrentMember)) ...and I entered as trend expression : CASE WHEN (KPIValue("Pourcentage de respect"),[APPEL].[H ...Show All

• Tryin2Bgood Selecting Statement execution

  hi all, this morning i went mad trying to understand how to do something like this: WHERE         CASE @Variable1                 WHEN 0 THEN T1.Field1 <= Value1 AND                 WHEN 1 THEN T1.Field1 >= Value2 AND                 WHEN NULL THEN T1.Field1 >= Value3 AND         END         T2.Field2=@Variable2 AND so on Can i select the statement that should be executed i tried even inserting all the WHERE clausoles into 3 different ...Show All

• denning_s Open reports with report builder

  Hi! We have a "folder hiriarchy" in reporting services with permission for different users to only create reports in their own folder. However, it would be nice if they (in report builder) could open eachothers reports, modify them and then save them in theri own folder. In this case, if they find a useful report that someone else has created, they could just make their own small modifications and save it in their own folder. The problem is that I cant't seem to find a securitysetting that allow this. Either they can create/modify/delete the reports in a "folder" or they can't even open them in report builder... Is there a solution to my problem regards Andreas It looks li ...Show All

• Helen999888 DTExec via xp_cmdshell

  In my previous post here: https://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1044739&SiteID=1 Michael Entin provides a number of responses to my questions regarding programatic execution of remote SSIS packages. Having experienced some significant reliability problems with the Microsoft.SqlServer.Dts.Runtime components from an ASP.NET process (the page either times out, or inevitably just stops responding), I have been prototyping the DTExec command option which Michael suggests as being a better approach to remote programability. So, off I've been prototyping this all day today... I have a stored procedure that wraps a call to xp_cmdshell which takes the DTS (DTEXEC) params as a big long argument. This scenario would h ...Show All

• Jim Wooley saving xml to table

  i have sql-server 2005 the xml structure saved in table with XML type(XmlOrderFile xml) /* create table TempOrder (seq int identity primary key, XmlOrderFile xml) */ the xml structure is : <ROOT> <Order> <OrderID>123</OrderID> <orderStatus>OK</orderStatus> <commments> <ordcomment> <Comment>Hi 123</Comment> <UserName>sharon </UserName> </ordcomment> <ordcomment> <Comment>Bye 123</Comment> <UserName>Sharon </UserName> </ordcomment> </commments> </Order> <Order> <OrderID>124</OrderID> <orderStatus>Not OK</orderStatus> < ...Show All

• allstar1234 problems in Hands-On-Lab, MED302

  Hi, I am new to Windows Mobile. I am trying to follow the expample, MED302: Developing an SQL Mobile Application with Visual Studio 2005 and SQL Server 2005. The problem happend when I reached Exercise 4: Create a Subscription. After task 1 and 2, I typed http://yunan/sqlmobile/sqlcesa30.dll in IE. But I got " The page cannot be displayed" message and "HTTP 500 Internal server error". I am sure the IIS is running. Is there any other settings I need to do If I continue to create subscription, I will get the following error message. " TITLE: Microsoft SQL Server Management Studio ------------------------------ A call to SQL Server Reconciler failed. Try to resynchronize. HRESULT 0x80004005 (29006) The schema script 'C:\Program Files\Microsof ...Show All

• unahb advanced parameter tutorial, lesson 5, multipart identifier error

  Hello, Hope I'm asking this question in the correct forum. I'm a newbie in Reporting Services and currently working my way through the tutorials with AdventureWorks. Came across this error while doing the MSDN tutorial for Advanced Features, lesson 5 - user defined functions. http://msdn2.microsoft.com/en-us/library/aa337435.aspx Created a new report, copied the following to the query screen: SELECT udf.ContactID, udf.FirstName + N' ' + udf.LastName AS Name, c.Phone, c.EmailAddress, udf.JobTitle, udf.ContactType FROM ufnGetContactInformation(@ContactID) udf JOIN Person.Contact c ON ufn.ContactID = c.ContactID I'm following the directions to the letter, and consistently get the following error: "The multi-part i ...Show All

• Eddie Garcia How can i prevent that all data can be seen with notepad?

  Hello, is there a way to say to SQL Server to make the data not readable Regards Markus hi Markus, I will obviously answer for me and not for Microsoft, so all considerations are IMVHO... and... not to flame, but just considerations... SQLExpress is not for Desktop Environment.. quoting from http://www.microsoft.com/sql/editions/express/default.mspx , "SQL Server 2005 Express Edition is the next version of MSDE and is a free, easy-to-use, lightweight, and embeddable version of SQL Server 2005. Free to download, free to redistribute, free to embed, and easy for new developers to use immediately, SQL Server Express Edition includes powerful features such as SQL Server 2005 ...Show All

• AArben Using Index Tuning Wizard for Stored Procedure

  Dear all, I tried to use Index Tuning Wizard for SQL 2000 DB to tune stored procedure but it does not capture any query inside stored procedure. I captured workload using built-in SQLProfilerTSQL_SPs.tdf which includes RPC:Starting, SP:Completed, SP:Starting, SP:StmtStarting and SQL:BatchStarting Events. Is it a correct option for SQL Profiler Do I miss some options in index tuning wizard How can I do it Best regards, CJira ...Show All

• Kamii47 Calendar Control issues

  Hi all, When I click on a calendar control for date parameters the page will freeze or throw a java script error. This does not happen all the time, and is not isolated to one PC. It happens randomly on several PCs. Is there any known issue with this control regards, Bill Just to clarify, we are aware of the issue with the script errors and how to fix it. In order to be fixed in a QFE, a customer will need to contact CSS and request the fix, otherwise look for the fix in a future release. If your are hindered by this issue, your best course of action is to contact Customer Support and request a fix. IE7 is only in beta 3 mode, I believe the issues with IE7 and RS will be resolved but there ...Show All

• YorickPeterse Can anyone explain this processing schedule

  Hi, I have a fairly complicated cube which has: 74 Measure groups Each measure group contains 12 partitions = 888 partitions in my cube I have a parameterized XMLA processing script that processes 2 partitions in each measure group - i.e. 148 partitions. It does this inside a <Parallel></Parallel> element. When I executed the XMLA script I recorded the progress in Profiler. I saw that, prior to processing the 148 paritions, there was lots and lots of "Progress Report End" EventClass records with a message of: Finished processing the ' <partition name> ' partition There were actually 518 of these records so whatever it is doing, it is not doing it for every single partition. Note th ...Show All

• lum1nos1ty Is Replication for Me? Help in understanding...

  I have a situation where I need to distribute a db to 'subscribers' for use during network, and preferred application downtime. Currently, we do this by employing MS-Access. We update our db on the 'subscriber' by sending a text file with the new data using FTP. When the 'subscriber' opens their local copy of the Access db application, a macro fires off to check for any new file in the ftproot folder, and if one is detect that is newer than the last update, it truncates the existing table, and imports the text file using a predefined import specification format. The process works well enough as is. However, we were hoping to move beyond our dependency on MS-Access for a variety of reasons, so we are looking at developing windows forms ...Show All

• shyma Bug in UPDATE statement and 1 : n cardinality ?

  The problem is in one-to-many cardinality and UPDATE statement : ( SQL server 2005 developer edition ) create table #table1( id int, firstCol int) insert #table1 values ( 1,0) insert #table1 values ( 2,0) go create table #table2( id int, secondCol int) insert #table2 values ( 1,10) insert #table2 values ( 1,20) insert #table2 values ( 1,30) insert #table2 values ( 3,100) go ----------------------------------------------------------------------------- 1. shape UPDATE update #table1 set firstCol = firstCol +( select secondCol from #table2 where #table1.id = #table2.id ) return error message : Msg 512, Level 16, State 1, Line 1 Subquery returned more than 1 value. This is not permitted when the subquery follows =, ...Show All

• deviprisoner Lookups and their error flows

  So I have three lookups in a row in my data flow. Basically they are doing data quality checks for me using a reference table. I want to be able to take the error flows of the three lookups and merge them together (union all) so that I can insert the "errors" (or non matches) into a table. Can't do it. Because SSIS deems non-matches as "errors" you automatically get the errorCode and errorColumn fields. When you try to union a lookup error output with another lookup's error output, you can't do it. What I would like to see is a lookup act more like a conditional statment where you have three outputs of a lookup table: match found, no match found, and error. Either that, or I'd like to be able to edit the names of the errorCode and errorCol ...Show All

• Oleksiy How to detect Backward Compatibility pack if it's already installed using C#?

  We have our custom install code using C# for a huge Client desktop application. We package SQL Express 2005 along with Backward Compatibility pack as this application was using MSDE before and at 11th hour management decided to pack SQL Express and backward compatibility pack. During installation we want to detect if the Backward compatibility pack is already installed to avoid overwrite. Can anyone suggest how to detect if Backward compatibility pack is already installed using C# I am sure there should be some registery keys to look for but don't know which. Thanks. Look up the SERVERPROPERTY() topc in Books Online - You'll probably find it in one of the values it returns. ...Show All