Search code examples
schemapentahodimensionworkbench

Pentaho Schema Workbench dimension attributes

I use PSW 3.5.11. I have a classic dimension for people (sex, ethnicity, religion, study level, etc.) and people code.

How can I create this dimension to use each attribute alone and not as a level?

I know how create a dimension with hierarchy, like

geography: Country -> Province - > Region -> City

but Geography dimension not has same structure of People dimension. How analyze my data by sex in a report, by ethnicity in another report? How can I create the People dimension?

Thanks for the help.

Solution

  • You can reference the same table multiple times. Define one dimension gender, pointing to the table and a single level gender given by column gender; set another dimension ethnicity, pointing to the same table and a single level ethnicity given by column ethnicity. Etc.

    If you prefer, you can instead set multiple hierarchies, one for each attribute, all within a single dimension People, but in practice there isn’t much difference (the MDX changes just a bit).