Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Log into Aeros VISION
  2. Select the query to be optimized and click the pencil icon.


         


   3. Verify that tables and columns to be used in query, are selected and added to the columns section. Additional tables and columns can be added after optimization if necessary.


        Image Added


    4. On the top menu bar, select Optimize icon.


       Image Added


    5. In the Entities section, only the tables used within the query should now be displayed. A popup box showing ‘Success – Data Model Optimized’ will be displayed. Click OK.


       Image Added


    6. On the menu bar, click the green Save button in the Data Model menu section to save the optimization.


       Image Added


    7. Click Yes on the Confirm Save popup box that appears.

    8. Click Exit to close the query after saving optimization.

    9. In the Aeros VISION query list box, re-open the optimized query by clicking on the pencil icon to edit.

    10. In the columns section, check to see that all previous joins and table relationships are still intact. If {unrecognized attribute} is showing, click on it. (there may be more than one, so click on each to correct broken relationship)

       Image Added


    11. When you click on { unrecognized attribute}, a list of tables that are part of the Optimized Data Model will be displayed.

    12. Select the correct table and column associated with the unrecognized attribute.


       Image Added


    13. Click on the Red Save button in the Query menu section.


       Image Added


    14. Click Run Query to verify the query works as expected.

    15. Click Exit

    16. In the Aeros VISION main screen, click on Settings on menu bar.

    17. Select Manage Data Models/Connections

       Image Added


    18. Scroll down to the word Model. Here you will see your optimized Data Model listed.

       Image Added


    19. The optimized Data Model can be re-used for additional queries. Keep in mind that ANY CHANGES to the optimized Data Model will affect ALL queries and reports that are referencing this Data Model.