Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

query performance with a very large dimention

query performance with a very large dimention

query performance with a very large dimention


We have a cube with more then 1000000 dimention members

How to improve response time?

RE: query performance with a very large dimention

I don't know what server you are using. The only MOLAP server that I know of that will cope with this is TM1. Various ROLAP servers will cope with this.

I know MOLAP Servers best. One tip I would give you is to introduce more consolidation levels into the dimension, even if they are artificial splits like a consolidation of A-M and N-Z. Adding consolidations can improve performance as it lets the OLAP Engine section the data. If it has to go straight from 1 million elements to a single top level number then for whatever reason this is harder than adding up via several intermediate levels.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close