I have a (respected) collegue that seems to be certain that a limitation of
a diminsion is 65,000
rows. I have not been able to confirm this anywhere. Only that the number of
Dimensions per cube

Hi, I have a best question practice about database design.  My idea is to
store business rules information for my customers.  Basically, I define a set
of rules.  For each rule, I know the type.  Then I want to describe the
customers' sets of rules.

I've read through several articles and on-line help, but still can't
visualize what a UDM is. Here are my thoughts. Please bear with me if I sound
like a novice (I am).
Is it the analysis services database in SQL2005?  Is it something else?

I am testing SASS by trying to process a cube while bombarding the
transactional database with new records. The process fails.
It works only when I stop making transactions.
Is there some configuration that enables cube processing while transactions

We have a db with the following schema:
TableA
TableAB (serves as a many-to-many relationship between A and B)
TableB

I have two simple dts pacakges , DTS_Main  and DTS_Sub.
DTS_Sub being called from DTS_Main.
When DTS_Main calls DTS_Sub  getting the following timeout error while
calling the package not while executing.

I am in the process of creating/setting up cubes from an ERP application
(Axapta) across user machines.  In some of the machines I noticed an error
message (which I believe) indicates DSO objects not being installed.
A quick look at SQL BOI gave me details of DSO library.

I'm relatively new to MDX and have what should be a simple problem to
solve.
I have a Hotel dimension and a hierarchial Geography
(Region/Market/SubMarket) dimension.  There's a join between the two on

I could not reach a conclusion on this. Maybe someone helps me to understand
better.
I have a consolidated  text extract from other systems and want to upload
the data to an SQL table.

I got 4 partitions corresponding to four fact tables.
Does it affect cube query performance? most of time, i need to access all
partitions.
If so, how can I combine them into one partition?

RemoteRepositoryConnectionString
A string property that defines a connection to a remote Analysis Services
repository.
RepositoryConnectionString

Given the following:
Dimension Name:          Issues
Measure:                       Issue Count
Dimension Attributes:     Priority (Values 1,2,3,4)

We have a main fact table that contains, for example, individual retail
transactions (e.g. Coke, Sprite, 7up, Milk, Bottled Water... chocolate cake,
steak.... t-shirt, mug, cap).
Each item can belong to several groups (e.g. group: drinks, non-alcholic

I'm working on a project at the moment where have an existing warehouse, and
need to bring in data from new source systems, which are from a similar (but
not quite the same) part of the business. These two parts of the business
merged recently, and they want to have a ...

I am not sure how aggregation works in the cube.
Is there a way to check if this succeds?
Thanks,
GUangming