Skip to Content

Export Transaction Data in a Flat File

Hi Experts,

I am trying to export Transaction Data using standard Data Manager Package.

Data manager Package : Export Transaction Data To a File.

I am trying to export this data year wise. Hence for all other dimension member i select as "ALL" and in TIME i select period 01 to Period 12. And exporting as "Sign Data" option.

Attached is the transformation file i am using to export transaction data into flat file. But after executing Package i am getting attached error.

export-transaction-data.jpg data-manager-package-log.jpg

Can you please help me what went wrong and why data is not getting exported to flat file. Kindly advise.

Parag

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Mar 30, 2017 at 08:09 AM

    When you export Signed Data you have to select only base members for all dimensions!

    Test for base members only!

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 30, 2017 at 08:51 AM

    Thanks Vadim for your quick response. After some time i did exported transaction data again using "Members Only" option and this time package ran successfully but with "WARNING" Status. But data got exported into file.

    As per your advise if i need to select "Base members Only" option then i think i need to select all the dimension members with "Base member only" option and not "All" option from drop down.

    Let me have a try with this option. Thanks again.

    Parag

    Add comment
    10|10000 characters needed characters exceeded