You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

Purpose

This documentation outlines the process for creating a Power BI report that allows users to toggle between Volume-Based, Sales-Based, and ICM-Based decompositions using a single-page layout.
The report integrates three datasets:

  • ICM dataset: gcp-sqo-data-pricing-d.DS_SpecialtyPolymers.V_FACT_FIDB_sales_history_icm

  • Sales dataset: gcp-sqo-data-pricing-d.DS_SpecialtyPolymers.V_FACT_FIDB_sales_history_volume 

  • Volume dataset: gcp-sqo-data-pricing-d.DS_SpecialtyPolymers.V_FACT_FIDB_sales_history_volume

Functional Requirements

  • Toggle Switch: Three buttons/segmented control – Volumes, Sales, ICM.

  • Persistent Filters: User-applied filters remain active when switching between datasets.

  • Waterfall Chart: Displays decomposition (Added/Lost Key, Variation, FX Conversion, etc.).

  • Data Table: Displays detailed breakdown by Market Cluster, BDM, Business Line, Region, Final Customer, Sold-to Name, H4/Product L4, Variation values.

  • Filters on Report:

    • gbu_region

    • sold_to_group

    • sold_to_code

    • sold_to_name

    • market_cluster

    • h4_product_l4

    • gbu_product_family

    • product_code

    • product_name

ICM Dataset

Source: V_FACT_FIDB_sales_history_icm
Required columns:

  • GBU, Market Cluster, BDM, Investor MKT Group, Business Line, GBU Region, Final Customer, Sold-to Name, Sold-to Code, H4/Product L4, GBU Product Family, Product Code, Product Name

  • ICM metrics (YTD previous year, Added/Lost Key, Volume Variation, Price Variation, Variable Costs Variation, FX Conversion, YTD current year)


  • No labels