on 06-23-2021 4:03 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Nobody...?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
65 | |
8 | |
7 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.