Hi All
In my time dimension(Year,Quarter,Month) field, due to some of the date values are null i am getting year values like 0,2001,2002.How to remove this 0 from my year values?

Thanks
Vasu

If are you deriving your Time dimension from a fact table field, you should build it from a separate dimension table
This way fact table records with null dates will not be included

For a complete discussion on building time dimensions see Tom Chester's excellent article

http://www.sqljunkies.com/Article/D1...0D60951395.scu

HTH
Bria
www.geocities.com/brianaltmann/olap.htm

Hi Brain Altmann

I using Views instead of Fact and dimesnion Tables. For views how
can i hide the 0 year and in that replace with string 'N/A' .

Thanks,
Vasu

"Brian Altmann" <anonymous (AT) discussions (DOT) microsoft.com> wrote

You could use a sql case statement in the member name column property
However it would really be best to create a time dimension table (or view)

HTH
Brian

If you don't need them at all, just filter them out in the SQL (e.g. "where
year <> 0 ..."). If you *DO* need the members in the dimension (for
instance, I've built cubes where facts may be associated with months,
quarters, &/OR years) then base the dimension on a view rather than the root
table. Use SQL like:
SELECT Case WHEN [YEAR] = 0 then 'N/A' else cast([YEAR] as varchar) end
as MemberName
FROM ....

Assuming your table has a "YEAR" column. Alternately, you could return an
empty string (instead of N/A) for the "unwanted" members and set the
dimension to "hide members with no name".

GW


"Brian Altmann" <anonymous (AT) discussions (DOT) microsoft.com> wrote