Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
OLAP server registration
Hi, Currently, I have newly installed SQL server 2000 with SP3 and AS 2000 on Win 2003 server. When I run AS 2000 and try to register a local server, the follow message pops-up. "Cannot connect to the repository Analysis server:DEV01 Error: Cannot open a database created with a previous...- aksm4783
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
OLAP MDX expression. IMMEDIATE HELP!!!!
Hi I have a question on Drillthrough function when I am building the cube. I have a view named 'v_trans_003_06' Column named 'tran' and it contains values (null, 1, 2, 5, 6) I have a cube build on the v_trans_003_06 and the dimension name for this column is "Transaction Code" My... -
Urgent! Unable to Delete Dimension and Cubes
Hi, I have a problem in deleting cubes and dimensions. When I tried to delete a dimensions in Analysis Service, this error occur "Unable to remove dimension from the repository could not delete from specified tables" and prevent me to delete it. When I delete the cubes, it let me... -
OLAP Analysis Services
Hi, When I tried to delete a cube or dimension in a server, the message the database is read-only pops up and not allow me to delete. But I have checked that the database that refer to the cube and dimensions are not read only. Thanks.
