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...
V7 copes with any schema - it doesn't need a Star or Snowflake, so that could allow you to normalise some less frequently accessed data and use less space. The database drivers have been improved so it should run faster.
We currently have version 5 and we are moving to 7. Do you have any...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.