cancel
Showing results for 
Search instead for 
Did you mean: 

SAC Analytics Designer getDimensionFilters()/setDimensionFilter() problem with BW hierarchy

06-23-2021 5:03 PM
axel_ Participant
2159 views 2 comments
0 Likes
SAP Managed Tags
Subscribe
Hi Folks,

I got a BW query that uses hierarchy nodes / elements as filter on a dimension.

Dimension members are like this:

7: {dimensionId: "ZDB_STRUK", id: "0HIER_NODE!ERTRAEGE_OHNE_AKT_EIGENL", description: "Erträge ohne aktivierte Eigenleistungen", displayId: "ERTRAEGE_OHNE_AKT_EIGENL"}
8: {dimensionId: "ZDB_STRUK", id: "!UERL", description: "Umsatzerlöse", displayId: "UERL"}
9: {dimensionId: "ZDB_STRUK", id: "!SERTR", description: "Sonstige Erträge", displayId: "SERTR"}


I try now setting the dimension filter to a particular value but no success.

Table_1.getDataSource().setDimensionFilter("ZDBSTRUK", "0HIER_NODE!ERTRAEGE_OHNE_AKT_EIGENL");

So I tried to set a value in the designer panel.

and retrieve it then via

var value = Table_1.getDataSource().getDimensionFilters("ZDBSTRUK");
console.log(value);

to see correct format etc. But the return is empty.

Could it be that analytics designer has problems for hierarchy based filters in BW queries?
Or do I something wrong?

For straight forward value based dimension filtering in BW queries all is working fine.

Any ideas?

Thanks for all replies in advance!

Best regards,

Axel

0 Likes

Accepted Solutions (0)

Answers (2)

Answers (2)

axel_
Participant
0 Likes

Problem was (as usual) in front of the screen....

I copied the wrong fieldname to the set and get method ZDBSTRUK instead of ZDB_STRUK.

When using the correct field name all was working fine.

axel_
Participant
0 Likes

Nobody...?