Saturday, November 29, 2014

What are types of storage modes and Explain

There are three standard storage modes in OLAP applications
1.       MOLAP
2.       ROLAP
3.       HOLAP

MOLAP (Multi dimensional Online Analytical Processing) : MOLAP is the most used storage type. Its designed to offer maximum query performance to the users. the data and aggregations are stored in a multidimensional format, compressed and optimized for performance. This is both good and bad. When a cube with MOLAP storage is processed, the data is pulled from the relational database, the aggregations are performed, and the data is stored in the AS database. The data inside the cube will refresh only when the cube is processed, so latency is high.
·         Since the data is stored on the OLAP server in optimized format, queries (even complex calculations) are faster than ROLAP.
·         The data is compressed so it takes up less space.
·         And because the data is stored on the OLAP server, you don’t need to keep the connection to the relational database.
·         Cube browsing is fastest using MOLAP.
ROLAP (Relational Online Analytical Processing) : ROLAP does not have the high latency disadvantage of MOLAP. With ROLAP, the data and aggregations are stored in relational format. This means that there will be zero latency between the relational source database and the cube.

Disadvantage of this mode is the performance, this type gives the poorest query performance because no objects benefit from multi dimensional storage.

·         Since the data is kept in the relational database instead of on the OLAP server, you can view the data in almost real time.
·         Also, since the data is kept in the relational database, it allows for much larger amounts of data, which can mean better scalability.
·         Low latency.


Hybrid Online Analytical Processing (HOLAP): HOLAP is a combination of MOLAP and ROLAP. HOLAP stores the detail data in the relational database but stores the aggregations in multidimensional format. Because of this, the aggregations will need to be processed when changes are occur. With HOLAP you kind of have medium query performance: not as slow as ROLAP, but not as fast as MOLAP. If, however, you were only querying aggregated data or using a cached query, query performance would be similar to MOLAP. But when you need to get that detail data, performance is closer to ROLAP.


·         HOLAP is best used when large amounts of aggregations are queried often with little detail data, offering high performance and lower storage requirements.
·         Cubes are smaller than MOLAP since the detail data is kept in the relational database.
·         Processing time is less than MOLAP since only aggregations are stored in multidimensional format.
·         Low latency since processing takes place when changes occur and detail data is kept in the relational database.

Monday, September 1, 2014

What is use of AttributeHierarchyOrdered ?

Determines whether the associated attribute hierarchy is ordered. The default value is True

if an attribute hierarchy will not be used for querying, you can save processing time by changing the value of this property to False.

Sunday, August 10, 2014

SSAS AttributeHierarchyEnabled

The value of the AttributeHierarchyEnabled property determines whether an attribute hierarchy is created. If this property is set to False, the attribute hierarchy is not created and the attribute cannot be used as a level in a user hierarchy; the attribute hierarchy exists as a member property only. However, a disabled attribute hierarchy can still be used to order the members of another attribute. If the value of the AttributeHierarchyEnabled property is set to True, the value of the AttributeHierarchyVisible property determines whether the attribute hierarchy is visible independent of its use in a user-defined hierarchy.

SSAS AttributeHierarchyDisplayFolder

The AttributeHierarchyDisplayFolder property serves as a point of identification for the folder in which we intend to display the associated attribute hierarchy to information consumers.