Hi,

In ssas2000 you are able to make a dimension with hierarchies based on
a date field in the facttable: Year > Month > Date

In ssas2005 this feature/wizard is not available anymore.

What is the best way to have the same result?

I did migrate an existing ssas2000 olap cube to ssas2005 and see that
the problem is solved by adding calculated fields in the UDM views for
all hierachies.

Is this the best way ?

Regards, Marco
www.gmsbv.nl

AS2005 has a time generator system
you can create a dimension and the equivalent database table in some
clicks...

right click on "Dimansions" then "New Dimensions"
select "build dimension without data source" and you have a date template.


"Marco" <olap (AT) gmsbv (DOT) nl> wrote

Probably the closest thing to the AS2k setup would be to use a "server
time dimension" http://msdn2.microsoft.com/en-us/library/ms174832.aspx

Although I generally tend to setup my own table for the time dimension.

Views over the fact table would "work", but SSAS would have to do
multiple "SELECT DISTINCT..." queries over the fact table in order to
build the time dimension which would not be very efficient.

--
Regards
Darren Gosbell - SQL Server MVP
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1157398677.465102.87830 (AT) m79g2000cwm (DOT) googlegroups.com>,
olap (AT) gmsbv (DOT) nl says...

Don't use views over the fact table -- they are slow and incomplete (if you
have no sales for a date in the fact table then that date wouldn't show up
in the time dimension). If necessary you can use the dimension wizard to
actually create a new time table (using the same information as the server
time dimension) and build the dimension from that...

Thanks,
Akshai
--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Darren Gosbell" <jam (AT) newsgroups (DOT) nospam> wrote