Hello gurus,
based on a data action I´d like to derive a dimension member based on dimension members of other 3 dimensions. How is this possible?
Let me give you an example:
I have 4 dimensions: profit center,Revenue type,Revenue detail, and revenue driver
Each profit center has its own revenue type.
Each revenue type can have multiple revenue detail, For example a new license as revenue type can be for car,truck,bikes ...
Each revenue detail can have multiple revenue driver, For example a car or truck or bike all of them can have revenue driver like seat belt.
How this can be achieved, any model structure enhancement I can do.

Thank you.