We are modelling a cube in analysis services 2005 which has custom rollup due to which the performance is very slow. If i use this property cache policy=9 the performance increases a bit.
I tried it in 2 ways:
1. I changed the value of calculation cover policy to 9 in msmdsrv.ini .
2.I added the property cache policy=9 in the connection string
(for example:Provider=MSOLAP.3;Cache Policy=9;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=ABBOTT D 01050 PSO STL ABNEOSA_11299__20080122;Location=localhostsqlserver2005)
My application works fine in the machine that has analysis services 2005 but my application fails to work in the system that doesnt have Analysis services 2005.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.
Your password has been sent to:firstname.lastname@example.org
To follow this tag...
Thanks! We'll email you when relevant content is added and updated.
Share this item with your network: