Global.Company – knowhow

Purpose

Headline for Company Details

Source

DIM_COMPANY_OL

Parameters

Company

Sample Exec

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

Response

global_id as company_item_id,
item_class as REGION,
item_code as COMPANY_ID,
item_desc as [Company Name]

SQL

BMT-DWH-DEV/Global_Company.sql

2 thoughts on “Global.Company”

Array
(
    [Current stable version] => 202409
    [exec] => @version = '202409'
    [Development] => @version = 'beta'
    [Change] => Regional View
)

Array
(
    [Current stable version] => 202404
    [exec] => @version = '202404'
    [Development] => @version = 'beta'
)

Leave a Comment Cancel reply

You must be logged in to post a comment.

Recent Comments

{"Current stable version":"202409","exec":"@version = ‘202409’","Development" : "@version = ‘beta’","Change":"Regional View"}

{"Current stable version":"202409","exec":"@version = ‘202409’","Development" : "@version = ‘beta’","Change":"Stable 09 View"}

Expected Condition The DataMart View BusOpp.Dates is in the style of 202409 As Found Condition The unversioned (beta) edition of…

Double check your WITH READ ONLY — it’s typically only used on views, not raw SELECT queries unless you're defining…

{"Current stable version":"202409","exec":"@version = ‘202409’","Development" : "@version = ‘beta’","Change":"Cross Apply version"}

{"Current stable version":"202409","exec":"@version = ‘202409’","Development" : "@version = ‘beta’","Change":"CTE Version"}