Recommendations for Metadata Issues

Metadata validation identifies potential metadata issues in Tax Reporting. The validation provides best practices like warnings and suggestions in the Recommendations module that you can review and implement.

Table 5-7 Metadata Validation

Priority	Artifact	Type (Recommendation Type)
High	Consol Account	Ensure TRCS_TOTAL_TAX must be a stored level 0 member in the Consol cube.
High	Consol, Config Account	Ensure plan types for accounts under TRCS_PillarTwoAccounts are set for both Consol and Config cube.
High	Consol Account	Ensure all base level members of Temporary Difference and Loss Credit Accounts do not have "CETR" attribute assigned.
High	Consol Account	Ensure all base members under TRCS_TaxAccounts have "TaxType" and "TaxDataType" attributes assigned.
High	Consol Account	Ensure all base members between TRCS_CurrentAddtlTotal and TRCS_CurrentAddtlETRTotal are shared.
Medium	Consol Account	Ensure all base level members having member formula have Data Storage type as Dynamic Calc.
High	Consol Account	Ensure all base level members of the Tax_Accounts do not have a member formula attached.
High	Consol Account	Ensure account(s) used as NIBT FX Override Difference Account(s) cannot use a source account FX rate.
High	Consol Account	Ensure Source Account FX Rate have Data Storage type as either Store or Never Share.
High	Consol Account	Ensure parent account(s) cannot be set to use source account FX Rate.
High	Consol Account	Ensure all base level members of TRCS_TaxCreditCYTotal and TRCS_RTaxCreditCYTotal must have the CETR attribute assigned.
Low	Consol, CbCR All Dimensions	Identify duplicate aliases across different dimensions.
Low	Consol, CbCR All Dimensions	Identify duplicate aliases within the same dimension.
Medium	Consol, CbCR All dimensions; except Year, Period, View, Currency, From Currency, and Entity in CbCR	Ensure primary member is present before shared member.
Medium	All cubes except Rates All dimensions except Year, Period, View, Currency	Ensure all base members with Dynamic Calc Data Store have member formula.
High	Consol, CbCR Entity only in Consol; non-Entity dimensions except Year, Period, View, Currency, and From Currency in Consol or CbCR	Ensure member names do not exceed 75 character limit.
High	Consol Entity	Ensure all base level members have "Domicile" attribute assignment.
High	Consol Entity	Ensure all parent entities with "ParentTaxCalc" attribute assigned have "Domicile" attribute assigned and Allow Upper-Level Entity Input property enabled.
High	Consol Data Source (derived from Entity ownership setup)	Ensure Data Source member(s) used in Ownership are present.
High	Consol, CbCR, Config Jurisdiction	Ensure all base level members under TRCS_TotalPillarTwoJurisdictions have "PillarTwoCurrency" attribute assigned.
High	Consol Scenario	Ensure "has_CbCR_Scenario" attribute is assigned if separate CbCR approval scenarios are present.