Cube with 120 dimensions !!

Cube with 120 dimensions !!

Post by Brad Ais » Sun, 06 Feb 2000 04:00:00

> My endeavor to present the business case I face :

> Suppose that I am a salesman of a newspaper company. We have a database
> that has captured most of the customer demographics .... age, income,
> interests in movies, soccer, cars ... say about 40 interests,
> purchasing habits, investing habits etc. ... all those things that you
> normally find on a application/joining form. So its about a 100
> fields.. which I want to convert into dimensions in a cube. "Number of
> customers" would be the measure.

You should consider collecting these attributes together into
dimensions, then populate the dimension with every combination that
appears in the data. The values then become attributes of the dimension,
not measures in the fact table. Try to find the things that correlate
fairly closely, so you don't end up generating N x M x O etc. records.
You don't lose a single bit of data, it is just organized more

This is how demographic and similar data is handled in most warehouses.

--   -- PGP public key available at:

"The paper wall will be next to fall." -- Brad Aisa


1. Count of dimension in cube; levels in dimension

I want to find out all the dimensions in a given cube, and all the
levels in each dimension. I run this query:

with member [Measures].[test] as 'Dimensions(1).uniquename'
        member [Measures].[test1] as
        member [Measures].[test2] as
select  {[Measures].[test], [Measures].[test1], [Measures].[test2]} on
columns from [Warehouse and Sales]

which returns:

[Store] [Store].[(All)] [Store].[Country]

However, I need to know how many Dimensions are in the cube, and how
many levels in each dimension. Otherwise, for example, to get all the
dimensions in
[Warehouse and Sales] I would have to keep doing queries with
Dimensions(n), incrementing n until a query failed. How can I find out
what the highest value of n is?

Thank you.

2. getbuffer command

3. Create a virtual cube from two cubes with different time dimensions(levels)

4. Linking External DB to Access (Follow-up)

5. 120 eval-copy concurrent sessions

6. Problems ADO VB reading secured Access DB

7. 120-day trial to Licensed Release

8. web publishing clobbers paragraphs?

9. 120-day evaluation version

10. SQL2K 120-day Eval & Win XP Home

11. 120 day licence expired.

12. Upgrading from 120-day Eval to Full Version of 6.5

13. How do I upgrade from the 120 day trial version