I’m new to using BO 4.0 and I was just confused about converting a dimension object to a measure. Below is the SQL and it’s an amount. So I have to sum it to aggregate. Also let me knw how to do it if its a count.
@catalog(‘BI_ABC_DEV’).“BI_ABC_V”.“PROJECT_WKLY_MTRC”.“PRJCT_BDGT_AM”
Sowmyaj (BOB member since 2012-02-06)
Hi,
Double click on the Object you want to change…Go to the properties tab…check the Measures radio button…Once you select the Measure radio button…a New selection criteria called Function will come up as a drop down defaulted to Sum.There you can change the aggregation to Max,Count,Min,Avg as you wish as per your requirement.
Hope this address you concern.
Regards,
Sud
sud317 
(BOB member since 2010-08-02)