Optimizing Performance in SQL Server® Analysis Services

September 22, 2009

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

Read the rest of this entry »

Advertisements

Reporting from Analysis Services Cubes Using Excel 2007

September 8, 2009

Session #14: Reporting from Analysis Services Cubes Using Excel 2007 (Peter Myers)

Event: 24 Hours of PASS

Presenter: Peter Myers

Download

SSRSSSAS1 Read the rest of this entry »


All about Microsoft SQL Server 2008 R2

August 16, 2009

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:
http://www.microsoft.com/downloads/details.aspx?FamilyID=e19689bd-38dd-46c4-8645-f58ca4d61d1f

Source: http://blogs.msdn.com/sqlrsteamblog/archive/2009/08/14/report-builder-3-0-august-ctp.aspx


Reporting and Business Intelligence in Microsoft Dynamics AX 2009

May 16, 2009

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.

Audience Profile
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


SSAS Resource Hub

May 10, 2009

SSAS-Info.com

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/ 

RSSNews RSSArticles


Building ASP.NET Reporting OLAP-Based Application Part-2

April 19, 2009

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

rs-p2-7
Read the rest of this entry »


Building ASP.NET Reporting OLAP-Based Application Part-1

April 18, 2009

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)

Infrastructure Architecture

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 »