calculating/aggregating at display time on calculated field

Raj Rajaram shared this question 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

Files:

The same question

Replies (3)

Raj Rajaram ●

display after sum!

Files:

Reply URL

Mahesh Thatipamula ●

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

Files:

Reply URL

Raj Rajaram ●

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

Reply URL