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