RazzaDS and Date/Time dimensions [Razza]

datastage · Posted: Fri Feb 27, 2004 1:37 pm

Since RazzaDS is intended to manage large complex dimensions with different hierarchical view across the enterprise such as accounts or product line dimensions, I was curious if there was any worth in trying to also manage a date dimension in a central place, possibly with just the goal of making the ETL updates of date dimensions easier.

Does it make sense to try this or has anyone tried this with success or failure?

ray.wurlod · Posted: Sat Feb 28, 2004 6:18 am

Doesn't really make sense. Typically you populate your date dimension well into the future. About the only thing that would ever change would be the holiday information - unless a Pope gets the noti ...

What's this?

falsehate · Participant Joined: 16 Mar 2004 Posts: 9 Points: 150

This is very often done to accomodate the automated launch of a cube with a one stop shopping approach to dimension aquisition via a Razza Dimension Server Book, which is a group of exports. Actually managing the time dimension in RazzaDS doesn't actually add a lot of value beyond the ability to ship it with the rest of the dimensionality in the cube and possibly control security configuration metadata.