I am using the following MDX query on Adventure Works DW sample
database.
The issue is that SSAS is returning the result that is not fully
sorted in descending order even if I am enforcing break hierarchy with

I realise this is a very general question, but after hours of Googling I am
none the wiser.
I think I want to use SSAS, because I have views and queries in T-SQL that
take too long to run every time a user runs them from a web site. The data

I would like to add another measure into cube which is counting distinct
employee_id instead of employee_key (surrogate key)
This is the relationship I have in cube
Fact_employee_time: Fact_time_key, Employee_key, Date_Key, .... hours, cost,..

I’m working with MDX functions. I would like to calculate the sum from
the first month in my Time dimension till current month.
e.g Jan 2007 till current month

can anyone point me to a routine or util that populates a time_dim table?
Given a date range, routine creates all rows for each day in range...
tia,
Chris

This is not a question of a degenerate dimension, I have that implemented and
it works fine.
I have a cube with three fact tables.  each fact represents a different
level of our business and is related to a lower level.

I am trying to establish Replication wherein my Publisher would be SQL Server
2000 SP3 and the Subscriber / Distributor is SQL Server 2008
I understand there is no option to "Allow initialization from Backup Files"
on the Publisher (SQL Server 2000) like SQL Server version 2005 ...

Good morning,
I have a new application I'm building, and the users want to be able to do
some analysis of the data managed by the application.  Because of the high
transactional volume involved, I know I'm going to need two separate sets of

Our company is expanding into Europe and we need to get some sample
databases so we can learn the input methods.
We mainly need to learn how European addresses and Telephone numbers are
formatted?  We will be storing the following in a MS-Access / SQL server