SAC Table - Filter on Hierarchy node not excluding parent nodes

[ezeugner]

Hi experts,

we are working with tables in SAC based on a query from a SAP BW live data connection.

In this table, we have a characteristic with a hierarchy enabled in our rows and some key figures in the columns.

The issue is, that when applying a filter on a hierarchy node, the parent nodes of that element are still being shown all the way up to the root node of the root node of the hierarchy. From my point of view, this behaviour seems faulty from a usability and a value perspective, as it differs from all the others SAP frontends, that I have in mind.

Please see the following example, which represents the filter behaviour in SAC:

This is the unfiltered hierarchy

This is the result when filtered on Node-H1-B:

I would have expected, that only the Node Node-H1-B and it´s children are shown and NOT the Node Node-H0-Root as well.

This is the result when filtered on Node-H2-BA:

I would have expected, that only the Node Node-H2-BA and it´s children are shown and NOT the Nodes Node-H1-B and Node-H0-Root as well.

This issue appears in the following scenarios:

• When applying story filters
• When applying page filters
• When using a hyperlink with taking the dimension value as a filter in the target

Strangely when selecting the node in the crosstag via right click and selecting "filter", the behaviour is just as expected.

Is this a bug on our tenant, are you experiencing a similar behaviour or do you have a workaround?

This behaviour is especially problematic, when having two characteristics in the row drill down, as the elements of the second characteristic are also shown for the parent nodes. This really causes the crosstable to enlarge in an unwanted manner.

Hope to find a solution or opinion for this from anyone of you.

Kind regards

Eric

[tapas_saha2]

Hi Eric,

I am encountering the exact same issue. Did you find a solution for this issue?

Regards,

Tapas Saha

[Tobias25 · Accepted solution]

For everybody else having this issue. Unfortunately it works as designed:

3399064 - After filtering on child node table displays all parent nodes of the child - SAP for Me

3584513 - SAC table : Wrong behavior when using Input Control filter for hierarchy dimension - SAP f...

But you can vote for an improvement request here:
Improvement Request Details - Customer Influence

[ezeugner · Accepted solution]

Hi Tobias, thanks for gathering these details here. I will mark this as the "solution". Unfortunately we still have to deal with this hierarchy behaviour.

[maqada]

Hello Eric,

We are facing the same issue. Could you tell me if you have solved it, please ?

Thank you for your help.

Regards,

Maria QADA

[ezeugner]

Hi Maria,

sadly I did not find a solution for this.

We had to get used to it and communicate, that it is behaving differently than Analysis for Office.

Kind regards
Eric

[ezeugner]

Hi Steve,

thanks for looking into that and sorry I did not respond earlier, I must have missed the notification.

Are you trying this with a live connection? For my live connection I do not get the advanced filter option.

Kind regards

Eric

[steve_bickerton]

OR filter would be found under Filter icon, then select advanced

[steve_bickerton]

Hi,

I can't reproduce your error. With hierarchy in the rows, and one measure selected, I get what you describe as desired.

Before filter:

After filter:

can you try to add screen shots? or perhaps simplify what you're working on? Maybe there is an OR advanced filter on.