Hi,
I hav created a nee Class with about 100 objects by dragging an “imported” mView into the Class/Object Window in my Universe Designer.
I now need to change about 80 of those columns into a “measure”. I do not want to do this one by one. Any chance for markining them all and set them all to “measure” at once?
Why does the Designer not support such an action?! Or am I just to blind to see how this is to be done?
Mostly when you’re creating a measure object you are including some sort of aggregation, e.g. sum() or count(). In this case you would want to change the objects individually as you have to consider how they should aggregate. I can’t think of any way to change multiple object properties at the same time.
I agree. Designer could definitely do with some improvements when it comes to usability. I was surprised to find out that you could change the format of a group of objects, but that’s about as far as it goes.
Apparently Designer gets a major overhaul in the next release. Let’s cross our fingers and hope for the best.
Each of your objects is defined as object_column, and you want it to be a measure that SUM(object_column)? Even if you could change all 80 to measures in one fell swoop, the SELECT portion of each object would not get the SUM() function added any way.
Unless I’m doing something quick-and-dirty for playing, I never drag a table nor object over and get objects automatically created. I create each and every object – giving it a meaningful name for the user, setting its SELECT clause, entering its HELP description, setting its type and projection, etc., manually.
You might have a look at this utility. It uses the Designer SDK to make mass updates to object names and descriptions. It could (probably) be adapted to work with any property.