Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Automation of adding new measures into model

Status
Not open for further replies.

Kaiaualad

Technical User
Jun 15, 2001
70
AU
Is it possible to automate the adding of new measures appearing in an existing datasource into a model?
How would a macro pick up a new column and add it as a new measure? I have not seen any scripting yet that has done this and am wondering if it has been done before.
 
You would have to create a script to open up an .imr file, that saves as a .iqd, and then the .iqd file has to do a "modify columns" (to add the new column to the model), then the .mdl saved, then run the .mdl to get the .mdc. I know the language is in the help files somewhere, and you can probably put it together with that information. good luck.

CP [cook]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top