SQL Server Performance Forum – Threads Archive
Why I can’t browse the cube???
I am a beginer of sql server.When I run the Analysis Service then right click the cube of sales in FoodMart2000 then click "browse data" ,but the "cube browser" just show mean error "Unable to browse sales;uaable to find sales".I want to know how can I deal with the problem.
thank you!
Ensure to install latest service pack for Analysis server and login used does have required privileges to access the cube data.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
is the cube processed? Right-click it and select Process and follow the steps in the ‘wizard’. Are you able to Edit the cube? (Right click and select Edit).
What option set for ‘ALL CAPTIONS’? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
To satya:
I have installed sql server sp3a.There are 3 service pack and I installed them all.And how can I set the privileges to access the cube data when I login.And how can I set ‘ALL CAPTIONS’ option? To stevefromOZ:
The cube is read-only,how can I set it to read-write?
Thanks for all of you!!1
Follow through this linkhttp://www.winnetmag.com/Article/ArticleID/7832/Windows_7832.html &http://www.microsoft.com/sql/techinfo/BI/ for step-by-step about OLAP. And also thishttp://www.databasejournal.com/features/mssql/article.php/1429671 link. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>