Hi,
Whether can we write macro to create objects?
If yes, how to create some standard measure objects (like, avg, stddev, etc…) for some of the columns in Fact table.
ravik (BOB member since 2004-06-02)
This post might be of use to you.
HTH
shamit (BOB member since 2004-07-01)
Shamit is correct. That utility changes object names and desriptions, but can be adapted to change select statements, qualifications (dimension, measure, detail), and so forth.
This is actually the topic of one of my presentations at User Conference this year … Automate Universe Maintenance with the Designer SDK.
Dwayne Hoffpauir 
(BOB member since 2002-09-19)
Hi Dwayne,
It is good macro.
However my requirement is that I want to create Classes and Objects. I want to generate objects such as standard aggregate functions (5 functions fixed) over all/select columns in fact table. we have over 100 fact tables.
ravik (BOB member since 2004-06-02)
Well, that utility certainly doesn’t create new objects, sorry. It certainly can be done, but I dont’ have any examples to share.
Dwayne Hoffpauir (BOB member since 2002-09-19)