Authorization load taking long time

[gauthamchilled]

Hi,

I've implemented a complex authorization logic provided by Basics for complex authorization‌

I have five fields used in authorization load for section access and it is taking long time to  reload the dashboard.

Load Distinct * Where Exists([~AUTH KEY]);

Load Year,

'<ANY>' & '|' & '<ANY>' & '|' & '<ANY>' & '|' & '<ANY>' & '|' & '<ANY>' as [~AUTH KEY] ,

Country & '|' & Office & '|' & Region & '|' & Department & '|' &  Category as [AUTH KEY]

resident Fact;

I have 32 load statements like above with different key combinations.

Please help is there any way to sort out the long reload time to shorter? Thanks

Gautham

[Siva_Sankar · Accepted solution]

If you are not changing the section access file everyday, then there is no need to create Auth key everyday. You could try creating fresh Auth keys only when the new user is added or section access file is changed. Create a condition to check something like

Load  Date(filetime()) as ModifiedDate

FROM

SectionAccess.Xlsx;

Let vActualDate =Today();

Let VLastModifiedDate = peek ( 'ModifiedDate', 0 , ' tmp ');

if  $(VLastModifiedDate)=$(vActualDate)  Then

Full Reload to create keys

Else

Load from QVDs.

Hope it helps.

Regards,

Siva

[gauthamchilled]

It worked. Thanks.