Answer Questions

• RayClark096 SSAS attempting to connect to domain server

  I'm developing an SSAS application for a client. Becuase our client is using Novel it has to bedeployed on a stand alone server with clients connecting via HTTP. During testing I noticed that every time the SSAS database is processing the server attempts to login into our domain server. As the account under which it operates does not exists on the domain server (I'm emulating my clients configuration) this rises security alerts on the domain server. The test server attempts to login from a range of ports starting about 2000 and progressively going up during each test. The system administrator is quite upset about it as he gets hundreds of security failures. Initially I thought it was a virus but we scanned the server a few times and ...Show All

• Tryin2Bgood SELECT failed because the following SET options have incorrect settin

  I am getting the following error message: [-E-19:42] Message: SELECT failed because the following SET options have incorrect settings: 'CONCAT_NULL_YIELDS_NULL, ANSI_WARNINGS, ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods. I am using the following set options before the sp is created: SET ARITHABORT ON SET CONCAT_NULL_YIELDS_NULL ON SET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON SET ANSI_PADDING ON SET ANSI_WARNINGS ON SET NUMERIC_ROUNDABORT OFF I looked on the internet and most of solutions were related to indexed views or computed columns. But I am neither u ...Show All

• tonn Tempdb Issues Urgent Help

  Hi, I have an app that changed the tempdb such that now I have 123GB of free space on the tempdb and is filling up my drive. When i use sp_spaceused I get the follwoing name dbsize unallcated space tempdb 123969.12 MB 123866.02 MB 872 KB 320 KB 400 KB 152 KB reserved data index size unused My question is this is production so shrikfile is it an option as i think since it is the space at the end of the file that i need what can I do other than restarign SQL Thanks. Well what are the effects of shrinkng the tempdb. I tried using shrinkfile with truncate only, no turncate only but the size does not reduce to my understanding shrink works if we have a large used portion of data or log file but ...Show All

• shmulik_segal CPU Usage on AS 2005 Server

  I have 5 cubes with 15 dimensions and one cube (like Virtual cube before) with 5 linked cubes. My client is Excel 2003 Pivot table. From Excel/Pivot table if I run a query which is taking long time. I press "Esc" key to cancel my query. However if I look into my Server "CPU Usage" even after canceling my query is very high. Looks it doesn't cancel my query on server. I am the only user using this server. If I restart my Analysis Services 2005 the CPU Usage drops in 90 degrees to almost 0%. Where is the problem any idea Thank you - Ashok Looks like you have a classic case of "runaway query". It is always hard to get to the bottom of who sent the query and wh ...Show All

• Tom Arn Connection error ( from MS Analysis to Applix TM1)

  Hi All, I am trying to connect from MS Analysis Services 2000 to Applix TM1. Applix has got Applix OLE DB MD Prodiver.It is installed on my machine. I create a datasource in MSAS. In Data Link I can see the this Applix OLE DD driver and I choose it. Then I can see Applix login and password screen. Then I logged in. When I test my connection, the connection is succeed. But when I create a cube from data source,it gets an error message as below; Connection teamnb-cem data source failed. Object or provider is not capable of performing requested operation Do you want to retry_ How can I fix it BEst Regards Cem DAGLI Dear Mosha, I am using Applix OLE DB MD Provider. Not Microsoft providers. W ...Show All

• dmouser Configure a Child Package to use the configuration file of a Parent Package?

  Hi guys, Here's the deal. I have a child package, (say, pack01.dtsx), which uses a dtsconfig file for its connection string, which can be called from other packages, but which also can be called by itself. However I also have another package (say, pack02.dtsx) which uses the same dtsconfig file for its connection string. It calls on pack01.dtsx. When I use DTEXECUI and run pack01.dtsx, specifying the proper .dtsconfig file, it goes well. But when I try and run pack02.dtsx, an error occurs saying pack01.dtsx connection cannot be established. How do I pass the connectionstring being used by pack02 to pack01, without having to remove the configuration file setting of pack01 Can a Parent Package configuration and a configuration file try and m ...Show All

• Bidyut Bhattacharjee Missing Data Mining provider in Management Studio Linked Server definition

  I'm trying to define a linked server using Microsoft OLE DB Provider for Data Mining Services. MSDMine data provider is missing. Do you know where I can get this Thanks in advance. I'm have a Xeon 64bit proc. using SP2. And had installed: SQLServer2005_ADOMD_x64.msi, SLQServer2005_ASOLEDB9_x64.msi,SQLServer2005_OLAPDM_x64.msi, and SQLServer2005_XMO_x64.msi. Thanks a lot. The OLEDB provider for Analysis Services 2005 (which should be used for Data Mining) is MSOLAP, not MSDMine. MSDMine is the old AS 2000 provider. Some details on executing queries in SQL, with a linked server, can be found in this article (Executing predictions from the SQL Server relationa ...Show All

• Gmorken SUm Distinct

  Hi people, I love reporting services 2005 BUT have struck a major limitation! Basically I need a sum distinct function. I have various duplicate details lines and just need to sum the unique values. Anyway this is not possible and a number of people a stuck with this. Yes you can write another sql statement using DISTINCT but then how can you easily integrate that into a table with scope you can't! Anyway has anyone been able to achieve this nicely in reporting services I was thinking of calling a distinct SQL statement from an Expression in a text box on a header field and passing another text box as a parameter to get around this limitation. Is this possible Here is a link with similiar problem http://forums.microsoft.com/ ...Show All

• maran.g xblkld4.dll and SSIS....

  I have created a VB.NET solution that includes a dll and a tester. The DLL has a refrence to a wrapped version of xblkld4.dll, which is created with TLBIMP, moved to the GAC with GacUtil and registered with RegAsm. From within the framework of the project everything runs smoothly, but when I try to use the DLL from within an SSIS script task I get the following error... [Void LoadData(System.String, System.String, System.String)] Error: Unable to cast COM object of type 'Interop.XBlkLd4.SQLXMLBulkLoad4Class' to interface type 'Interop.XBlkLd4.ISQLXMLBulkLoad4'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{88465BA7-AEEE-49A1-9499-4416287A0160}' failed due to the following err ...Show All

• WalangAlam Friendly Names of Dimension Attributes for ProClarity UI tool

  Hi, I am creating Cubes, Dimensions and most of all the SSAS objects using AMO. I use the data from a Oracle datawarehouse for this. Finally when the cubes are ready I use a front end tool called ProClarity Web Professional to create reports off it. Proclarity displays the cube data with the dimensions as drop downs in the web page. The problem is that the Dimensions and its attributes display the label and value as "DIM_dimname_ColumName". This is because in SSAS the id is programmatically set as "DIM_DimName_ColumnName", This is a standard in the system and cant be changed. Now I want ProClarity to display friendly names, that I would set in the ssas objects. I am not able to find any property in SSAS where ...Show All

• yanyee How to choose one of two success-paths?

  I have an ActiveX Script Task in SQL Server 2000. It chooses one of two possible success-paths depending on if a file exist or not. (Part of the old ActiveX Script for choosing next step is below) I need to rewrite this for a Script Task in SQL Server 2005 but it seems like it doesn't have this functionality and objects. Does anyone know how to write the code for choosing the next step in a Script Task or knows another way to solve my problem The package is not suppose to fail if the file is missing, it's must succeed and that's why I need two success-paths. Regards, Sara '********************************************************************** ' Visual Basic ActiveX Script '************************************************ ...Show All

• bob the unknown from mars Expression to get the last word of the fields

  Hi, How do i get the last word of a field in an expression Thanks Yes I did try different ways to do it with a combination of FINDSTRING, SUBSTRING and LEN I never used the REVERSE now I will for sure know the different ways how to use it and how powerful it is. Thanks for every one Well, with Perl this would be easy! But for your issue, what defines a "word" How many words are there in the field Is the number of words in a field consistent across all rows What if the field only has one "word" Etc... Show us some data. I am aware of all the string functions available in the expression editor, how would I last wor ...Show All

• Latso Remove the "All" member from OLAP

  In my report, I use a dimension as a parameter. However, I don't allow user to choose the "All" member. How can I filter it out in the report This is what happens when you use the default MDX generated by RS, you will need to tweak it by hand, paying attention to the "on rows" part of the select. As an example, your default MDX for a snapshot dimension might read something like this: WITH MEMBER [Measures].[ParameterCaption] AS '[As At].[Snapshot].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[As At].[Snapshot].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[As At].[Snapshot].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measur ...Show All

• FireFly3k Union All

  When any changes have been made to the underlying table structure, the Union all reports error and does not automatically correct the error. I then have to delete it and recreate it. Is this a bug Arry wrote: When any changes have been made to the underlying table structure, the Union all reports error and does not automatically correct the error. I then have to delete it and recreate it. Is this a bug I'm surprised that an underlying table change would affect this. Have any upstream components in the data-flow changed as a result -Jamie Liran R wrote: Hi Array, I think I know what you mean: I you for example change the data type of a certain column after creating ...Show All

• GRoston The fastest way to stop SQL Server 2000 without admin permissions... (Bug)

    Do You want to stop the SQL Server service without admin permissions Use this Code : CREATE TABLE [dbo].[stop_service] (  [NUMBER] [int] NULL , ) ON [PRIMARY] GO INSERT [dbo].[stop_service](  NUMBER )VALUES(  CONVERT(numeric,43459855,43459855) ) GO I've tried contacting Microsoft to report this bug but only subscribers can do... Don't run the code above in a production environment !! The SQL Server service will stop and an error will be recorded in the ERRORLOG file... Does anybody know how to submit this error Thanks for Your help Umachandar, I don't have control over all statements executed in our servers and I'm sure that there are unnecessary conversions. The main problem here is that ...Show All