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
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