Skip to Content

Issue with Hierarchies in Webi report when trying to display nodes in column level

Hello All,

We're trying to display the Product hierarchies in Webi report -displaying the nodes in columns unlike 'Tree structure' (like below screenshot).

due to the unassigned nodes, when we drag and drop the nodes into reporting area, some orders are missing from the report.

Example - from the below snapshot, when we drag Level 04/05...09 into the report, some orders are disappearing (due to unassigned data), is there any word around for this ?

a8o5z.png (27.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Mar 21 at 03:42 PM

    Here is the solution for Flatten Hierarchical data with Web Intelligence -

    - we have created the variables for each node using ForAll function, and write the below formula for each variable as below - and below highlighted is the unassigned order to the hierarchy , we've measures against to that are displaying as well so there is no issues with the data at all.

    var Level01 = [Material (inc Hierarchy)].[Level 01]ForAll ([Material (inc Hierarchy)].[Level 01])

    var Level02 = [Material (inc Hierarchy)].[Level 02]ForAll ([Material (inc Hierarchy)].[Level 01])

    var Level03 = [Material (inc Hierarchy)].[Level 03]ForAll ([Material (inc Hierarchy)].[Level 01])

    var Level04 = [Material (inc Hierarchy)].[Level 04]ForAll ([Material (inc Hierarchy)].[Level 01])

    var Level05 = [Material (inc Hierarchy)].[Level 05]ForAll ([Material (inc Hierarchy)].[Level 01])

    and so on.. once we created the variables as above just need to drag and drop the field.

    and the count of orders are still the same when we drop Level into the report.

    Thanks you all for your valuable inputs.

    Thanks,

    Teena

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 13 at 10:58 AM

    I haven't tried but you can try to create one more webi query and only materiel hierarchy object.Later merge materiel hierarchy object from both the query and use merge object in the report layout.

    Add comment
    10|10000 characters needed characters exceeded