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!