"Bedrock.Cube.Data.Export" does not export all measures

[vladino]

Hi guys,
I'm wondering if anybody has experienced the same strange behavior as I did just few minutes ago...

I'm using Bedrock library and in this case I need to export data for specific version. So I used this:

Code: Select all

      ExecuteProcess('Bedrock.Cube.Data.Export',
        'pCube','plan',
        'pView','',
        'pFilter','version: BU',
        'pDimensionDelim','&',
        'pElementStartDelim',':',
        'pElementDelim','+',
        'pSkipRules',0,
        'pSkipCons',0,
        'pZeroSource',0,
        'pDestroyTempObj',1,
        'pFilePath','',
        'pFileName', 'export_plan_BU.txt',
        'pDebug',0
        );

But one measure is missing completely in the exported file.

TempObj contains also this measure but it's not in the exported file.

How to fix this?

BR
Vladino

[lotsaram]

You might want to
1/ run with pDestroyTempObj=0
2/ run with pDebug=1

Depending on the process bedrock can produce rather a lot of logs with the debug option on but I think you would more than likely get your answer from not destroying the temp view and subsets. Export the view manually in a cma or if it isn't too big open the the cube viewer. Is your missing measure in the view? If not you have your answer.

Note that the bedrock data export sets zero supression on by default (logical since there's no point exporting null values). If your missing measure is rule calculated and is not fed then it won't be exported.

[vladino]

Thanks a lot, this is what I wanted to know.