Hi,
I recently started to use Analysis Services 2005 after i build my cube i initiated the adhoc analysis in Excel... what was my surprise when i saw the msmdsrv.exe process reaching over 800mb Memory occupation... and no data was return for hours...
Is this normal? When i design the aggregations in that cube i calculted the total items of about 338.323 or so... but then said 0 Agreggations made.. so i get a little bit confused here too...
Anyone experiencing this?
Best Regards,
Luis Sim?es
Well i have found that the problem is one of mine dimensions... It as 1031 members and about 200 are using rollup formulas...
Can this be the problem?
|||Do you have any user hierarchies in the cube dimensions? I am talking about hierarchies in the old AS2000 style.
If the cube have dimensions with user hierarchies, have you designed attribute relations between the levels in each user hierarchy?
Kind Regards
Thomas Ivarsson
No comments:
Post a Comment