OLAP Services: Automating Archival/Restore Of OLAP Databases
Sep 19, 2000
Hello All,
Our OLAP environment involves an ETL/Data Warehouse/Data Mart server and a cube publisher server.
We would like to learn how to automate the Archival/Restore of OLAP databases. We are currently doing
it manually though OLAP Manager. Any help would be appreciated. Thanks. James.
--
James E. Bothamley
Senior Database Administrator
Dave & Buster's, Inc.
2481 Manana
Dallas, TX 75220
Work
Phone (214) 904-2296
email jbothaml@DaveAndBusters.Com
"Once in a while you can get shown the light
in the strangest of places if you look at it right"
I was working with an OLAP Services Processing Task when I ran into some difficulties. I was prompted with a message which told me that the object could not be found. When I went back to the OLAP Manager I was not able to see the databases for that server.
Does anyone know why I can no longer see these databases i have tried refreshing/rebooting......??
We have a live OLTP database for which we create full backups every week and differential backups every day. Recently we added an OLAP database, which we need to update daily with changes from the live database.
This is the process we are planning to use. 1. Restore last full OLTP backup. 2. Apply the last differential OLTP backup. At this point we should have a replica of the live OLTP database. 3. Update OLAP database based on the OLTP replica database. 4. Delete the OLTP replica database.
Two questions. 1. If different from the process above, how is this OLTP-to-OLAP transformation typically done in the industry? 2. What is the best way to implement this process with SQL Server 2005?
I have installed OLAP services along with SQL Server 7.0. I want to use the sample MDX application supplied with the CD. When I try to use the dsample application, it comes up with a dialog to enter the server name and gives me an error unable to connect to the OLAP server. My computer is Windows 98. Do I need to install OLAP Server ? If so how ?
I try to load in a C# application a DTS Package containing only one OLAP Task. But the "LoadFromSQLServer" command hangs for 1h30 before retrieving the DTS Package information. The same code is working perfectly fine for other DTS Packages.
I have already set the Workflow properties of the DTS task to "execute on main thread". It doesn't change anything.
We have an OLAP Cube which has 126 Levels in it (128 is maximum). The processing of this cube only works sometimes. Latest problem is the folling error message when refreshing the cube´s Data-Source:
Failed to inform the OLAP-Server to refresh the connection to the 'A000S8-DW' data source. (A000S8 is the OLAP-Server-Name) Error: Cannot open transaction to the server. Cannot open database 'A000S8' on the OLAP-Server. (There is no A000S8 database on the Server A000S8 !)
When i test the connection in the data-sources-properties-box it says 'TEST Connection succeeded'
I have cube created, When I use the drill through option for some cells I get the the following message
'Unable to drill through. The operation requested failed due to timeout'
I tried setting connection timeout in the advanced tab of data Link properties to max(at the moment set to 15 seconds), But could not save that. The Analysis manager does not respond.
I have created a DTS package which should process an Incremental Update OLAP Cube ... however it is generating the following error message ... HELP has anyone seen this before ?
I would like to know if Reporting Services 2005 is a good tool for making reporting activities on SQL Server 2005 DW and also using OLAP (Analysis Services 2005).
Hello,Can I import an OLTP (Reltional DB) as a Data Source into SQL ServerAnalysis Services 2005 and then use the Cube Wizard and the new DataSource View feature to create the OLAP model ?Or do I have to first design an OLAP Data Warehouse with a Star Schemaand then import this DW as a Data Source into my Analysis ServicesProject.With SQL Server 2000 , OLAP would be the way to go..but with SQLServer 2005 , it seems as though the wizard and data source viewfeatures do half the work for you.I have an OLTP DB and am not sure which route I should take ! Anysuggestions / input would be much appreciated.Thanks in Advance...RegardsRusszee
How do I use vba string functions in MDX queries? The on-line help says that the functions can be used but I can't figure out the right syntax for it. PLEASE HELP! I want to take the first letter from a level i.e.([NET INCOME] in the e.g. below) and display it.
For eg. WITH MEMBER [DIMENSION].[NET INCOME].A AS 'LEFT({[DIMENSION].[NET INCOME].MEMBERS,1})' SELECT measures ON COLUMNS, [DIMENSION].MEMBERS ON ROWS FROM CUBE a.
I have install OLAP srvice on SQL Server 7.0 server. When I try to connect to OLAP server I get the following error: 'cannot connect to the registry on the server computer'
Has anyone tried installing an OLAP Manager 2000 instance on a server that already supports SQL 7.0 and OLAP 7.0? We will not be using the OLAP 7.0 instance so we would like to either upgrage OLAP 7.0 to OLAP 2000 or unistall OLAP 7.0 altogether. Any feedback would be helpful. Thanks. James.
Analysis services is installed on a Windows 2000 server (call it computer A) in Domain A. SQL 2000 has been installed on the server using mixed security. All of the SQL services are running under an account in Domain A (not local system). The problem is the computer (call it computer B) I wish to run Analysis Manager on and use to administer the Analysis services on Computer A is in Domain B. There are no trusts between Domain A and Domain B. Can Analysis services be administered by a computer in a domain not trusting the domain that the server running Analysis server is in? Any help would be appreciated. Thanks
Hi, Can anyone tell me where to fine some good help on designing Date type dimensions in an OLAP cube. This particular thing has been a pain for me.. I have a Time dimension in my CUBE which has year-week-day as levels. I want the week to start from Monday and span seven days ( naturally !! ). But OLAP surprises and entertains me by showing different number of days in every week. Whatever I do, it never starts a week on Monday and spans it for next 7 days consistently.
I've installed SQL7.0 and OLAP service on my PC(windows 95), but I cannot find the OLAP Manager. Can an OLAP Manager be installed on Windows 95? If it cannot, can I create an OLAP database (or application) on my PC?
So I am starting to look at an OLAP problem having been an OLTP DB wonk for several years.
All very nice. Am bending my head aorund cubes and the dimensions trciks and learing to choose them more carefully.
Have wokred through the various chapters of various SQL books (OLTP books with a couple of chapters of OLAP I admit) and am starting to feel if not comfortable with it at leats not compleetly terrified.
Now the Analysis manager in SQL is all well and good but I'm not about to hand it to the accounting monkeys that work here.
Does anyone have any suggetsions of some good OLAP specific books and any Cube viewing tools/suites/utilities that I can give to the computer-illiterate bean counters I work for?
I'm new to this forum and as well as new to OLAP testing . I would like to know OLAP testing and guidance for SQL server anlaysis services .
I have been trying install SQL server 2000 in my system but it not going through, Can anybody send information how to install SQL server and how to play with sample database.
I'm trying to retrieve calculated members from a cube using the OPENQUERY function and a OLAP linked server, the results from MDX Queries are then stored to a SQL Server DB Table.
below is the error message I get:
Could not get the data of the row from the OLE DB provider 'MSOLAP'. OLE DB error trace [OLE/DB Provider 'MSOLAP' IRowset::GetData returned 0x80040e21: Data status returned from the provider: [COLUMN_NAME=[Measures].[first column] STATUS=DBSTATUS_E_UNAVAILABLE], [COLUMN_NAME=[Measures].[second column] STATUS=DBSTATUS_E_UNAVAILABLE]]
When I run the same query in MDX Sample Application it works fine!