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, a user need not be aware of the database being accessed, the tables affected, or even the results.