Monday, April 15, 2019

Financial Dimensions and their related entity tables


    • Financial dimension 'Use values from'Related entity
      < Custom dimension >DimAttributeFinancialTagEntity
      AgreementsDimAttributeAgreementHeaderExt_RUEntity
      Bank accountsDimAttributeBankAccountTableEntity
      BusinessUnitsDimAttributeOMBusinessUnitEntity
      CampaignsDimAttributeSmmCampaignTableEntity
      Cash accountsDimAttributeRCashTable_RUEntity
      Cost centersDimAttributeOMCostCenterEntity
      Customer groupsDimAttributeCustGroupEntity
      CustomersDimAttributeCustTableEntity
      DeferralsDimAttributeRDeferralsTable_RUEntity
      DepartmentsDimAttributeOMDepartmentEntity
      Expense and income codesDimAttributeRTax25ProfitTable_RUEntity
      Expense PurposesDimAttributeTrvTravelTxtEntity
      Fiscal establishmentsDimAttributeFiscalEstablishment_BREntity
      Fixed asset groupsDimAttributeAssetGroupEntity
      Fixed assetsDimAttributeAssetTableEntity
      Fixed assets (Russia)DimAttributeRAssetTable_RUEntity
      FundsDimAttributeLedgerFund_PSN
      Item groupsDimAttributeInventItemGroupEntity
      ItemsDimAttributeInventTableEntity
      JobsDimAttributeHcmJobEntity
      Legal entitiesDimAttributeCompanyInfoEntity
      POS registersDimAttributeRetailTerminalEntity
      PositionsDimAttributeHcmPositionEntity
      Project contractsDimAttributeProjInvoiceTableEntity
      Project groupsDimAttributeProjGroupEntity
      ProjectsDimAttributeProjTableEntity
      ProspectsDimAttributeSmmBusRelTableEntity
      Resource groupsDimAttributeWrkCtrResourceGroupEntity
      ResourcesDimAttributeWrkCtrTableEntity
      StoresDimAttributeRetailStoreEntity
      Value streamsDimAttributeOMValueStreamEntity
      Vendor groupsDimAttributeVendGroupEntity
      VendorsDimAttributeVendTableEntity
      WorkersDimAttributeHcmWorkerEntity
    • Right-click the Financial dimension name under Relations.
    • Select New, and then click Normal.
    • In the Properties pane, choose the name of the Financial dimension in the Field.
    • In the Related field, type Value. The new relation is similar to the following example.
      1. Right-click DimensionCombinationEntity or DimensionSetEntity. Select Open.
      2. Right click Relations. Select New and then click Relation.
      3. In the Properties pane, set the following properties.
        • Validate - No
        • Cardinality - ZeroMore
        • Name - Enter the name of the financial dimension, such as Department.
        • Related Data Entity - Select the entity for the financial dimension that you entered in the Name field. The following table contains a list of the financial dimensions and the related entities.
    • Related Data Entity Cardinality - ZeroOne
    • Related Data Entity Role - Enter a unique name, such as Dimension Department.
    • Relationship Type - Association
    • Role - Enter a unique name, such as Dimension Department.
  1. DimensionCombinationEntity.DimensionIntegration.Department==DimAttributeOMDepartmentEntity.Value
    
    lookupwiki
  2. Build the project and then synchronize it with the database.

No comments:

Post a Comment