August 5, 2003 at 3:49 am
Hi everybody
It will be very helpful to know
what is the size and the minimum and maximum values for every data type (or at least integers and decimals) that can be assigned to a cube's measure and how this setting affects cube's size and processing/query performance.
Is there a related link?
Thank you very much in advance
August 5, 2003 at 9:01 am
Take a look in SQL Server Books Online (BOL) and search for Data Types. As far as I know, Analysis Services can use any data type [that SQL Server uses] for measures and dimension members. As far as how the data type affects the cube size, you can do the math on the bytes used by each data type multiplied by the number of rows in the fact table by the number of possible intersecting dimension data points...or something like that. That should give you a rough idea of how data type will affect cube size.
hth,
Michael
Michael Weiss
Michael Weiss
August 6, 2003 at 3:16 am
My 2 cents worth: I was having problems a while ago with the ntext data type and Analysis Services. I ended up leaving it out and haven't tried since so I'm not too sure if analysis services "accepts" ntext data types.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply