Analytics Software

Hi All,

I've run into a mental block while building my BMM layer. I am wondering if OBIEE is able to handle semi-additive measures? For example, say a company has to maintain a number of equipments. Each equipment is assessed and given a health score irregularly throughout the year. Therefore, for reporting purpose, I would not want to sum up the scores throughout the period. Rather, I'd like to report only the latest score for each equipment at any given point of time.

I know that I probably have to use the aggregation "last" against the time dimension in some way. But I cannot seem to get it to work correctly. In the BMM layer, I set the measure's aggregation rule to be based on my Time dimension and use "last", and for Others, I use "sum". However, when I run a simple query in Answers, the measure becomes empty.

Does anyone have any suggestions?

Thanks a lot for any input.