Microsoft Data Analyzer

I have downloaded Microsoft Data Analyzer and it is
asking for a CUBE on online OLAP server. Is there anyway
to connect it to Data in a plain 2000 SQL server.
if I do need OLAP what do I need to install on my SQL
server
Thanks
Steven Hill wrote:
> I have downloaded Microsoft Data Analyzer and it is
> asking for a CUBE on online OLAP server. Is there anyway
> to connect it to Data in a plain 2000 SQL server.
> if I do need OLAP what do I need to install on my SQL
> server
You need to have OLAP services installed on your SQL Server. From MDA FAQ -
OLAP refers to an online analytical processing database capable of handling
queries more complex than those handled by standard relational databases. It
does this through multidimensional access to data, intensive calculation
capability, and specialized indexing techniques. To learn more about this
technology, visit the OLAP and Data Mining page
(http://msdn.microsoft.com/library/de...-us/createdw/c
reatedw_1vqf.asp) on the MSDN site.
sincerely,
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.
sql