Optimizations

[Karim_Haddadi]

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() 
))

[vinieme12]

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

[Karim_Haddadi]

Thanks