Can't load a specific measure from its id in sap bw query using SAP BEX Connector

[igorgois_]

I am extracting some measures from one sap bw query using SAP BEX Connector.

I got all the measures id in sap query designer. It turns out that my load script doesnt work when I add 2 specific measures (see print).

These 2 measures have the same structure from others measures in the same query.

The query has 186 measures and I can load correctly 184 measures. 

I also tried to add only these two measures alone and then tried with a few others measures. Same error

Any clue about that?

Thanks in advance

[igorgois_ · Accepted solution]

Problem solved!

These two child measures were in a collapsed structure parent node. Just need to change the parent structure to expanded.

https://support.qlik.com/articles/000061023

"Collapsed key figure structures: The BEx Connector cannot access key figures or characteristics that are hidden in collapsed structures. As a workaround to this limitation, edit the BEx query in Query Designer and set all nodes to expanded."

[QFabian]

Hi, because of that kind of things, i always separate the loads of the different measures, even using For Cycles to optimized the loads.

greetings