SQL Server Performance

How to select data on 31 Dec

Discussion in 'Analysis Services/Data Warehousing' started by biru, Jul 25, 2007.

  1. biru New Member

    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.
  2. satya Moderator

Share This Page