One dimension has two groups of level attributes

10 views
Skip to first unread message

Jose Ramirez

unread,
Sep 20, 2018, 12:25:36 PM9/20/18
to Cubes
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

unread,
Dec 23, 2018, 8:44:19 AM12/23/18
to cubes-...@googlegroups.com

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.
Reply all
Reply to author
Forward
0 new messages