Hello everyone,
In universe (BO 3.1),
Is there any way to turn objects (dimensions) to measures by one time?
i have many objects (100+) which are measures actually.
and making measure 1 by 1 is very long operation
thank you
hadalar 
(BOB member since 2006-06-21)
100 measures? Wow - that’s a lot. Are they really all measures that you want to aggregate?
No way I know of to change in one go. How would Bobj know what aggregation you wanted for each? Or projection function?
Debbie
Debbie 
(BOB member since 2005-03-01)
Unfortunately yes, 10+ tables, each has 20-30 needed measure objects
actually i need aggregation function sum for all
i really would love to see such feature in universe: selecting multiple objects, choosing aggregation function, and turning them to measure by one click
hadalar (BOB member since 2006-06-21)
100 isn’t a lot, especially in a larger universe.
There isn’t a fast way barring cutting the sum( and pasting it at the start of each in a repetitive keystroke way. It’s easier to keep the object definition box open, so from when you double click the first object to invoke the box::
1/ Make sure Sum( is in your clipboard (type it in notepad, select and copy it)
2/ Click on the end of the SQL string
3/ Press )
4/ Press the Home key
5/ Press CTRL+V
6/ Click on the next object and then click yes on apply changes
Repeat steps 2-6 until done.
Boring but straightforward enough
my final measure objects count is over 1000
Actually i am doing this Mark, but this is also not efficient because of apply changes popup, but no chance other
little bit more efficent way is pasting “sum(” to all objects and, then pasting “)” to all objects.
since pressing home key on notebooks (using with Fn key) is difficult if you are pressing more than 1000 times
hadalar (BOB member since 2006-06-21)
Hi,
You could achieve this using Designer’s SDK but that would require some coding in VBA.
Marek Chladny 
(BOB member since 2003-11-27)
I’ familiar with VBA coding, but never used Designer’s SDK.
any help is valuable
hadalar (BOB member since 2006-06-21)
A good starting point is checking this utility in the BOB’s Download section:
It’s used for mass updating names and descriptions of universe objects. You would need to modify it for mass updating object definitions and qualifications.
Good luck!
Marek Chladny (BOB member since 2003-11-27)
i’ll check
thank you
hadalar (BOB member since 2006-06-21)
I achieved by universe sdk
thank you for everyone
hadalar (BOB member since 2006-06-21)