sp with time hierarchy - 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

General SQL Server Forums

New to SQL Server Programming

sp with time hierarchy

Author

Topic

asad.lte
Starting Member

32 Posts

Posted - 2010-05-28 : 06:22:26

hi experts,

i was asked to write a sp for time hierarcy like year,month,dayof week.example The Year, Quarter and Month values must always remain in the cube.
The Days will be a rolling 63 days.

Label formats should be as follows:
Year should be “CCYY”. Example: 2009
Quarter should be “Q# CCYY”. Example: Q2 2009
Month should be “MTH CCYY”. Example: APR 2009
Day should be “MM/DD/CCYY (day-of-week)”. Example: 04/06/2009 (MON)

= = =
Question: Can we also add a Day-Of-Week hierarchy similar to what was used in Application Submissions cube?

this is the req.plz support me to put tht in shape.this info is enough r still something is required.post ur comments n suggestions

vaibhavktiwari83
Aged Yak Warrior

843 Posts

Posted - 2010-05-28 : 07:48:58

What are you going to pass the SP date of what??

Vaibhav T

To walk FAST walk ALONE
To walk FAR walk TOGETHER