1

Topic: SSAS to Measure time of request MDX

Good afternoon all.
Read https://blog.crossjoin.co.uk/2017/08/25 … -function/

WITH MEMBER MEASURES.TEST AS
[Measures]. [Internet Sales Amount]
,BACK_COLOR =
IIF ([Measures]. [Internet Sales Amount]> 3000,
255
, 0 - null - 255*255*255 - null
)
SELECT {[Customer]. [Country]. [Country].MEMBERS} ON 0;
NON EMPTY
[Date]. [Date]. [Date].MEMBERS
*
[Product]. [Product]. [Product].MEMBERS
ON 1
FROM
[Adventure Works]
WHERE (MEASURES.TEST)
CELL PROPERTIES VALUE, FORMATTED_VALUE, BACK_COLOR

it goes up to 6.5 seconds on a warm SE cache.
I think I will look how many at myself -  and I do not know as
Googled
? 1)  to include - yes there it is visible, but whether it is possible then to trust (in sense an overhead charge  are insignificant)
? 2) mdx studio -
Yes shows - Time: 2 sec 421 ms
But the request why that hangs up for half-minutes and even more (though then and shows result)
3) to include OlapQueryLog
on each request (QueryLogSampling =1) on localhost
Also I do not understand as it to use
Select * from aa. OlapQueryLog
order by starttime desc
duration shows 0 - though at me in SSMS explicitly  longer  3-5 precisely (m.  long??)

2

Re: SSAS to Measure time of request MDX

Feodor;
Once for a long time read on the foreign Internet on this question of measurement of duration MDX of request.
The abstract such that precisely do not count, since duration fixes only some part (I do not remember what)