MDX statement error:"Internal error : no result set"

[former_member718822]

Dear Experts,

we have a requirement to export transaction data to File.

When we execute standard Data Manager package "Export Transaction data to File" package sometimes fails with the error message below:

Task name TRANSACTION DATA SOURCE: MDX statement error:"Internal error : no result set" model: Financial. Package status: ERROR

What we also observed the package fails when we include significant number of members in data range selection screen below (Screenshot 1). In turn, if we break data range into smaller pieces, the package is running successfully. This is of course workaround for us but we would rather have the package working for bigger data ranges given number of data we need to export.

Any idea what could be causing the issue?

Is there a known limit for the number of members in data range input?

out platform details:

• SAP BPC 10.1 NW (standard or classic setup i.e. not embedded)
• SAP_BASIS: 7500013SAPK-75013INSAPBASIS SAP Basis Component
• SAP_ABA: 7500013SAPK-75013INSAPABA Cross-Application Component
• SAP_BW: 7500013SAPK-75013INSAPBW SAP Business Warehouse
• Database System: HDB Release: 2.00.045.00.1575639312

Additionally I am attaching Global / Environment / Model parameter configuration from spro (Screenshot 2-4). We are using a lot of member formulas in our setup (Screenshot 5)

Screenshot 1

Screenshot 2

Screenshot 3

Screenshot 4

Screenshot 5

[former_member186338]

Please provide your transformation file!

[former_member718822]

Hi Vadim,

please see transformation file below.

we do not use any conversion.

Thanks,

Marek