Hello,

I have a Datetime value in my fact table called LASTBUY,
when added it as a measure I choose MAX for the agregation function.

The problem is when browsing in MS excel, if there is a null value in fact
table,
shows 1/01/1900 in Excel

So, I used a calculated measure for this called LASTBUYCALC

iif(
[Measures].[LASTBUY] = null,
null,
[Measures].[LASTBUY]
)

Until here all was going well. All machines uses Windows 2000 Professional
and OFFICE 2003

The problem originated when browsing in Windows98 using OFFICE 2000.
All datetime cells in Dynamic Table shows values of 1-1-1900,
The PivotTable don´t show nulls (by my MDX expression), it shows empty cells.

The question is if this kind of problem is for the operative system (98) or
Office version (is Office 2000 with last service pack [3] ) and what the
actions or solutions to solve this.

Thx!


--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200507/1