Skip to Content
1

Filter not working in chart in SAP analytic for cloud

Feb 18 at 01:52 AM

109

avatar image

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.

10 |10000 characters needed characters left characters exceeded

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?

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Ingo Hilgefort
Feb 20 at 04:49 AM
1

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


screen01.jpg (64.5 kB)
screen02.jpg (21.6 kB)
screen03.jpg (39.2 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded

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.

0

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

Regards

Ingo

0
Ingo Hilgefort
Feb 19 at 05:54 AM
0

HI,

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

Regards

Ingo Hilgefort, SAP

Show 3 Share
10 |10000 characters needed characters left characters exceeded

I have applied filter on the chart.

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

0

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

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

0