Re: using OLAP on sql server 2005



I think the confusion you are having is that in SQL Sever 2005 the analysis
services cubes are created inside the Business Intelligence Development
Studio as opposed to the Enterprise Manager in SQL 2000.

You need to open the business intelligence studio and create a new Analysis
Services project.

I would take some time and do some reading inside the books online.

How to: Create an Analysis Services Project Using the Analysis Service
Project Template...
http://msdn2.microsoft.com/en-us/library/ms174481.aspx

--

/*
Warren Brunk - MCITP,MCTS,MCDBA
www.techintsolutions.com
*/


"Roy Goldhammer" <roy@xxxxxxxxxxx> wrote in message
news:%23E1K9BKSIHA.2208@xxxxxxxxxxxxxxxxxxxxxxx
Hello there

I have huge server with lots of data. Approx 500 GB.

In order to let many of my users to make their own statistics I want to
set cubs for them.

I'm new on Analasys services on 2005. On sql server 2000 It was simple to
do it but it's not look the same on 2005.

At first. what i need to do in order to create new cube?
after that. what i need to do to send only data witch added on last day to
cube?
and how can I use analsys on sql server 2005?



.



Relevant Pages

  • Re: Strange processing error.
    ... I've a sneaking suspicion that this may be down to memory, ... Analysis Services previously (especially when trying to share a box w/ a SQL ... There are around 7-10 dimension connected / measure group. ... cube Analysis Services Execute DDL Task ...
    (microsoft.public.sqlserver.olap)
  • Re: Impact on cube availibility while Processsing one of the parti
    ... The cube will go into an unprocessed state until you reprocess ... SQL BI Product Unit ... This posting is provided "AS IS" with no warranties, and confers no rights. ... >> SQL BI Product Unit (Analysis Services) ...
    (microsoft.public.sqlserver.olap)
  • Re: 2000 vs. 2005 OLAP hierarchies question
    ... Services technical drilldown white paper. ... SQL BI Product Unit ... suggestions for best practices in dimensional model, ETL, cube and ...
    (microsoft.public.sqlserver.olap)
  • VS 2005 is trying to deploy WRONG database... help!
    ... All was well and good until this latest change to the cube - all I did ... Errors in the metadata manager. ... \SX Sql Extract EC Flat.20.det.xml'. ... another dev went and compressed the entire Program Files --> SQL ...
    (microsoft.public.sqlserver.olap)
  • Re: LIMIT OF FACT TABLE DATA
    ... SQL BI Product Unit ... > There is no limit on the size of the fact table in Analysis Services. ... >> My Warehouse Data is basically in Oracle and I am using SQL Server DTS ... > ETL and SQL Server Analysis Services for viewing the cube. ...
    (microsoft.public.sqlserver.datawarehouse)

Loading