モデル:メンテナンス - ファクト テーブルの仕様:資産健全性の計測値

このページでは、モデルに関する仕様をご覧いただけます。メンテナンスとファクト テーブル:資産の健全性の測定値。

属性

属性	説明 (該当する場合)

計測値(可能な限り表を作成)

明示的に記載されていない場合、測定値の集計は SUM に基づきます。

このセクションでは、キューブ内の基本的な測定値について説明します。これらは、コア情報ソース、モデル自体、または ETL プロセスで定義された測定値です。列には次の意味があります。

• コア メジャー:重要部分の情報ソースに起源を持つ測定値
• 計算済みの Y/N:モデルに対して特に定義された測定基準 (パーセンテージなど)。これらの測定値は情報ソースから得られるものではありません。
• タイム インテリジェンス Y/N が含まれます:一部の測定値には、YTD (年初来) などの追加のタイム インテリジェンス測定値もあります。別のセクションを参照してください。
• 定義/注釈:測定値の背後に特定のロジックがあるかどうかを指定します。さらに詳しい情報は、情報ソースのドキュメントにも記載されています。
• 集計タイプ:測定の集計タイプを指定します。
• 非表示の Y/N:測定値が非表示になっていて、モデルを参照するときにエンド ユーザーに表示されないようにするかどうかを指定します。
• メジャー式:メジャー定義内の DAX 式。

メジャー	計算済みの Y/N:	タイム インテリジェンス Y/N を含む	定義/注記 (該当する場合)	集計タイプ	非表示の Y/N	メジャー式
AHAvg					N	IF(ISBLANK(AVERAGE('ASSET HEALTH'[Asset Health])), "", AVERAGE('ASSET HEALTH'[Asset Health]))
Average_Type					N	CALCULATE(AVERAGE('ASSET HEALTH'[Asset Health]), FILTER(ALL('ASSET HEALTH'), 'ASSET HEALTH'[Object Type] = SELECTEDVALUE('ASSET HEALTH'[Object Type])))
AverageHealth_Type					N	IF(HASONEVALUE('ASSET HEALTH'[Object Type]), [Average_Type], AVERAGE('ASSET HEALTH'[Asset Health]))
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" ))))))
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" ))))))
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" ))))))
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- AVERAGE('ASSET HEALTH'[Asset Health])
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]))
Filter_check					N	IF(HASONEVALUE('ASSET HEALTH'[Object Type]), 1, 0)
Filter_check_Object					N	IF(ISFILTERED('ASSET HEALTH INDICATOR'[Parameter]), 1,0)
FilterPie					N	countrows(FILTER('ASSET HEALTH', 'ASSET HEALTH'[Asset Health Level] in VALUES('HEALTH LEVEL'[Description])))
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( 'ASSET HEALTH INDI HST'[Normalized Value],1 ), FILTER ( 'ASSET HEALTH INDI HST', 'ASSET HEALTH INDI HST'[DIMENSION] = SELECTEDVALUE('ASSET HEALTH INDICATOR'[ParameterID]) && 'ASSET HEALTH INDI HST'[Dim_Asset_Id] = SELECTEDVALUE('ASSET HEALTH'[Dim_Asset_Id]) && 'ASSET HEALTH INDI HST'[Recorded Date] = MAX('ASSET HEALTH INDI HST'[Recorded Date]) ) )
LastIndicatorValueType					N	CALCULATE ( FIRSTNONBLANK( 'ASSET HEALTH INDI HST'[Normalized Value],1 ), FILTER ( 'ASSET HEALTH INDI HST', 'ASSET HEALTH INDI HST'[DIMENSION] = SELECTEDVALUE('ASSET HEALTH INDICATOR'[Parameter]) && 'ASSET HEALTH INDI HST'[Dim_Asset_Id] = SELECTEDVALUE('ASSET HEALTH INDI HST'[Dim_Asset_Id]) ) )
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)
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" ) ) ) ) ) )), "" )
PAGE_FUNCTIONAL_OBJECT					N	IFERROR(IF([SingleObject], VALUES(EnvPath) & "page/FunctionalObject/Form;$filter=Contract eq '"& SELECTEDVALUE(SITE[ID]) &"'%20and%20MchCode%20eq%20'" & SELECTEDVALUE('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 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_Indicator					N	IF(ISFILTERED('ASSET HEALTH INDICATOR'[Parameter]),"", "Please select an Indicator")
TXT_SELECT_OBJ					N	IF(AND([SelectedCount], ISFILTERED('ASSET HEALTH'[Asset Id])), "", "Please select an Asset")
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())
PAGE_ASSET_PERFORMANCE					N	IFERROR(IF([SingleObject], VALUES(EnvPath) & "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_FAULT_REPORT					N	IFERROR(IF([SingleObject], VALUES(EnvPath) & "assistant/CreateFaultReportAssistant/FaultReportWizardAssistant;$action=SetTaskAttrForSteps%7B%20ReportMchCode:%20'" & SELECTEDVALUE('ASSET HEALTH'[Asset Id]) & "',%20MchCodeContractNew:%20'" & SELECTEDVALUE(SITE[ID]) & "'%7D"), "")
メジャー					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]) ))

タイム インテリジェンス計測値

タイム ベースの測定値は、他の測定値を基準にしてキューブ内で計算されます。以下の表は、さまざまな時間測定単位の意味/定義を示します。これらのメジャーは、特定の時間ディメンション階層の[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	Sum XXX YTD/Count XXX YTD
Avg XXX R12	Sum XXX R12/Count XXX R12
XXX % YTD	Count XXX YTD/Count YYY YTD
XXX % R12	Count XXX R12/Count XXX R12

使用モデル

モデル名

データソース情報

このオブジェクトのデータソースは、IFS Developer Tool を使用して定義されます。さらなるトランスフォーメーションは Power BI を使用して行われます。

追加情報は、情報ソースのオンライン ドキュメントをご覧ください。

モデル テーブル	BI アクセスビュー	参照情報ソース	推奨アクセスタイプ
資産健全性の計測値	FACT_ASSET_HEALTH_BI	FACT_ASSET_HEALTH	オンライン