Choose Index below for a list of all words and phrases defined in this glossary.

Private Dimension

index | Index

Private Dimension - definition(s)

Private Dimension - In Microsoft Analysis Services, a dimension that is restricted in use to one particular cube.

Shared (conformed) dimensions are very useful in creating a unified data warehousing structure. You can create a dimension once and use it in several different cubes.

Private dimensions are useful in those situations where you want independent cubes. If you change a private dimension, that change only affects a single cube, whereas the change of a shared dimensions can have implications for many cubes.

[Category=Data Warehousing ]

Source: SDG Computing Inc., 11 May 2010 09:32:26, SDG Computing, now offline





Data Quality Glossary.  A free resource from GRC Data Intelligence. For comments, questions or feedback: