Hi,

I actually posted this under another topic. Sorry for the inconvenience.

I'm using .Net with Analysis Server and 3rd party tool Snowflake for data
browsing. When I use the existing Foodmart 2000's cubes and view in webpage
via the Snowflake control, i can select measure (including calculated ones
like profit and average) without any problem and quite fast too.

When I created a another db to replicate the Foodmart DB, i also created
similar cube (Sales) like in Foodmart DB. However, when using the the same
environment as above, but connected to my sample cube, accessing the
calculated measures causes the page loading to slow down. I noticed that
aspnet_wp and msmdrv processes eating up memory resources until my system
crash. this happens only when i want to view calculated measures. View the
data in Analysis Server for my sample db and cube causes no errors.

My web page is empty except for the Snowflake control. Thus i feel the
problem is with the way i designed or generated my cube, since the Foodmart
already existed.

Any ideas on why this happens?

Poobalan