Export member formula result to flat file

[former_member276034]

Hi to all,

I try to export datas from one of our cubes (Data manager export to flat file) and I want to export some members formula results but the export does not work.

Is there a method to export the result of members formulas on the transformation file or is it possible to make a formula on the conversion file maybe ?

Many thanks for your help.

Stéphane

[former_member186338 · Accepted solution]

"but the export does not work" - what do you mean? My system don't work, please help me?

In the standard Export transaction data to file advanced script you may change SELECTINPUT to SELECT to be able to select members with member formula. Also use measure PERIODIC, YTD,... and not SIGNEDDATA!

[former_member276034]

Hi Vadim,

When I said that did not work, that is because I have no data for those accounts.

I tried with Periodic instead of SIGNEDDATA and it works perfectly, many thanks for your help one more time.

I never export member formulas before that attempt but is this only for member formulas that we do use measures ?

Thanks

Stéphane

[former_member186338]

"is this only for member formulas that we do use measures" - not only! Also to export parent nodes (with SIGNEDDATA only base members are exported)!