topic Re: Is a $(vMeasure) more efficient than a simple SUM(Measure)? in App Development

Is a $(vMeasure) more efficient than a simple SUM(Measure)?

julioarriaga — Sat, 16 Nov 2024 07:11:47 GMT

I'm developping a big app that uses several variables as expressions and I stumbled upon this doubt. Is it more efficient to use a variable instead of a simple expression like SUM, without set analysis, for instance?

Re: Is a $(vMeasure) more efficient than a simple SUM(Measure)?

Kalmer — Tue, 27 Nov 2018 18:53:30 GMT

1) If possible i would predefine the measures in a measure table in the LOAD script.
2) I would make a variable that the measure would be selectable (or on details, multiple measures on a straight table or something).
3) If all the measures are on one page and they have much data to calculate or many measures to be calculated (example Dashboard page or something) then i would use another variable within the measure variable so that the script would not load all the measures at the same time, just one of them. It will significantly reduce load time within one page where the measures are being used.

a) It can easily be done now with the NEW QS updated features.
b) Or on older versions with a variable extension
c) Small datalake of measure names which has no connections to other tables. later to use all the definitions of the measures inside the table in a straight table so that it's selectable. IF not selected you can use IF(GetSelectedCount(table name) = 0, DIMENSION1, else DIM2).

If it makes no sense i'll make an example.

Re: Is a $(vMeasure) more efficient than a simple SUM(Measure)?

rwunderlich — Tue, 27 Nov 2018 18:55:32 GMT

There is no significant difference in runtime performance. In theory, the $(vMeasure) has a bit more overhead but I doubt it could be measured.

-Rob