We had to manfully correct a couple records in our data mart - but don't
have the luxury of changing the source OLTP tables.
What is the best approach to prevent the ETL to pick this change us as a SCD
entry and move back the data correction to be in line with the source

I've inherited a project which has numerous fields that have extra spaces in
them -- this is causing a problem with data Inserts, Edits, and Deletions in
my .ASP Website.
I'm importing data tables from ACCESS 2003 into SQL Server 2005, and I need

Although I'm familiar with Kimball Group methods for DW modelling, I am now
in search of a more specialized learning resource (preferably a leading book,
but perhaps also a blog or website) that covers dimensional modelling best
practices (in relational engine) into line with the ...

I am new to this area, please be nice to me.
BTW, am I in the right group?
I am very new to SSIS, but tons of experience in SQL programming. I
would like to do an SSIS package, a simple one. can I do it in SSIS

Quick question about modeling a Type 2 SCD.  Assuming I have a dimension
table that resembles this:
DimCustomer
--------------

Is there a way with MDX to discover the hierarchy of a dimension.  In other
words a calendar dimension would have year - quarter - month - week.  I want
to create a MDX query that would return [Calendar].[month] instead of
"January 2007" for a month or [Calendar].[Quarter] ...

We are using Pivot Table object in MS-Excel 2003 to display the reports
using OLAP objects like Cubes. It connects to an OLAP Server and database to
fetch the data.
When we try to refresh data in the pivot table, it internally checks whether

can SQL Server 2005 enterprise of any other version store documents such as
word, acrobat, Excel

I join a datawarehouse project which already run in 2 years.
There is few document left,so I can't see the whole picture of the
project and data movement.
Now I've tried to trace these data movement and keep it in record.

I have a simple cube with one measure group and 3 dimensions (A,B,C).
The cube is deployed and processed sucessfully.
When I browse the cubes with Dimension A and B the measure is showing the
data. But when I start using the third dimension C the measure is showing as

hi all, i was finally excited when i got to process the whole cube without
the errors.
but now im facing another catastrophe!!
when i try to browse the processed cube, dragged the gross revenue measure

I need to replace a single slow view with a faster object that makes
several joins on some 36 tables/views (for reporting). I would like to
create a cube on a seperate server that has this same functionality, but
at the hopes that it improves performance and allows my report writers

We are creating a new environment for our BI DW. This includes servers for
SSIS and one for DW and disks on a SAN. Because of licensing the current
environment uses virtualization.
My question is, what are the drawbacks of using virtualization with MS SQL

I am using MS Analysis Server 2000 to build cubes. To display the result I am
using MS-Excel 2003. In the cube which I have made, I have  enabled the Drill
Through option and selected all fields to drill through in the cube.  I am
able to see the row level data in the data pane ...

We have a SSAS 2005 Cube already created for Sales Executives. As of now, I
can see reports for all of them as an admin. I would like to restrict reports
viewed by a Sharepoint (MOSS 2007) user. Basically I would like to show a
Sales Executive, reports that they are supposed to ...