Update. For whom missed it I found it as a post by Carl Rabeler http://sqlcat.com/top10lists/archive/2009/02/24/top-10-performance-and-productivity-reasons-to-use-sql-server-2008-for-your-business-intelligence-solutions.aspx
Download SQL Server 2008 R2: http://www.microsoft.com/downloads/details.aspx?familyid=E19689BD-38DD-46C4-8645-F58CA4D61D1F&displaylang=en
What’s new in SQL Server Integration Services: No new features they just fixed some bugs: http://blogs.msdn.com/mattm/archive/2009/08/14/no-new-features-in-for-integration-services-in-sql-server-2008-r2.aspx
What’s new in SQL Server Analysis Services: I didn’t find any information about that!! if you know please drop a link.
What’s new in SQL Server Reporting Services: http://blogs.msdn.com/sqlrsteamblog/archive/2009/08/11/sql-server-2008-r2-august-ctp-what-s-new-in-reporting-services.aspx
Microsoft Gemini: http://www.microsoft.com/officebusiness/office2010/Default.aspx?vid=Gemini or https://connect.microsoft.com/SQLServer/Downloads/DownloadDetails.aspx?DownloadID=21090 to know about Microsoft Gemini
A small stand-alone MSI for Report Builder 3.0, August CTP, is now available for download here: http://go.microsoft.com/fwlink/?LinkID=160384
Download packages for SQL Server 2008 R2 August CTP are available here:
Reporting and Business Intelligence in Microsoft Dynamics AX 2009
FREE From Microsoft E-Learning
About this Course
This two-day instructor-led course provides students with the knowledge and skills to leverage the extended Reporting and Business Intelligence (RBI) features of Microsoft Dynamics AX 2009. The training course covers installation of pre-requisites and supporting technology, creating and deploying reports using SQL Server Reporting Services, creating, adjusting and deploying business intelligence projects using SQL Server Analysis Services, and integrating all these features together in the Rich client, Enterprise Portal or Role Centers, for the end-user.
The course is intended for developers or those individuals who will be creating and deploying reports and business intelligence projects.
At Course Completion
After completing this course, students will be able to:
– Differentiate between Microsoft Dynamics AX 2009 reporting features, SQL Server Reporting Services and SQL Server Analysis Services.
– Appreciate the benefits of leveraging SQL Server Reporting Services and SQL Server Analysis Services with Microsoft Dynamics AX 2009.
– Explain what the Role Center in Microsoft Dynamics AX 2009 is used for.
– List the system requirements for Reporting and Business Intelligence for Microsoft Dynamics AX 2009.
– Step through the procedures for installing SQL Server Reporting Services and the integration components for Microsoft Dynamics AX 2009.
– Design reports in Report Builder and Visual Studio using Microsoft Dynamics AX 2009 data sources.
– Integrate SQL Server Reports with Microsoft Dynamics AX 2009 Client, Enterprise Portal and Role Centers.
– Step through the procedures for installing SQL Server Analysis Services and the integration components for Microsoft Dynamics AX 2009.
– Become familiar with SQL Server Business Intelligence Studio.
– Navigate the multi-dimensional space of OLAP cubes.
– Import cubes from Microsoft Dynamics AX 2009.
– Fix broken cubes.
– Create new cubes from Microsoft Dynamics AX 2009.
– Deploy and process cubes.
– Read and write MDX expressions in KPIs.
– Step through the procedures for installing Role Centers for Microsoft Dynamics AX 2009.
– Modify existing Role Centers.
– Create new Role Centers.
To add this course to your Microsoft learning or start it right now; here you’re: http://www.microsoft.com/learning/en/us/syllabi/50195A.aspx
This website is designed for the developers and administrators who work with Microsoft SQL Server Analysis Services (SSAS) 2005 or 2008. Here you will be able to find latest news, MDX FAQs, OLAP design FAQs, links to articles, BI blogs, webcasts, forums, job postings, products and any other information that is related to SSAS.
Personally, I recommend every BI Developer to follow up this portal http://www.ssas-info.com/
In the previous post we learned how to build simple cube using BIDS, and if you’re follower I’ve forgot something important is deployment the cube on the Analysis Services.
1- We just need to add some attributes to the dimensions(DimPromotion, DimProduct) as each of which pure (contains just the key) for some reasons we need to show the user the name of product, or the promotion because it very hard to make human treat with numbers contrary to machines which prefer them. We shall add some attributes to the dimensions to make it meaningful.
2- Double click on DimPromotion; the dimension design window opened you find Data Source View, Hierarchies and Attributes; simply drag EnglishPromotionName from the Data Source View table to Attributes.
3- Repeat the previous step with the DimProduct to add EnglishProductName
Here I’ll talk about how to integrate your asp.net application with Reporting Service through ReportViewer web control which provides rich functionality to deliver Reporting Service Report through asp.net applications.
In real life applications; Analysis Service and Reporting Service on server machine, Web Server another server machine and clients usually on another domain access the website to do something.
Let’s take a look on this diagram to visualize what happened in intra applications which one of its functionality shows reports this reports actually based on OLAP Data (SSAS used here)
Here we build OLAP Cube as Report data source.
So, let’s begin to build our report based on Cube which built from AdventureWorksDW Read the rest of this entry »