Datasource Views and Teradata

SQL Server Analysis Services

Index ‹ SQL Server

- Previous
  - 1
    - Deployment problem Help Hello all experts, I have tried to deploy my cube using an XML Script in dev box, modify connecting string by changing server name, run in QA box, and process cube, but always failed. Error massage: ‘Process failed. Trace information is still being transferred. If you do not want to wait for all of the information to arrive press Stop.’ Any one had experience for this error Thanks in advance. Tag: Datasource Views and Teradata
  - 2
    - Reporting Services printer problem I have a windows NT service, which prints to a laser printer programmatically using MSRS 2K. It works fine with a HP printer however when I try printing to a Lexmark Printer it does not always print. Somebody help. Microsoft please release a latest patch for MSRS 2K, its been so long since we had one. Tag: Datasource Views and Teradata
  - 3
    - Month/Year comparison against a date I don't think that is exactly 'right'. (I did make the assumption that the OP wanted ONLY JULY 2007 dates.) Follow this code: Code Snippet DECLARE @StartDate datetime, @EndDate datetime SELECT @StartDate = '06/7/2007', @EndDate = '7/15/2007' -- Arnie's Variation -- Starting at midnight, 7/1/2007, Ending at midnight, 8/1/2007 SELECT 'Arnie', dateadd( month, datediff( month, 0, @StartDate ) + 1, 0 ), dateadd( month, datediff( month, 0, @EndDate ) + 1, 0 ) -- Mandip's Variation -- Starting at midnight, 5/31/2007, ending at midnight, 8/1/2007 SELECT 'Mandip', dateadd( month, datediff( month, 0, @StartDate ) , -1 ), dateadd( month, datediff( month, 0, @EndDate ) + 1,0 ) -- OP Requested -- the sp needs to select all records that come -- after 6/30/2006 and on or before 7/31/2007 ----- ------------------------- ------------------------ Arnie 2007-07-01 00:00:00.000 2007-08-01 00:00:00.000 ------ ------------------------ ------------------------ Mandip 2007-05-31 00:00:00.000 2007-08-01 00:00:00.000 Tag: Datasource Views and Teradata
  - 4
    - VB6 RDO error Did you try naming the owner of the procedure as a prefix of the procedure It is recommended to always qualify the procedure / objects with their whole name including the schema / owner name. Jens K. Suessmeyer --- http://www.sqlserver2005.de --- Tag: Datasource Views and Teradata
  - 5
    - Transaction Question When I run the following in Query Analyzer: SET QUOTED_IDENTIFIER OFF -- allows double quotes (") used as wrapper for dynamic sql. DECLARE @E int BEGIN TRAN T1 PRINT 'Start...' EXEC ( " begin tran T2| raiserror( ' inside proc', 16, 11) PRINT STR(@@ERROR) rollback tran T2 PRINT STR(@@ERROR) return " ) SET @E = @@ERROR IF @E <> 0 BEGIN PRINT 'Error ' + LTRIM ( STR ( @E )) + ' out of here...' ROLLBACK TRAN T1 RETURN END PRINT 'Done.' COMMIT TRAN T1 I get the following output and error: Start... Msg 50000, Level 16, State 11, Line 3 inside proc 50000 Msg 6401, Level 16, State 1, Line 5 Cannot roll back T2. No transaction or savepoint of that name was found. 6401 Msg 266, Level 16, State 2, Line 7 Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 2. Error 266 out of here... Anyone have an idea why I would get the 6401 and 266 error JD Waleska, GA MSBassSingerNO-SPAM@alltel.NO-SPAMnet (just remove the string NO-SPAM) Tag: Datasource Views and Teradata
  - 6
    - Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4 Hi, I have installed " SQL Server 2000 SP 4" to SQL server and it is running fine. But when i install the " SQL Server CE version 2.0 Update for use with IIS and SQL Server 2000 SP4 ", i get below error: "SQL Server CE Tool is compatible only with SQL Server 2000 Service pack 1 and higher. When you install SQL Server CE Server Tools on a computer running both IIS and SQL Server 2000 , ensure the installer for SQL Server CE Server Tools corresponds To the version of SQL Server 2000." I have go thougth few articles in the forum, try to open the sqlce20sql2ksp4.exe file and then run only the MSI, but still fail. By the way, i found that the sqlce20sql2ksp4.exe does not include any MSI, it is a direct executable file. Appreciate if anyone tell me the solution. Thanks in advance. Best regards, Plane. Tag: Datasource Views and Teradata
  - 7
    - Integrating SSRS with report viewer In your web project Add reporting web service reference Use ListChildren mothed to get all reports Use GetReportLink mothed to get report link Pass link to reportviewer. You can find the details about these two mothed from MSDN Tag: Datasource Views and Teradata
  - 8
    - successful implementation of dataware house and data mining hi all i want an article on a company or organization that has successfully implemented dataware house and data mining, and by its help they have been able to increase their business or sale etc etc help will really be appreciated Tag: Datasource Views and Teradata
  - 9
    - Aggregation wizard Thanks for the response, I did a refresh and then a new count and this did not update the counts. I tried deleting all of the counts in the wizard and the recount gave the correct counts but when procedding in the wizard, the % imporovement was zero when it reached the max partition size. With the prvious record counts, I had a 21% improvement with a smaller partition. Any thoughts Steve Tag: Datasource Views and Teradata
  - 10
    - USING SSIS for scheduled import StartMenu > ControlPainel > AdministrativeTools > Services Helped regards! Tag: Datasource Views and Teradata
  - 11
    - Monitor network resources used by single database Hi, Is there any methord to monitor network utilization per database on single instance of SQLServer2005 or SQLServer2000. Please help Regards Mohd Sufian Tag: Datasource Views and Teradata
  - 12
    - Drop database on a different SQL Server. As far as I know, in this case, you have to recreate the sproc on target server. Tag: Datasource Views and Teradata
  - 13
    - replicating UDT's to subscribers I am not sure if this will solve your problem but you can try re-initializing your subscription before regenerating a new snapshot. -Raymond Tag: Datasource Views and Teradata
  - 14
    - XQUERY / XPATH versus nodes containing ":"-character Hi, all. I'm having problems using XPATH / XQUERY versus input containing ":" in the node names. Example: Code Snippet <MyData:Output xmlns:MyData=" www.myprovider .com"> <MyData:Provider> <MyData:Property MyData:Name="FirstName">Joe</MyData:Property> </MyData:Provider> </MyData:Output> T-SQL (breaks): Code Snippet SELECT XMLContents.query('/MyData:Output/MyData:Provider') FROM dbo.Some_Table __________________________________________________________ XQuery [dbo.Some_Table.XMLContents.query()]: The name "MyData" does not denote a namespace. However, if I remove all the "MyData:" references from code and data, it works fine. I don't have an option of getting the incoming data changed; is there a way to escape the character to get this code to work Tag: Datasource Views and Teradata
  - 15
    - SQL Server vs. XML Configurations You aren't by chance defining a SQL Server connection (in the package configuration) for the very connection that you need to get to the package configuration table, are you Tag: Datasource Views and Teradata
  - 16
    - converting to numeric (6,3) Hey guys, I am trying to achive the following: Truncate the values 1680.390000000000000000 to numeric (6,3) All works ok until i hit a value over 1000, (as above) The code i was using is: cos1 = 1680.390000000000000000000 CONVERT (NUMERIC(6 , 3), ROUND(COS1, 3)) I have tried a few others, but nothing seems to work.. I get the following error. "Arithmatic Overflow" Has anyone got any suggestions Thanks guys, Scotty Tag: Datasource Views and Teradata
- Next
  - 1
    - Understanding code created by SSIS import/export Wizard Why can you not change these things in SSIS Designer (i.e. BIDS) -Jamie Tag: Datasource Views and Teradata
  - 2
    - SQL Server 2005 Service Pack 2 - RTM - WHEN??? Hi, Does anybody know how many CTPs will be provided before the RTM will be delivered Thanks Tag: Datasource Views and Teradata
  - 3
    - Parameterized Queries Just getting started using SSce and having a few problems What I want to do is something like this... Dim Code As Integer Dim Description As String = txtDescription.Text.Trim Dim conn As SqlCeConnection = ConnectToLocalDatabase() Dim ssql As New System.Text.StringBuilder ssql.AppendLine( "INSERT INTO T_Titles (Description)" ) ssql.AppendLine( "VALUES(@Description)" ) ssql.AppendLine( "SELECT @Code = @@IDENTITY" ) Dim cmd As New SqlCeCommand(ssql.ToString, conn) Dim sqlCode As New SqlCeParameter( "@Code" , 0) sqlCode.Direction = ParameterDirection.InputOutput cmd.Parameters.Add(sqlCode) cmd.Parameters.Add( New SqlCeParameter( "@Description" , Description)) cmd.ExecuteNonQuery() Code = CInt (sqlCode.Value) ********************************************************************** The above code doesnt work. Firstly I am not sure if I can execute the two statements in one go. Secondly, I am not sure if output parameters are supported. I have been working with SQL Server since 6.5 but have always used sprocs and am feeling a little lost here without them. Any help getting started would be greatly appreciated. Thanks Tag: Datasource Views and Teradata
  - 4
    - Users and Roles script In 2005, is there a way to automate this I'd like to be able to do this automatically periodically: 1) Script out the development users and their roles in my development database 2) Backup the production database and restore the it to the development database 3) Re-synch the existing users (sp_change_users_login), drop any obsolete users (sp_dropuser), and add any development users with roles back on Does anyone have a script that can help me achieve this Tag: Datasource Views and Teradata
  - 5
    - how to extract this text? I have options_field contains a lot of data.. here are examples: DT·NB·NM·ANI=80088080 39139662 ANI=80088080 36637576 ·DNIS=80088080·DT·NB·NM·UNIT ANI=80088080 39188390 ·ANI=8008808017403125·DNIS=80088080·DT·NB·NM·UNIT ANI=80088080 39653135 ·ALIAS·DNIS=80088080·DT·NB·NM·UNIT ALIAS·ANI=80088080 39169467 ·ANI=8008808017326875·UNIT·NM·NB·DT·DNIS=80088080 DT·NB·NM·DNIS=80088080·ANI=80088080 36331200 ·ANI=80088080 39318646 I want to extract every 39 and 36 mobile numbers in the ANI. All numbers are 8digits as highlighted ad some records will have more than mobile number while some won't have any mobile number listed. so the result should be 39139662 36637576 39188390 39653135 39169467 36331200 - 39318646 Tag: Datasource Views and Teradata
  - 6
    - Differences in varchar size usage, declaring the maximum available of 8000 characters SQL Server does not really allocate space based on the datatype definition in your table. It allocates enough space to hold the data (so if you have 10 chars, it only allocates space for 10 chars). After the data is in memory, one of the checks we do is check the length of the data against the defined length. If the size of the data is bigger, we raise an error. Internally, SQL Server uses several algorithms to avoid too many memory allocations (sometimes it allocates more than needed if it finds out that a lot of string concatenation is being done). The defined size of a variable does not really play a big role here. Are you using SQL Server 2000 or SQL Server 2005 If you use SQL Server 2005, you can use the varchar(max) datatype, which will hold data up to 2GB, and you never really have to worry about the size. SQL Server will do the right thing for you. Only when your data gets bigger than 8K, you might get a small perf hit when using varchar(max) as it won't fit on a single page anymore, but if you have a lot of data that is smaller than 8K, you might as well use varchar(max) as internally in the engine varchar(N) and varchar(max) are treated very simular as long as the data is less than 8K. Hope this helps, Marcel van der Holst [MSFT] Tag: Datasource Views and Teradata
  - 7
    - Daylight Saving Time DST 2007 Problems so, instead of a 5 hour difference between the two you should see a 4 hour difference Tag: Datasource Views and Teradata
  - 8
    - end conversation : security context could not be retrieved HI I was reading the other thread about no security header and check the time in the enqueue time, which was ahead of the server time the last enqueue_time on the target was 2007-04-13 22:27:16 but when I did a select getdate() I get 2007-04-13 20:24:03 how can the enqueue time be in the future thanks Paul Tag: Datasource Views and Teradata
  - 9
    - Unicode causes Dimension build failure? The SQL Server is using Collation SQL_Latin1_General_CP1_CI_AS The Analysis Server is set to Latin1_General, with Accent-Sensitive enabled. These appear to be the same, are these considered the same Tag: Datasource Views and Teradata
  - 10
    - Change member properties order in excel 2007 pivot table Hi everyone, i am trying to change the member properties order in a excel 2007 pivot table but it wont work... I've found how i should do it according to Microsoft Office web site ( http://office.microsoft.com/en-us/excel/HA101777521033.aspx , see : Display member properties as data in a PivotTable report ) but even if i follow the instruction by the letter it is not working... I've searched a lot but i can't find anything on this... Anybody's having the same issues or know a way around it I'm using SSAS 2005 SP2 and Excel 2007 Thank you very much! Tag: Datasource Views and Teradata
  - 11
    - SQL Server 2005 Limitation: Having many attributes for Neural Network No, I only care the attributes with value 1 on each row. For example: Jack = Attr1, Attr3, Attr100000 Sam = Attr2, Attr3 Mary = Attr1, Attr2, Attr100000 Customer Attr1 Attr2 Attr3 ..... Atr100000 ============================== Jack 1 0 1 ..... 1 Sam 0 1 1 ...... 0 Mary 1 1 0 ...... 1 To give a better idea of my problem. Here is the scenario. Say that I have a set words to describe each customer's characteristics. Customer Friendly Tall Rich ..... Good Looking =================================== Jack 1 0 1 ..... 1 Sam 0 1 1 ...... 0 Mary 1 1 0 ...... 1 Jack = Friendly, Rich, Good Looking Sam = Tall, Rich Mary = Friendly, Tall, Good Looking I also have 100,000 attributes (Friendly, Tall, Rich, ...., Good Looking). Each attribute can only have 1 or 0 value. Say that I have 1 million rows. In some cases, the same customer may appear more than once in the table. For example: Simon 0 1 1 ...... 0 Simon 1 0 1 ...... 0 I only care the attributes with the value of 1. Later, I want to use Neural Network to find the customers who are friendly and rich. What the best way to implement such idea in Neural Network Please assist! Regards, Mary Tag: Datasource Views and Teradata
  - 12
    - readonly custom property HuangBo wrote: I need to generate the value for a custom property internally and make it visible to developers, but I don't want them to modify it to ensure the data flow works correctly. Hope we'll have a way to do that in the future. Couldn't you override SetComponentProperty to reject the change Tag: Datasource Views and Teradata
  - 13
    - Label in parameter Hello! Is it possible to create a row of "labels" in a multi-value parameter list i mean something like this: Name, Age JJ, 12 PP, 10 Thanks //C Tag: Datasource Views and Teradata
  - 14
    - SSIS performance If you are running the package using "dtexecui" or "visual studio" then you might want to try running it using "dtexec". for example run this command from the command line: dtexec /reporting EW /file Package1.dtsx Tag: Datasource Views and Teradata
  - 15
    - - DeWayne, Thanks for your help. I have other question: While am s etting up SQLMail to use SQLMail profile and then set SQL Server Agent mail to use SQLAgentMail profile. Receiving the following error. Error 22022 QLServerAgentError: Unable to get the default MAPI Address Book due to MAPI error 271: An error occurred while attempting to open the Window Address Book. Please specify a default mail delivery location in you profile. If I try to create MAPI profile IBM Lotus Domino Access for Microsoft Outlook - create - new profile through getting the below error. Failed to create new MAPI profile. Error creating personal Folders service Note: This error can be caused by an incorrect configuration of out look 2000. If you are using outlook 2000, Please verify that is running in Corporate/Workgroup Mode. Setup encountered an error and failed to create a MAPI profile. You will need to reinstall IBM Lotus Domino Access for Microsoft Outlook (Already we removed and reinstalled) Any help please Ven Tag: Datasource Views and Teradata
  - 16
    - Problem in Configuring ASPState DB for .NET 2.0 Hi, I got this problem resolved by running the aspnet_regsql.exe with command line options to setup the ASPState DB. Anyways, Thanks for the suggestion. Thanks, Siva Tag: Datasource Views and Teradata

ceg2

I'm trying to to use SSAS 05 w/ our Teradata warehouse (VERSION 05.01.02.70 RELEASE V2R.05.01.02.40) and I'm having a problem creating datasource views.

My issue is that the wizard returns every view and table in the warehouse (tens of thousands) which takes over 10 minutes . I can't seem to limit it to only the database I'm intersted in using. I've tried using the restrict schema option but then no objects are returned. Any ideas on how to do this Can you create the datasource views without the wizard

Thanks.

Top