Re: Analysis Services for Planning

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Nigel Pendse (nigelp.nospam_at_olapreport.com)
Date: 10/29/04 

Date: Fri, 29 Oct 2004 11:56:38 +0100

"Karen Middleton" <karenmiddleol@yahoo.com> wrote in message
news:a5fd468a.0410281707.204d7dfe@posting.google.com
> I agree what Nigel says and partly with what Howard says.
>
> What I felt so frustrating is there is totally no information in
> neither books online
> or in any of the books on Analysis Services to customers how to model
> and
> build what-if applications on analysis Services. I am really surprised
> that
> MS have not released even a few simple scenarios like cost planning or
> cash flow planning or sales planning some sample cubes and reports
> with
> the Excel addin.
>
> There is a big lack of know how on how to model a planning and
> budgetting
> application on Analysis Services - I guess this is the biggest gap in
> AS 2000 if it exists MS as not done any effort in making the user
> community
> aware of using this feature and none of the authors of a number of
> books
> on Analysis Services have endeavoured to make this known. It is really
> a
> sort of mystery how to do it. Many times users want to build some
> budgetting,
> planning and what-if applications in house and once they outgrow the
> AS 2000 and Excel Addin would like to go for something like MIS Plain
> or O2OLAP or whatever but even to do basic things there is no starter
> models.
>
> Perhaps if MS could take this onboard and do something.

I think the reason is probably that Analysis Services 2000 isn't often
used for planning apps, and when it is, it's usually in conjunction with
pre-built apps such as OutlookSoft Everest, Geac MPC or CIP ES, which
deal with a lot of the tricky functional/performance issues. Some
consultants have also developed techniques based on hard experience, but
I guess they don't want to give them away freely.

Of course, a lot will change with Yukon, which would also explain why
people may not be interested in documenting such techniques for what is
now a four year old product.

Relevant Pages

  • Re: Analysis Services for Planning
    ... >> I agree what Nigel says and partly with what Howard says. ... >> cash flow planning or sales planning some sample cubes and reports ... >> on Analysis Services have endeavoured to make this known. ... >> budgetting, ...
    (microsoft.public.sqlserver.olap)
  • Re: Consept of scenes
    ... Reading others' posts, I see (tho there are many exceptions, both writers ... planning, some thinking it up as I go along post planning when both ... or pick up ideas from several different such books. ... Screen-writing books and novel-writing books that take the screen-writing ...
    (rec.arts.sf.composition)
  • Re: About Security
    ... Obviously Books Online is a good resource for this topic and security ... is covered quite extensively in many of the good Analysis Services books. ... > "Yash" wrote: ... >> I too agree with Jamie regarding MDX. ...
    (microsoft.public.sqlserver.olap)
  • Planning on getting MCSA... suggestions?
    ... I imagine you are planning to go the XP and Windows 2003 ... Transcender are great exams to prepare you for the kind of ... Sybex books are great for content and preparation. ... like Transcender and SmartCertify. ...
    (microsoft.public.cert.exam.mcsa)
  • Analysis Services + MDX Book recommendations
    ... Can anyone recommend any books on analysis services and/or MDX. ... We're a pretty tech savvy bunch of developers who need some kick start ...
    (microsoft.public.sqlserver.datawarehouse)