How to Set Default Columns for the Datawarehouse Export and the Flattened Export

How to Set Default Columns for the Datawarehouse Export and the Flattened Export

The Datawarehouse Export and the Flattened Export are both very valuable reports in OrderLogix because they allow you to retrieve data in many different combinations, some of which may not be available from other default reports. These reports allow you to select from several different date filters, item statuses, and product values as well as allowing you to select exactly which columns you would like displayed. 

If your organization utilizes these reports for the same information often, you may wish to set default columns. This will allow you to simply set your desired filters and run the export without having to configure the columns that you require. 


To set default columns, navigate to Company Data-->Company-->System Preferences and click the green edit pencil beside your organization's name to open the Edit System Preferences window. In this window, click on the System/Autoships tab at the top and find the "Edit default warehouse columns" sections toward the bottom of the window, as displayed below:


The top two boxes are for the Datawarehouse Export and the bottom two are for the Flattened Export. Utilize the arrows (->, <-)  or the double arrows (>>, <<) to move column names between the Available box to the left and the Selected box to the right and the up and down arrows to move column names into the order you would like them displayed in the Selected box. Once you have the columns configured the way you would like, click Save on the window to set your changes. 

Please note that these default configurations will be applied to all users in your organization.


If you have any further questions regarding setting default columns for the Datawarehouse and Flattened Exports, please contact OrderLogix Customer Care. Thank you!

    • Related Articles

    • Short Call Duration and Short Abandon Duration default values

        In the OrderLogix editions that include call data, the default Short Call Duration is 15 seconds and the default Short Abandon Duration is 15 seconds as well. This means that any calls answered that are <= 15 seconds will be reported as a short ...
    • Set a Manager Override Code

      If you would like to assign a manager override code to an employee, navigate to the Add/View Employees page in the HR Section of the OrderLogix application. Locate the employee in the list and click the edit pencil beside their name. Once the ...
    • System Preference: Expand Sales Agent Commission by Default

      When agents are viewing their Sales Commissions for a date range, it can become cumbersome for them to expand each order line to review the product specific details. If you wish to have all of the commission lines expanded automatically upon loading ...
    • Export Error: Server error 4: Failure

      You may encounter one of the following errors when attempting to deliver/export a file to an FTP/SFTP/FTPs server: ---------------------------- Job starting... Attempting to send test file Unable to send test file. Server error (4): Failure ...
    • Export delivery via sFTP, FTPS or FTP Failing

      Problems with firewalls and setup are the most common problems with export delivery. OLX v4.0 supports sFTP, FTPs and FTP. Please verify that you have submitted a Firewall Rule request to OrderLogix for the IP address of the FTP site. Please verify ...