Hi I have created a package to do this which simply returns with the erro '1 task(s) failed during execution'. I can process the dimensions an cubes manually in analysis Manager fine. SQL and analysis Manager are both on the same server and the tas appears to be running with the domain a...more >>

I’m starting to look at using a data warehouse and would like to have some tracking of the queries ran against the data warehouse. I’ve gone through several articles about the MS Access database msmdqlog.mdb and I’m just looking for ways to implement the auditing and I have a few ques...more >>

I am a former DBA that has moved into a totally new role and environment, as a data architect on an enterprise data warehousing project for the national statistics office. I've started reading the Kimball Data Warehouse Toolkit (2nd Edition) and now have a feel for the approach that I'd like to...more >>

Hallo NG, I have some complicated database with many relational tables and one root table (i.e. has no FK) What I need to do is to copy a row inside the root table then copy all child rows and change references in them to refer to the copied row in the root table, and then copy the...more >>

We have a large DW running on a server with 4GB memory, and mostly reponse is fine. However when we make a query which has several dimensions each of which may have hundreds or more values, then add in a few measures. It will take a long time when we select drill down from the top level tot...more >>

I'm trying to import data into my table and I'm received an error message that I've been able to resolve. The message is: Error Source: Microsoft Transformation Services (DTS) Data Pump Error Description: Data for source column 3 ("column_name") is too large for the specified buffer size. ...more >>

Our SQL Server database is being utilized by many Applix/iHelpdesk forms. On a cloumn with a 'text char(16)' datatype, we recently found 2 <Long Text> errors on a table. The Applix developers said their application was locked up. My DBArtisan can disply only two records. The third row showed...more >>

I inherited a rudimentary data warehouse and would like to gather data on which tables and which indexes are being used. Queries to the warehouse are typically issued via ODBC from an ACC2003 front-end. I have chosen SQL profiler as the tool to identify object usage. I thought ObjectOpened...more >>

Hi, I have to plan a datawarehouse structure where the primary reporting usage is to list detailed information about customers. And also, we have OLAP cube for analysis purpose. I'll have 100 000 customers and a fact table containing between 35 to 45millions of rows by year. (we also have...more >>

We are currently trying to implement a BI solution for a data warehouse, but can't seem to get the last few kinks worked out. I have a cube made by BI that has monthly partitions. The problem is that whenever I add new dimention information (which should be an incremental update), I have to r...more >>

Does anyone use this in their organization? 1. What is the administrative effort? Does it require a lot of setup/support? 2. What is the learning curve like for the users? 3. What products are comparable to this? ...more >>

I installed Analysis Services and then I installed SP3 for SqlServer2k and SP3 for Analysis Services But I am still getting an error when browsing the cube Errors like "Provider not found. not properly installed and then "Unspecified error" and some times "Unable to connect to the registr...more >>

Hi, I've an SQL file which contain accent characters to fill my default values like this: insert into mtytable.... values('Février') and also I create storedprocedures which execute some insert / update command with the same values. The SQL file is correct. I've a batch file (.bat) whic...more >>

When you install the Accelerator it only has the ProClarity Generator. ¿is there any other available? ...more >>

Hi all, Anyone with experience with SAS-datawarehouse. Good or bad? Why? They have a lot of front end tools. /Kent J. ...more >>

What is the best way to set up a datwarehouse? Do I use replication or dts packages or what? What I need to do is archive production data every two weeks to this datawarehouse. Then I will need to be able to query the archive data. What is the best way to do this? And how do I go about doing ...more >>

Hi all I need to be sure a table had not been updated since it was created. Is there a way to extract a log of updates, deletions and inserts commited against a table from sql server?? TIA Rea ...more >>

I'm new to the whole data warehousing business and I'm going through the tutorial and as I get to the end where I process the cube I then try to browse the data and get an error Unable to browse cube. Unspecified Error. From the research I've done this problem was happening in 2002 and 2003 an...more >>

Hi, how can I know or log the volume loaded by my DTS packages? I need to evaluate the traffic and the bandwidth required. Does the profiler can provide enough info? For the moment I work on a copy of the production database. so all is local on my server. Thanks for your help Jerom...more >>

We have a small data warehouse (less than 50 million rows in roughly 75 gigabytes) however, it is growing steadily. We have noticed that we get much better performance on queries when there are no foreign key constraints. We have demonstrated a 14% improvement. I am aware that many data wareh...more >>

I am a semi-experienced DBA, but have some questions regarding the storage of images inside of SQL Server (which I have never done before). I am researching to pros and cons of storing images inside of SQL Server verses a file server and DB combination (storing the file paths in SQL). The...more >>

Hi, Hoping someone out there has some advice on what to me seems like a common database problem. We have a high-throughput 24/7 transactional system that we're looking to mirror to a different physical server, the intent being to redirect our query system which right now hits the OLTP datab...more >>

Hello, I have a analysis services design question I've been struggling with. Let me pose the question in simplified terms and hopefully one of you experts can help me along... We have cetain tools that go out on jobs. These tools can perform one or more services for our customers at the ...more >>

We need to make a choice between using MS AS or Cognos PowerPlay. PowerPlay has a much better interface and some advantages. Can anyone comment on this? Also, does anyone know of good fron-end products to create MS AS cubes rather than using the Microsoft UI? Thanks Alex alexdinu1@hotmail.c...more >>

Hello, Now, I use SQL Server 2000 and Analysis Manager. I have some problem about transaction logs that have been expanded day by day for the database of SQL and Ananlysis Manager. Currently, size of transaction log files are bigger than data files. Please advise me how to clear or ...more >>