How To Set Fiscal Year? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

How To Set Fiscal Year?

Author

Topic

lemune
Starting Member

3 Posts

Posted - 2008-09-12 : 06:27:53

Hi,

On my project, I'm trying to create Time Dimension. That has Year,Quarter, and Month.

But my project fiscal year is different from normal date.
The first day of the fiscal year is on date 01 December

How To Set It?

I Just Set Year, Quarter, and Month.
But when I browse the data on First Quarter (Q1) It show January, February, December.

What should I do?

Thanks.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-09-12 : 06:40:44

[code]SELECT theDate,
DATEPART(YEAR, DATEADD(MONTH, 1, theDate)) AS dimYear,
DATEPART(QUARTER, DATEADD(MONTH, 1, theDate)) AS dimQuarter,
DATEPART(MONTH, DATEADD(MONTH, 1, theDate)) AS dimMonth
FROM (
SELECT DATEADD(DAY, Number, '20000101') AS theDate
FROM master..spt_values
WHERE Type = 'P'
AND Number < 400
) AS d[/code]

E 12°55'05.63"
N 56°04'39.26"

lemune
Starting Member

3 Posts

Posted - 2008-09-12 : 06:50:44

Thanks Peso,

I'm also has create stored procedure like u create, the difference is only on the month, i use the month name.

When i create the cube on Sql Analysis Services On Q1, i want it will show December, January, February, but it's shows January, February, December.

I have this idea to create the value on field month like this:
01 - December
02 - January
etc

But I don't want to use this method, but if I stack I will use this method.

But if some one could show other method, I would really apreciate it.

Thank.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources