Skip to content

Latest commit

 

History

History
62 lines (54 loc) · 5.47 KB

RELEASE_NOTES.md

File metadata and controls

62 lines (54 loc) · 5.47 KB
Raw

Release v5.4.1

  • Update README with message about using Balance Sheet and Income Statement with SAP Financial test harness data available with Cortext Framework.

Release v5.4

  • General:

    • Added a required constant to provide flexibility in how revenue amounts appear in Income Statement reporting. To display revenue as positive, set the value of SIGN_CHANGE constant to yes.
    • Removed optional constants max_fiscal_period and derive_comparison_period.
    • Updated language_map_sdt view to default to English if no locale match or locale language does not exist in BalanceSheet or ProfitAndLoss tables.
    • Added universal_ledgers_md view to provide Ledger Name for reporting.

  • Balance Sheet:

    • Improved fields descriptions and organization within the Balance Sheet Explore.
    • Updated underlying logic for hierarchy levels to display the selected top level and its subordinate levels, rather than just the lowest level.
    • Added navigation feature that allows users to switch between Subtotals dashboards that provide comparisons to other timeframes and those that do not have such comparisons.
    • Modified the logic behind calculating the comparison period to no longer rely on the max_fiscal_period constant.
    • Added context to view and explore definitions with more-detailed comments.
    • Added Balance Sheet dashboard template to minimize edits to filters and other shared dashboard elements.
    • For Report Table dashboard, changed column order so that variance values appear at the end.
    • Change labels used in Comparison Type parameter to Year Ago and Prior Fiscal Period.
    • Modify Company filter to allow multiple values.

  • Profit and Loss / Income Statement:

    • Added views, explores and dashboards to support Income Statement reporting.

Release v5.3.1

  • Balance Sheet Updates:

    • Added the Persistent Derived Table (PDT) view balance_sheet_path_to_node_pdt and Datagroup balance_sheet_node_count. This PDT finds the full hierarchy path to each Balance Sheet node (e.g., Assets/Current Assets/Cash & Equivalents). This PDT will regenerate if the count of Client, Chart of Accounts, Hierarchy Name, Level, and Node changes. Requires BigQuery connection used for this LookML model to have Persistent Derived Tables enabled.
    • Updated Balance Sheet dashboards by:
      • including three levels of the hierarchy as specified by user
      • adding filter for Ledger
      • renaming dashboards and select filters to more business-friendly terms
      • modifying the sort order for columns and rows
      • adding defaults for select filters based on user attributes for SQL Flavor (S4 or ECC) and Use of Test Data (Yes or No)
    • Added the following user attributes to set default values for select filters used in the balance sheet dashboard. A Looker Admin will need to add these user attributes to Looker (see README doc for more details) or update LookML dashboards to use other defaults.
      • sap_use_demo_data: set to Yes if using the test data included with the Cortex Framework
      • sap_sap_sql_flavor: set to either S4 or ECC depending upon your SAP system

  • Accounts Receivable Updates:

    • Added the Persistent Derived Table (PDT) view global_currency_list_pdt, an Explore based on this view and a Datagroup named monthly_on_day_1. Generated on the 1st day of the month, this PDT provides a unique list of ToCurrency_TCURR values that are used for filter suggestions. To adjust the update frequency of a particular PDT, a Looker developer or admin can modify the associated Datagroup trigger.
    • In the data_intelligence_ar view, for the Currency_Required parameter, replaced the allowed values with the suggest_dimension global_currency_list_pdt.to_currency_tcurr.

Release v5.3

  • Added views, explores and dashboards to support Balance Sheet reporting
  • Added constants to the manifest to allow for the reuse of HTML value formatting and comparison period logic used in the Balance Sheet.
  • Note the manifest and the Balance Sheet views and explores leverage liquid templating language. For more information, refer to Looker's Liquid Variable Reference documentation.

Release v5.0.1

  • Updated all views to have a single primary key dimension. For some views, added a key dimension to concatenate multiple dimensions making up the primary key
  • Edited sales_orders Explore to remove unnecessary join between currency_conversion_new and sales_order_pricing
  • Replaced currency_conversion_pricing with currency_conversion_new in dashboards and view sales_orders
  • In view and Explore sales_orders:
    • removed SQL_DISTINCT_KEY parameter from measure sales_order_netvalue_glob_curr_1 as its no longer necessary
    • added USD as default for parameter Currency_Required
    • added value of parameter Currency_Required to join condition for currency_conversion_new
  • Updated LookML Dashboard file 6d_Total_Receivable to use PeriodCalc dimension instead of Fiscal_Year
  • Added measure total_actual_billed_quantity_fkimg to view billing
  • In view and Explore data_intelligence_ar:
    • added currency_conversion_new to the Explore
    • replaced SQL function Currency Conversion with currency_conversion_new
    • added USD as default for parameter Currency_Required
    • replaced Split function with Substring function for several dimensions derived from PeriodCalc