cancel
Showing results for 
Search instead for 
Did you mean: 

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

axel_
Participant
0 Kudos
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

Accepted Solutions (0)

Answers (2)

Answers (2)

axel_
Participant
0 Kudos

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 Kudos

Nobody...?