topic Access Pass Reset Date in Management & Governance

Access Pass Reset Date

jheasley — Tue, 29 May 2018 13:38:01 GMT

I am using the following Master Dimension (created in the license monitor) to determine when my Login Access passes will reset. can anyone (particularly with @Qlik) verify that this is a valid method?

aggr(Only({<Command = {'License user access'},[Access Type]={'Login Access'}>}UsageId), UsageId))

Recovery Date =

Date([Date]+29)

Recovery Count =

Count( Distinct aggr(Only({<Command = {'License user access'},[Access Type]={'Login Access'}>}UsageId), UsageId)))

whether or not my method is correct, why isn't this type of metric part of the current license monitoring application?

Re: Access Pass Reset Date

Levi_Turner — Tue, 29 May 2018 14:51:22 GMT

In principle this approach seems right.

Another reference point: https://www.youtube.com/watch?v=Ua1ylwVIxes

twa‌ : Thoughts on integrating this into the default app?

Re: Access Pass Reset Date

jheasley — Tue, 29 May 2018 14:58:56 GMT

if you're asking if I would mind if you integrated this - i would not mind at all. plus it would have the added benefit of being reviewed by experts prior to release! Thanks for your quick reply, i will watch the video shortly.

Re: Access Pass Reset Date

Tyler_Waterfall — Fri, 01 Jun 2018 16:40:18 GMT

Hi Joe -

Yes you could work it that way.

I played around with it a little last year and tried using Date as the dimension and

num(

Ceil(

sum( aggr( rangesum( above( count({$<Date,[Access Type]={'Login Access'}>} distinct UsageId),0,27) ),Date))

/10

)

+sum({1} 0)

,'#,##0')

as the measure, making sure you sort by date.

The flaw here is that any missing dates get skipped and skew the projection looking forward.

I'm not sure why you nest an aggr() in your measure though.

Why not just add 28 days to Date and count({$<[Access Type]={'Login Access'}>} UsageId) ?