GitHub - ziaa/SqlPersianDateDimension: SQL script to create and populate a date dimension which is used in generating OLAP Cubes. Also a function to convert dates from Gregorian to Jalali calendar (A.K.A Persian calendar)

ziaa / SqlPersianDateDimension Public

SQL script to create and populate a date dimension which is used in generating OLAP Cubes. Also a function to convert dates from Gregorian to Jalali calendar (A.K.A Persian calendar)

8 stars 3 forks Branches Tags Activity

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 5 Commits
GregorianToJalali.sql		GregorianToJalali.sql
LICENSE		LICENSE
README.md		README.md
spPopulatePersianDateDimension.sql		spPopulatePersianDateDimension.sql

Repository files navigation

## راهنمای ساختن بُعد تاریخ شمسی برای استفاده در OLAP Cube

1. ایجاد کردن تابع تبدیل میلادی به شمسی

2. ساختن جدول نگهدارنده تاریخ‌ها و روالِ (Stored Procedure) پُر کردن این جدول

3. پُر کردن بُعد تاریخ برای یک بازه زمانی خاص

EXECUTE dbo.spPopulatePersianDateDimension @FromDate = '2016-1-1', @ToDate = '2017-1-1'

همین!

یه ذره (!) اطلاعات بیشتر

About

SQL script to create and populate a date dimension which is used in generating OLAP Cubes. Also a function to convert dates from Gregorian to Jalali calendar (A.K.A Persian calendar)

sql sql-server persian persian-calendar jalali shamsi olap-cube khorshidi jalali-date

Report repository

Languages

PLSQL 100.0%