cancel
Showing results for 
Search instead for 
Did you mean: 

Filter not working in chart in SAP analytic for cloud

abhimanyu_sharma
Contributor

Hi Experts,

I have created a story in SAP Analytics on cloud on consumption view (2CCFIGLLINEITEMQ0001) . i have created a chart and set 'Amount in company code currency' in measures. But i want to see amount for specific GL account. Hence, I have added filters in the chart on GL but here is the issue. GL account is hierarchy and when i am applying filter on parent node or root node or leaf node , the chart is not considering it in filteration. But when I applyimg filter on GL in flat presentation, the filter works. I need to apply filters on more than 100 GL accounts hence selecting each GL in filters is time consuming. Instead , if i apply filters on hierarchy node it will be lot easier. Could you please help on this and provide solution so that filter on hierarchy node works in Analytic for cloud story.

JohnL
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi abhimanyu

Were you able to get around this?

Have you considered using property type filter? Your account dimension would need to have some properties in it that you could filter on.

Do you have any screenshots of what you are seeing?

Accepted Solutions (0)

Answers (2)

Answers (2)

IngoH
Advisor
Advisor

Hi,

here the screenshots of an example using BW with a hierarchy.

Screen 01 shows the chart with the hierarchy drill down on world.

Screen 2 shows the filter with hierarchy as part of the dimension in the chart definition panel.

Screen 3 shows an input control providing the list of hierarchies and the option to choose a hierarchy and a hierarchy node / leaf

Regards

Ingo Hilgefort

screen01.jpg

screen02.jpg

screen03.jpg

abhimanyu_sharma
Contributor
0 Kudos

Hi Igno,

Yes, I am able to see the option to choose a hierarchy and hierarchy node/leaf in my story. But when I am applying filter on say Hierarchy - Country Hierarchy 3, the data is not getting filtered based on it. It is still showing full data.

But if I select filter on countries in Country Hiearchy 3 in flat representation, The data is getting filtered out.

This is the issue I am facing.

Thanks,

Abhimanyu Sharma.

IngoH
Advisor
Advisor
0 Kudos

then I would suggest you open a case with the support team and they can look into it in more details.

Regards

Ingo

IngoH
Advisor
Advisor
0 Kudos

HI,

did you setup the filter on just the visualization or the page or the story ?

Regards

Ingo Hilgefort, SAP

abhimanyu_sharma
Contributor
0 Kudos

I have applied filter on the chart.

I have dragged the Numeric chart in the page and applying filter on it.

IngoH
Advisor
Advisor
0 Kudos

so then the filter will only be applied to the chart. Take a look at the option to create page / story based filter.

Then the filter is applied to the page or the story and not just the one chart.

Are you receiving the hierarchical view of the filter ?

Regards

Ingo

abhimanyu_sharma
Contributor
0 Kudos
Hi Ingo,

I have clearly mentioned that filter is applied on the chart only. But issue is when I am adding filter on GL account using hierarchical view , the filter values doesn't work but if I apply filter using Flat presentation, the filter works.

Under one hierarchy we can have 100+ GL Accounts hence it is not possible to filter on each value in chart (using flat presentation). It is way easier to apply filter on hierarchy for which the data should be displayed in the chart.

Could you please provide me solution or reason why the tool is not considering Hierarchy filter in SAP Analytics for cloud?