I'm trying to figure out how I would best model the following situation

I'm trying to model a retailing case which is fairly easy except for
one mind boggling thing (at least for me). I'm having a SKU dimension

i'm New at Datawarehousing and sqlserver 2005, i don't know how can i Design
a Data Warehouse based on an Original Relational Database? dows sql server
2005 have a utility to do this?
tnx

I'm looking for a tool that would help me to build mdx queries and
display the resulting mdx so I can copy/paste it wherever I want.
The Report Server in SQL Server 2005 does have one but for some reasons
it does not allow generation of matrix result within the request.

I have designed a simple Sales cube which has the data of 7 different
companies. The Cube has both sales and cost data.
I want to manage security using Active Directory. I can manage securtiy by
columns for AD accounts, I can hide or show  cost data for based on AD

is cube a Replacement for data warehouse in sql server 2005?

I Have a cube with many measures. One of them use as "Aggregate
Function" the function "Distinct Count". But some records of fact table
has null value in the field of this measure. In SQL Server, when I
execute a "SELECT COUNT (DISTINCT field)" command, it eliminates the

In a calculated member I need to be ale to select the same day of the week a
year ago as opposed to the same date. For example, if the current day is
wednesday of week 50, 2005, I need to get the wednesday of week 50, 2004.
This means that a -1 parallelPeriod is useless.

Alguem sabe como referenciar uma determinada coluna?
Exemplo:
/*    Variavel @xCOD     */
 SET @xCOD = nome da coluna    <<---  Coluna à ser referenciada

SQL 2000 AS.
I have a dimension table 'Periods' example :
1 = Jan 2005
2 = Feb 2005

I need some guideline for designing diemsional model for the situation
given below. Suppose we track individual sales transactions alongwith
different categories of product, areas and employee who made sale.
Sales targets have alreay been assigned to employees for a given time

I am new to SQL Server and need to load the data from Excel Sheet into a SQL
table? Could anyone please help ?
Thanks
Harsh

I struggle with a DW design issue that I hope somebody can provide a
solution for?
I have a traditional Star Schema, and are building an OLP cube on top. The
development is taken place using SQL Server 2005.

I was just going over the new partitioned tables features in SQL2005.
They are very proud of how you can move a partition from one table to
the other and it's just metadata so it happens quickly and
efficiently.

time stamp magicaly updated when ever update event occures on a row
in sql server 2000 i have a table. when i do any update on the table, a
field of the effected rows gets a new time stamp, there  are no triggers on
the table, nothing special in the DDL of the table, is there any ...

Guys I am trying to demoralize the source column in one of my tables so
I can identify the combination of sources that the email was recruited
from.
I know I can do this with a while loop (or cursor) but I would really