Defining display order in "Current Selection Box"

    Purpose

    The purpose is to be able to define the order in wich the selected dimensions will be displayed in the "Current Selection Box".

     

    Steps

    1. Start your load script with a "Load Inline" with the list of dimensions, in the order that you want in "Current Selection Box". 

      • CurrentSelectionBox_Order:
        LOAD * INLINE [
            Currency, Country, State

        ];

    2. Drop this temporary table at the end of your script

      • DROP Table CurrentSelectionBox_Order;


    Summary

    By default, selected dimensions are displayed in load order. With this tips, you define  dimensions' load order, before loading data