The ministery of Education is developing a datawarehouse. As a result they can deliver Ascii files or facttables and dimensiontables. Statistics Netherlands is allowed to make use of their figures. Is it possible to make a full copy of their database or should we ask the ascii file so that we can...more >>

I'm new to dw i'm just confuse with the terms 1. what is a warehouse? Is it just a copy of an OLTP database that has been cleased and transformed is this a SQL server DB and not an AS DB or is it the AS DB thanks -- Jose de Jesus Jr. Mcp,Mcdba Data Architect Sykes Asia (...more >>

Scenario: An incident dimension table has two dates "OpenedDate" and "ClosedDate". I have created an "Incidents" dimension and I want to create 2 measures "Opened Incident Count" and "Closed Incident Count" and then browse the cube displaying both incident counts, slicing with the time d...more >>

I have been searching for a similar Excel Add-in for AS 2005 and am unable to find one. Does anyone have any suggestions for creating an "easy" Excel-based client for our datawarehouse connection? We currently pay for a datawarehousing application and we are trying to replace it with one that ...more >>

Can anyone tell me what the pros/cons are of using blobs in sql? We are looking at scanning certain paperwork and storing it with the appropriate records in our database. The two options are to store the images as blobs or to store them as file system objects with a referral pointer in the ...more >>

Hi, I am calling a stored proc from a DTS package in SQL 2000 using Execute SQL step & when I try to execute it from DTS, I get 'failed on execution', but when I run the stored proc manually, it runs fine, but gives a couple of warnings: Warning: Null value is eliminated by an aggregate or o...more >>

Hi, We need Analysis Service 2005 connect to Teradata directly, but we can¡¦t find the way. There is no odbc driver selection in AS 2005. How can we do that? Thanks Byron Hu ...more >>

Hi, What's the best way to handle data reloads when you have implemented Type 2 slowly changing dimension? For example, you might have an Account dimension, with a status of open or closed. Someone accidentally closes the account, which we then extract and update, creating a new record. ...more >>

Hi, To try to improve my performance on a system where I have no control (a long long story...) My problem: the HD subsystem is "bad", I'm on a SAN and most of my wait types are caused by the disks. I have only 1 disk available (300gb in Raid 5, but I don't know how many disks behind t...more >>

Hi, How can I improve the communication and the data transfert betwee n 2 servers across a 1ghz LAN? I have a data warehouse on a server and my OLAP cubes on a second server. the data transfert never takes more then 5% of the 1gbps bandwidth My SQL query is optimized but I have 3 tables li...more >>

Anyone know of any good AS performance tuning guides on the web?...more >>

Hi again, my second problem is the CXPACKET wait type. during the execution of complex queries when the same table is used multiple times, I have some CXPACKET waits. My server is SQL 2000 Ent. SP4 with 4 proc. (with HT, so windows see 8 processors) my HD subsystem is bad and I can't d...more >>

Hi, I have heavy updates and the most frequent problem is the PAGEIOLATCH_SH wait type. The update is blocked by himself (using the sp_who1, I see the lock) what can I do? there is any hint or option to test? which counter of performance I have to follow? thanks. Jerome. ...more >>

When I use the PivotTable Wizard in Excel 2003 to connect to a SQL 2005 cube, the wizard successfully finds and connects to the cube, but when I click 'finish' to retrieve the data, I get the following error: "Initialization of the data source failed. Check the database server or contact y...more >>

Hi! I use Excel Pivot Tables as OLAP Cube Browser, for cubes which are on an SQL Server Analysis Services Server. This works fine and I'm hapy with it, but some of my cubes contain dimension properties, that only Excel 2003 can show, and my company's unfortunately working with Office 2000,...more >>

What is Datawarehouse and How can we take benefit out from it. ??...more >>