topic Re: Most Efficient Way of Showing Max Available Date Only in a Table in App Development

Most Efficient Way of Showing Max Available Date Only in a Table

Thu, 01 Dec 2016 14:49:11 GMT

I have a rather large table - about 15 dimensions and 10 measures in all, across a few source tables.

I would like to only show data for the latest available Reporting Date dimension, according to the user selections.

Previously I had all 10 measures contain set analysis for the latest date.

However, I wanted to see if there was a more efficient way of doing this?

I tried a calculated dimension, though, I'm unsure if that is much better. It seems to take the same amount of time.

Calc'd dimension I used =

If(Num(REPORTING_DATE)=$(=(max(REPORTING_DATE))), REPORTING_DATE, null)

In a lot of blog posts I've read, they warn against using any calculated dimensions. Though, the same posts warn about over using set analysis.

Re: Most Efficient Way of Showing Max Available Date Only in a Table

thomaslg_wq — Thu, 01 Dec 2016 15:48:13 GMT

Set analysis is the better option.

Maybe you could show us your data model, the number of lines, your final table and the several set analysis expressions, so we could help you improve the overall time response.

Re: Most Efficient Way of Showing Max Available Date Only in a Table

Thu, 01 Dec 2016 16:25:59 GMT

Set analysis like this should do the trick for your metrics...

sum({$<[Date] = {'$(=date(Max([Date])))'}>} <Insert Balance Dimm here> )