Hierarchy in Webi Report

building reports webintelligence
1

Hi all!

i have an issue with the display of a hierarchy in my webi report.

The report have a crosstab who contain the hierarchy in the vertical axis and month in the horizontal axis and obviously a ratio in the body.

I create an input control to filter the month.

The first time the hierarchy work perfect because show the first level of the hierarchy (with the capability to navigate to the 2nd and more levels).

the problem occurs when i filter the report (selecting another month in the input control). The hierarchy expand automatically all the levels…

how i can fix this?, i only need the first level allways (and the option to navigate thru the other levels).

Thx for your help!!

(PD: sorry for my english)

Lannce (BOB member since 2013-01-22)

2

Is it possible that there was no data for the filtered month, for the level that you drilled to?

andy.v :belgium: (BOB member since 2008-12-19)

3

yes it´s possible but my test was allways in month who have data for all the levels of the hierarchy.

I will try to explain in a better way my problem

  1. When i open the table with the hierarchy for first time, the hierarchy its close (and that’s is fine!)

Hierarchy Data 1 Data 2
+1st_Node XXXX XXXX
+2nd_Node XXXX XXXX
+3er_Node XXXX XXXX

  1. When i UPDATE an Input Control in the report (like month, Tipe_of_Report, Local, etc) the hierarchy expand automatically, and that behaviour it’s my problem…

Hierarchy Data 1 Data 2
-1st_Node XXXX XXXX
son1_node XXXX XXXX
son2_node XXXX XXXX
-2nd_Node XXXX XXXX
son1_node XXXX XXXX
-3er_Node XXXX XXXX
son1_node XXXX XXXX

I hope this description help to find an answer to my question…

thx for your help!

Lannce (BOB member since 2013-01-22)