hai iam having some measure objects in my universe i have a aggregate function as sum in the select box of the designer as
ex:sum(measureobjects)
and now what my problem is i also have a sum function in the object properties will it create any problem if i hav two sum function for the same object in select statement and as well as object properties any one give a guidance iam confussed in this issue
If you are using sum() function for a measure object in universe, the properties tab shows the sum function also which is normal.
And obviously when this object is used in the report SQL it will create a group by clause
You dont have to worry as to why its appearing in two places of object properties