SSAS 'dimension definition'

Mr_Shaw
Mr_Shaw used Ask the Experts™
on
In SSAS I have been advised that I need to goto the 'dimension definition', Where is this in BIDS?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
I don't find that the statement conflict with one another, a cube needs a dimension to be called a cube, hence a dimension is a structural attribute of the cube. A dimension is composed of related attributes. Each dimension can be part of a hierarchy.

I believe that you're on to something in that terminology is often confusing for no good reason and mis-leading and if you're not within the field you'll go bonkers trying to understand what people are saying. The author (kimball) mentioned above has a set of rules and methods and examples which standardize things.

As for the definition of dimension, its simply a lookup table.

Author

Commented:
Thanks... U pointed me in the right direction

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial