Hi,

What is the meaning of the property "Fact Table Size" for the design
storage?
If this property is set to 1, will the aggregations be created during
the process of the cube (let's say the cube uses only one partition)?


Thanks,
Shirly.




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Fact Table Size is extremely important in determining what aggregations are
created by the server. I'd recommend that you read the following whitepaper
which gives a much better explanation of the topic then what I could
possibly cover here in a couple of paragraphs.

http://www.microsoft.com/technet/tre...e/ANSvcsPG.asp


Sean


--
Sean Boon
SQL Server BI Product Unit

**This posting is provided AS IS, with no warranties, and confers no
rights.**

"Shirly Baruch" <shirly.baruch (AT) intel (DOT) com> wrote

Hi,

I read this paper and it is written there that when a client queries a
cube, all measures in the cube are read from disk and downloaded,
regardless of the measures specified in the query.

What does it mean?
1. Does it mean that the definition of the measures is downloaded or
that aggregations are downloaded? What exactly is downloaded?
2. Are the measures downloaded to the server's memory or are they also
downloaded to the client machine?

Thanks,
Shirly.




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

1. When an aggregation is read, all measures are read for that aggregation.
"Download" sounds like an imprecise word usage.
2. Server memory

- Matt Carroll
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Shirly Baruch" <shirly.baruch (AT) intel (DOT) com> wrote