KB43617: Attribute elements used for the Image Layout widget are not recognized by the widget in MicroStrategy Web 9.4.1 and above.

SYMPTOM:
A user trying to use the Image Layout widget notices that after creating the warehouse data that would be pulled by the widget, the widget recognizes some of the attribute elements but not all of them, in Strategy Web.
 
In the example below, the World Image map is being used and 4 attribute elements exists in the warehouse, however only 3 of them display.
 

 
STEPS TO REPRODUCE:

• Create an Excel file, with the following columns:
   
  

  Strategy Grandmaster Badges Receive a badge for being recognized as a Strategy Grandmaster. Former Strategy Grandmasters will also be recognized with an alumni badge. Community Influencer Badges Receive a badge for being recognized as a Community Influencer. Former Community Influencers will also be recognized with an alumni badge.     DossBoss Badge  Receive a badge for winning our monthly data visualization challenge, DossBoss. Learn more about the competition here.  MethodDescriptionTypeBottomLevelA bottom level specifies the lowest analysis level that the security filter is applied.IDSSDimtyExpressionSecurity filter.IDSSExpressionInfoThe IDSSObjectInfo interface for the MD security filter.IDSSObjectInfoPopulate ( object as IDSSMDSecurityFilter)Populate this filter's value from an existing MD security filter. RootA shortcut to Expression.Root.IDSSNodeTopLevelA top level specifies the highest analysis level that the security filter is applied without changing the dimensionality of metrics. IDSSDimtyStrategy Function NameSQL PatternABSABS(#0)COSCOS(#0)EXPEXP(#0)LNLN(#0)LOG10LOG(#0)POWERPOWER(#0, #1)ROUNDROUND(#0,0)ROUND2ROUND(#0, #1)SINSIN(#0)SQRTSQRT(#0)MOD((#0) MOD (#1))STDEVSTDDEV_SAMP(#0#< #*#>)VARVAR_SAMP(#0#< #*#>)STDEVPSTDDEV_POP(#0#< #*#>)VARPVAR_POP(#0#< #*#>)SKEWSKEW(#0#< #*#>)KURTOSISKURTOSIS(#0#< #*#>)Strategy Function NameSQL PatternCURRENTDATECURRENT_DATEDAYOFMONTHEXTRACT(DAY FROM #0)DAYOFWEEKTO_NUMBER(TO_CHAR(#0, 'D'))DAYOFYEARTO_NUMBER(TO_CHAR(#0, 'DDD'))WEEKTO_NUMBER(TO_CHAR(#0, 'WW'))MONTHEXTRACT(MONTH FROM #0)QUARTERTO_NUMBER(TO_CHAR(#0, 'Q'))YEAREXTRACT(YEAR FROM #0)CURRENTDATETIMELOCALTIMESTAMPCURRENTTIMELOCALTIMESTAMPHOURTO_NUMBER(TO_CHAR(#0, 'HH24'))MINUTETO_NUMBER(TO_CHAR(#0, 'MI')SECONDTO_NUMBER(TO_CHAR(#0, 'SS'))DATETRUNC(CAST(#0 AS DATE))DAYSBETWEENCAST(#1 AS DATE) - CAST(#0 AS DATE)MONTHSBETWEENFLOOR(MONTHS_BETWEEN(#1, #0))ADDDAYS(#0 + #1 * INTERVAL '1' DAY)ADDMONTHSADD_MONTHS(#0, Cast(#1 as Integer))MONTHSTARTDATETRUNC(ADD_MONTHS((LAST_DAY(#0) + 1), -1))MONTHENDDATETRUNC(LAST_DAY(#0))YEARSTARTDATEADD_MONTHS(TRUNC(#0) - EXTRACT(DAY FROM #0) + 1, 1 - EXTRACT(MONTH FROM #0))YEARENDDATEADD_MONTHS(TRUNC(#0) - EXTRACT(DAY FROM #0), 13 - EXTRACT(MONTH FROM #0))Strategy Function NameColumn NameRUNNINGAVGavg(#0) over(#1)RUNNINGMAXmax(#0) over(#1)RUNNINGMINmin(#0) over(#1)RUNNINGCOUNTcount(#0) over(#1)RUNNINGSUMsum(#0) over(#1)MOVINGAVGavg(#0) over(#1)MOVINGMAXmax(#0) over(#1)MOVINGMINmin(#0) over(#1)MOVINGSUMsum(#0) over(#1)Rank#0#,#<partition by#>#<#, #*#>#|rank over(#1#2#<,#*#> order by #0)COVARIANCECOVAR_POP(#0, #1)CORRELATIONCORR(#0, #1)SLOPEREGR_SLOPE(#0, #1)INTERCEPTREGR_INTERCEPT(#0, #1)BANDINGCase  when  (#0  between  #1  and  #2)  then cast((1.0*(#0- #1)/#3) +1 AS INTEGER) else 0 endBANDINGCCase when (#1=#2  and #0=#1) then #3  when (#0=#2) then #3 when (#0 between #1 and #2) then CAST(1.0*(#0- #1)/(#2- #1)*#3+1 AS INTEGER) else 0 endIF(Case when #0 then #1 else #2 end)RUNNINGSTDEVstddev_samp(#0) over(#1)RUNNINGSTDEVPstddev_pop(#0) over (#1)MOVINGSTDEVstddev_samp(#0) over(#1)MOVINGSTDEVPstddev_pop(#0) over(#1)OLAPSUMsum(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:nOLAPAVGavg(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:yOLAPCOUNTcount(#0#<   #*#>)  over  ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|N:y|R:yOLAPMAXmax(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:yOLAPMINmin(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:yLAGCASE  WHEN  count(*)  OVER  ([#P]  [#O]  rows between unbounded preceding and current row) <= #1 THEN #2 ELSE sum(#0#< #*#>) OVER ([#P][#O]  rows  between  #1  preceding  and  #1 preceding) END" OLAPDBPATTERN="P:o|O:rLEADCASE  WHEN  count(*)  OVER  ([#P]  [#O]  rows between current row and unbounded following)  <= #1 THEN #2 ELSE sum(#0#< #*#>) OVER ([#P] [#O] rows between #1 following and #1 following) END" OLAPDBPATTERN="P:o|O:rOLAPRANKrank() over ([#P] [#O])" OLAPDBPATTERN="P:o|O:rLAGlag(#0#<, #*#>) over ([#P][#O])" OLAPDBPATTERN="P:o|O:rLEADlead(#0#<, #*#>) over ([#P] [#O])" OLAPDBPATTERN="P:o|O:rOLAPRANKrank() over ([#P] [#O])" OLAPDBPATTERN="P:o|O:rMEDIANMEDIAN(#0)FIRST IN RANGEfirst_value(#0) over(#1)LAST IN RANGElast_value(#0) over(#1)Strategy Function NameSQL PatternACOSACOS(#0)ASINASIN(#0)ATANATAN(#0)ATAN2ATAN2(#0,#1)COSHCOSH(#0)SINHSINH(#0)TANTAN(#0)TANHTANH(#0)ACOSHACOSH(#0)ASINHASINH(#0)ATANHATANH(#0)GEOMEANEXP(AVG(LN(#0)))PRODUCT(CASE WHEN SUM(CASE WHEN #0=0 THEN 1 ELSE 0 END) > 0 THEN 0 ELSE (POWER(-1,SUM(CASE WHEN #0<0 THEN 1 END)))*EXP(SUM(LN(ABS(CASE WHEN #0<>0 THEN #0 ELSE NULL END)))) END) CEILINGCEILING(#0)DEGRESS(POWER(ASIN(1),(-1))*#0*90)FLOORFLOOR(#0)RADIANS(ASIN(1)*#0/90)TRUNCTRUNC(#0)Strategy Function NameSQL PatternINTCASE WHEN #0 > 0 THEN TRUNC(#0, 0) ELSE (TRUNC(#0, 0) - 1) ENDINT2(CASE WHEN (#0-CAST(#0 as integer)) >= 0 THEN CAST(#0 as integer) ELSE (CAST(#0 as integer) - 1) END)LOG(LN(#0)/LN(#1))QUOTIENTTRUNC((#0)/(CASE WHEN (#1)=0 THEN NULL ELSE(#1) END), 0)MOVINGCOUNTSUM(#0- #0+1) OVER(#1)MOVINGSTDEV(CASE WHEN SUM(#0 - #0 +1) OVER(#1)=1 THEN 0 ELSE   SQRT((SUM(#0*#0)   OVER(#1)-((SUM(#0) OVER(#1))/(SUM(#0-OVER(#1)*SUM(#0) OVER(#1))))/(SUM(#0- #0+1) OVER(#1)-1)) END)FISHER(LN((1+#0)/(1- #0))/2)INVERSEFISHER((EXP(2*#0)-1)/(EXP(2*#0)+1))PEARSON(((SUM(#0-#0+#1-#1+1)*SUM(#0*#1))-(SUM(#0)*SUM(#1)))/SQRT(((SUM(#0-#1+1)*SUM(#0*#0))-(SUM(#0)*SUM(#0)))*((SUM(#0-#1+1)*SUM(#1*#1))-(SUM(#1)*SUM(#1)))))STANDARDIZEcase when (#2 > 0) then (#0 - #1)/(#2) else NULL endRSQUAREREGR_R2(#0,#1)STEYXSQRT((1/(SUM(#1- #1+#0- #0+1)*(SUM(#1- #1+#0- #0+1)-2)))*((SUM(#1- #1+#0- #0+1)*SUM(#0*#0))- (SUM(#0)*SUM(#0))-((((SUM(#1- #0+1)*SUM(#1*#0))-(SUM(#1)*SUM(#0)))*((SUM(#1-#0+1)*SUM(#1*#0))-(SUM(#1)*SUM(#0))))/((SUM(#1-#0+1)*SUM(#1*#1))-(SUM(#1)*SUM(#1))))))GREATESTGREATEST(#0#<, #*#>)LEASTLEAST(#0#<, #*#>)CountryMetricCanada23Australia10United States50Estonia12	Strategy Grandmaster Badges Receive a badge for being recognized as a Strategy Grandmaster. Former Strategy Grandmasters will also be recognized with an alumni badge. Community Influencer Badges Receive a badge for being recognized as a Community Influencer. Former Community Influencers will also be recognized with an alumni badge.     DossBoss Badge  Receive a badge for winning our monthly data visualization challenge, DossBoss. Learn more about the competition here.  MethodDescriptionTypeBottomLevelA bottom level specifies the lowest analysis level that the security filter is applied.IDSSDimtyExpressionSecurity filter.IDSSExpressionInfoThe IDSSObjectInfo interface for the MD security filter.IDSSObjectInfoPopulate ( object as IDSSMDSecurityFilter)Populate this filter's value from an existing MD security filter. RootA shortcut to Expression.Root.IDSSNodeTopLevelA top level specifies the highest analysis level that the security filter is applied without changing the dimensionality of metrics. IDSSDimtyStrategy Function NameSQL PatternABSABS(#0)COSCOS(#0)EXPEXP(#0)LNLN(#0)LOG10LOG(#0)POWERPOWER(#0, #1)ROUNDROUND(#0,0)ROUND2ROUND(#0, #1)SINSIN(#0)SQRTSQRT(#0)MOD((#0) MOD (#1))STDEVSTDDEV_SAMP(#0#< #*#>)VARVAR_SAMP(#0#< #*#>)STDEVPSTDDEV_POP(#0#< #*#>)VARPVAR_POP(#0#< #*#>)SKEWSKEW(#0#< #*#>)KURTOSISKURTOSIS(#0#< #*#>)Strategy Function NameSQL PatternCURRENTDATECURRENT_DATEDAYOFMONTHEXTRACT(DAY FROM #0)DAYOFWEEKTO_NUMBER(TO_CHAR(#0, 'D'))DAYOFYEARTO_NUMBER(TO_CHAR(#0, 'DDD'))WEEKTO_NUMBER(TO_CHAR(#0, 'WW'))MONTHEXTRACT(MONTH FROM #0)QUARTERTO_NUMBER(TO_CHAR(#0, 'Q'))YEAREXTRACT(YEAR FROM #0)CURRENTDATETIMELOCALTIMESTAMPCURRENTTIMELOCALTIMESTAMPHOURTO_NUMBER(TO_CHAR(#0, 'HH24'))MINUTETO_NUMBER(TO_CHAR(#0, 'MI')SECONDTO_NUMBER(TO_CHAR(#0, 'SS'))DATETRUNC(CAST(#0 AS DATE))DAYSBETWEENCAST(#1 AS DATE) - CAST(#0 AS DATE)MONTHSBETWEENFLOOR(MONTHS_BETWEEN(#1, #0))ADDDAYS(#0 + #1 * INTERVAL '1' DAY)ADDMONTHSADD_MONTHS(#0, Cast(#1 as Integer))MONTHSTARTDATETRUNC(ADD_MONTHS((LAST_DAY(#0) + 1), -1))MONTHENDDATETRUNC(LAST_DAY(#0))YEARSTARTDATEADD_MONTHS(TRUNC(#0) - EXTRACT(DAY FROM #0) + 1, 1 - EXTRACT(MONTH FROM #0))YEARENDDATEADD_MONTHS(TRUNC(#0) - EXTRACT(DAY FROM #0), 13 - EXTRACT(MONTH FROM #0))Strategy Function NameColumn NameRUNNINGAVGavg(#0) over(#1)RUNNINGMAXmax(#0) over(#1)RUNNINGMINmin(#0) over(#1)RUNNINGCOUNTcount(#0) over(#1)RUNNINGSUMsum(#0) over(#1)MOVINGAVGavg(#0) over(#1)MOVINGMAXmax(#0) over(#1)MOVINGMINmin(#0) over(#1)MOVINGSUMsum(#0) over(#1)Rank#0#,#<partition by#>#<#, #*#>#|rank over(#1#2#<,#*#> order by #0)COVARIANCECOVAR_POP(#0, #1)CORRELATIONCORR(#0, #1)SLOPEREGR_SLOPE(#0, #1)INTERCEPTREGR_INTERCEPT(#0, #1)BANDINGCase  when  (#0  between  #1  and  #2)  then cast((1.0*(#0- #1)/#3) +1 AS INTEGER) else 0 endBANDINGCCase when (#1=#2  and #0=#1) then #3  when (#0=#2) then #3 when (#0 between #1 and #2) then CAST(1.0*(#0- #1)/(#2- #1)*#3+1 AS INTEGER) else 0 endIF(Case when #0 then #1 else #2 end)RUNNINGSTDEVstddev_samp(#0) over(#1)RUNNINGSTDEVPstddev_pop(#0) over (#1)MOVINGSTDEVstddev_samp(#0) over(#1)MOVINGSTDEVPstddev_pop(#0) over(#1)OLAPSUMsum(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:nOLAPAVGavg(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:yOLAPCOUNTcount(#0#<   #*#>)  over  ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|N:y|R:yOLAPMAXmax(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:yOLAPMINmin(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:yLAGCASE  WHEN  count(*)  OVER  ([#P]  [#O]  rows between unbounded preceding and current row) <= #1 THEN #2 ELSE sum(#0#< #*#>) OVER ([#P][#O]  rows  between  #1  preceding  and  #1 preceding) END" OLAPDBPATTERN="P:o|O:rLEADCASE  WHEN  count(*)  OVER  ([#P]  [#O]  rows between current row and unbounded following)  <= #1 THEN #2 ELSE sum(#0#< #*#>) OVER ([#P] [#O] rows between #1 following and #1 following) END" OLAPDBPATTERN="P:o|O:rOLAPRANKrank() over ([#P] [#O])" OLAPDBPATTERN="P:o|O:rLAGlag(#0#<, #*#>) over ([#P][#O])" OLAPDBPATTERN="P:o|O:rLEADlead(#0#<, #*#>) over ([#P] [#O])" OLAPDBPATTERN="P:o|O:rOLAPRANKrank() over ([#P] [#O])" OLAPDBPATTERN="P:o|O:rMEDIANMEDIAN(#0)FIRST IN RANGEfirst_value(#0) over(#1)LAST IN RANGElast_value(#0) over(#1)Strategy Function NameSQL PatternACOSACOS(#0)ASINASIN(#0)ATANATAN(#0)ATAN2ATAN2(#0,#1)COSHCOSH(#0)SINHSINH(#0)TANTAN(#0)TANHTANH(#0)ACOSHACOSH(#0)ASINHASINH(#0)ATANHATANH(#0)GEOMEANEXP(AVG(LN(#0)))PRODUCT(CASE WHEN SUM(CASE WHEN #0=0 THEN 1 ELSE 0 END) > 0 THEN 0 ELSE (POWER(-1,SUM(CASE WHEN #0<0 THEN 1 END)))*EXP(SUM(LN(ABS(CASE WHEN #0<>0 THEN #0 ELSE NULL END)))) END) CEILINGCEILING(#0)DEGRESS(POWER(ASIN(1),(-1))*#0*90)FLOORFLOOR(#0)RADIANS(ASIN(1)*#0/90)TRUNCTRUNC(#0)Strategy Function NameSQL PatternINTCASE WHEN #0 > 0 THEN TRUNC(#0, 0) ELSE (TRUNC(#0, 0) - 1) ENDINT2(CASE WHEN (#0-CAST(#0 as integer)) >= 0 THEN CAST(#0 as integer) ELSE (CAST(#0 as integer) - 1) END)LOG(LN(#0)/LN(#1))QUOTIENTTRUNC((#0)/(CASE WHEN (#1)=0 THEN NULL ELSE(#1) END), 0)MOVINGCOUNTSUM(#0- #0+1) OVER(#1)MOVINGSTDEV(CASE WHEN SUM(#0 - #0 +1) OVER(#1)=1 THEN 0 ELSE   SQRT((SUM(#0*#0)   OVER(#1)-((SUM(#0) OVER(#1))/(SUM(#0-OVER(#1)*SUM(#0) OVER(#1))))/(SUM(#0- #0+1) OVER(#1)-1)) END)FISHER(LN((1+#0)/(1- #0))/2)INVERSEFISHER((EXP(2*#0)-1)/(EXP(2*#0)+1))PEARSON(((SUM(#0-#0+#1-#1+1)*SUM(#0*#1))-(SUM(#0)*SUM(#1)))/SQRT(((SUM(#0-#1+1)*SUM(#0*#0))-(SUM(#0)*SUM(#0)))*((SUM(#0-#1+1)*SUM(#1*#1))-(SUM(#1)*SUM(#1)))))STANDARDIZEcase when (#2 > 0) then (#0 - #1)/(#2) else NULL endRSQUAREREGR_R2(#0,#1)STEYXSQRT((1/(SUM(#1- #1+#0- #0+1)*(SUM(#1- #1+#0- #0+1)-2)))*((SUM(#1- #1+#0- #0+1)*SUM(#0*#0))- (SUM(#0)*SUM(#0))-((((SUM(#1- #0+1)*SUM(#1*#0))-(SUM(#1)*SUM(#0)))*((SUM(#1-#0+1)*SUM(#1*#0))-(SUM(#1)*SUM(#0))))/((SUM(#1-#0+1)*SUM(#1*#1))-(SUM(#1)*SUM(#1))))))GREATESTGREATEST(#0#<, #*#>)LEASTLEAST(#0#<, #*#>)CountryMetricCanada23Australia10United States50Estonia12
  Strategy Grandmaster Badges Receive a badge for being recognized as a Strategy Grandmaster. Former Strategy Grandmasters will also be recognized with an alumni badge. Community Influencer Badges Receive a badge for being recognized as a Community Influencer. Former Community Influencers will also be recognized with an alumni badge.     DossBoss Badge  Receive a badge for winning our monthly data visualization challenge, DossBoss. Learn more about the competition here.  MethodDescriptionTypeBottomLevelA bottom level specifies the lowest analysis level that the security filter is applied.IDSSDimtyExpressionSecurity filter.IDSSExpressionInfoThe IDSSObjectInfo interface for the MD security filter.IDSSObjectInfoPopulate ( object as IDSSMDSecurityFilter)Populate this filter's value from an existing MD security filter. RootA shortcut to Expression.Root.IDSSNodeTopLevelA top level specifies the highest analysis level that the security filter is applied without changing the dimensionality of metrics. IDSSDimtyStrategy Function NameSQL PatternABSABS(#0)COSCOS(#0)EXPEXP(#0)LNLN(#0)LOG10LOG(#0)POWERPOWER(#0, #1)ROUNDROUND(#0,0)ROUND2ROUND(#0, #1)SINSIN(#0)SQRTSQRT(#0)MOD((#0) MOD (#1))STDEVSTDDEV_SAMP(#0#< #*#>)VARVAR_SAMP(#0#< #*#>)STDEVPSTDDEV_POP(#0#< #*#>)VARPVAR_POP(#0#< #*#>)SKEWSKEW(#0#< #*#>)KURTOSISKURTOSIS(#0#< #*#>)Strategy Function NameSQL PatternCURRENTDATECURRENT_DATEDAYOFMONTHEXTRACT(DAY FROM #0)DAYOFWEEKTO_NUMBER(TO_CHAR(#0, 'D'))DAYOFYEARTO_NUMBER(TO_CHAR(#0, 'DDD'))WEEKTO_NUMBER(TO_CHAR(#0, 'WW'))MONTHEXTRACT(MONTH FROM #0)QUARTERTO_NUMBER(TO_CHAR(#0, 'Q'))YEAREXTRACT(YEAR FROM #0)CURRENTDATETIMELOCALTIMESTAMPCURRENTTIMELOCALTIMESTAMPHOURTO_NUMBER(TO_CHAR(#0, 'HH24'))MINUTETO_NUMBER(TO_CHAR(#0, 'MI')SECONDTO_NUMBER(TO_CHAR(#0, 'SS'))DATETRUNC(CAST(#0 AS DATE))DAYSBETWEENCAST(#1 AS DATE) - CAST(#0 AS DATE)MONTHSBETWEENFLOOR(MONTHS_BETWEEN(#1, #0))ADDDAYS(#0 + #1 * INTERVAL '1' DAY)ADDMONTHSADD_MONTHS(#0, Cast(#1 as Integer))MONTHSTARTDATETRUNC(ADD_MONTHS((LAST_DAY(#0) + 1), -1))MONTHENDDATETRUNC(LAST_DAY(#0))YEARSTARTDATEADD_MONTHS(TRUNC(#0) - EXTRACT(DAY FROM #0) + 1, 1 - EXTRACT(MONTH FROM #0))YEARENDDATEADD_MONTHS(TRUNC(#0) - EXTRACT(DAY FROM #0), 13 - EXTRACT(MONTH FROM #0))Strategy Function NameColumn NameRUNNINGAVGavg(#0) over(#1)RUNNINGMAXmax(#0) over(#1)RUNNINGMINmin(#0) over(#1)RUNNINGCOUNTcount(#0) over(#1)RUNNINGSUMsum(#0) over(#1)MOVINGAVGavg(#0) over(#1)MOVINGMAXmax(#0) over(#1)MOVINGMINmin(#0) over(#1)MOVINGSUMsum(#0) over(#1)Rank#0#,#<partition by#>#<#, #*#>#|rank over(#1#2#<,#*#> order by #0)COVARIANCECOVAR_POP(#0, #1)CORRELATIONCORR(#0, #1)SLOPEREGR_SLOPE(#0, #1)INTERCEPTREGR_INTERCEPT(#0, #1)BANDINGCase  when  (#0  between  #1  and  #2)  then cast((1.0*(#0- #1)/#3) +1 AS INTEGER) else 0 endBANDINGCCase when (#1=#2  and #0=#1) then #3  when (#0=#2) then #3 when (#0 between #1 and #2) then CAST(1.0*(#0- #1)/(#2- #1)*#3+1 AS INTEGER) else 0 endIF(Case when #0 then #1 else #2 end)RUNNINGSTDEVstddev_samp(#0) over(#1)RUNNINGSTDEVPstddev_pop(#0) over (#1)MOVINGSTDEVstddev_samp(#0) over(#1)MOVINGSTDEVPstddev_pop(#0) over(#1)OLAPSUMsum(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:nOLAPAVGavg(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:yOLAPCOUNTcount(#0#<   #*#>)  over  ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|N:y|R:yOLAPMAXmax(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:yOLAPMINmin(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:yLAGCASE  WHEN  count(*)  OVER  ([#P]  [#O]  rows between unbounded preceding and current row) <= #1 THEN #2 ELSE sum(#0#< #*#>) OVER ([#P][#O]  rows  between  #1  preceding  and  #1 preceding) END" OLAPDBPATTERN="P:o|O:rLEADCASE  WHEN  count(*)  OVER  ([#P]  [#O]  rows between current row and unbounded following)  <= #1 THEN #2 ELSE sum(#0#< #*#>) OVER ([#P] [#O] rows between #1 following and #1 following) END" OLAPDBPATTERN="P:o|O:rOLAPRANKrank() over ([#P] [#O])" OLAPDBPATTERN="P:o|O:rLAGlag(#0#<, #*#>) over ([#P][#O])" OLAPDBPATTERN="P:o|O:rLEADlead(#0#<, #*#>) over ([#P] [#O])" OLAPDBPATTERN="P:o|O:rOLAPRANKrank() over ([#P] [#O])" OLAPDBPATTERN="P:o|O:rMEDIANMEDIAN(#0)FIRST IN RANGEfirst_value(#0) over(#1)LAST IN RANGElast_value(#0) over(#1)Strategy Function NameSQL PatternACOSACOS(#0)ASINASIN(#0)ATANATAN(#0)ATAN2ATAN2(#0,#1)COSHCOSH(#0)SINHSINH(#0)TANTAN(#0)TANHTANH(#0)ACOSHACOSH(#0)ASINHASINH(#0)ATANHATANH(#0)GEOMEANEXP(AVG(LN(#0)))PRODUCT(CASE WHEN SUM(CASE WHEN #0=0 THEN 1 ELSE 0 END) > 0 THEN 0 ELSE (POWER(-1,SUM(CASE WHEN #0<0 THEN 1 END)))*EXP(SUM(LN(ABS(CASE WHEN #0<>0 THEN #0 ELSE NULL END)))) END) CEILINGCEILING(#0)DEGRESS(POWER(ASIN(1),(-1))*#0*90)FLOORFLOOR(#0)RADIANS(ASIN(1)*#0/90)TRUNCTRUNC(#0)Strategy Function NameSQL PatternINTCASE WHEN #0 > 0 THEN TRUNC(#0, 0) ELSE (TRUNC(#0, 0) - 1) ENDINT2(CASE WHEN (#0-CAST(#0 as integer)) >= 0 THEN CAST(#0 as integer) ELSE (CAST(#0 as integer) - 1) END)LOG(LN(#0)/LN(#1))QUOTIENTTRUNC((#0)/(CASE WHEN (#1)=0 THEN NULL ELSE(#1) END), 0)MOVINGCOUNTSUM(#0- #0+1) OVER(#1)MOVINGSTDEV(CASE WHEN SUM(#0 - #0 +1) OVER(#1)=1 THEN 0 ELSE   SQRT((SUM(#0*#0)   OVER(#1)-((SUM(#0) OVER(#1))/(SUM(#0-OVER(#1)*SUM(#0) OVER(#1))))/(SUM(#0- #0+1) OVER(#1)-1)) END)FISHER(LN((1+#0)/(1- #0))/2)INVERSEFISHER((EXP(2*#0)-1)/(EXP(2*#0)+1))PEARSON(((SUM(#0-#0+#1-#1+1)*SUM(#0*#1))-(SUM(#0)*SUM(#1)))/SQRT(((SUM(#0-#1+1)*SUM(#0*#0))-(SUM(#0)*SUM(#0)))*((SUM(#0-#1+1)*SUM(#1*#1))-(SUM(#1)*SUM(#1)))))STANDARDIZEcase when (#2 > 0) then (#0 - #1)/(#2) else NULL endRSQUAREREGR_R2(#0,#1)STEYXSQRT((1/(SUM(#1- #1+#0- #0+1)*(SUM(#1- #1+#0- #0+1)-2)))*((SUM(#1- #1+#0- #0+1)*SUM(#0*#0))- (SUM(#0)*SUM(#0))-((((SUM(#1- #0+1)*SUM(#1*#0))-(SUM(#1)*SUM(#0)))*((SUM(#1-#0+1)*SUM(#1*#0))-(SUM(#1)*SUM(#0))))/((SUM(#1-#0+1)*SUM(#1*#1))-(SUM(#1)*SUM(#1))))))GREATESTGREATEST(#0#<, #*#>)LEASTLEAST(#0#<, #*#>)CountryMetricCanada23Australia10United States50Estonia12	Strategy Grandmaster Badges Receive a badge for being recognized as a Strategy Grandmaster. Former Strategy Grandmasters will also be recognized with an alumni badge. Community Influencer Badges Receive a badge for being recognized as a Community Influencer. Former Community Influencers will also be recognized with an alumni badge.     DossBoss Badge  Receive a badge for winning our monthly data visualization challenge, DossBoss. Learn more about the competition here.  MethodDescriptionTypeBottomLevelA bottom level specifies the lowest analysis level that the security filter is applied.IDSSDimtyExpressionSecurity filter.IDSSExpressionInfoThe IDSSObjectInfo interface for the MD security filter.IDSSObjectInfoPopulate ( object as IDSSMDSecurityFilter)Populate this filter's value from an existing MD security filter. RootA shortcut to Expression.Root.IDSSNodeTopLevelA top level specifies the highest analysis level that the security filter is applied without changing the dimensionality of metrics. IDSSDimtyStrategy Function NameSQL PatternABSABS(#0)COSCOS(#0)EXPEXP(#0)LNLN(#0)LOG10LOG(#0)POWERPOWER(#0, #1)ROUNDROUND(#0,0)ROUND2ROUND(#0, #1)SINSIN(#0)SQRTSQRT(#0)MOD((#0) MOD (#1))STDEVSTDDEV_SAMP(#0#< #*#>)VARVAR_SAMP(#0#< #*#>)STDEVPSTDDEV_POP(#0#< #*#>)VARPVAR_POP(#0#< #*#>)SKEWSKEW(#0#< #*#>)KURTOSISKURTOSIS(#0#< #*#>)Strategy Function NameSQL PatternCURRENTDATECURRENT_DATEDAYOFMONTHEXTRACT(DAY FROM #0)DAYOFWEEKTO_NUMBER(TO_CHAR(#0, 'D'))DAYOFYEARTO_NUMBER(TO_CHAR(#0, 'DDD'))WEEKTO_NUMBER(TO_CHAR(#0, 'WW'))MONTHEXTRACT(MONTH FROM #0)QUARTERTO_NUMBER(TO_CHAR(#0, 'Q'))YEAREXTRACT(YEAR FROM #0)CURRENTDATETIMELOCALTIMESTAMPCURRENTTIMELOCALTIMESTAMPHOURTO_NUMBER(TO_CHAR(#0, 'HH24'))MINUTETO_NUMBER(TO_CHAR(#0, 'MI')SECONDTO_NUMBER(TO_CHAR(#0, 'SS'))DATETRUNC(CAST(#0 AS DATE))DAYSBETWEENCAST(#1 AS DATE) - CAST(#0 AS DATE)MONTHSBETWEENFLOOR(MONTHS_BETWEEN(#1, #0))ADDDAYS(#0 + #1 * INTERVAL '1' DAY)ADDMONTHSADD_MONTHS(#0, Cast(#1 as Integer))MONTHSTARTDATETRUNC(ADD_MONTHS((LAST_DAY(#0) + 1), -1))MONTHENDDATETRUNC(LAST_DAY(#0))YEARSTARTDATEADD_MONTHS(TRUNC(#0) - EXTRACT(DAY FROM #0) + 1, 1 - EXTRACT(MONTH FROM #0))YEARENDDATEADD_MONTHS(TRUNC(#0) - EXTRACT(DAY FROM #0), 13 - EXTRACT(MONTH FROM #0))Strategy Function NameColumn NameRUNNINGAVGavg(#0) over(#1)RUNNINGMAXmax(#0) over(#1)RUNNINGMINmin(#0) over(#1)RUNNINGCOUNTcount(#0) over(#1)RUNNINGSUMsum(#0) over(#1)MOVINGAVGavg(#0) over(#1)MOVINGMAXmax(#0) over(#1)MOVINGMINmin(#0) over(#1)MOVINGSUMsum(#0) over(#1)Rank#0#,#<partition by#>#<#, #*#>#|rank over(#1#2#<,#*#> order by #0)COVARIANCECOVAR_POP(#0, #1)CORRELATIONCORR(#0, #1)SLOPEREGR_SLOPE(#0, #1)INTERCEPTREGR_INTERCEPT(#0, #1)BANDINGCase  when  (#0  between  #1  and  #2)  then cast((1.0*(#0- #1)/#3) +1 AS INTEGER) else 0 endBANDINGCCase when (#1=#2  and #0=#1) then #3  when (#0=#2) then #3 when (#0 between #1 and #2) then CAST(1.0*(#0- #1)/(#2- #1)*#3+1 AS INTEGER) else 0 endIF(Case when #0 then #1 else #2 end)RUNNINGSTDEVstddev_samp(#0) over(#1)RUNNINGSTDEVPstddev_pop(#0) over (#1)MOVINGSTDEVstddev_samp(#0) over(#1)MOVINGSTDEVPstddev_pop(#0) over(#1)OLAPSUMsum(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:nOLAPAVGavg(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:yOLAPCOUNTcount(#0#<   #*#>)  over  ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|N:y|R:yOLAPMAXmax(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:yOLAPMINmin(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:yLAGCASE  WHEN  count(*)  OVER  ([#P]  [#O]  rows between unbounded preceding and current row) <= #1 THEN #2 ELSE sum(#0#< #*#>) OVER ([#P][#O]  rows  between  #1  preceding  and  #1 preceding) END" OLAPDBPATTERN="P:o|O:rLEADCASE  WHEN  count(*)  OVER  ([#P]  [#O]  rows between current row and unbounded following)  <= #1 THEN #2 ELSE sum(#0#< #*#>) OVER ([#P] [#O] rows between #1 following and #1 following) END" OLAPDBPATTERN="P:o|O:rOLAPRANKrank() over ([#P] [#O])" OLAPDBPATTERN="P:o|O:rLAGlag(#0#<, #*#>) over ([#P][#O])" OLAPDBPATTERN="P:o|O:rLEADlead(#0#<, #*#>) over ([#P] [#O])" OLAPDBPATTERN="P:o|O:rOLAPRANKrank() over ([#P] [#O])" OLAPDBPATTERN="P:o|O:rMEDIANMEDIAN(#0)FIRST IN RANGEfirst_value(#0) over(#1)LAST IN RANGElast_value(#0) over(#1)Strategy Function NameSQL PatternACOSACOS(#0)ASINASIN(#0)ATANATAN(#0)ATAN2ATAN2(#0,#1)COSHCOSH(#0)SINHSINH(#0)TANTAN(#0)TANHTANH(#0)ACOSHACOSH(#0)ASINHASINH(#0)ATANHATANH(#0)GEOMEANEXP(AVG(LN(#0)))PRODUCT(CASE WHEN SUM(CASE WHEN #0=0 THEN 1 ELSE 0 END) > 0 THEN 0 ELSE (POWER(-1,SUM(CASE WHEN #0<0 THEN 1 END)))*EXP(SUM(LN(ABS(CASE WHEN #0<>0 THEN #0 ELSE NULL END)))) END) CEILINGCEILING(#0)DEGRESS(POWER(ASIN(1),(-1))*#0*90)FLOORFLOOR(#0)RADIANS(ASIN(1)*#0/90)TRUNCTRUNC(#0)Strategy Function NameSQL PatternINTCASE WHEN #0 > 0 THEN TRUNC(#0, 0) ELSE (TRUNC(#0, 0) - 1) ENDINT2(CASE WHEN (#0-CAST(#0 as integer)) >= 0 THEN CAST(#0 as integer) ELSE (CAST(#0 as integer) - 1) END)LOG(LN(#0)/LN(#1))QUOTIENTTRUNC((#0)/(CASE WHEN (#1)=0 THEN NULL ELSE(#1) END), 0)MOVINGCOUNTSUM(#0- #0+1) OVER(#1)MOVINGSTDEV(CASE WHEN SUM(#0 - #0 +1) OVER(#1)=1 THEN 0 ELSE   SQRT((SUM(#0*#0)   OVER(#1)-((SUM(#0) OVER(#1))/(SUM(#0-OVER(#1)*SUM(#0) OVER(#1))))/(SUM(#0- #0+1) OVER(#1)-1)) END)FISHER(LN((1+#0)/(1- #0))/2)INVERSEFISHER((EXP(2*#0)-1)/(EXP(2*#0)+1))PEARSON(((SUM(#0-#0+#1-#1+1)*SUM(#0*#1))-(SUM(#0)*SUM(#1)))/SQRT(((SUM(#0-#1+1)*SUM(#0*#0))-(SUM(#0)*SUM(#0)))*((SUM(#0-#1+1)*SUM(#1*#1))-(SUM(#1)*SUM(#1)))))STANDARDIZEcase when (#2 > 0) then (#0 - #1)/(#2) else NULL endRSQUAREREGR_R2(#0,#1)STEYXSQRT((1/(SUM(#1- #1+#0- #0+1)*(SUM(#1- #1+#0- #0+1)-2)))*((SUM(#1- #1+#0- #0+1)*SUM(#0*#0))- (SUM(#0)*SUM(#0))-((((SUM(#1- #0+1)*SUM(#1*#0))-(SUM(#1)*SUM(#0)))*((SUM(#1-#0+1)*SUM(#1*#0))-(SUM(#1)*SUM(#0))))/((SUM(#1-#0+1)*SUM(#1*#1))-(SUM(#1)*SUM(#1))))))GREATESTGREATEST(#0#<, #*#>)LEASTLEAST(#0#<, #*#>)CountryMetricCanada23Australia10United States50Estonia12
  Strategy Grandmaster Badges Receive a badge for being recognized as a Strategy Grandmaster. Former Strategy Grandmasters will also be recognized with an alumni badge. Community Influencer Badges Receive a badge for being recognized as a Community Influencer. Former Community Influencers will also be recognized with an alumni badge.     DossBoss Badge  Receive a badge for winning our monthly data visualization challenge, DossBoss. Learn more about the competition here.  MethodDescriptionTypeBottomLevelA bottom level specifies the lowest analysis level that the security filter is applied.IDSSDimtyExpressionSecurity filter.IDSSExpressionInfoThe IDSSObjectInfo interface for the MD security filter.IDSSObjectInfoPopulate ( object as IDSSMDSecurityFilter)Populate this filter's value from an existing MD security filter. RootA shortcut to Expression.Root.IDSSNodeTopLevelA top level specifies the highest analysis level that the security filter is applied without changing the dimensionality of metrics. IDSSDimtyStrategy Function NameSQL PatternABSABS(#0)COSCOS(#0)EXPEXP(#0)LNLN(#0)LOG10LOG(#0)POWERPOWER(#0, #1)ROUNDROUND(#0,0)ROUND2ROUND(#0, #1)SINSIN(#0)SQRTSQRT(#0)MOD((#0) MOD (#1))STDEVSTDDEV_SAMP(#0#< #*#>)VARVAR_SAMP(#0#< #*#>)STDEVPSTDDEV_POP(#0#< #*#>)VARPVAR_POP(#0#< #*#>)SKEWSKEW(#0#< #*#>)KURTOSISKURTOSIS(#0#< #*#>)Strategy Function NameSQL PatternCURRENTDATECURRENT_DATEDAYOFMONTHEXTRACT(DAY FROM #0)DAYOFWEEKTO_NUMBER(TO_CHAR(#0, 'D'))DAYOFYEARTO_NUMBER(TO_CHAR(#0, 'DDD'))WEEKTO_NUMBER(TO_CHAR(#0, 'WW'))MONTHEXTRACT(MONTH FROM #0)QUARTERTO_NUMBER(TO_CHAR(#0, 'Q'))YEAREXTRACT(YEAR FROM #0)CURRENTDATETIMELOCALTIMESTAMPCURRENTTIMELOCALTIMESTAMPHOURTO_NUMBER(TO_CHAR(#0, 'HH24'))MINUTETO_NUMBER(TO_CHAR(#0, 'MI')SECONDTO_NUMBER(TO_CHAR(#0, 'SS'))DATETRUNC(CAST(#0 AS DATE))DAYSBETWEENCAST(#1 AS DATE) - CAST(#0 AS DATE)MONTHSBETWEENFLOOR(MONTHS_BETWEEN(#1, #0))ADDDAYS(#0 + #1 * INTERVAL '1' DAY)ADDMONTHSADD_MONTHS(#0, Cast(#1 as Integer))MONTHSTARTDATETRUNC(ADD_MONTHS((LAST_DAY(#0) + 1), -1))MONTHENDDATETRUNC(LAST_DAY(#0))YEARSTARTDATEADD_MONTHS(TRUNC(#0) - EXTRACT(DAY FROM #0) + 1, 1 - EXTRACT(MONTH FROM #0))YEARENDDATEADD_MONTHS(TRUNC(#0) - EXTRACT(DAY FROM #0), 13 - EXTRACT(MONTH FROM #0))Strategy Function NameColumn NameRUNNINGAVGavg(#0) over(#1)RUNNINGMAXmax(#0) over(#1)RUNNINGMINmin(#0) over(#1)RUNNINGCOUNTcount(#0) over(#1)RUNNINGSUMsum(#0) over(#1)MOVINGAVGavg(#0) over(#1)MOVINGMAXmax(#0) over(#1)MOVINGMINmin(#0) over(#1)MOVINGSUMsum(#0) over(#1)Rank#0#,#<partition by#>#<#, #*#>#|rank over(#1#2#<,#*#> order by #0)COVARIANCECOVAR_POP(#0, #1)CORRELATIONCORR(#0, #1)SLOPEREGR_SLOPE(#0, #1)INTERCEPTREGR_INTERCEPT(#0, #1)BANDINGCase  when  (#0  between  #1  and  #2)  then cast((1.0*(#0- #1)/#3) +1 AS INTEGER) else 0 endBANDINGCCase when (#1=#2  and #0=#1) then #3  when (#0=#2) then #3 when (#0 between #1 and #2) then CAST(1.0*(#0- #1)/(#2- #1)*#3+1 AS INTEGER) else 0 endIF(Case when #0 then #1 else #2 end)RUNNINGSTDEVstddev_samp(#0) over(#1)RUNNINGSTDEVPstddev_pop(#0) over (#1)MOVINGSTDEVstddev_samp(#0) over(#1)MOVINGSTDEVPstddev_pop(#0) over(#1)OLAPSUMsum(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:nOLAPAVGavg(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:yOLAPCOUNTcount(#0#<   #*#>)  over  ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|N:y|R:yOLAPMAXmax(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:yOLAPMINmin(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:yLAGCASE  WHEN  count(*)  OVER  ([#P]  [#O]  rows between unbounded preceding and current row) <= #1 THEN #2 ELSE sum(#0#< #*#>) OVER ([#P][#O]  rows  between  #1  preceding  and  #1 preceding) END" OLAPDBPATTERN="P:o|O:rLEADCASE  WHEN  count(*)  OVER  ([#P]  [#O]  rows between current row and unbounded following)  <= #1 THEN #2 ELSE sum(#0#< #*#>) OVER ([#P] [#O] rows between #1 following and #1 following) END" OLAPDBPATTERN="P:o|O:rOLAPRANKrank() over ([#P] [#O])" OLAPDBPATTERN="P:o|O:rLAGlag(#0#<, #*#>) over ([#P][#O])" OLAPDBPATTERN="P:o|O:rLEADlead(#0#<, #*#>) over ([#P] [#O])" OLAPDBPATTERN="P:o|O:rOLAPRANKrank() over ([#P] [#O])" OLAPDBPATTERN="P:o|O:rMEDIANMEDIAN(#0)FIRST IN RANGEfirst_value(#0) over(#1)LAST IN RANGElast_value(#0) over(#1)Strategy Function NameSQL PatternACOSACOS(#0)ASINASIN(#0)ATANATAN(#0)ATAN2ATAN2(#0,#1)COSHCOSH(#0)SINHSINH(#0)TANTAN(#0)TANHTANH(#0)ACOSHACOSH(#0)ASINHASINH(#0)ATANHATANH(#0)GEOMEANEXP(AVG(LN(#0)))PRODUCT(CASE WHEN SUM(CASE WHEN #0=0 THEN 1 ELSE 0 END) > 0 THEN 0 ELSE (POWER(-1,SUM(CASE WHEN #0<0 THEN 1 END)))*EXP(SUM(LN(ABS(CASE WHEN #0<>0 THEN #0 ELSE NULL END)))) END) CEILINGCEILING(#0)DEGRESS(POWER(ASIN(1),(-1))*#0*90)FLOORFLOOR(#0)RADIANS(ASIN(1)*#0/90)TRUNCTRUNC(#0)Strategy Function NameSQL PatternINTCASE WHEN #0 > 0 THEN TRUNC(#0, 0) ELSE (TRUNC(#0, 0) - 1) ENDINT2(CASE WHEN (#0-CAST(#0 as integer)) >= 0 THEN CAST(#0 as integer) ELSE (CAST(#0 as integer) - 1) END)LOG(LN(#0)/LN(#1))QUOTIENTTRUNC((#0)/(CASE WHEN (#1)=0 THEN NULL ELSE(#1) END), 0)MOVINGCOUNTSUM(#0- #0+1) OVER(#1)MOVINGSTDEV(CASE WHEN SUM(#0 - #0 +1) OVER(#1)=1 THEN 0 ELSE   SQRT((SUM(#0*#0)   OVER(#1)-((SUM(#0) OVER(#1))/(SUM(#0-OVER(#1)*SUM(#0) OVER(#1))))/(SUM(#0- #0+1) OVER(#1)-1)) END)FISHER(LN((1+#0)/(1- #0))/2)INVERSEFISHER((EXP(2*#0)-1)/(EXP(2*#0)+1))PEARSON(((SUM(#0-#0+#1-#1+1)*SUM(#0*#1))-(SUM(#0)*SUM(#1)))/SQRT(((SUM(#0-#1+1)*SUM(#0*#0))-(SUM(#0)*SUM(#0)))*((SUM(#0-#1+1)*SUM(#1*#1))-(SUM(#1)*SUM(#1)))))STANDARDIZEcase when (#2 > 0) then (#0 - #1)/(#2) else NULL endRSQUAREREGR_R2(#0,#1)STEYXSQRT((1/(SUM(#1- #1+#0- #0+1)*(SUM(#1- #1+#0- #0+1)-2)))*((SUM(#1- #1+#0- #0+1)*SUM(#0*#0))- (SUM(#0)*SUM(#0))-((((SUM(#1- #0+1)*SUM(#1*#0))-(SUM(#1)*SUM(#0)))*((SUM(#1-#0+1)*SUM(#1*#0))-(SUM(#1)*SUM(#0))))/((SUM(#1-#0+1)*SUM(#1*#1))-(SUM(#1)*SUM(#1))))))GREATESTGREATEST(#0#<, #*#>)LEASTLEAST(#0#<, #*#>)CountryMetricCanada23Australia10United States50Estonia12	Strategy Grandmaster Badges Receive a badge for being recognized as a Strategy Grandmaster. Former Strategy Grandmasters will also be recognized with an alumni badge. Community Influencer Badges Receive a badge for being recognized as a Community Influencer. Former Community Influencers will also be recognized with an alumni badge.     DossBoss Badge  Receive a badge for winning our monthly data visualization challenge, DossBoss. Learn more about the competition here.  MethodDescriptionTypeBottomLevelA bottom level specifies the lowest analysis level that the security filter is applied.IDSSDimtyExpressionSecurity filter.IDSSExpressionInfoThe IDSSObjectInfo interface for the MD security filter.IDSSObjectInfoPopulate ( object as IDSSMDSecurityFilter)Populate this filter's value from an existing MD security filter. RootA shortcut to Expression.Root.IDSSNodeTopLevelA top level specifies the highest analysis level that the security filter is applied without changing the dimensionality of metrics. IDSSDimtyStrategy Function NameSQL PatternABSABS(#0)COSCOS(#0)EXPEXP(#0)LNLN(#0)LOG10LOG(#0)POWERPOWER(#0, #1)ROUNDROUND(#0,0)ROUND2ROUND(#0, #1)SINSIN(#0)SQRTSQRT(#0)MOD((#0) MOD (#1))STDEVSTDDEV_SAMP(#0#< #*#>)VARVAR_SAMP(#0#< #*#>)STDEVPSTDDEV_POP(#0#< #*#>)VARPVAR_POP(#0#< #*#>)SKEWSKEW(#0#< #*#>)KURTOSISKURTOSIS(#0#< #*#>)Strategy Function NameSQL PatternCURRENTDATECURRENT_DATEDAYOFMONTHEXTRACT(DAY FROM #0)DAYOFWEEKTO_NUMBER(TO_CHAR(#0, 'D'))DAYOFYEARTO_NUMBER(TO_CHAR(#0, 'DDD'))WEEKTO_NUMBER(TO_CHAR(#0, 'WW'))MONTHEXTRACT(MONTH FROM #0)QUARTERTO_NUMBER(TO_CHAR(#0, 'Q'))YEAREXTRACT(YEAR FROM #0)CURRENTDATETIMELOCALTIMESTAMPCURRENTTIMELOCALTIMESTAMPHOURTO_NUMBER(TO_CHAR(#0, 'HH24'))MINUTETO_NUMBER(TO_CHAR(#0, 'MI')SECONDTO_NUMBER(TO_CHAR(#0, 'SS'))DATETRUNC(CAST(#0 AS DATE))DAYSBETWEENCAST(#1 AS DATE) - CAST(#0 AS DATE)MONTHSBETWEENFLOOR(MONTHS_BETWEEN(#1, #0))ADDDAYS(#0 + #1 * INTERVAL '1' DAY)ADDMONTHSADD_MONTHS(#0, Cast(#1 as Integer))MONTHSTARTDATETRUNC(ADD_MONTHS((LAST_DAY(#0) + 1), -1))MONTHENDDATETRUNC(LAST_DAY(#0))YEARSTARTDATEADD_MONTHS(TRUNC(#0) - EXTRACT(DAY FROM #0) + 1, 1 - EXTRACT(MONTH FROM #0))YEARENDDATEADD_MONTHS(TRUNC(#0) - EXTRACT(DAY FROM #0), 13 - EXTRACT(MONTH FROM #0))Strategy Function NameColumn NameRUNNINGAVGavg(#0) over(#1)RUNNINGMAXmax(#0) over(#1)RUNNINGMINmin(#0) over(#1)RUNNINGCOUNTcount(#0) over(#1)RUNNINGSUMsum(#0) over(#1)MOVINGAVGavg(#0) over(#1)MOVINGMAXmax(#0) over(#1)MOVINGMINmin(#0) over(#1)MOVINGSUMsum(#0) over(#1)Rank#0#,#<partition by#>#<#, #*#>#|rank over(#1#2#<,#*#> order by #0)COVARIANCECOVAR_POP(#0, #1)CORRELATIONCORR(#0, #1)SLOPEREGR_SLOPE(#0, #1)INTERCEPTREGR_INTERCEPT(#0, #1)BANDINGCase  when  (#0  between  #1  and  #2)  then cast((1.0*(#0- #1)/#3) +1 AS INTEGER) else 0 endBANDINGCCase when (#1=#2  and #0=#1) then #3  when (#0=#2) then #3 when (#0 between #1 and #2) then CAST(1.0*(#0- #1)/(#2- #1)*#3+1 AS INTEGER) else 0 endIF(Case when #0 then #1 else #2 end)RUNNINGSTDEVstddev_samp(#0) over(#1)RUNNINGSTDEVPstddev_pop(#0) over (#1)MOVINGSTDEVstddev_samp(#0) over(#1)MOVINGSTDEVPstddev_pop(#0) over(#1)OLAPSUMsum(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:nOLAPAVGavg(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:yOLAPCOUNTcount(#0#<   #*#>)  over  ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|N:y|R:yOLAPMAXmax(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:yOLAPMINmin(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:yLAGCASE  WHEN  count(*)  OVER  ([#P]  [#O]  rows between unbounded preceding and current row) <= #1 THEN #2 ELSE sum(#0#< #*#>) OVER ([#P][#O]  rows  between  #1  preceding  and  #1 preceding) END" OLAPDBPATTERN="P:o|O:rLEADCASE  WHEN  count(*)  OVER  ([#P]  [#O]  rows between current row and unbounded following)  <= #1 THEN #2 ELSE sum(#0#< #*#>) OVER ([#P] [#O] rows between #1 following and #1 following) END" OLAPDBPATTERN="P:o|O:rOLAPRANKrank() over ([#P] [#O])" OLAPDBPATTERN="P:o|O:rLAGlag(#0#<, #*#>) over ([#P][#O])" OLAPDBPATTERN="P:o|O:rLEADlead(#0#<, #*#>) over ([#P] [#O])" OLAPDBPATTERN="P:o|O:rOLAPRANKrank() over ([#P] [#O])" OLAPDBPATTERN="P:o|O:rMEDIANMEDIAN(#0)FIRST IN RANGEfirst_value(#0) over(#1)LAST IN RANGElast_value(#0) over(#1)Strategy Function NameSQL PatternACOSACOS(#0)ASINASIN(#0)ATANATAN(#0)ATAN2ATAN2(#0,#1)COSHCOSH(#0)SINHSINH(#0)TANTAN(#0)TANHTANH(#0)ACOSHACOSH(#0)ASINHASINH(#0)ATANHATANH(#0)GEOMEANEXP(AVG(LN(#0)))PRODUCT(CASE WHEN SUM(CASE WHEN #0=0 THEN 1 ELSE 0 END) > 0 THEN 0 ELSE (POWER(-1,SUM(CASE WHEN #0<0 THEN 1 END)))*EXP(SUM(LN(ABS(CASE WHEN #0<>0 THEN #0 ELSE NULL END)))) END) CEILINGCEILING(#0)DEGRESS(POWER(ASIN(1),(-1))*#0*90)FLOORFLOOR(#0)RADIANS(ASIN(1)*#0/90)TRUNCTRUNC(#0)Strategy Function NameSQL PatternINTCASE WHEN #0 > 0 THEN TRUNC(#0, 0) ELSE (TRUNC(#0, 0) - 1) ENDINT2(CASE WHEN (#0-CAST(#0 as integer)) >= 0 THEN CAST(#0 as integer) ELSE (CAST(#0 as integer) - 1) END)LOG(LN(#0)/LN(#1))QUOTIENTTRUNC((#0)/(CASE WHEN (#1)=0 THEN NULL ELSE(#1) END), 0)MOVINGCOUNTSUM(#0- #0+1) OVER(#1)MOVINGSTDEV(CASE WHEN SUM(#0 - #0 +1) OVER(#1)=1 THEN 0 ELSE   SQRT((SUM(#0*#0)   OVER(#1)-((SUM(#0) OVER(#1))/(SUM(#0-OVER(#1)*SUM(#0) OVER(#1))))/(SUM(#0- #0+1) OVER(#1)-1)) END)FISHER(LN((1+#0)/(1- #0))/2)INVERSEFISHER((EXP(2*#0)-1)/(EXP(2*#0)+1))PEARSON(((SUM(#0-#0+#1-#1+1)*SUM(#0*#1))-(SUM(#0)*SUM(#1)))/SQRT(((SUM(#0-#1+1)*SUM(#0*#0))-(SUM(#0)*SUM(#0)))*((SUM(#0-#1+1)*SUM(#1*#1))-(SUM(#1)*SUM(#1)))))STANDARDIZEcase when (#2 > 0) then (#0 - #1)/(#2) else NULL endRSQUAREREGR_R2(#0,#1)STEYXSQRT((1/(SUM(#1- #1+#0- #0+1)*(SUM(#1- #1+#0- #0+1)-2)))*((SUM(#1- #1+#0- #0+1)*SUM(#0*#0))- (SUM(#0)*SUM(#0))-((((SUM(#1- #0+1)*SUM(#1*#0))-(SUM(#1)*SUM(#0)))*((SUM(#1-#0+1)*SUM(#1*#0))-(SUM(#1)*SUM(#0))))/((SUM(#1-#0+1)*SUM(#1*#1))-(SUM(#1)*SUM(#1))))))GREATESTGREATEST(#0#<, #*#>)LEASTLEAST(#0#<, #*#>)CountryMetricCanada23Australia10United States50Estonia12
  Strategy Grandmaster Badges Receive a badge for being recognized as a Strategy Grandmaster. Former Strategy Grandmasters will also be recognized with an alumni badge. Community Influencer Badges Receive a badge for being recognized as a Community Influencer. Former Community Influencers will also be recognized with an alumni badge.     DossBoss Badge  Receive a badge for winning our monthly data visualization challenge, DossBoss. Learn more about the competition here.  MethodDescriptionTypeBottomLevelA bottom level specifies the lowest analysis level that the security filter is applied.IDSSDimtyExpressionSecurity filter.IDSSExpressionInfoThe IDSSObjectInfo interface for the MD security filter.IDSSObjectInfoPopulate ( object as IDSSMDSecurityFilter)Populate this filter's value from an existing MD security filter. RootA shortcut to Expression.Root.IDSSNodeTopLevelA top level specifies the highest analysis level that the security filter is applied without changing the dimensionality of metrics. IDSSDimtyStrategy Function NameSQL PatternABSABS(#0)COSCOS(#0)EXPEXP(#0)LNLN(#0)LOG10LOG(#0)POWERPOWER(#0, #1)ROUNDROUND(#0,0)ROUND2ROUND(#0, #1)SINSIN(#0)SQRTSQRT(#0)MOD((#0) MOD (#1))STDEVSTDDEV_SAMP(#0#< #*#>)VARVAR_SAMP(#0#< #*#>)STDEVPSTDDEV_POP(#0#< #*#>)VARPVAR_POP(#0#< #*#>)SKEWSKEW(#0#< #*#>)KURTOSISKURTOSIS(#0#< #*#>)Strategy Function NameSQL PatternCURRENTDATECURRENT_DATEDAYOFMONTHEXTRACT(DAY FROM #0)DAYOFWEEKTO_NUMBER(TO_CHAR(#0, 'D'))DAYOFYEARTO_NUMBER(TO_CHAR(#0, 'DDD'))WEEKTO_NUMBER(TO_CHAR(#0, 'WW'))MONTHEXTRACT(MONTH FROM #0)QUARTERTO_NUMBER(TO_CHAR(#0, 'Q'))YEAREXTRACT(YEAR FROM #0)CURRENTDATETIMELOCALTIMESTAMPCURRENTTIMELOCALTIMESTAMPHOURTO_NUMBER(TO_CHAR(#0, 'HH24'))MINUTETO_NUMBER(TO_CHAR(#0, 'MI')SECONDTO_NUMBER(TO_CHAR(#0, 'SS'))DATETRUNC(CAST(#0 AS DATE))DAYSBETWEENCAST(#1 AS DATE) - CAST(#0 AS DATE)MONTHSBETWEENFLOOR(MONTHS_BETWEEN(#1, #0))ADDDAYS(#0 + #1 * INTERVAL '1' DAY)ADDMONTHSADD_MONTHS(#0, Cast(#1 as Integer))MONTHSTARTDATETRUNC(ADD_MONTHS((LAST_DAY(#0) + 1), -1))MONTHENDDATETRUNC(LAST_DAY(#0))YEARSTARTDATEADD_MONTHS(TRUNC(#0) - EXTRACT(DAY FROM #0) + 1, 1 - EXTRACT(MONTH FROM #0))YEARENDDATEADD_MONTHS(TRUNC(#0) - EXTRACT(DAY FROM #0), 13 - EXTRACT(MONTH FROM #0))Strategy Function NameColumn NameRUNNINGAVGavg(#0) over(#1)RUNNINGMAXmax(#0) over(#1)RUNNINGMINmin(#0) over(#1)RUNNINGCOUNTcount(#0) over(#1)RUNNINGSUMsum(#0) over(#1)MOVINGAVGavg(#0) over(#1)MOVINGMAXmax(#0) over(#1)MOVINGMINmin(#0) over(#1)MOVINGSUMsum(#0) over(#1)Rank#0#,#<partition by#>#<#, #*#>#|rank over(#1#2#<,#*#> order by #0)COVARIANCECOVAR_POP(#0, #1)CORRELATIONCORR(#0, #1)SLOPEREGR_SLOPE(#0, #1)INTERCEPTREGR_INTERCEPT(#0, #1)BANDINGCase  when  (#0  between  #1  and  #2)  then cast((1.0*(#0- #1)/#3) +1 AS INTEGER) else 0 endBANDINGCCase when (#1=#2  and #0=#1) then #3  when (#0=#2) then #3 when (#0 between #1 and #2) then CAST(1.0*(#0- #1)/(#2- #1)*#3+1 AS INTEGER) else 0 endIF(Case when #0 then #1 else #2 end)RUNNINGSTDEVstddev_samp(#0) over(#1)RUNNINGSTDEVPstddev_pop(#0) over (#1)MOVINGSTDEVstddev_samp(#0) over(#1)MOVINGSTDEVPstddev_pop(#0) over(#1)OLAPSUMsum(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:nOLAPAVGavg(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:yOLAPCOUNTcount(#0#<   #*#>)  over  ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|N:y|R:yOLAPMAXmax(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:yOLAPMINmin(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:yLAGCASE  WHEN  count(*)  OVER  ([#P]  [#O]  rows between unbounded preceding and current row) <= #1 THEN #2 ELSE sum(#0#< #*#>) OVER ([#P][#O]  rows  between  #1  preceding  and  #1 preceding) END" OLAPDBPATTERN="P:o|O:rLEADCASE  WHEN  count(*)  OVER  ([#P]  [#O]  rows between current row and unbounded following)  <= #1 THEN #2 ELSE sum(#0#< #*#>) OVER ([#P] [#O] rows between #1 following and #1 following) END" OLAPDBPATTERN="P:o|O:rOLAPRANKrank() over ([#P] [#O])" OLAPDBPATTERN="P:o|O:rLAGlag(#0#<, #*#>) over ([#P][#O])" OLAPDBPATTERN="P:o|O:rLEADlead(#0#<, #*#>) over ([#P] [#O])" OLAPDBPATTERN="P:o|O:rOLAPRANKrank() over ([#P] [#O])" OLAPDBPATTERN="P:o|O:rMEDIANMEDIAN(#0)FIRST IN RANGEfirst_value(#0) over(#1)LAST IN RANGElast_value(#0) over(#1)Strategy Function NameSQL PatternACOSACOS(#0)ASINASIN(#0)ATANATAN(#0)ATAN2ATAN2(#0,#1)COSHCOSH(#0)SINHSINH(#0)TANTAN(#0)TANHTANH(#0)ACOSHACOSH(#0)ASINHASINH(#0)ATANHATANH(#0)GEOMEANEXP(AVG(LN(#0)))PRODUCT(CASE WHEN SUM(CASE WHEN #0=0 THEN 1 ELSE 0 END) > 0 THEN 0 ELSE (POWER(-1,SUM(CASE WHEN #0<0 THEN 1 END)))*EXP(SUM(LN(ABS(CASE WHEN #0<>0 THEN #0 ELSE NULL END)))) END) CEILINGCEILING(#0)DEGRESS(POWER(ASIN(1),(-1))*#0*90)FLOORFLOOR(#0)RADIANS(ASIN(1)*#0/90)TRUNCTRUNC(#0)Strategy Function NameSQL PatternINTCASE WHEN #0 > 0 THEN TRUNC(#0, 0) ELSE (TRUNC(#0, 0) - 1) ENDINT2(CASE WHEN (#0-CAST(#0 as integer)) >= 0 THEN CAST(#0 as integer) ELSE (CAST(#0 as integer) - 1) END)LOG(LN(#0)/LN(#1))QUOTIENTTRUNC((#0)/(CASE WHEN (#1)=0 THEN NULL ELSE(#1) END), 0)MOVINGCOUNTSUM(#0- #0+1) OVER(#1)MOVINGSTDEV(CASE WHEN SUM(#0 - #0 +1) OVER(#1)=1 THEN 0 ELSE   SQRT((SUM(#0*#0)   OVER(#1)-((SUM(#0) OVER(#1))/(SUM(#0-OVER(#1)*SUM(#0) OVER(#1))))/(SUM(#0- #0+1) OVER(#1)-1)) END)FISHER(LN((1+#0)/(1- #0))/2)INVERSEFISHER((EXP(2*#0)-1)/(EXP(2*#0)+1))PEARSON(((SUM(#0-#0+#1-#1+1)*SUM(#0*#1))-(SUM(#0)*SUM(#1)))/SQRT(((SUM(#0-#1+1)*SUM(#0*#0))-(SUM(#0)*SUM(#0)))*((SUM(#0-#1+1)*SUM(#1*#1))-(SUM(#1)*SUM(#1)))))STANDARDIZEcase when (#2 > 0) then (#0 - #1)/(#2) else NULL endRSQUAREREGR_R2(#0,#1)STEYXSQRT((1/(SUM(#1- #1+#0- #0+1)*(SUM(#1- #1+#0- #0+1)-2)))*((SUM(#1- #1+#0- #0+1)*SUM(#0*#0))- (SUM(#0)*SUM(#0))-((((SUM(#1- #0+1)*SUM(#1*#0))-(SUM(#1)*SUM(#0)))*((SUM(#1-#0+1)*SUM(#1*#0))-(SUM(#1)*SUM(#0))))/((SUM(#1-#0+1)*SUM(#1*#1))-(SUM(#1)*SUM(#1))))))GREATESTGREATEST(#0#<, #*#>)LEASTLEAST(#0#<, #*#>)CountryMetricCanada23Australia10United States50Estonia12	Strategy Grandmaster Badges Receive a badge for being recognized as a Strategy Grandmaster. Former Strategy Grandmasters will also be recognized with an alumni badge. Community Influencer Badges Receive a badge for being recognized as a Community Influencer. Former Community Influencers will also be recognized with an alumni badge.     DossBoss Badge  Receive a badge for winning our monthly data visualization challenge, DossBoss. Learn more about the competition here.  MethodDescriptionTypeBottomLevelA bottom level specifies the lowest analysis level that the security filter is applied.IDSSDimtyExpressionSecurity filter.IDSSExpressionInfoThe IDSSObjectInfo interface for the MD security filter.IDSSObjectInfoPopulate ( object as IDSSMDSecurityFilter)Populate this filter's value from an existing MD security filter. RootA shortcut to Expression.Root.IDSSNodeTopLevelA top level specifies the highest analysis level that the security filter is applied without changing the dimensionality of metrics. IDSSDimtyStrategy Function NameSQL PatternABSABS(#0)COSCOS(#0)EXPEXP(#0)LNLN(#0)LOG10LOG(#0)POWERPOWER(#0, #1)ROUNDROUND(#0,0)ROUND2ROUND(#0, #1)SINSIN(#0)SQRTSQRT(#0)MOD((#0) MOD (#1))STDEVSTDDEV_SAMP(#0#< #*#>)VARVAR_SAMP(#0#< #*#>)STDEVPSTDDEV_POP(#0#< #*#>)VARPVAR_POP(#0#< #*#>)SKEWSKEW(#0#< #*#>)KURTOSISKURTOSIS(#0#< #*#>)Strategy Function NameSQL PatternCURRENTDATECURRENT_DATEDAYOFMONTHEXTRACT(DAY FROM #0)DAYOFWEEKTO_NUMBER(TO_CHAR(#0, 'D'))DAYOFYEARTO_NUMBER(TO_CHAR(#0, 'DDD'))WEEKTO_NUMBER(TO_CHAR(#0, 'WW'))MONTHEXTRACT(MONTH FROM #0)QUARTERTO_NUMBER(TO_CHAR(#0, 'Q'))YEAREXTRACT(YEAR FROM #0)CURRENTDATETIMELOCALTIMESTAMPCURRENTTIMELOCALTIMESTAMPHOURTO_NUMBER(TO_CHAR(#0, 'HH24'))MINUTETO_NUMBER(TO_CHAR(#0, 'MI')SECONDTO_NUMBER(TO_CHAR(#0, 'SS'))DATETRUNC(CAST(#0 AS DATE))DAYSBETWEENCAST(#1 AS DATE) - CAST(#0 AS DATE)MONTHSBETWEENFLOOR(MONTHS_BETWEEN(#1, #0))ADDDAYS(#0 + #1 * INTERVAL '1' DAY)ADDMONTHSADD_MONTHS(#0, Cast(#1 as Integer))MONTHSTARTDATETRUNC(ADD_MONTHS((LAST_DAY(#0) + 1), -1))MONTHENDDATETRUNC(LAST_DAY(#0))YEARSTARTDATEADD_MONTHS(TRUNC(#0) - EXTRACT(DAY FROM #0) + 1, 1 - EXTRACT(MONTH FROM #0))YEARENDDATEADD_MONTHS(TRUNC(#0) - EXTRACT(DAY FROM #0), 13 - EXTRACT(MONTH FROM #0))Strategy Function NameColumn NameRUNNINGAVGavg(#0) over(#1)RUNNINGMAXmax(#0) over(#1)RUNNINGMINmin(#0) over(#1)RUNNINGCOUNTcount(#0) over(#1)RUNNINGSUMsum(#0) over(#1)MOVINGAVGavg(#0) over(#1)MOVINGMAXmax(#0) over(#1)MOVINGMINmin(#0) over(#1)MOVINGSUMsum(#0) over(#1)Rank#0#,#<partition by#>#<#, #*#>#|rank over(#1#2#<,#*#> order by #0)COVARIANCECOVAR_POP(#0, #1)CORRELATIONCORR(#0, #1)SLOPEREGR_SLOPE(#0, #1)INTERCEPTREGR_INTERCEPT(#0, #1)BANDINGCase  when  (#0  between  #1  and  #2)  then cast((1.0*(#0- #1)/#3) +1 AS INTEGER) else 0 endBANDINGCCase when (#1=#2  and #0=#1) then #3  when (#0=#2) then #3 when (#0 between #1 and #2) then CAST(1.0*(#0- #1)/(#2- #1)*#3+1 AS INTEGER) else 0 endIF(Case when #0 then #1 else #2 end)RUNNINGSTDEVstddev_samp(#0) over(#1)RUNNINGSTDEVPstddev_pop(#0) over (#1)MOVINGSTDEVstddev_samp(#0) over(#1)MOVINGSTDEVPstddev_pop(#0) over(#1)OLAPSUMsum(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:nOLAPAVGavg(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:yOLAPCOUNTcount(#0#<   #*#>)  over  ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|N:y|R:yOLAPMAXmax(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:yOLAPMINmin(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:yLAGCASE  WHEN  count(*)  OVER  ([#P]  [#O]  rows between unbounded preceding and current row) <= #1 THEN #2 ELSE sum(#0#< #*#>) OVER ([#P][#O]  rows  between  #1  preceding  and  #1 preceding) END" OLAPDBPATTERN="P:o|O:rLEADCASE  WHEN  count(*)  OVER  ([#P]  [#O]  rows between current row and unbounded following)  <= #1 THEN #2 ELSE sum(#0#< #*#>) OVER ([#P] [#O] rows between #1 following and #1 following) END" OLAPDBPATTERN="P:o|O:rOLAPRANKrank() over ([#P] [#O])" OLAPDBPATTERN="P:o|O:rLAGlag(#0#<, #*#>) over ([#P][#O])" OLAPDBPATTERN="P:o|O:rLEADlead(#0#<, #*#>) over ([#P] [#O])" OLAPDBPATTERN="P:o|O:rOLAPRANKrank() over ([#P] [#O])" OLAPDBPATTERN="P:o|O:rMEDIANMEDIAN(#0)FIRST IN RANGEfirst_value(#0) over(#1)LAST IN RANGElast_value(#0) over(#1)Strategy Function NameSQL PatternACOSACOS(#0)ASINASIN(#0)ATANATAN(#0)ATAN2ATAN2(#0,#1)COSHCOSH(#0)SINHSINH(#0)TANTAN(#0)TANHTANH(#0)ACOSHACOSH(#0)ASINHASINH(#0)ATANHATANH(#0)GEOMEANEXP(AVG(LN(#0)))PRODUCT(CASE WHEN SUM(CASE WHEN #0=0 THEN 1 ELSE 0 END) > 0 THEN 0 ELSE (POWER(-1,SUM(CASE WHEN #0<0 THEN 1 END)))*EXP(SUM(LN(ABS(CASE WHEN #0<>0 THEN #0 ELSE NULL END)))) END) CEILINGCEILING(#0)DEGRESS(POWER(ASIN(1),(-1))*#0*90)FLOORFLOOR(#0)RADIANS(ASIN(1)*#0/90)TRUNCTRUNC(#0)Strategy Function NameSQL PatternINTCASE WHEN #0 > 0 THEN TRUNC(#0, 0) ELSE (TRUNC(#0, 0) - 1) ENDINT2(CASE WHEN (#0-CAST(#0 as integer)) >= 0 THEN CAST(#0 as integer) ELSE (CAST(#0 as integer) - 1) END)LOG(LN(#0)/LN(#1))QUOTIENTTRUNC((#0)/(CASE WHEN (#1)=0 THEN NULL ELSE(#1) END), 0)MOVINGCOUNTSUM(#0- #0+1) OVER(#1)MOVINGSTDEV(CASE WHEN SUM(#0 - #0 +1) OVER(#1)=1 THEN 0 ELSE   SQRT((SUM(#0*#0)   OVER(#1)-((SUM(#0) OVER(#1))/(SUM(#0-OVER(#1)*SUM(#0) OVER(#1))))/(SUM(#0- #0+1) OVER(#1)-1)) END)FISHER(LN((1+#0)/(1- #0))/2)INVERSEFISHER((EXP(2*#0)-1)/(EXP(2*#0)+1))PEARSON(((SUM(#0-#0+#1-#1+1)*SUM(#0*#1))-(SUM(#0)*SUM(#1)))/SQRT(((SUM(#0-#1+1)*SUM(#0*#0))-(SUM(#0)*SUM(#0)))*((SUM(#0-#1+1)*SUM(#1*#1))-(SUM(#1)*SUM(#1)))))STANDARDIZEcase when (#2 > 0) then (#0 - #1)/(#2) else NULL endRSQUAREREGR_R2(#0,#1)STEYXSQRT((1/(SUM(#1- #1+#0- #0+1)*(SUM(#1- #1+#0- #0+1)-2)))*((SUM(#1- #1+#0- #0+1)*SUM(#0*#0))- (SUM(#0)*SUM(#0))-((((SUM(#1- #0+1)*SUM(#1*#0))-(SUM(#1)*SUM(#0)))*((SUM(#1-#0+1)*SUM(#1*#0))-(SUM(#1)*SUM(#0))))/((SUM(#1-#0+1)*SUM(#1*#1))-(SUM(#1)*SUM(#1))))))GREATESTGREATEST(#0#<, #*#>)LEASTLEAST(#0#<, #*#>)CountryMetricCanada23Australia10United States50Estonia12
  Strategy Grandmaster Badges Receive a badge for being recognized as a Strategy Grandmaster. Former Strategy Grandmasters will also be recognized with an alumni badge. Community Influencer Badges Receive a badge for being recognized as a Community Influencer. Former Community Influencers will also be recognized with an alumni badge.     DossBoss Badge  Receive a badge for winning our monthly data visualization challenge, DossBoss. Learn more about the competition here.  MethodDescriptionTypeBottomLevelA bottom level specifies the lowest analysis level that the security filter is applied.IDSSDimtyExpressionSecurity filter.IDSSExpressionInfoThe IDSSObjectInfo interface for the MD security filter.IDSSObjectInfoPopulate ( object as IDSSMDSecurityFilter)Populate this filter's value from an existing MD security filter. RootA shortcut to Expression.Root.IDSSNodeTopLevelA top level specifies the highest analysis level that the security filter is applied without changing the dimensionality of metrics. IDSSDimtyStrategy Function NameSQL PatternABSABS(#0)COSCOS(#0)EXPEXP(#0)LNLN(#0)LOG10LOG(#0)POWERPOWER(#0, #1)ROUNDROUND(#0,0)ROUND2ROUND(#0, #1)SINSIN(#0)SQRTSQRT(#0)MOD((#0) MOD (#1))STDEVSTDDEV_SAMP(#0#< #*#>)VARVAR_SAMP(#0#< #*#>)STDEVPSTDDEV_POP(#0#< #*#>)VARPVAR_POP(#0#< #*#>)SKEWSKEW(#0#< #*#>)KURTOSISKURTOSIS(#0#< #*#>)Strategy Function NameSQL PatternCURRENTDATECURRENT_DATEDAYOFMONTHEXTRACT(DAY FROM #0)DAYOFWEEKTO_NUMBER(TO_CHAR(#0, 'D'))DAYOFYEARTO_NUMBER(TO_CHAR(#0, 'DDD'))WEEKTO_NUMBER(TO_CHAR(#0, 'WW'))MONTHEXTRACT(MONTH FROM #0)QUARTERTO_NUMBER(TO_CHAR(#0, 'Q'))YEAREXTRACT(YEAR FROM #0)CURRENTDATETIMELOCALTIMESTAMPCURRENTTIMELOCALTIMESTAMPHOURTO_NUMBER(TO_CHAR(#0, 'HH24'))MINUTETO_NUMBER(TO_CHAR(#0, 'MI')SECONDTO_NUMBER(TO_CHAR(#0, 'SS'))DATETRUNC(CAST(#0 AS DATE))DAYSBETWEENCAST(#1 AS DATE) - CAST(#0 AS DATE)MONTHSBETWEENFLOOR(MONTHS_BETWEEN(#1, #0))ADDDAYS(#0 + #1 * INTERVAL '1' DAY)ADDMONTHSADD_MONTHS(#0, Cast(#1 as Integer))MONTHSTARTDATETRUNC(ADD_MONTHS((LAST_DAY(#0) + 1), -1))MONTHENDDATETRUNC(LAST_DAY(#0))YEARSTARTDATEADD_MONTHS(TRUNC(#0) - EXTRACT(DAY FROM #0) + 1, 1 - EXTRACT(MONTH FROM #0))YEARENDDATEADD_MONTHS(TRUNC(#0) - EXTRACT(DAY FROM #0), 13 - EXTRACT(MONTH FROM #0))Strategy Function NameColumn NameRUNNINGAVGavg(#0) over(#1)RUNNINGMAXmax(#0) over(#1)RUNNINGMINmin(#0) over(#1)RUNNINGCOUNTcount(#0) over(#1)RUNNINGSUMsum(#0) over(#1)MOVINGAVGavg(#0) over(#1)MOVINGMAXmax(#0) over(#1)MOVINGMINmin(#0) over(#1)MOVINGSUMsum(#0) over(#1)Rank#0#,#<partition by#>#<#, #*#>#|rank over(#1#2#<,#*#> order by #0)COVARIANCECOVAR_POP(#0, #1)CORRELATIONCORR(#0, #1)SLOPEREGR_SLOPE(#0, #1)INTERCEPTREGR_INTERCEPT(#0, #1)BANDINGCase  when  (#0  between  #1  and  #2)  then cast((1.0*(#0- #1)/#3) +1 AS INTEGER) else 0 endBANDINGCCase when (#1=#2  and #0=#1) then #3  when (#0=#2) then #3 when (#0 between #1 and #2) then CAST(1.0*(#0- #1)/(#2- #1)*#3+1 AS INTEGER) else 0 endIF(Case when #0 then #1 else #2 end)RUNNINGSTDEVstddev_samp(#0) over(#1)RUNNINGSTDEVPstddev_pop(#0) over (#1)MOVINGSTDEVstddev_samp(#0) over(#1)MOVINGSTDEVPstddev_pop(#0) over(#1)OLAPSUMsum(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:nOLAPAVGavg(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:yOLAPCOUNTcount(#0#<   #*#>)  over  ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|N:y|R:yOLAPMAXmax(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:yOLAPMINmin(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:yLAGCASE  WHEN  count(*)  OVER  ([#P]  [#O]  rows between unbounded preceding and current row) <= #1 THEN #2 ELSE sum(#0#< #*#>) OVER ([#P][#O]  rows  between  #1  preceding  and  #1 preceding) END" OLAPDBPATTERN="P:o|O:rLEADCASE  WHEN  count(*)  OVER  ([#P]  [#O]  rows between current row and unbounded following)  <= #1 THEN #2 ELSE sum(#0#< #*#>) OVER ([#P] [#O] rows between #1 following and #1 following) END" OLAPDBPATTERN="P:o|O:rOLAPRANKrank() over ([#P] [#O])" OLAPDBPATTERN="P:o|O:rLAGlag(#0#<, #*#>) over ([#P][#O])" OLAPDBPATTERN="P:o|O:rLEADlead(#0#<, #*#>) over ([#P] [#O])" OLAPDBPATTERN="P:o|O:rOLAPRANKrank() over ([#P] [#O])" OLAPDBPATTERN="P:o|O:rMEDIANMEDIAN(#0)FIRST IN RANGEfirst_value(#0) over(#1)LAST IN RANGElast_value(#0) over(#1)Strategy Function NameSQL PatternACOSACOS(#0)ASINASIN(#0)ATANATAN(#0)ATAN2ATAN2(#0,#1)COSHCOSH(#0)SINHSINH(#0)TANTAN(#0)TANHTANH(#0)ACOSHACOSH(#0)ASINHASINH(#0)ATANHATANH(#0)GEOMEANEXP(AVG(LN(#0)))PRODUCT(CASE WHEN SUM(CASE WHEN #0=0 THEN 1 ELSE 0 END) > 0 THEN 0 ELSE (POWER(-1,SUM(CASE WHEN #0<0 THEN 1 END)))*EXP(SUM(LN(ABS(CASE WHEN #0<>0 THEN #0 ELSE NULL END)))) END) CEILINGCEILING(#0)DEGRESS(POWER(ASIN(1),(-1))*#0*90)FLOORFLOOR(#0)RADIANS(ASIN(1)*#0/90)TRUNCTRUNC(#0)Strategy Function NameSQL PatternINTCASE WHEN #0 > 0 THEN TRUNC(#0, 0) ELSE (TRUNC(#0, 0) - 1) ENDINT2(CASE WHEN (#0-CAST(#0 as integer)) >= 0 THEN CAST(#0 as integer) ELSE (CAST(#0 as integer) - 1) END)LOG(LN(#0)/LN(#1))QUOTIENTTRUNC((#0)/(CASE WHEN (#1)=0 THEN NULL ELSE(#1) END), 0)MOVINGCOUNTSUM(#0- #0+1) OVER(#1)MOVINGSTDEV(CASE WHEN SUM(#0 - #0 +1) OVER(#1)=1 THEN 0 ELSE   SQRT((SUM(#0*#0)   OVER(#1)-((SUM(#0) OVER(#1))/(SUM(#0-OVER(#1)*SUM(#0) OVER(#1))))/(SUM(#0- #0+1) OVER(#1)-1)) END)FISHER(LN((1+#0)/(1- #0))/2)INVERSEFISHER((EXP(2*#0)-1)/(EXP(2*#0)+1))PEARSON(((SUM(#0-#0+#1-#1+1)*SUM(#0*#1))-(SUM(#0)*SUM(#1)))/SQRT(((SUM(#0-#1+1)*SUM(#0*#0))-(SUM(#0)*SUM(#0)))*((SUM(#0-#1+1)*SUM(#1*#1))-(SUM(#1)*SUM(#1)))))STANDARDIZEcase when (#2 > 0) then (#0 - #1)/(#2) else NULL endRSQUAREREGR_R2(#0,#1)STEYXSQRT((1/(SUM(#1- #1+#0- #0+1)*(SUM(#1- #1+#0- #0+1)-2)))*((SUM(#1- #1+#0- #0+1)*SUM(#0*#0))- (SUM(#0)*SUM(#0))-((((SUM(#1- #0+1)*SUM(#1*#0))-(SUM(#1)*SUM(#0)))*((SUM(#1-#0+1)*SUM(#1*#0))-(SUM(#1)*SUM(#0))))/((SUM(#1-#0+1)*SUM(#1*#1))-(SUM(#1)*SUM(#1))))))GREATESTGREATEST(#0#<, #*#>)LEASTLEAST(#0#<, #*#>)CountryMetricCanada23Australia10United States50Estonia12	Strategy Grandmaster Badges Receive a badge for being recognized as a Strategy Grandmaster. Former Strategy Grandmasters will also be recognized with an alumni badge. Community Influencer Badges Receive a badge for being recognized as a Community Influencer. Former Community Influencers will also be recognized with an alumni badge.     DossBoss Badge  Receive a badge for winning our monthly data visualization challenge, DossBoss. Learn more about the competition here.  MethodDescriptionTypeBottomLevelA bottom level specifies the lowest analysis level that the security filter is applied.IDSSDimtyExpressionSecurity filter.IDSSExpressionInfoThe IDSSObjectInfo interface for the MD security filter.IDSSObjectInfoPopulate ( object as IDSSMDSecurityFilter)Populate this filter's value from an existing MD security filter. RootA shortcut to Expression.Root.IDSSNodeTopLevelA top level specifies the highest analysis level that the security filter is applied without changing the dimensionality of metrics. IDSSDimtyStrategy Function NameSQL PatternABSABS(#0)COSCOS(#0)EXPEXP(#0)LNLN(#0)LOG10LOG(#0)POWERPOWER(#0, #1)ROUNDROUND(#0,0)ROUND2ROUND(#0, #1)SINSIN(#0)SQRTSQRT(#0)MOD((#0) MOD (#1))STDEVSTDDEV_SAMP(#0#< #*#>)VARVAR_SAMP(#0#< #*#>)STDEVPSTDDEV_POP(#0#< #*#>)VARPVAR_POP(#0#< #*#>)SKEWSKEW(#0#< #*#>)KURTOSISKURTOSIS(#0#< #*#>)Strategy Function NameSQL PatternCURRENTDATECURRENT_DATEDAYOFMONTHEXTRACT(DAY FROM #0)DAYOFWEEKTO_NUMBER(TO_CHAR(#0, 'D'))DAYOFYEARTO_NUMBER(TO_CHAR(#0, 'DDD'))WEEKTO_NUMBER(TO_CHAR(#0, 'WW'))MONTHEXTRACT(MONTH FROM #0)QUARTERTO_NUMBER(TO_CHAR(#0, 'Q'))YEAREXTRACT(YEAR FROM #0)CURRENTDATETIMELOCALTIMESTAMPCURRENTTIMELOCALTIMESTAMPHOURTO_NUMBER(TO_CHAR(#0, 'HH24'))MINUTETO_NUMBER(TO_CHAR(#0, 'MI')SECONDTO_NUMBER(TO_CHAR(#0, 'SS'))DATETRUNC(CAST(#0 AS DATE))DAYSBETWEENCAST(#1 AS DATE) - CAST(#0 AS DATE)MONTHSBETWEENFLOOR(MONTHS_BETWEEN(#1, #0))ADDDAYS(#0 + #1 * INTERVAL '1' DAY)ADDMONTHSADD_MONTHS(#0, Cast(#1 as Integer))MONTHSTARTDATETRUNC(ADD_MONTHS((LAST_DAY(#0) + 1), -1))MONTHENDDATETRUNC(LAST_DAY(#0))YEARSTARTDATEADD_MONTHS(TRUNC(#0) - EXTRACT(DAY FROM #0) + 1, 1 - EXTRACT(MONTH FROM #0))YEARENDDATEADD_MONTHS(TRUNC(#0) - EXTRACT(DAY FROM #0), 13 - EXTRACT(MONTH FROM #0))Strategy Function NameColumn NameRUNNINGAVGavg(#0) over(#1)RUNNINGMAXmax(#0) over(#1)RUNNINGMINmin(#0) over(#1)RUNNINGCOUNTcount(#0) over(#1)RUNNINGSUMsum(#0) over(#1)MOVINGAVGavg(#0) over(#1)MOVINGMAXmax(#0) over(#1)MOVINGMINmin(#0) over(#1)MOVINGSUMsum(#0) over(#1)Rank#0#,#<partition by#>#<#, #*#>#|rank over(#1#2#<,#*#> order by #0)COVARIANCECOVAR_POP(#0, #1)CORRELATIONCORR(#0, #1)SLOPEREGR_SLOPE(#0, #1)INTERCEPTREGR_INTERCEPT(#0, #1)BANDINGCase  when  (#0  between  #1  and  #2)  then cast((1.0*(#0- #1)/#3) +1 AS INTEGER) else 0 endBANDINGCCase when (#1=#2  and #0=#1) then #3  when (#0=#2) then #3 when (#0 between #1 and #2) then CAST(1.0*(#0- #1)/(#2- #1)*#3+1 AS INTEGER) else 0 endIF(Case when #0 then #1 else #2 end)RUNNINGSTDEVstddev_samp(#0) over(#1)RUNNINGSTDEVPstddev_pop(#0) over (#1)MOVINGSTDEVstddev_samp(#0) over(#1)MOVINGSTDEVPstddev_pop(#0) over(#1)OLAPSUMsum(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:nOLAPAVGavg(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:yOLAPCOUNTcount(#0#<   #*#>)  over  ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|N:y|R:yOLAPMAXmax(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:yOLAPMINmin(#0#<   #*#>)   over   ([#P]   [#O]   [#W])" OLAPDBPATTERN="P:o|O:o|W:o|D:n|R:yLAGCASE  WHEN  count(*)  OVER  ([#P]  [#O]  rows between unbounded preceding and current row) <= #1 THEN #2 ELSE sum(#0#< #*#>) OVER ([#P][#O]  rows  between  #1  preceding  and  #1 preceding) END" OLAPDBPATTERN="P:o|O:rLEADCASE  WHEN  count(*)  OVER  ([#P]  [#O]  rows between current row and unbounded following)  <= #1 THEN #2 ELSE sum(#0#< #*#>) OVER ([#P] [#O] rows between #1 following and #1 following) END" OLAPDBPATTERN="P:o|O:rOLAPRANKrank() over ([#P] [#O])" OLAPDBPATTERN="P:o|O:rLAGlag(#0#<, #*#>) over ([#P][#O])" OLAPDBPATTERN="P:o|O:rLEADlead(#0#<, #*#>) over ([#P] [#O])" OLAPDBPATTERN="P:o|O:rOLAPRANKrank() over ([#P] [#O])" OLAPDBPATTERN="P:o|O:rMEDIANMEDIAN(#0)FIRST IN RANGEfirst_value(#0) over(#1)LAST IN RANGElast_value(#0) over(#1)Strategy Function NameSQL PatternACOSACOS(#0)ASINASIN(#0)ATANATAN(#0)ATAN2ATAN2(#0,#1)COSHCOSH(#0)SINHSINH(#0)TANTAN(#0)TANHTANH(#0)ACOSHACOSH(#0)ASINHASINH(#0)ATANHATANH(#0)GEOMEANEXP(AVG(LN(#0)))PRODUCT(CASE WHEN SUM(CASE WHEN #0=0 THEN 1 ELSE 0 END) > 0 THEN 0 ELSE (POWER(-1,SUM(CASE WHEN #0<0 THEN 1 END)))*EXP(SUM(LN(ABS(CASE WHEN #0<>0 THEN #0 ELSE NULL END)))) END) CEILINGCEILING(#0)DEGRESS(POWER(ASIN(1),(-1))*#0*90)FLOORFLOOR(#0)RADIANS(ASIN(1)*#0/90)TRUNCTRUNC(#0)Strategy Function NameSQL PatternINTCASE WHEN #0 > 0 THEN TRUNC(#0, 0) ELSE (TRUNC(#0, 0) - 1) ENDINT2(CASE WHEN (#0-CAST(#0 as integer)) >= 0 THEN CAST(#0 as integer) ELSE (CAST(#0 as integer) - 1) END)LOG(LN(#0)/LN(#1))QUOTIENTTRUNC((#0)/(CASE WHEN (#1)=0 THEN NULL ELSE(#1) END), 0)MOVINGCOUNTSUM(#0- #0+1) OVER(#1)MOVINGSTDEV(CASE WHEN SUM(#0 - #0 +1) OVER(#1)=1 THEN 0 ELSE   SQRT((SUM(#0*#0)   OVER(#1)-((SUM(#0) OVER(#1))/(SUM(#0-OVER(#1)*SUM(#0) OVER(#1))))/(SUM(#0- #0+1) OVER(#1)-1)) END)FISHER(LN((1+#0)/(1- #0))/2)INVERSEFISHER((EXP(2*#0)-1)/(EXP(2*#0)+1))PEARSON(((SUM(#0-#0+#1-#1+1)*SUM(#0*#1))-(SUM(#0)*SUM(#1)))/SQRT(((SUM(#0-#1+1)*SUM(#0*#0))-(SUM(#0)*SUM(#0)))*((SUM(#0-#1+1)*SUM(#1*#1))-(SUM(#1)*SUM(#1)))))STANDARDIZEcase when (#2 > 0) then (#0 - #1)/(#2) else NULL endRSQUAREREGR_R2(#0,#1)STEYXSQRT((1/(SUM(#1- #1+#0- #0+1)*(SUM(#1- #1+#0- #0+1)-2)))*((SUM(#1- #1+#0- #0+1)*SUM(#0*#0))- (SUM(#0)*SUM(#0))-((((SUM(#1- #0+1)*SUM(#1*#0))-(SUM(#1)*SUM(#0)))*((SUM(#1-#0+1)*SUM(#1*#0))-(SUM(#1)*SUM(#0))))/((SUM(#1-#0+1)*SUM(#1*#1))-(SUM(#1)*SUM(#1))))))GREATESTGREATEST(#0#<, #*#>)LEASTLEAST(#0#<, #*#>)CountryMetricCanada23Australia10United States50Estonia12

  
   
  
• Use Data Import to convert the Excel file into a cube.
• Create a document based on the cube, and add Country and Metric to the grid in the document.
• Configure the grid as an Image Layout widget, like shown below.
   
  

• Access the widget properties and make sure "Countries of the world" is the map selected.
   
  
• View the document in Interactive mode. Notice that there is no marker on United States.

 
 
CAUSE:
 
The WorldImageMapCoords.html file (located in C:\Program Files (x86)\Strategy\Web ASPx\VisFramework\map) not only defines the areas of the image that belong to each of the countries of the world but also defines how they are referred to. In this file, United States is referred to as "USA" and not as "United States", as shown below in the ALT variable.
Sample Code/Error

<MAP NAME="World">
<AREA SHAPE="POLY" ALT="USA" COORDS= ...

1. Modify the corresponding shape file with a text editor, replacing the polygon name with the name of the attribute element in the data warehouse.
   Note: Following best practices, save a backup of the original file before modifying.
   In the above example, modify the WorldImageMapCoords.html and replace "USA" with "United States" as shown below:
   
   Sample Code/Error
   
   

   
   <MAP NAME="World">
   <AREA SHAPE="POLY" ALT="United States" COORDS=

   
   
   
    
   And clear the browser caches, so the browser can request the newly modified html file.
   
2. Access the corresponding shape file and change the values in the data warehouse tables to match the polygon names listed in the shape file. Then clear the report caches.