BusinessObjects Board

What to choose for Measure Object Type

building semantic layer
#1

Hi,

I made several objects to Measure type and BO asking me for the function to use when it used in Aggregation. By default it pointing to Sum. I can make it as it as or should change??

Please suggest me…

Thanks

BOCP (BOB member since 2007-07-02)

#2

Explained in Daves blog, here:-

http://www.dagira.com/2009/07/06/sql-aggregate-versus-universe-projection/

Mak 1 :uk: (BOB member since 2005-01-06)

#3

Thanks Mak for your spont response.

I will come if i find any difficulties…

Thanks

BOCP (BOB member since 2007-07-02)

#4

See also this old post here, please.

Andreas :de: (BOB member since 2002-06-20)

#5

That was the one, I couldn’t remember where it was… 8) .

Mak 1 :uk: (BOB member since 2005-01-06)

#6

Thank you all.

And one more question is please:

for few objects i just have formula like follows:

[M_Obj1]=Tab1.amount-Tab2.amount
[M_Obj2]=Tab1.total * Tab2.total etc…,

I used them in object definition as above. My question is: May i need to insert aggregate functions before those or not?? Like Sum…,

Thanks

BOCP (BOB member since 2007-07-02)

#7

Did you read the links and understand them?

I’ll give you a hint, where do you want the caculation to be performed, for optimum performance, DB or report?

You could also test the results of this, yourself, by running a couple of queries Sum vs No Sum, then compare the times and number of rows retrieved :).

This would also help you validate you universe design.

Mak 1 :uk: (BOB member since 2005-01-06)