Re: 800 Dimensions... Too many?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

My interpretation of the question on attributes was: can you group the
dimensions together into larger entities?

For example, if your 800 dimensions look a lot like:
[Flag1], [Flag2], [IsDeleted], [IsAvailable], etc.
Then can you combine all these types of attributes into somehow logical
groups and create a dimension that has a large composite key attribute and
lots of related attributes with the actual flags?

Can you give a summary of what your 800 dimensions look like?

Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Bob H." <BobH@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:434D5089-8955-4136-94CB-5336D55971DF@xxxxxxxxxxxxxxxx
Would attributes be more efficient than dimensions? I've got this up and
running, but the response time is slow (60 seconds to display results).

Visual Studio (2005 - 32-bit Visual Studio on the dual Opteron x64 system)
could not deploy the cube (system out of memory!). I had to write scripts
and
run them through xmla query windows in Management Studio.

Thanks!
--
Bob Hodgman


"Jéjé" wrote:

you are right... 800 is really huge!!!

does it's really dimensions or attributes?
how the system performs?

your problems come from the end user access, this a lot of metadata to
play
with.


"Bob H." <BobH@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CE84563F-3528-4504-827A-FDB9EAB163B1@xxxxxxxxxxxxxxxx
...on one cube?

I'm developing in SSAS 2005 running on dual core dual Opteron 64 bit
machine.

I know. It sounds like a lot of dimensions. But sometimes the world is
really complex and your cubes get complex, too.

Anyone have any experience with this? Anyone have any advice on this.

--
Bob Hodgman





.

Relevant Pages

  • Re: 800 Dimensions... Too many?
    ... The 800 dimensions represent questions on a questionaire. ... The purpose of the cube is to allow a group of analysts to find out how many ... Bob Hodgman ... Please do not send email directly to this alias. ...
    (microsoft.public.sqlserver.olap)
  • Re: 800 Dimensions... Too many?
    ... a sample of your dimensions can help us. ... what is this cube? ... Please do not send email directly to this alias. ... Bob Hodgman ...
    (microsoft.public.sqlserver.olap)
  • Re: Memory Error(quota estimate) -when processing AS2005 cube
    ... Try processing the dimensions separately. ... Please do not send email directly to this alias. ... issue fixed recently where the quota estimation for deep parent/child ... Memory error: The operation cannot be completed because the memory ...
    (microsoft.public.sqlserver.olap)
  • Re: 800 Dimensions... Too many?
    ... using separated tables for the dimensions is a first step. ... this reduce the size of the cube and provides a better process performance. ... I would recommend building the dimensions from real dimension ... Please do not send email directly to this alias. ...
    (microsoft.public.sqlserver.olap)
  • Re: 800 Dimensions... Too many?
    ... My dimensions are all separate tables ... and my keys are all integers. ... this reduce the size of the cube and provides a better process performance. ... Please do not send email directly to this alias. ...
    (microsoft.public.sqlserver.olap)