Here is the post, written by Dwight Specht: Who uses BI?
I myself am working on BI reports, a lot, nowadays and posts such as this only add to my constant improvement.
Special thanks to Dwight.
VAIDY
Once GP2010 R2 installation is over and GP Utilities start configuring system, almost the last setup is SRS Reports Deployment wizard. It’s a welcome change from previous versions, as this one is more explanatory and clear.
Once it starts deploying reports, the following error message is thrown:
Now what exactly are we talking about? The session was all about listing the most promising (some are already existing) BI Tools running on top of either OR all of the following: SQL Server 2008 R2, SharePoint 2010, Silverlight.
The following are the list:
The approach taken by Microsoft is fairly unusual.
Leave the BI Design to End-Users (or designated Power End Users) and simultaneously build EDW (Enterprise Data Warehouse). Once the design & EDW is ready, use following tools to achieve this CBI Model:
Microsoft Office, SharePoint 2010, SQL Server 2008 R2, Silverlight Technology.
CBI basically means one Single Enterprise Report Catalog. It’s then delivered as a SharePoint based BI Portal. Microsoft IT hosts BI with Reporting Services, PPS, etc, BUT Power End Users design and publish Reports on to this Portal. There are certain restrictions in terms of how many users being allowed to publish these reports for their own Team/Department/Division.
Top 10 Questions which Microsoft asked themselves before CBI (and of course everyone of us to ask ourselves as well):
1. IT Cost too much to implement this BI Catalog. What to do first? EDW or BI Reporting Catalog?
1.1. Allow End Users to publish all their ideas on a Not-So-Clean EDW Data.
1.2. Clean EDW and keep EDW ready.
2. How do you get the First Sponsorship?
2.1. Push and Pull Approach
2.2. Create a Cool Demo
3. How do you architect with big Holistic Enterprise Vision?
4. How do we implement seamless security across layers?
5. Who should create BI and show we actually give control of the report catalog to business and enable self-serviced BI?
6. Can we implement ZERO footprint deployment for masses using SharePoint?
7. What about regional deployment and scalability?
8. What front end tools to BI publishers use and how do you integrate various tools?
9. How do you evangelize and achieve enterprise adoption?
10. How do you achieve high Customer Satisfaction?
10.1. Customer Empathy
10.2. Maintain Customer Relationship
10.3. Improve, Improve & just Improve
Until next post on Tech-Ed from me.
VAIDY
This article is a good one to get start of Excel Report Builder and creating a meaningful and handsful Pivots out that single set of data.
Read it here: Excel Report Builder – GP2010 Pivot Tables – Sales By… Anything!
VAIDY
There are many articles across the Blogosphere on Management Reporter for MS Dynamics ERPs.
This one’s pretty good in terms of explaining the basics of MR. And also the points which would make Customers migrate to MR from FRx.
Read the article, Management Reporter For Dynamics ERP – An Analysis, on ERP Software Blog.
UPDATE (19JUN2010): The above link to the original article on ERP Software Blog, seems to be broken and not working.
VAIDY
I was deploying GP SSRS Reports on SQL Server 2008 64 Bit and was facing the following error message:
There was an exception running the extensions specified in the config file. —> Maximum request length exceeded.
Googled it and here the resolution: http://www.developmentnow.com/g/115_2006_4_0_0_735861/Request-Length-Exceeded.htm
I hope this would be a useful tip for people out there deploying SSRS for GP.
VAIDY
