OlapExportDataareaFromAnyCube fails

Ralf Zerfass

First of all: Thank you @martin-reischl for providing the useful OLAP-Functions for APE!

Just wanted to use one to export a DAC-Cube (#F_COMP) to a SQL-table using the function OlapExportDataareaFromAnyCube

Unfortunately, couldn't get the job done successfully, it fails with this error:

Message: Exception has been thrown by the target of an invocation.
InnerException:Numeric data area export failed: Calling function 'OLAPExportDataArea' failed with this message: Invalid job data.. Error code '304': Ungültige Jobdaten.

When debugging, I found out that the error appears when calling OLAPExportDataArea:

try
{
//export the data - this will write the data to SQL
OLAPExportDataArea(da, conf);
NotifyDebug("Numeric data exported.");
}
catch (errorMessage, errorCode)
{
RaiseError("Numeric data area export failed: " + errorMessage, errorCode);
}

What looks strange, is the value of the conf-parameter, which looks like this:

{DataConnection=InforBI_Transfer, TargetTable=RIGHTS_F_COMP, ValueColumn=ValueNumber, ValueDimension=, ColumnMapping={F_COMP:{,F_COMP},#__GRP__:{,__GRP__},, ValueMapping={}

Where's the trick to get this export done? Am I doing something wrong?

Version is 2024.12.03

Thanks,

Ralf

martin-reischl

Hi Ralf, 

what does your target table look like, RIGHTS_F_COMP?

EPM won't accept  the # sign in a column name, so the column for the group dimension should be called __GRP__. Ideally, use the statement from the log to create the table:

SELECT 'F_COMP' AS [F_COMP],'#__GRP__' AS [__GRP__],cast(0 as int) AS [DataSourceID], cast(0 as float) AS [ValueNumber]

I just tested this with a permissions cube in the latest version 2025.03, and it works fine. 

Best Regards

Martin