Answered You can hire a professional tutor to get the answer.

QUESTION

Optimize cube and measure group design-Keep cube space as small as possible by only including measure groups that are needed.

Optimize cube and measure group design-Keep cube space as small as possible by only including measure groups that are needed.Define cascading attribute relationships (for example Day > Month > Quarter > Year) and define user hierarchies of related attributes (called natural hierarchies) within each dimension as appropriate for your data.

B) Define effective aggregations -Avoid designing an excessive number of aggregations. Excessive aggregations reduce processing performance and may reduce query performance. If SQL Server Profiler traces indicate that most user queries that are not resolved from cache are resolved by partition reads rather than aggregation reads, consider using the Aggregation Manager sample application to design custom aggregations.

C)Use partitions -For optimum performance, partition data in a manner that matches common queries.Define partitions to enable Analysis Services to query less data to resolve a query when it cannot be resolved from the data cache or from aggregations. Also define the partitions to increase parallelism when resolving queries.

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question