Optimizations

Karim_Haddadi — Tue, 03 May 2022 14:58:37 GMT

Good day,

I hope you are doing well.

Please advise me on how can I optimize the three below codes?

First:

It's a dimension

If(
aggr(
rank(AuditChecklist_ChecklistTypeDateRank,4,2)
,AuditChecklist_Protocol
, AuditChecklist_ChecklistTypeDateRanking)<7

,aggr(
rank(AuditChecklist_ChecklistTypeDateRank,4,2)
,AuditChecklist_Protocol
, AuditChecklist_ChecklistTypeDateRanking)
)

Second

It's a measure:

if(maxstring([AuditChecklist_Checklist.Compliant])=1,'Y'
,if(maxstring([AuditChecklist_Checklist.NonCompliant])=1 and maxstring(AuditChecklist_HasComment) = 1,'N'
,if(maxstring([AuditChecklist_Checklist.NonCompliant])=1 and maxstring(AuditChecklist_HasComment) = 0,'N*'
,if(maxstring([AuditChecklist_Checklist.NotAnswered])=1,'NA'
))))

Third

It's a dimension

=if(QuestionID=[SsrmStandardsChecklists_Checklist.QuestionID] ,[SsrmStandardsChecklists_Checklist.Question],
If(isnull(QuestionID),
'-', Null()
))

Re: Optimizations

vinieme12 — Tue, 03 May 2022 17:12:53 GMT

You can optimise second and third calculated dimensions by creating them in your load script

First one is basically filtering top 6 , nothing to do there

Re: Optimizations

Karim_Haddadi — Tue, 03 May 2022 17:38:25 GMT

Thanks

topic Re: Optimizations in App Development

Optimizations

Re: Optimizations

Re: Optimizations