OLAP and Report Services

anneliang 2005-07-29 05:37:02

OLAP database and Database in the same server A.
Web application and report service in the same server B.

Server A and server B are in different domain.

When I try to connect report from Web application, I have message: Can't connect database SCMOlap( SCMOlap is OLAP database).

Could anyone help?

...全文

104 1 打赏收藏转发到动态举报

写回复

1 条回复

切换为时间正序

请发表友善的回复…

发表回复

sinoghost 2005-08-27

打赏
举报

回复

顶

Book Description Every business has a reams of business data locked away in databases, business systems, and spreadsheets. While you may be able to build some reports by pulling a few of these repositories together, actually performing any kind of analysis on the data that runs your business can range from problematic to impossible. Pro SQL Server 2008 Analysis Services will show you how to pull that data together and present it for reporting and analysis in a way that makes the data accessible to business users, instead of needing to rely on the IT department every time someone needs a different report. Accessible–With a single author’s voice, this book conducts a guided tour through the technology that makes it easy to dive into. Solution–oriented–While technically deep, the goal is to focus on practical application of the technologies instead of acting as a technical manual. ComprehensiveThis book covers every aspect of Analysis Services and ancillary technologies to enable you to make the most of SQL Server.What you’ll learn Understand the importance of OLAP and Analysis Services technologies. Build cubes and dimensions that let you get business value out of large volumes of data. Learn the fundamentals of MDX–the query language for advanced analysis. Apply ancillary aspects of SSAS: KPIs, perspectives, and calculated members. Apply basic data mining concepts–identify answers to questions you weren’t even aware you should ask. Learn the various ways to consume Analysis Services data (Reporting Services, Excel, and ProClarity).

基于SQLServer2005的数据仓库构建及OLAP多维分析实验.pptx

Book Description SQL Server 2012 accounts for a huge share of the database market, and more and more companies are implementing SSRS as part of their BI implementation. Its Reporting Services offers a comprehensive, highly scalable solution that enables real-time decision making. SQL Server 2012 Reporting Services Blueprints is intended to be just that, a series of Blueprints – things that work straight out of the box and that mirror what a real job requires real report developers to do. You will not be bored with an “Introduction to X” or “What’s under the hood of Y”. We go straight to the practical development of reporting skills, explaining actions as they are taken. This book is a step-by-step, task-driven tutorial. It provides enterprise reporting blueprints that address your day-to-day issues and requirements. Right from the very start, you’ll learn SSRS beyond the basics, giving you the skills to create the best reports for any task. Explore the possibilities, master your options, and choose the best tool for the job. What you will learn from this book Fully understand the structure and properties of your reports Add interactive elements to your reports Use parameters effectively in different scenarios Utilize a range of advanced graphs Make use of geospatial data and maps Use OLAP Cubes in your reports Deploy your SSRS projects Integrate SharePoint, PowerPivot, and Power View into your reports Approach Follow the fictional John Kirkland through a series of real-world reporting challenges based on actual business conditions. Use his detailed blueprints to develop your own reports for every requirement. Who this book is written for This book is for report developers, data analysts, and database administrators struggling to master the complex world of effective reporting in SQL Server 2012. Knowledge of how data sources and data sets work will greatly help readers to speed through the tutorials. Book Details Paperback: 246 pages Publisher: Packt Publishing (October 2013) Language: English ISBN-10: 1849685088 ISBN-13: 978-1849685085

不用多介绍了，弄过Reporting services的朋友都应该看过此书了。此书为英文版的，反感英文的朋友不用浪费积分了（下载了你也不一定看）。

Professional Microsoft SQL Server 2012 Reporting Services

4,820

社区成员

14,134

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章