BO Universe using Macros

Hi Gurus,

Can we create a BO universe in UDT based on teradata macros. We are having some performance issue with our WebI reports due to huge volume of data so we have decided to move to macros where all the calculations will happen at the database level. We will have to just call the macros for the requested inputs and when the user will run the report, he/she will be able to see the data for that input.

This is a self service model so I would also like to know how do we call the macro every time the user has different inputs. Business users will not do that. Can anyone give me some idea please?

Thanks