TM1 Forum

Posted: **Thu May 28, 2015 2:44 pm**

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

Posted: **Thu May 28, 2015 8:38 pm**

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.

Posted: **Fri May 29, 2015 10:32 am**

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

TM1 Forum

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

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

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

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