Report with two Dynaranges - hide duplicated items

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • Report with two Dynaranges - hide duplicated items

    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!