Olap Server
Mar 16, 2006Hi everyone, Sql express support olap server?, because I try it to make an a Pivot table in Ms Excel, but i can't, then Sql server have this feature?thx.p.d: sorry but my english :P
View 3 Replies
ADVERTISEMENT
OLAP Services: Automating Archival/Restore Of OLAP Databases
Sep 19, 2000Hello 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"
JG 1942-1995 RIP
How To Repair A Corrupted OLAP Database? (was Olap!:)
Jun 12, 2007How to repair a corrupted OLAP database?
View 2 Replies View RelatedOLAP Server
Apr 15, 1999Anyone managed to get the OLAP server installed onto SQL7 Desktop?
I'm running it on Win98 and the installation only offers the Client and sample applications.
Obviously the client won't connect as there's no server to connect to.
The documentation on what does/doesn't run in Desktop version doesn't mention OLAP server.
Please email reply to me at RussLewis@msn.com
Thanks
OLAP In SQL Server 2005
Mar 21, 2007HI, i am new to OLAP in Sql Server 2005, bascially i have read through lots of article on this OLAP and basically i get to know how it works and function theorically, but i could not find an article to show me step by step on how to create the cube and how to query the data from the cube. Would very much appreciated if somebody out there can explain to me in details how to i create cube from sql server 2005 as i totally no idea at all. Though i can view the sample cude in sql server 2005, but i dunno how to create it from my relational database. I need it very urgent as needed by my job functionality. Hope to get some explanation from you guys asap. Just assume i am totally new and please guide me step by step to create a normal and simple cube and query from the cube. I just need to create simple prototype. Thanks alot yea guys :)
View 3 Replies View RelatedConnecting To OLAP Server
Jun 7, 2001I keep getting this error when trying to connect users to the OLAP server from Excel (using SQL 7.0).
"Unable to open connection.
Cannot Connect to server 'OLAP Server Name'.
OLAP server error: The operation failed due to network problems."
When I use this excel on my machine it works just fine. Any ideas?
OLAP Server Stability
Mar 19, 1999Is anyone satisfied with stability of OLAP-services ?
We´ve got a cube with 103 Levels and about 1.100.000 rows in the
fact table.
After processing the cube everything works fine.
After changing the fact-table (new rows) the only option is to
process the cube (no incremental update or refresh offered).
OK.
After processing the cube (which sometimes failes) the cube sometimes
containes wrong data !?
Sometimes during operation with the OLAP-Client(inSight from arcplan)
the data changes.
Sometimes it is not possible to connect to the cube.
Did anyone have same or other or better experience ?
Keen to discuss !
Connecting To OLAP Server
Feb 27, 2001We are running SQL Server 7.0, Service Pack 3, on a NT 4.0 (Service Pack 5a?)
server. The server is running both SQL Server and OLAP.
When attempting to connect to the OLAP instance on the NT 4.0 server from a local
PC, also running SQL Server 7.0 Service Pack 3, the following error message is
displayed:
"Cannot retrieve the repository information from the server [datamartact]."
Note: 'datamartact' is the name of the NT 4.0 server.
Does anyone encountered this message before? Could this mean that the person
who is trying to connect neads read or read/write permission to the partition
were the repository is kept?
Bill Zimmer - zim@ibx.com
Register Server OLAP
May 6, 2005I want register a server it is on other PC is a server, BUT IT SHOW TO ME A MESSAGE OF ERROR:
Errors ocurred while connecting to ----ip-----
Cannot open connection to Analysis server ----ip-----
Can not connect a server ----ip-----. not this in operation or this occupied
Do you still Want to register this server
Setting Up OLAP Server: Need Help!
Aug 24, 2006:eek:
I am having trouble setting my SQL databases up as analysis services databases in SQL Server '05. Does anyone know how to help me???? I have lots of cubes to build, but I can't get the datasources there.
Thanks much for any advice.
mbunch@bighammer.com
OLAP Server Connections
Sep 21, 2007Hi all,
Is it true that connections to the OLAP server can only be made using a Windows Account?
Is there a way to setup those connections to the OLAP using a Standard Account?
Thanks in advance
Yukon DBA
Sizing An OLAP Server
Apr 16, 2008Hi there,
We are experiencing some contention of resources between our RDBMS and our OLAP environment; both SQL2005; so we are going to put the OLAP side of life onto another seperate box. Therefore I need to work out what sort of requirements we are going to need; and this is where i have no idea.
I have had a look at the HP sizers, however this is looking primarily at normal RDBMS setups rather than specifically for OLAP. Is there any specifics that I need to consider/nail down before working this out?
To give you an idea:
We currently have 210 million rows in our main fact table, and each row is averaging about 330 bytes
The size of our current OLAP database is only 4GB
It appears as though we are currently getting anywhere between 6 and 20-30 concurrent users
Considering the above; I would have thought a dual core cpu setup (maybe x2) with 8-10GB of ram would have been the ticket?
Now I have done a server sizing exercise for a normal SQL2005 installation; considering temp db on seperate spindles to the log and database tables etc; but what sort of considerations do I need to do for a server running SSAS?
Thanks in advance for any assistance anyone can offer on this front
Regards
Troy
Unable To Connect To OLAP Server
Mar 1, 2000I have SQL Server 7 SP1
OLAP Server SP1
installed on two WIN NT 4 SP5 machines.
On machine 1 I can connect to the locally installed OLAP Server, but cannot connect to machine 2's OLAP server. (and vice versa machine 2 cannot connect to machine1's OLAP server)
The error I am getting is the following:
"Error occurred while connecting to machine2
Cannot open the following registry key on the server computer(machine2):
SOFTWAREMicrosoftOlap ServerServer
Connection Info"
Can anyone give me a clue as to what is going on.
(note: I have tried the 'default' MS troubleshooting method of re-installing - no change)
Thanks
OLAP Server Connect Error
Jul 14, 1999All of my client boxes connect nicely to MS OLAP Server except one which fails with the following message: "Cannot connect to the registry on the server computer (servername)" where servername is the name of the server on which OLAP server resides.
Anybody seen this???
Registering Server In OLAP Manager
Jan 26, 1999I'm trying to register a remote OLAP server under OLAP Manager.
After I enter the machine name I get the following:
Errors occurred while connecting to <server>.
Cannot open the following registry key on the server computer (<server>):
SoftwareMicrosoftOLAP ServerServer Connection Info
Do you still want to register this server?
The noticeable thing about this error message is that the registry key is missing the first level (HKEY_....). Has anyone been able to register a remote server? I can run OLAP Manager on the server without a problem. I just uninstalled and reinstalled OLAP services on the server and my desktop.
There is a registry key with this path under HKEY_LOCAL_MACHINE on the server.
Acces An Remote OLAP Server
Jul 22, 2005I try to access an OLAP Server from a remote compute, using ADO MD Library with following string conection :
"Datasource=SERVNAME; Provider=msolap; Initial Catalog=FoodMart 2000;"
I recive the following error code: -2147467259 (0x80004005), "Unspecified error"
Can sombody help me
OLAP Server Or SQL Analysis Service
Jul 24, 2006Hi
I am new to SQL Server and not quite understand the difference between OLAP server or SQL Analysis Service. Are they referring to the same thing?? An user asked me to confirm that the OLAP server is active on a server running SQL Server 2005, what do I need to check. The Analysis service is up and running, does it mean it is OK??
Please advise.
Thanks.
OLAP Server Returns Incorrect Data
May 24, 2001I'm working with PivotTable on Excel 2000 which is connected to an OLAP server (from SQL Server 7 installation). The pivot is intended to analyze Sales during April 2001. Yesterday I found out that OLAP/Excel returned/displayed inconsistent data. The 'April Total' value is NOT equal to the 'Quarter 2 Total' (I already inspected the underlying database and sure that there is absolutely NO data for months after April 2001). The value for 'April Total' is the correct one. I'm not sure whether the problem resides on the OLAP Server or Excel (pivot) itself. For ones who like to help me I would be glad to supply you with the screenshots (just email me).
Please help.
Regards
Dave
Crystal Analysis 9.0 Vs MS SQL Server 2000 (OLAP)
Oct 2, 2005Hi
I want to connect MS SQL 2000 Server with Crystal Analysis via OLAP.
I have installed SQL with Windows authentication mode and installed crystal Analysis 9.0
I have configured Crystal OLAP connection setup.
When I am trying to open or create new application through CA I am not getting through OLAP connection with SQL and I am receiving the error as the following.
Error 1
" Unknown User name and bad password."
Error 2
Failes to initialize.( Cannot connect to the server 'XXXX." the server is not started or too busy)
My SQL server has already started.
Please advsie me ASAP.
Why Isn't Microsoft Actively Marketing SQL Server 2000 OLAP?
Apr 9, 2001I recently wrote a white paper on OLAP and was having a hard time finding any information about what was new in SQL Server 2000 OLAP on the web. I didn't really find much until I downloaded a trial copy of SQL Server 2000 (which didn't have OLAP, but had links to information on it). We use Hyperion Essbase, and I was wondering if Microsoft OLAP 2000 would be a viable competitor.
View 2 Replies View RelatedSQL Server 2008 :: OLAP CUBE And Data Sources
Aug 3, 2015I've
1. Data Warehouse
2. OLAP CUBE in Analysis Services
My question is - If my Data Warehouse is changed (Having Append Data) - My OLAP Cube will have the Append Data?
It's possible, my OLAP Cube always having Append Data if my Data Warehouse is changed? If yes, how to do it without re-deploy and re-process my Analysis Services Project....
Ting Services For Reports On DW And OLAP (SQL Server 2005)
May 7, 2007Hello,
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).
There are any limitations or bugs to using it.
This is good for trends.
Thank, any help will very appreciated.
Copy An Olap Database To A Remote Server Using SSIS
May 2, 2008How to add a task to copy an OLAP database to a remote Sql server in control flow using SSIS 2005? This OLAP database is existed in the remote server and I just want to replace the existing one with the one just been updated in the SSIS package and the last task in the package is to copy the updated OLAP database and replace the one at the remote server. Hopfully during the copy and paste process it will not screw up the reports that are using the OLAP cubes at the remote server as the report data source. Thanks.
View 6 Replies View RelatedUsing SSIS Packages To Process SQL Server 2000 OLAP Objects
Nov 16, 2006Can a SSIS server, i.e. staging server be used to create packages that update SQL Server 2000 Analysis services objects on another server running SQL server 2000 OLAP?
It appears that the OLAP connection manager ion SSIS supports only connections (and thus updates) to 2005 OLAP objects. I work for a company that has a huge investment in a 3rd party DW that uses Analysis Services 2000. the DW tool vendor will not support an upgrade to SSAS 2005. We wish to extend the DW from other data sources. My thought was to use a staging server with SSIS, used solely as the ETL tool for all new development (thus no more DTS development), and to update the sql server 2000 operational data store on another box.
I can find no documentation on how to process sql server 2000 analysis services objects from within an SSIS package. Any ideas?
Excel 2003 To SQL Server 2005 OLAP Cube Timeout Issues
Nov 13, 2007
Hola
We are getting symptoms of a 30 second timeout irrespective of what we do, but only on certain machines. Can anyone shed any light on how the connection timeout can be set, as there seems to be a factor overiding any settings we set?
We are working in Excel (2003) connecting to an Analysis Services 2005 cube through a website https://Datasource connection. When we edit the connection string that the file is using (either by forcing use of an exterior .ODC file and editing the settings in there, or by converting the xls spreadsheet into an xml spreadsheet and manually editing the connection string in there) we get no joy: after 30 seconds the error appears:
"Either a connection cannot be made to the [my server address], or Analysis services is not running on the computer specified".
This error is itself rubbish: If a smaller query (one that takes < 30 seconds) is run in the same Excel file and Pivot Table, it connects fine.
What really doesn't make sense is that the exact same file works on some machines and not others. These machines are all inside the same network (and the machines that work have been proven to work on a number of other networks). What's more there is no pattern to the machine capabilities - some newer / faster machines get the error. These machines (that work and do not) have excel 2003 SP3. (Another of the ones that works has Excel 2007).
Changing the connection string to include "Timeout=300" or "Connect Timeout=300" makes no difference, and "Command Timeout" causes a different error so that it wont even attempt to run the query (as opposed to collapsing after 30 seconds of normal progress).
Similarly in the .ODV the tags <ODC:CommandTimeout>, <CommandTimeout>, <ODC:Connect Timeout>, <ODC:Command Timeout>, <meta name=CommandTimeout content=1000> etc. have no effect (the file still gets the 30 seconds error rather than just giving up so no way of working out correct syntax)
The only pattern we can see, and we can't fix this, is that the machines that work have Retail versions of excel, and the ones that do not have corporately licensed versions of excel. We cannot see any difference between them in the Help >Abouts, but thought it might be worth mentioning.
Any help would be fantastically appreciated, we are out of ideas.
Thanks kindly
Amundo
OLAP And ASP.NEt
Aug 2, 2005Hi,
I am looking at deploying an ASP.NET site which accesses an OLAP database - Microsoft Analysis Services
My question is how is this normally done:
Straight SQL / Stored Procedures
3rd party Adhoc plugin
Anything else
If there is anyone out there with experience in using ASP.NET and
Analysis Services I would be interested in hearing how they did it -
Database Architecture
System Architecture
and any
pitfalls etc...
Thanks in Advance
Jerry
OLAP
Aug 12, 2005Does any one know a very good control for OLAP in ASP.NET?
View 2 Replies View RelatedOLAp And MDX
Jul 28, 2000How 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.
OLAP
Jan 17, 2001I 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'
Does anyone know how to fix this problem.
Thank You,
Mark
SQL 70 And OLAP 2K On Same Box
Sep 25, 2001Has 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.
View 2 Replies View RelatedOlap
Jul 7, 2004hi,
i need "microsoft(r) sql server(tm) 2000 analysis services step by step" in digital,can you help me ?
shawnlee@cena.com.cn
OLAP Help
Jan 20, 2004i do not know if i am posting in the right place so forgive me if i have.
also i have search and cannot find any answers to this.
ok, i have Windows server 2003 and i want to run SQL on it, i got SP3a and i found out i need something like OLAP, and my PC does not have OLAP on it.
so i was wondering if someone will tell me how/where i can get if from.
thanks alot.
Mrbob2
OLAP
Mar 20, 2007Mary writes "Hi
Could you give me some notes about ALAP ? What is ALAP exactly? What is the usage of this part of SQL? Could you give me some example.
Thanx"