Are there any specific functional areas / kinds of analysis that MSAS can
handle well or where MSAS has any limitations compared to other BI tools?

I also need information on performance and other issues that might be need to
be considered while deciding on whether MSAS can be used for implementing a
BI solution.

Is there any place where I can get info on all this?

thanks a lot!
michelle


--
Message posted via http://www.sqlmonster.com

analysis services with sql 2005 rocks.. it is going to change the
industry.

if you need something sooner than now; you could do SQL 2000 Analysis
Services.

but at this point; all new olap development should be in sql 2005

thank you!
but can you tell me if SQL 2005 AS has any specific limitations or features
regarding financial analysis?


dbahooker (AT) hotmail (DOT) com wrote:

--
Message posted via http://www.sqlmonster.com

You can check out the list of Analysis Services Enhancements in the SQL
Server 2005 BOL documentation:

http://msdn2.microsoft.com/en-us/library/ms239136



- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

2005 provide specific features for financial analysis
there is a predefined account dimension (created from a wizard)
except dedicated financial software, I'm not sure if you can found any tool
which provide a good access except AS 2005.

for the performance question, you can handle millions of rows easely.
I have a 100 millions rows cube where most of the queries are anserwed under
1second.


"Michelle via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote

Some of the account dimension features looked pretty good.

Using the wizard you could tag accounts as being of various types
(income, expense, balance sheet) and whether the could be added up over
the time dimension or whether they should use some other scheme (such as
a closing balance) to calculate their value.

I think from memory the wizard lets you define these accounts according
to numbering schemes (eg accounts beginning with '4' are expenses) I
have not used this feature, only seen it demo'ed so I hope I got the
details right.

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

In article <O2U$k9gwFHA.3256 (AT) TK2MSFTNGP09 (DOT) phx.gbl>,
willgart (AT) BBBhotmailAAA (DOT) com says...