Help Needed with Analysis Services 2005

Tech-Archive recommends: Fix windows errors by optimizing your registry



Hi,

I am new to Analysis Services and was wondering if some one could
assist me with the issues I am having.

Basically we have one single table on which I need to build a cube so
that managemet can view the data in excel and have good perofrmance. I
started with AS 2000 but ran into the issue of having more than 64,000
members for a dimension level which were not unique.I tried various
suggestions given on the forum but none worked.

So I installed AS 2005 but it is so different, I mean I am not able to
create a cube using a single table as I was able to do it in AS 2000.
Is there any documentation online that I can reference to get a handle
on AS 2005, I read the documentation(Tutorial) on MSDN but it does not
shed any light on the issue of creating a cube using a single table.
Any help in this regard would be appreciated.

Thanks

.



Relevant Pages

  • Re: how do I load a cube?
    ... sql 2005 analysis services but there is no option to load a cube. ... New to analysis server. ...
    (microsoft.public.sqlserver.olap)
  • Re: Analysis Manager - CubeSales - browse data
    ... This setup will install latest version of OLEDB for OLAP provider. ... > I have installed Analysis Services from a development version of SQL ... > select browse data - this message is displayed: Unable to browse the cube ...
    (microsoft.public.sqlserver.olap)
  • Re: LIMIT OF FACT TABLE DATA
    ... There is no limit on the size of the fact table in Analysis Services. ... "Akber" wrote in message ... ETL and SQL Server Analysis Services for viewing the cube. ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: how do I load a cube?
    ... sql 2005 analysis services but there is no option to load a cube. ... New to analysis server. ...
    (microsoft.public.sqlserver.olap)
  • Re: Performance problems with cubes
    ... All of this is discussed in detail in the Analysis Services Performance ... Operations Guide ... using the optimize schema tool (from the cube editor) to simplify the SQL ... >> Program Manager ...
    (microsoft.public.sqlserver.olap)