calculating/aggregating at display time on calculated field

Raj Rajaram shared this question 2 years ago
Answered

Hi,


I'm trying to aggregate a calculated field at display time without it having to do a group by in the background sql processing in which case the numbers go awry.


In Microstrategy it is being done thru multi-pass sql and internal aggregate functions.


Thanks

Raj

Comments (3)

photo
1

display after sum!

photo
1

Hi Raj,


Can you please give us bit more information about your calculated field.

I have done a quick example with aggregate sum function on the calculated field which is 2 times of cost.

And you can see the total and the aggregate values matches.


Let me know if I am doing it wrong and if this is not the answer for your question.


Regards,


Mahe

photo
1

Hi Mahe,

The problem for me was multiple joins in the background sql because my view data model is quite complex which meant multiple/duplicate rows and since it was grouping by all the attributes in the Select clause the aggregation was totally off.

I was able to solve this problem by creating a virtual table and aggregating the calculated field inside that and display on the report. This worked for me and looks to me that this is the way to go in Yellowfin.

Thanks,

Raj