このページでは、モデルに関する仕様をご覧いただけます。メンテナンスとファクト テーブル:資産の健全性の測定値。
| 属性 | 説明 (該当する場合) |
明示的に記載されていない場合、測定値の集計は SUM に基づきます。
このセクションでは、キューブ内の基本的な測定値について説明します。これらは、コア情報ソース、モデル自体、または ETL プロセスで定義された測定値です。列には次の意味があります。
| メジャー | 計算済み Y/N: | タイム インテリジェンス Y/N を含む | 定義/注記 (該当する場合) | 集計タイプ | 非表示 Y/N | 表形式 |
| AHAvg | N | IF(ISBLANK(AVERAGE('ASSET HEALTH'[Asset Health])), "", AVERAGE('ASSET HEALTH'[Asset Health])) | ||||
| AVGHealthColor | N | IF(ISFILTERED('ASSET TYPE'[Asset Type]) && HASONEVALUE('ASSET HEALTH'[Object Type]) , IF([Average_Type] <= CALCULATE(FIRSTNONBLANK('ASSET HEALTH LEVEL'[IntervalMax],1)/100, filter(all('ASSET HEALTH LEVEL'),'ASSET HEALTH LEVEL'[Obj Type] = SELECTEDVALUE('ASSET TYPE'[Asset Type]) && 'ASSET HEALTH LEVEL'[Level] = "Critical")), "#9D1C40", IF([Average_Type] <= CALCULATE(FIRSTNONBLANK('ASSET HEALTH LEVEL'[IntervalMax],1)/100, filter(all('ASSET HEALTH LEVEL'),'ASSET HEALTH LEVEL'[Obj Type] = SELECTEDVALUE('ASSET TYPE'[Asset Type]) && 'ASSET HEALTH LEVEL'[Level] = "Poor")), "#F09E57", IF([Average_Type] <= CALCULATE(FIRSTNONBLANK('ASSET HEALTH LEVEL'[IntervalMax],1)/100, filter(all('ASSET HEALTH LEVEL'),'ASSET HEALTH LEVEL'[Obj Type] = SELECTEDVALUE('ASSET TYPE'[Asset Type]) && 'ASSET HEALTH LEVEL'[Level] = "Fair")), "#F2D478", IF([Average_Type] <= CALCULATE(FIRSTNONBLANK('ASSET HEALTH LEVEL'[IntervalMax],1)/100, filter(all('ASSET HEALTH LEVEL'),'ASSET HEALTH LEVEL'[Obj Type] = SELECTEDVALUE('ASSET TYPE'[Asset Type]) && 'ASSET HEALTH LEVEL'[Level] = "Good")), "#8DD382", IF([Average_Type] <= CALCULATE(FIRSTNONBLANK('ASSET HEALTH LEVEL'[IntervalMax],1)/100, filter(all('ASSET HEALTH LEVEL'),'ASSET HEALTH LEVEL'[Obj Type] = SELECTEDVALUE('ASSET TYPE'[Asset Type]) && 'ASSET HEALTH LEVEL'[Level] = "Excellent")), "#36775C", IF([Average_Type] <= 0.20, "#9D1C40", IF([Average_Type] <= 0.40, "#F09E57", IF([Average_Type] <= 0.60, "#F2D478", IF([Average_Type] <= 0.80, "#8DD382", IF([Average_Type] <= 1, "#36775C" ))))) ))))), IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= 0.20, "#9D1C40", IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= 0.40, "#F09E57", IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= 0.60, "#F2D478", IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= 0.80, "#8DD382", IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= 1, "#36775C" )))))) | ||||
| AverageHealthLevel | N | IF(ISFILTERED('ASSET TYPE'[Asset Type]), IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= CALCULATE(FIRSTNONBLANK('ASSET HEALTH LEVEL'[IntervalMax],1)/100, filter(all('ASSET HEALTH LEVEL'),'ASSET HEALTH LEVEL'[Obj Type] = SELECTEDVALUE('ASSET TYPE'[Asset Type]) && 'ASSET HEALTH LEVEL'[Level] = "Critical")), "Critical", IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= CALCULATE(FIRSTNONBLANK('ASSET HEALTH LEVEL'[IntervalMax],1)/100, filter(all('ASSET HEALTH LEVEL'),'ASSET HEALTH LEVEL'[Obj Type] = SELECTEDVALUE('ASSET TYPE'[Asset Type]) && 'ASSET HEALTH LEVEL'[Level] = "Poor")), "Poor", IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= CALCULATE(FIRSTNONBLANK('ASSET HEALTH LEVEL'[IntervalMax],1)/100, filter(all('ASSET HEALTH LEVEL'),'ASSET HEALTH LEVEL'[Obj Type] = SELECTEDVALUE('ASSET TYPE'[Asset Type]) && 'ASSET HEALTH LEVEL'[Level] = "Fair")), "Fair", IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= CALCULATE(FIRSTNONBLANK('ASSET HEALTH LEVEL'[IntervalMax],1)/100, filter(all('ASSET HEALTH LEVEL'),'ASSET HEALTH LEVEL'[Obj Type] = SELECTEDVALUE('ASSET TYPE'[Asset Type]) && 'ASSET HEALTH LEVEL'[Level] = "Good")), "Good", IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= CALCULATE(FIRSTNONBLANK('ASSET HEALTH LEVEL'[IntervalMax],1)/100, filter(all('ASSET HEALTH LEVEL'),'ASSET HEALTH LEVEL'[Obj Type] = SELECTEDVALUE('ASSET TYPE'[Asset Type]) && 'ASSET HEALTH LEVEL'[Level] = "Excellent")), "Excellent", IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= 0.20, "Critical", IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= 0.40, "Poor", IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= 0.60, "Fair", IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= 0.80, "Good", IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= 1, "Excellent" )))))))))), //Defaulting IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= 0.20, "Critical", IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= 0.40, "Poor", IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= 0.60, "Fair", IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= 0.80, "Good", IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= 1, "Excellent" )))))) | ||||
| AverageHealth_Type | N | IF(HASONEVALUE('ASSET HEALTH'[Object Type]), [Average_Type], AVERAGE('ASSET HEALTH'[Asset Health])) | ||||
| AverageLevel | N | IF(ISFILTERED('ASSET TYPE'[Asset Type]), IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= CALCULATE(FIRSTNONBLANK('ASSET HEALTH LEVEL'[IntervalMax],1)/100, filter(all('ASSET HEALTH LEVEL'),'ASSET HEALTH LEVEL'[Obj Type] = SELECTEDVALUE('ASSET TYPE'[Asset Type]) && 'ASSET HEALTH LEVEL'[Level] = "Critical")), "#9D1C40", IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= CALCULATE(FIRSTNONBLANK('ASSET HEALTH LEVEL'[IntervalMax],1)/100, filter(all('ASSET HEALTH LEVEL'),'ASSET HEALTH LEVEL'[Obj Type] = SELECTEDVALUE('ASSET TYPE'[Asset Type]) && 'ASSET HEALTH LEVEL'[Level] = "Poor")), "#F09E57", IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= CALCULATE(FIRSTNONBLANK('ASSET HEALTH LEVEL'[IntervalMax],1)/100, filter(all('ASSET HEALTH LEVEL'),'ASSET HEALTH LEVEL'[Obj Type] = SELECTEDVALUE('ASSET TYPE'[Asset Type]) && 'ASSET HEALTH LEVEL'[Level] = "Fair")), "#F2D478", IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= CALCULATE(FIRSTNONBLANK('ASSET HEALTH LEVEL'[IntervalMax],1)/100, filter(all('ASSET HEALTH LEVEL'),'ASSET HEALTH LEVEL'[Obj Type] = SELECTEDVALUE('ASSET TYPE'[Asset Type]) && 'ASSET HEALTH LEVEL'[Level] = "Good")), "#8DD382", IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= CALCULATE(FIRSTNONBLANK('ASSET HEALTH LEVEL'[IntervalMax],1)/100, filter(all('ASSET HEALTH LEVEL'),'ASSET HEALTH LEVEL'[Obj Type] = SELECTEDVALUE('ASSET TYPE'[Asset Type]) && 'ASSET HEALTH LEVEL'[Level] = "Excellent")), "#36775C", IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= 0.20, "#9D1C40", IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= 0.40, "#F09E57", IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= 0.60, "#F2D478", IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= 0.80, "#8DD382", IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= 1, "#36775C" )))))))))), //Defaulting IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= 0.20, "#9D1C40", IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= 0.40, "#F09E57", IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= 0.60, "#F2D478", IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= 0.80, "#8DD382", IF(AVERAGE('ASSET HEALTH'[Asset Health]) <= 1, "#36775C" )))))) | ||||
| Average_Type | N | CALCULATE(AVERAGE('ASSET HEALTH'[Asset Health]), FILTER(ALL('ASSET HEALTH'), 'ASSET HEALTH'[Object Type] = SELECTEDVALUE('ASSET HEALTH'[Object Type]))) | ||||
| ButtonBorderColor | N | IF(AND([SelectedCount],ISFILTERED('ASSET HEALTH'[Asset Id])), "#E8E8E8", "#FFFFFF00") | ||||
| ButtonHoverColor | N | IF(AND([SelectedCount],ISFILTERED('ASSET HEALTH'[Asset Id])), "#0365D8", "#FFFFFF00") | ||||
| ButtonTypeHoverColor | N | IF(HASONEVALUE('ASSET TYPE'[Asset Type]), "#0365D8", "#FFFFFF00") | ||||
| CardBG | N | IF(AND([SelectedCount],ISFILTERED('ASSET HEALTH'[Asset Id])), "#FFFFFF00", "#FFFFFF") | ||||
| Color_Critical | N | IF(SELECTEDVALUE('ASSET HEALTH'[Asset Health Level]) = "Critical", VALUES('ASSET HEALTH'[Asset Health]), BLANK()) | ||||
| Color_Empty | N | 1- SELECTEDVALUE('資産の健全性'[資産の健全性]) | ||||
| Color_Excellent | N | IF(SELECTEDVALUE('ASSET HEALTH'[Asset Health Level]) = "Excellent", VALUES('ASSET HEALTH'[Asset Health]), BLANK()) | ||||
| Color_Fair | N | IF(SELECTEDVALUE('ASSET HEALTH'[Asset Health Level]) = "Fair", VALUES('ASSET HEALTH'[Asset Health]), BLANK()) | ||||
| Color_Good | N | IF(SELECTEDVALUE('ASSET HEALTH'[Asset Health Level]) = "Good", VALUES('ASSET HEALTH'[Asset Health]), BLANK()) | ||||
| Color_Poor | N | IF(SELECTEDVALUE('ASSET HEALTH'[Asset Health Level]) = "Poor", VALUES('ASSET HEALTH'[Asset Health]), BLANK()) | ||||
| CountAll | N | IF(HASONEVALUE('ASSET HEALTH'[Object Type]), CALCULATE(COUNT('ASSET HEALTH'[Object Seq]), FILTER(ALL('ASSET HEALTH'), 'ASSET HEALTH'[Object Type] = SELECTEDVALUE('ASSET HEALTH'[Object Type]) )), COUNT('ASSET HEALTH'[Asset Health])) | ||||
| FilterPie | N | countrows(FILTER('ASSET HEALTH', 'ASSET HEALTH'[Asset Health Level] in VALUES('HEALTH LEVEL'[Description]))) | ||||
| Filter_check | N | IF(HASONEVALUE('ASSET HEALTH'[Object Type]), 1, 0) | ||||
| Filter_check_Object | N | IF(ISFILTERED('ASSET HEALTH INDICATOR'[Parameter]), 1,0) | ||||
| HealthLevel_Total | N | var MAXXX = MAX('ASSET HEALTH'[Asset Health Level]) Return IF(ISFILTERED('ASSET HEALTH'[SITE_TX]), COUNTROWS ( FILTER ( ALLSELECTED( 'ASSET HEALTH' ), 'ASSET HEALTH'[Object Type] in DISTINCT( 'ASSET HEALTH'[Object Type] ) && 'ASSET HEALTH'[Asset Health Level] = SELECTEDVALUE('HEALTH LEVEL'[Description] ) && 'ASSET HEALTH'[SITE_TX] in DISTINCT('ASSET HEALTH'[SITE_TX]) ) ) , COUNTROWS ( FILTER ( ALL ( 'ASSET HEALTH' ), 'ASSET HEALTH'[Object Type] in DISTINCT( 'ASSET HEALTH'[Object Type] ) && 'ASSET HEALTH'[Asset Health Level] = SELECTEDVALUE ('HEALTH LEVEL'[Description] ) ) )) | ||||
| LastIndicatorValue | N | CALCULATE (FIRSTNONBLANK('資産の健全性インジケーター HST'[正規化された値],1)/100, FILTER ('資産の健全性インジケーター HST', '資産の健全性インジケーター HST'[DIMENSION] = SELECTEDVALUE('資産の健全性インジケーター'[パラメータ]) && '資産の健全性インジケーター HST'[オブジェクト シーケンス] = SELECTEDVALUE('資産の健全性インジケーター HST'[オブジェクト シーケンス]) && '資産の健全性インジケーター HST'[記録日] = MAX('資産の健全性インジケーター HST'[記録日]))) | ||||
| LastIndicatorValueType | N | CALCULATE (FIRSTNONBLANK('資産の健全性インジケーター HST'[正規化された値],1), FILTER ('資産の健全性インジケーター HST', '資産の健全性インジケーター HST'[DIMENSION] = SELECTEDVALUE('資産の健全性インジケーター'[パラメータ]) && '資産の健全性インジケーター HST'[OBJ_TYPE] = SELECTEDVALUE('資産タイプ'[資産タイプ]))) | ||||
| MS_SELECTED_CARD | N | IFERROR ( IF ( ISBLANK ( COUNTROWS ( FILTER ( 'ASSET HEALTH', NOT ( ISBLANK ( 'ASSET HEALTH'[Object Type] ) ) ) ) ), "No Assets", IF ( AND(ISFILTERED ( 'ASSET HEALTH'[Asset Id] ),[MaxTypes]), CONCATENATEX ( 'ASSET TYPE', 'ASSET TYPE'[Asset Type], " , " ), IF (AND([MaxTypes], AND ( ISFILTERED ( 'ASSET TYPE'[Asset Type] ), ISFILTERED ( 'COLOR LEVEL'[Description] ) )), CONCATENATEX ( 'ASSET TYPE', 'ASSET TYPE'[Asset Type], " , " ) & " (" & CONCATENATEX ( 'COLOR LEVEL', 'COLOR LEVEL'[Description], " , " ) & ")", IF ( AND ( ISFILTERED ( 'COLOR LEVEL'[Description] ), ISFILTERED ( SITE[SITE_TX] ) ), VALUES ( SITE[SITE_TX] ) & " (" & VALUES ( 'COLOR LEVEL'[Description] ) & ")", IF ( ISFILTERED ( 'COLOR LEVEL'[Description] ), CONCATENATEX ( 'COLOR LEVEL', 'COLOR LEVEL'[Description],", ") & " (All)", IF ( AND(ISFILTERED ( 'ASSET TYPE'[Asset Type] ),[MaxTypes]), CONCATENATEX ( 'ASSET TYPE', 'ASSET TYPE'[Asset Type], " , " ), IF ( AND(ISFILTERED ( 'ASSET HEALTH'[ObjSearch] ), HASONEVALUE('ASSET HEALTH'[ObjSearch])), SELECTEDVALUE('ASSET HEALTH'[Object Type]), "Multiple Assets Selected" ) ) ) ) ) )), "" ) | ||||
| MaxCritical | N | IF(ISBLANK(CALCULATE(FIRSTNONBLANK('ASSET HEALTH LEVEL'[IntervalMax],1)/100, filter(all('ASSET HEALTH LEVEL'), 'ASSET HEALTH LEVEL'[Obj Type] = SELECTEDVALUE('ASSET HEALTH'[Object Type]) && 'ASSET HEALTH LEVEL'[Level] = "Critical"))), 0.2, CALCULATE(FIRSTNONBLANK('ASSET HEALTH LEVEL'[IntervalMax],1)/100, filter(all('ASSET HEALTH LEVEL'), 'ASSET HEALTH LEVEL'[Obj Type] = SELECTEDVALUE('ASSET HEALTH'[Object Type]) && 'ASSET HEALTH LEVEL'[Level] = "Critical"))) | ||||
| MaxFair | N | IF(ISBLANK(CALCULATE(FIRSTNONBLANK('ASSET HEALTH LEVEL'[IntervalMax],1)/100, filter(all('ASSET HEALTH LEVEL'), 'ASSET HEALTH LEVEL'[Obj Type] = SELECTEDVALUE('ASSET HEALTH'[Object Type]) && 'ASSET HEALTH LEVEL'[Level] = "Fair"))), 0.6, CALCULATE(FIRSTNONBLANK('ASSET HEALTH LEVEL'[IntervalMax],1)/100, filter(all('ASSET HEALTH LEVEL'), 'ASSET HEALTH LEVEL'[Obj Type] = SELECTEDVALUE('ASSET HEALTH'[Object Type]) && 'ASSET HEALTH LEVEL'[Level] = "Fair"))) | ||||
| MaxGood | N | IF(ISBLANK(CALCULATE(FIRSTNONBLANK('ASSET HEALTH LEVEL'[IntervalMax],1)/100, filter(all('ASSET HEALTH LEVEL'), 'ASSET HEALTH LEVEL'[Obj Type] = SELECTEDVALUE('ASSET HEALTH'[Object Type]) && 'ASSET HEALTH LEVEL'[Level] = "Good"))), 0.8, CALCULATE(FIRSTNONBLANK('ASSET HEALTH LEVEL'[IntervalMax],1)/100, filter(all('ASSET HEALTH LEVEL'), 'ASSET HEALTH LEVEL'[Obj Type] = SELECTEDVALUE('ASSET HEALTH'[Object Type]) && 'ASSET HEALTH LEVEL'[Level] = "Good"))) | ||||
| MaxPoor | N | IF(ISBLANK(CALCULATE(FIRSTNONBLANK('ASSET HEALTH LEVEL'[IntervalMax],1)/100, filter(all('ASSET HEALTH LEVEL'), 'ASSET HEALTH LEVEL'[Obj Type] = SELECTEDVALUE('ASSET HEALTH'[Object Type]) && 'ASSET HEALTH LEVEL'[Level] = "Poor"))), 0.4, CALCULATE(FIRSTNONBLANK('ASSET HEALTH LEVEL'[IntervalMax],1)/100, filter(all('ASSET HEALTH LEVEL'), 'ASSET HEALTH LEVEL'[Obj Type] = SELECTEDVALUE('ASSET HEALTH'[Object Type]) && 'ASSET HEALTH LEVEL'[Level] = "Poor"))) | ||||
| MaxTypes | N | IF(COUNTROWS('ASSET TYPE') <= 5, True, False) | ||||
| メジャー | N | CALCULATE(AVERAGE('ASSET HEALTH INDI HST'[Normalized Value]), FILTER(ALL('ASSET HEALTH INDI HST'), 'ASSET HEALTH INDI HST'[Dim_Asset_Type] = SELECTEDVALUE('ASSET TYPE'[ID]) && 'ASSET HEALTH INDI HST'[Dimension] = SELECTEDVALUE('ASSET HEALTH INDI HST'[Dimension]) )) | ||||
| PAGE_ASSET_PERFORMANCE | N | IFERROR(IF([SingleObject], VALUES(EnvPath) & "/main/ifsapplications/web/page/AssetPerformanceDetails/AssetPerformanceDetails;$filter=%28%28Contract%20eq%20'"& SELECTEDVALUE(SITE[ID]) &"'%29%29%20and%20%28MchCode%20eq%20'" & SELECTEDVALUE('ASSET HEALTH'[Asset Id]) & "'%29", ""), "") | ||||
| PAGE_ASSET_STRUCTURE_PERFORMANC | N | IFERROR(IF([SingleObject], VALUES(EnvPath) & "/main/ifsapplications/web/page/AssetPerformanceOverview/StructurePerformancePage;searchcontext=EquipmentObjectSeq:" & SELECTEDVALUE('ASSET HEALTH'[Object Seq]) & ";", ""), "") | ||||
| PAGE_FAULT_REPORT | N | IFERROR(IF([SingleObject], VALUES(EnvPath) & "/main/ifsapplications/web/assistant/CreateFaultReportAssistant/FaultReportWizardAssistant;$action=SetTaskAttrForSteps%7B%20ReportMchCode:%20'" & SELECTEDVALUE('ASSET HEALTH'[Asset Id]) & "',%20MchCodeContractNew:%20'" & SELECTEDVALUE(SITE[ID]) & "'%7D"), "") | ||||
| PAGE_FUNCTIONAL_OBJECT | N | IFERROR(IF([SingleObject], VALUES(EnvPath) & "/main/ifsapplications/web/page/FunctionalObject/Form;$filter=Contract eq '" & VALUES(SITE[ID]) &"'%20and%20MchCode%20eq%20'" & VALUES('ASSET HEALTH'[Asset Id]) & "'", ""), "") | ||||
| SelectedCount | N | IF(HASONEVALUE('ASSET HEALTH'[Object Type]), True, False) | ||||
| SingleObject | N | IF([SelectedCount], 1, 0) | ||||
| TXT_ASSET_DETAILS | N | IF(AND([SelectedCount],ISFILTERED('ASSET HEALTH'[Asset Id])), "Asset Details", "") | ||||
| TXT_ASSET_PERFORMANCE | N | IF(AND([SelectedCount],ISFILTERED('ASSET HEALTH'[Asset Id])), "Asset Structure Performance", "") | ||||
| TXT_ASSET_STRUCTURE_PERFORMANCE | N | IF(AND([SelectedCount],ISFILTERED('ASSET HEALTH'[Asset Id])), "Asset Performance", "") | ||||
| TXT_FAULT_REPORT | N | IF(AND([SelectedCount],ISFILTERED('ASSET HEALTH'[Asset Id])), "Fault Report", "") | ||||
| TXT_OBJECT_PAGE | N | IF(AND([SelectedCount],ISFILTERED('ASSET HEALTH'[Asset Id])), "Object Page", "") | ||||
| TXT_SELECT_OBJ | N | IF(AND([SelectedCount], ISFILTERED('ASSET HEALTH'[Asset Id])), "", "Please select an Asset") | ||||
| TXT_Select_Indicator | N | IF(ISFILTERED('ASSET HEALTH INDICATOR'[Parameter]),"", "Please select an Indicator") | ||||
| Type_Color_Critical | N | IF([AverageHealthLevel] = "Critical", [AHAvg], BLANK()) | ||||
| Type_Color_Excellent | N | IF([AverageHealthLevel] = "Excellent", [AHAvg], BLANK()) | ||||
| Type_Color_Fair | N | IF([AverageHealthLevel] = "Fair", [AHAvg], BLANK()) | ||||
| Type_Color_Good | N | IF([AverageHealthLevel] = "Good", [AHAvg], BLANK()) | ||||
| Type_Color_Poor | N | IF([AverageHealthLevel] = "Poor", [AHAvg], BLANK()) |
タイム ベースの測定値は、他の測定値を基準にしてキューブ内で計算されます。以下の表は、さまざまな時間測定単位の意味/定義を示します。これらのメジャーは、特定の時間ディメンション階層の[REPORTING_DATE].[RepDateMFHy] で使用する必要があります。
| メジャー | 意味 |
| YTD | 当年の当月の集計値の値。たとえば、期間 202010 の場合、YTD は期間 202000 ～ 202010 の合計を表します。 |
| R12 | 特定の期間について、1 年前から前月までのすべての月の合計。例:202010 の 12 カ月の継続は、201910 ~ 202009 までの月の合計になります。 |
| PY | 前年 1 年前の該当する月の値。たとえば、202010 の月の場合は、201910 の月の値になります。 |
| YTD PY | 前年累計 1 年前の該当する月の集計値の値。たとえば、202010 の場合、前年累計は 201901 ～ 201910 の月の合計を表します。 |
| R12 PY | 前年の継続 12 か月 (完了) 特定の月について、まず 1 年前まで遡り、次に もう 1 年遡ってから前月までのすべての月の合計を計算します。たとえば、202010 の場合は 201810 ～ 201909 の合計 |
| Avg XXX Ytd | 合計 XXX YTD/カウント XXX YTD |
| Avg XXX R12 | 合計 XXX R12/カウント XXX R12 |
| XXX % YTD | カウント XXX YTD/カウント YYY YTD |
| XXX % R12 | カウント XXX R12/カウント XXX R12 |
| モデル名 | |
| メンテナンス | メンテナンス |
このオブジェクトのデータソースは、IFS Developer Tool を使用して定義されます。データソースには、モデルが最後のステップ、つまりデータソース ビュー名 (DW ソースビュー名) からデータを読み取る変換が多数含まれています。
追加情報は、情報ソースのオンライン ドキュメントをご覧ください。
| モデル テーブル | DW ソースビュー (SQL Server) | BI アクセスビュー | 参照情報ソース | 推奨アクセスタイプ |
| 資産健全性の計測値 | FACT_ASSET_HEALTH_TM | FACT_ASSET_HEALTH_BI | FACT_ASSET_HEALTH | オンライン |