You can create a macro for your own use or grant execution authorization to others. For example, your macro might enable a user in another department to perform operations on the data in Vantage. When executing the macro, the user need not be aware of the database access, the tables affected, or even the results.