I have a measure type dimension with 1 - 5 types. I want to calculate sum of measures with type of 3 and 4. So I will have 6 types. And I want to show sum of measures on column, and 6 types on rows. how can do this? Thanks, Guangming...more >>

Tab1 and Tab2 has the following info.ID column in Tab1 and Tab2 has matching values. Tab3 should have the info as below. Tab1 ------ ID Val1 Val2 1 qqq sa 2 aaa fa 3 ddd we Tab2 ------- ID F1 1 A 1 B 1 C 1 ...more >>

Hi, what is most important to focus on when we choose a drive setup to support a small datawarehouse? (10GB and less) IO/Sec or MB/s ? (same question regarding the tempdb database storage) except the SQLIO and SQLIOStress, there is any testing tool which simulate DW loading process...more >>

Hi, I set up drillthrough action in my cube in MS SQL 2000 AS and it's working fine when I explore the cube with the cube browser in AS, but when I try to invoke the drillthrough action in MS Excel 2003 I get an message the there are no details to be displayed - it failes. Does anyone know w...more >>

Hi , What is the difference I create a view from TableA with 3 fields and I select 3 fields from TableA ? Let's assume TableA have 20 field attach to it Will it increase the performance when I select from view ? -- Travis Tan...more >>

This is my first post here, hopefully you folks can help me. I have the typical Invoice Header and Invoice Detail Fact Tables. I’ve read that you should declare a clustered index on all of the foreign dimension keys in a fact table (for SQL Server). However, that wouldn’t be unique as a custome...more >>

Hi All, What is datawarehouse? Is there any good website related to learning from the beginning of datawarehouse? Is datawarehouse in Oracle and SQL server different? I am good in SQL Server and Oracle Programming and willing to go for datawarehouse. Please suggest? I have decided to ...more >>

In this post I am going to try to simply a question that I posted earlier. Can I use VFP to access a SQL Database? If so what is the command? What is the best software for creating applications to work with SQL? I am just getting my feet wet with SQL so please take it easy on a rookie. ...more >>

Hey All, Please have a quick read and add your opinions. I work in the insurance industry. In our datawarehouse there's a policy header table and a policy transaction header. The description of each policy number is in the form 'ABC/XYZ/1234567' My problem is the header table holds this v...more >>

I have a data warehouse that imports all of the required profile, transactions, logs, etc. on a daily basis and has been running fine. The other night, I started to receive the following errors during the web log import. My package logging shows: Step 'DTSStep_CS_DTSLogImps.DTSLogImport...more >>

Hi , What is the diffence I create 1 file on the same disk under 1 file group and multiple files on same disk under 1 file group ? -- Travis Tan...more >>

Hi , I already create clustered and non clustered index in order to improve the reports performance. But after I test several times on my reports , the processing time almost the same as before I index the table. Any other method to increase the performance ? Can I index the "view" I ...more >>

Hi , I have created 3 fields in for my table , FieldA , B and C all asc order. What is the diff if I perform the query like : A) Select * From TableA Where FieldA = 'A' And FieldB = 'B' And FieldC = 'C' B) Select * From TableA Where FieldC = 'C' And FieldB = 'B' An...more >>

Hi, there is anything to do to improve the DBCC indexdefrag command? currently I defrag my indexes after every datawarehouse load. (only if I have 10% of fragmentation or more) but the process is long, this takes 35minutes. I'm using 4 SCSI disks in Raid 5 most of my indexes are unique c...more >>

Howdy - - I have to keep time series on large amounts of numeric data (millions of rows). I had the idea of storing these data as int and converting to decimal in views; this way, my numeric columns shrink down to four bytes from 9 bytes. Would the performance gained be an improvement...more >>

What tools (companies) have you found to work well with your Data Warehouse, easy to use by non-developers and also interface with MS Reporting Services? -- JBH1...more >>

Hi , If I create several views from the transaction table for reporting purpose. Do the view occupy the disk space as well ? -- Travis Tan...more >>

What is the different between calcualted member and calculated cells? Is there any guildeline in using calculated member and calculated cells?...more >>

So let's say i manage to construct a warehouse. And let's pretend i can conjure a system to constantly bring in new data from the "live" system. How do the computer illiterate end-users perform their own querying of my warehouse? i can't image any canned software exists - since that softwa...more >>

Hi, We use SQL2000 starschemas with "innerjoin" between dim-tables och a facttable. select distinct country_descr, product_descr, sum(qty),sum(amount) from facts_order,dim_product,dim_dates,dim_country where dim_dates.month=... Our facttable has appr 4000' rows, dim_prod 10', dim_dates 1...more >>

I'm thinking I may have worked with a data warehouse before, but how can I be sure? I am applying for jobs that ask for an understanding of multiple data warehouses but the definition for data warehouse to me is unclear since i'm not sure if i've seen one (or worked with one). Would it be th...more >>

Hello, I am going to be a bit cheeky here and ask for some information on Analyst Services and the like that I have been asked to answer. Unfortunatly I do not posess the knowledge to do most of this so I was wondering if someone out there did, or could forward me a web site that could. Anywa...more >>

Recently we have migrated the datawarehouse server to windows 2003 server from windows 2000 server. Since then all dts packages are getting timedout with the following error. Step Error Source: Microsoft OLE DB Provider for SQL Server Step Error Description:Timeout expired Step Error code: 8...more >>

I have a Product dimension on which I expect about 90 attributes mainly they are related to classifying the material. Can somebody please share ideas how I can implement such a large set of dimension attributes any other alternatives you can think off. Sometimes the attrbutes can be dynami...more >>

Hi , I am creating a report for user from our live database , if user are quering on my reports and some of the user are insert or updating on the live database , will the table lock from any insert or updations ? Any solutions of that if the db do lock the table .. TQ -- Travis Tan...more >>