Search
InstantDoc ID
GO

Browse By: Author | Issue

March 23, 2004 05:23 PM

Financial Reporting with Analysis Services

OLAP lets end users drill down for report details
Rating: (0)
Yoram Levin
SQL Server Magazine
InstantDoc ID #41783
You might think that financial reporting should be a straightforward implementation of the OLAP model. Almost every vendor that offers a product in the business intelligence (BI) arena touts financial reporting as one of the primary implementations of its tool. But if you're going to use SQL Server 2000 Analysis Services to implement financial reporting, you can expect some complicated problems to come your way. Although Analysis Services can readily provide the detailed information that users want, it isn't designed to present the information in the form they require.

For...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

I am a novice at AS and still do not understand how to restore the sample database. Which file "isn't .CAB" ? Whan I browse from Analysis Manager to restore that database it only allows selection of CAB files.

bredins2/28/2005 6:25:39 AM

You can restore the database, the file isn't .CAB!!!

Oded Dror 3/30/2004 7:22:04 AM

While I like the article, unfortunately I am unable to use the downloaded code. The article says: "To use the sample databases, download the .zip file at InstantDoc ID 41783, open the file in a directory of your choice, and restore the OLAP database." But it does not explain how. In the analysis services if you have to restore an OLAP database, it asks for a file with a .cab extension but when the downloaded zipped file is unzipped I observe that there are several files with different extensions and as such neither the article tells you how to restore the OLAP database, nor can I find a suitable method in the Analysis services to restore from those files. I was even trying to find a readme file but I could not find any. Could you please let me know as how I can restore the OLAP DATABASE from the several files that I have. THANKS

ROY SINGER 3/25/2004 7:51:30 AM

You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.