formatting - SSAS Date Measure Max StringFormat when Null -
i have cube measure of type date, performing max aggregation, of data points have null value date. in these cases, max value becomes 12/30/1899 believe earliest expression of date.
is there way have these appear in results blank rather bogus date?
i tried use measure's stringformat property no luck.
change nullprocessing property measure preserve. can in bids. open project, cube, on cube structure tab expand measure group , select measure. in properties pane select source, expand , should see property there. after process, measure null instead of default 0 gets assigned nulls. 0 gets cast date , becomes 00/01/1900 in excel.
Comments
Post a Comment