One dimension has two groups of level attributes

[Jose Ramirez]

My dimension has two groups of level attributes, for example:

line of production  (line)

sub line of production (subline)

category of product (category)

sub category of product (subcategory)

which is the best way to structure my dimension, in the documentation does not explain this case.

simple product table

---------------------------

sku

line

subline

category

subcategory

price

stock

Thank you

[José Juan Montes]

Your line of production would be a dimension with a hierarchy consisting of two levels.

Your products would possibly be a dimension with one hierarchy of three levels (product cat / product sub / product), or you can keep your product itself as a separate single dimension.

Cubes does not support dimension "roles" (also called dimension "alias") and does not support nesting dimensions. Therefore you need to separate that dimension in two and use both of them in each fact (this is "flattening" your dimensions on top of your fact).

I hope that helps.

Jose Juan Montes

--
You received this message because you are subscribed to the Google Groups "Cubes" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cubes-discus...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.