Calendar Mapping Table for Data Warehouses

Data

Published by: Centrica Energy
Categories: Power & Utilities, Reference
Date added: 12/7/2012
Get support for this offering

This is a star schema table for data warehouses. It contains a full set of hierarchies for the standard calendar and the ISO week structure. The Period_Name column contains all levels in the structure, so fact data at any level of granularity (or multi granularity fact data) can be joined via this single column. Note the ISO week calendar is also used for selling UK Power (also known as the EFA calendar)

Service root URL

https://api.datamarket.azure.com/CENTRICAENERGY/MAP_CALENDAR/v1/

This service supports both fixed and flexible query. Some queries may include required input parameters. (learn more about query types)

MAP_CALENDAR

Input parameters:

Name Sample values Type Required
BeforeDateTime DateTime
Day_Name String
Half_Year_Name String
Month_For_Week_Name String
Month_Name String
OnOrAfterDatetime DateTime
Period_Duration_Days Int32
Period_ID Int32
Period_Name String
Period_Sequence_Number Int32
Period_Type String
Quarter_For_Week_Name String
Quarter_Name String
Season_For_Week_Name String
Season_Name String
Week_Name String
Year_For_Week_Name String
Year_Name String

Results:

Name Type
BeforeDateTime DateTime
Day_Name String
Half_Year_Name String
Month_For_Week_Name String
Month_Name String
OnOrAfterDatetime DateTime
Period_Duration_Days Int32
Period_ID Int32
Period_Name String
Period_Sequence_Number Int32
Period_Type String
Quarter_For_Week_Name String
Quarter_Name String
Season_For_Week_Name String
Season_Name String
Week_Name String
Year_For_Week_Name String
Year_Name String
Free for all
Unlimited

Transactions/month
A transaction is one request that returns one page of results. Retrieving multiple pages will result in multiple transactions executed.

$0.00

per month

Sign Up

Resources

  • Microsoft PowerPivot For Excel 2010

    Learn how to use Microsoft PowerPivot for Excel 2010, with this and other DataMarket data, to create compelling self-service BI solutions.

  • Tableau Software

    Learn how to visualize this and other DataMarket datasets in Tableau. Tableau’s rapid fire business intelligence solution provides best-in-class data visualization and web dashboards anyone can use.

  • Learn How To Use This Data In Visual Studio

    Learn how to seamlessly consume DataMarket data in Visual Studio with strongly-typed data access and full IntelliSense support to ease development.