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?
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"
The installation SQL 2008 R2 Management Tools on a Windows 7 workstation fails with the error, The specified account already exists.
Final result: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
I am running SQL Server 2005 x64 Enterprise under Windows 2003 x64 Enterprise. My current backup strategy uses T-SQL jobs run by SQL Agent (writes out *.bak files) and then I have an Integration Services job that copies the *.bak files to our NAS device. I have performed a restore without issue. The jobs are all automated every four hours via SQL Agent. Is this a sound strategy or are there additional benefits to using 3rd party tools? If so, what are the advantages and which tool provides them?
Login failed for user 'TOSHIBA-USERASPNET' I know that the file persmission for the web application have to include aspnet, so i keep resetting the folder permission for aspnet in file manager, but the login failed keeps coming back every day or two problem is after working with VS05 Pro, SQL Server Management Studio CTP, somehow the aspnet persmission get changed, use alot of sqldatasource wizards and often there is a conflict/hang between the datasource wizard and the need to have the mdf in a dettached state within VS server explorer, not sure but the procedure to fix this seems to be to reboot, detach and re-attach the mdf in the Sql server Studio tool, re-apply the aspnet file permission on the web app folders (wonder should i be doing this in IIS instead), make sure the mdf within server explorer is detached, the it works anyway, getting real tired of the resulting delays and design time derailment, clues greatly appreciated, thanks sometimes i can use View in Browser when in VS05 form view and i wont get the aspnet folder permission error and other times i do. last thing, is it a bad idea to give aspnet full permission for the entire web applicaiton??
Is there - apart from the notorious RESTORE HEADERONLY - an tool which is able to tell which SQL Server version created a specific BAK file? I'm looking for a tool that can be used w/o an available/running SQL Server installation.
Alternatively, is there any documentation about what is read with RESTORE HEADERONLY so I could write a tool myself?
Where would I find the version "bytes" in a BAK file?
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.
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......??
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?
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'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!