I'm trying this on a workstation running XP Pro SP2. IIS 5.1 is on it and working. Analysis Services patched to SP3a is on it and working. I am attempting to create a cube through a web interfac...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21411411.html
Hi,
Is there a way to configure SQL Server 2000 SP3 Analysis Manager to work on a server without having to give users local admin rights? They are in the local OLAP Administrators group, but it ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22760937.html
Hi,
I am trying to make a remote connection to the Analysis Server running in a PC with XP Professional in my LAN.
First, I am trying to use the Microsoft Sql Server Management Studio, but af...
http://www.experts-exchange.com/Database/OLAP/Q_23574430.html
Hi Experts
I need a tool that views the SQL Server Transaction Log File as human readable text. I need the SQL Command, the User and the Time when the user executed the command. The tool should ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21514026.html
Hi Experts
I am trying to work my way through the Analysis Services tutorial but am falling at the second hurdle, as I cannot get Analysis Manager to connect.
I have SQL Server Developer Ed...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21576466.html
Hi,
I am new to SQL Server 2005 Analysis Service. Please treat me as a dummy.
I have setup and used SQL Server 2005 Analysis Service for 2 months and I just changed the server name that insta...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2343...
I'm wondering if there is a way or guide out there (I can't seem to find much on regarding this anywhere) to deploy SQL Analysis server on a SQL 2005 cluster.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2343...
Using SQL Server Analysis 2000, I am able to Process the Database through the Analysis Manager, but when I attempt to browse the cube processed I get the error message:
Unable to browse the cube...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23644746.html
Hi There,
Is there a way to find out if a member exists in a set in MDX other than using STRTOSET?
I do not want to use: (since STRTOSET is expensive and sort of deprecated)
IIF( STRTOSET(@A, ...
http://www.experts-exchange.com/Database/OLAP/Q_23290152.html
Hi Experts,
I have this question regarding the sort order of MDX query. I did the example (attached doc) on AdventureWorks cube.
Question:
1. Does anyone know what is the sort order for the...
http://www.experts-exchange.com/Database/OLAP/Q_23501049.html
