cancel
Showing results for 
Search instead for 
Did you mean: 

Lumira: GetData fails on hierarchy-aggregated measures

former_member525455
Discoverer
0 Kudos
155

I have a measure with a Dimension with an hierarchy.The higher-level-values are aggregated along that hierarchy. All data on all levels is displayed fine in a crosstab. Now I want to read the values via getData. This works fine on the lowest hierarchy-level but fails for all aggregated values (Error: "No matching data found in selection" and "Could not find member"). How can I get the aggregated values? Lumira version is 2.2 SP0 Patch 3 (Version: 22.0.3).

Accepted Solutions (1)

Accepted Solutions (1)

reiner_hille-doering
Active Contributor
0 Kudos

If the crosstab shows the data, getData can also retrieve it. The tricky thing is to guess the correct member internal key. Hierarchy nodes have a very special syntax, e.g. "HIERARCHY_NODE/0HIER_NODE/EUROPE". Best you use the "Select cell..." feature from content assist of getData API. If it doesn't work, you might need to write a helper app calling CROSSTAB.getSelectedMember or similar to display the correct key.

Answers (1)

Answers (1)

former_member525455
Discoverer
0 Kudos

Thanks, this helped. The Key can be obtained this way and the Syntax is for the internal key is (Simplyfied BNF)

'HIERARCHY_NODE/'<DimensionName>'/'<Key>