How To Guess That A Cell Represents A Total (or A Subtotal)
Bonjour à tous !
I'm evaluating FastCube
and trying to guess how to recognize a total
(or subtotal) cell.
In the formula editor for a calculated measure,
I did something like the following :
var
n : integer ;
begin
Measures.PrepareDetailInfo ;
n := Measures.RecordCount ;
if ( n = 1 ) then // the cell is "probably" a total if any
end
As expected, it takes a while because of "Measures.PrepareDetailInfo" !!!
Could you please teach me a better solution ?
Thank you.
Joseph
PS. I can read Russian
I'm evaluating FastCube
and trying to guess how to recognize a total
(or subtotal) cell.
In the formula editor for a calculated measure,
I did something like the following :
var
n : integer ;
begin
Measures.PrepareDetailInfo ;
n := Measures.RecordCount ;
if ( n = 1 ) then // the cell is "probably" a total if any
end
As expected, it takes a while because of "Measures.PrepareDetailInfo" !!!
Could you please teach me a better solution ?
Thank you.
Joseph
PS. I can read Russian
Комментарии
Excuse for a delay with the answer.
I will add this property in script in next update.
Now You can test Dimensions.Items[ADimensionIndex].Caption for string 'Total'.
Oleg.
Thank you very much