use a macro! you won't need Excel, not even design tables. check
Re: Outputting driven dimensions?
In 2003 I have been able to get the design table to update to a driven dimension. Add the dimension to a design table as usual, then set it to driven. Every time you open the design table, the value should update (assuming updates are not blocked). This should be slightly faster than updating them by hand.
GOOD NEWS!!!
Jeremy Krocak of Extreme Design & Programming created a macro for exactly this purpose a while back that was featured in the SolidSolutions Newsletter. It was actually an excel macro that manipulated a SWX model.
Here is the link:
BAD NEWS!!! I can't seem to find the macro available for download anywhere on Jeremy Krocak's site. Maybe you could send him an email requesting that particular macro. I will check at home if I still have it around somewhere.
I remember using it. It works very well and is very easy to use.
Sorry, I could not find the macro (excel file actually) on my home computer either.
If you manage to get hold of it, let me know, I would like to add it to my collection (and hopefully keep it handy).
I got this from Jeremy.
WT
You can download the files at:
Jeremy Krocak
Extreme Design & Programming
612.756.4259 snipped-for-privacy@extremedp.comJoin the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required