Skip to Content
0
Sep 01, 2023 at 01:04 PM

Derive members from other dimensions

136 Views

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.

image.png

Thank you.

Attachments

image.png (29.4 kB)