This is my situation:
organisational structure (realized with treepc) as dimension "organisation units"
- A
-- A/TeamA
-- A/TeamB
- B
(...)
Now there are processes that happen in a defined organisation unit as dimension "processes"
1 => A
2 => A/TeamA
3 => A/TeamB
now my reports should show all organisation units and the processes that happen(d) there.
Dynarange1: Organisation units
Dynarange2: (nested in Dynarange1): Processes for Dynarange1 (uses data filter with organisational unit = Dynarange1 and sum of elements = 1)
Now I get
A
> 1
> 2
> 3
A/TeamA
> 2
A/TeamB
> 3
The output I'd like to have is:
A
> 1
A/TeamA
> 2
A/TeamB
> 3
processes should only appear exactly in the organisation unit where they happened.
Ideas:
(1) a new dimension in the cube that stores organisation structure in just 2 levels:
* All units
** A
** A/TeamA
** A/TeamB
... works but its a little bit crazy and not nice
(2) storing organisation unit as attribute for processes and use attribute filter for dynarange 2 but this is also not really nice..
Are there other ideas from the jedox community? Maybe I do not use the data filter or something else the right way...?
Thanks a lot!
organisational structure (realized with treepc) as dimension "organisation units"
- A
-- A/TeamA
-- A/TeamB
- B
(...)
Now there are processes that happen in a defined organisation unit as dimension "processes"
1 => A
2 => A/TeamA
3 => A/TeamB
now my reports should show all organisation units and the processes that happen(d) there.
Dynarange1: Organisation units
Dynarange2: (nested in Dynarange1): Processes for Dynarange1 (uses data filter with organisational unit = Dynarange1 and sum of elements = 1)
Now I get
A
> 1
> 2
> 3
A/TeamA
> 2
A/TeamB
> 3
The output I'd like to have is:
A
> 1
A/TeamA
> 2
A/TeamB
> 3
processes should only appear exactly in the organisation unit where they happened.
Ideas:
(1) a new dimension in the cube that stores organisation structure in just 2 levels:
* All units
** A
** A/TeamA
** A/TeamB
... works but its a little bit crazy and not nice
(2) storing organisation unit as attribute for processes and use attribute filter for dynarange 2 but this is also not really nice..
Are there other ideas from the jedox community? Maybe I do not use the data filter or something else the right way...?
Thanks a lot!