Filters using hierarchy nodes showing additional values

[Former Member]

Hi,

We have built a query which uses structures. One of the structure element is defined so as it fliters the data by restricting the characteristic values for segment. For example, if there is hierarchy for 0Segment as below:

Root

Node 1

Subnode1

Subnode2

Node 2

Subnode3

Subnode4

Subnode5

Subnode6

and we selected the filter values for 0Segment in the structure element as it should display Node 1 and all its leaf's and also should display Subnode4 and its leaf's.

But when we execute the query Subnode3 is also getting displayed in the result which is wrong. Can anyone let me know what would be possible problem and its solution.

Thanks in advance.

Regards,

Ravi Kishore

[Former Member]

Hi,

Can you try in rows 1st put a char 0segment and after that create a structure as per your requirement . hope your may be issue solve.

Regards

sivaraju

[Former Member]

Hi,

Thanks for reply.

My requirement is not to display 0Segment values but to aggregate all the sales for the segment values included in the form of heirarchy nodes and then display as the structure element.

Please advice.

Regards,

Ravi Kishore

[Former Member]

Hi,

For clear understanding below is the hierarchy structure:

Root

-Node1

--Subnode1

--Subnode2

-

---

Subnode3

-

---

Subnode4

-Node2

--Subnode5

--Subnode6

-

---

Subnode7

-

---

Subnode8

I want to display data for Node1 and Subnode6. But when the filters are set on segment characteristic using Node1 and Subnode6, values are getting displayed along with the Subnode5 values which is not actually included in the filter section.

Please advice.

Regards,

Ravi Kishore