DSXchange

Your question about refresh frequency also makes me wonder about implementing slowly changing dimensions in the dimension server. Thoughts on the best practices approach to the good old friend of data warehouse developers? The dimension server does an excellent job of supporting slowly changing dim...

This is a template for some 'canned' properties to support Hyperion Enterprise. If you run the script it will create the property categories and the properties. These are really only useful if the Enterprise export class was purchased and activated.

After rereading your question, often if the dimension server is not the source for new nodes in a particular dimension, like accounts, then ETL feeds may occur daily. There are multiple ways to get data into the dimension server, all of which are subject to the same rules and validations that user m...

Typically the dimension server controls the reporting hierarchies for the enterprise as a whole, so BI processes get approved organization, account and other hierarchies from the dimension server. The hierarchies, or reporting structures, are managed independently from application data by the data s...

Keeping in mind that a dimension server manages reporting dimension hierarchies and their associated reference/translation data, but doesn't deal with actual transactional records, it is difficult to say whether or not data quality assessments are relevant to the success of an implementation. In my ...

From a practical standpoint, often clients want to implement a departmental solution as a proof of concept prior to committing to reorganizing their business processes around centrally managed hierarchies and reporting dimensions. Fundamentally, an enterprise's implementation of a dimension server i...

A node level property should be created to calculate the node type, usually a lookup or derived property. There is a hierarchy level property called 'HierNodeType', which can be set to point to a node level property that provodes the node type for a given node to the hierarchy, which then applies th...

This section allows local properties, or properties configured to vary by hierarchy to be imported.

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 shi...