How to select data on 31 Dec | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to select data on 31 Dec

Hi everyone…i’m developing an OLAP report which consist of date and vehicle dimension…and also Amount as measure…the date dimension consist of year,quarter,month and day…now i want the date dimension to view only the Amount of 31 Dec every year…which means that in the report, when i extend the month level, it will only show 31 Dec…how can i do that?…if there’s any calculated members required, what is the syntax and where to put it?…can anybody give me an example?…for your information, i’m using MSSQL server 2000 analysis services and MS Excel to view the report…thank you.
See thishttp://www.zachhunter.net/blog/How …oft SQL Server OLAP Date Dimension Table.aspx andhttp://msdn2.microsoft.com/en-us/library/Aa159896(office.11).aspx too Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
@http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>