Dict-Physical

View VMF_Building

Card of view VMF_Building

Name	VMF_Building
Comment	This view presents only the most current building information (current fiscal year). It contains facts like gross and net square footage. The grain of this table is simply the building. For simple space cubes, this is appropriate; for more complex cubes that must take historical areas into account, use VMF_PerYearBuildingFact. The grain of VMF_PerYearBuildingFact (as opposed to VMF_Building) is per building per fiscal year. The dual-attribute key makes joins and cube construction a bit more challenging than for VMF_Building, although this fact table obscures historical changes in area, for example.
Dimensional Type	Fact

SQL query of the view VMF_Building

-- Take only the most current building information (current fiscal year)
-- For simple space cubes, this is appropriate; for more complex cubes that
-- must take historical areas into account, use VMF_PerYearBuildingFact
select
MD_Building_SurrogateKey,
MF_PerYrBuild_BuildingID,
MF_PerYrBuild_NetArea,
MF_PerYrBuild_GrossArea
from
MF_PerYearBuildingFacts mfp
where
   mfp.MF_PerYrBuild_FiscalYear =
      CASE
         WHEN MONTH(GETDATE()) >= 7 THEN YEAR(GETDATE()) + 1
         ELSE YEAR(GETDATE())
      END

SELECT,VIEW DEFINITION

SpaceReader

List of view columns of the view VMF_Building

MD_Building_SurrogateKey

numeric

MF_PerYrBuild_BuildingID

varchar(16)

MF_PerYrBuild_NetArea

float

Net square footage of a building's interior spaces (for easier filtering and reporting).

MF_PerYrBuild_GrossArea

float

Gross square footage of a building's interior spaces, discretized into ranges (for easier filtering and reporting).

Home

View VMF_Building

Card of view VMF_Building

SQL query of the view VMF_Building

List of outgoing view references of the view VMF_Building

List of diagrams containing the view VMF_Building

List of permissions of the view VMF_Building

List of view columns of the view VMF_Building