Supplier.Details

Purpose

The Common View for Supplier Details, excluding dates or measures, acts as a unified and reliable source for data on business suppliers. It is accessible to different departments and systems across the organisation. This view supports integration with fact tables for reporting and analysis and provides a limited set of dimension attributes.

Use Case

Owner: Data Engineering
Typical Use Case: Supplies content for a Supplier slicer, ensuring a uniform style for Title descriptions.
Style: Dimension i.e. Single row per Supplier ID

Source

DIM_SUPPLIER_OL

Key Parameters

Company (default as Global Company 9900)
Supplier

Sample Exec

EXEC get.myView @dataMart = 'Supplier', @viewName = 'Details', @token = '<myToken>', @version = '<202404>'

Response

SEQ

	9900 as COMPANY,
	CODE as SUPPLIER_ID,

    src.SUPPLIER_NAME,
    left(CONCAT_WS(' - ', src.CODE, src.SUPPLIER_NAME), 40)
        + IIF(LEN(CONCAT_WS(' - ', src.CODE, src.SUPPLIER_NAME)) > 40, '...', '') AS [Supplier_Title],

Dates

Measures

Codes

	COUNTRY,
	ASSOCIATION_NO

SQL

BMT-DWH-DEV/Supplier_Details.sql