I have to deploy my SQL Server Analysis Services project to a test server then to a production server after testing is completed. For both of these deployments I need to provide an installation program. I am not allowed to access either of these servers. For my own testing I can deploy my project using Business Intelligence Development Studio (BIDS) and this works great. How can I create an installer that my IT team can use to perform the deployment?  Read more...

Display data series' as a set of points with an XY (scatter) chart - typically to compare distinct values across categories. BI Architect Bill Pearson leads the hands-on creation of an XY chart based upon an Analysis Service data source.  Read more...

Join BI Architect Bill Pearson in this introduction to Partitions in Analysis Services 2008. Here we explore partitioning concepts and advantages, and look forward to hands-on practice with partitions in subsequent articles.  Read more...

BI Architect Bill Pearson introduces Storage in Analysis Service 2008. This article begins an extended examination of storage topics, including partitions and aggregations, within a multiple-article subseries.  Read more...

I have seen the tip Dynamically Control Data Filtering in SQL Server Reporting Services Reports which showed how to leverage a SQL Server database table to filter sales data based on the user running the report. I have a similar requirement to implement dynamic filtering except my data is in a SQL Server Analysis Services (SSAS) cube and the users query the data with a variety of different tools. How can I implement dynamic security in my case?  Read more...

Microsoft SQL Server 2005 Analysis Services (SSAS) delivers both online analytical processing (OLAP) and data mining functionality for business intelligence applications. This article thoroughly explores the architecture of SSAS and how it can be implemented.  Read more...

Architect Bill Pearson leads the hands-on creation of a simple doughnut chart based upon an Analysis Services data source.  Read more...

Join BI Architect Bill Pearson as he leads hands-on practice with the “Clusters” discretization method in Analysis Services. In this article we continue to explore attribute discretization, as a part of an extended examination of the dimensional model lying at the heart of the integrated Microsoft Business Intelligence solution.  Read more...

Because Microsoft SQL Server Analysis Services query and processing performance tuning is a fairly broad subject, this white paper organizes performance tuning techniques into the following three segments.   Read more...

S partitions from the ground up, with advice on binding, merging, and selecting partition data.   Read more...

There are three standard storage modes (MOLAP, ROLAP and HOLAP) in OLAP applications which affect the performance of OLAP queries and cube processing, storage requirements and also determine storage locations.   Read more...

MSAS Architect Bill Pearson leads the hands-on creation of an exploded pie chart based upon an Analysis Service data source.  Read more...

I have a requirement to provide users with the capability to define their own reporting hierarchies for sales data. For instance they had a report which broke down sales by the four regional VPs then by office. Later they created regions, assigned VPs to each region, then assigned offices to each VP. Now they want to be able to create a number of other scenarios and choose which one when they run a report. Can you provide some suggestions on how to do this?   Read more...

Put the stacked bar chart to work in your own business environment. BI Architect Bill Pearson continues his hands-on introduction to Reporting Services charts based upon Analysis Services data sources.  Read more...

This article will review the processes for providing Operational Analytics via Microsoft Analysis Services, Informatica and Qlikview  Read more...

SQL Server 2005 introduces a rich set of tools supporting the development and management of Business Intelligence applications. This includes applications using Analysis Services (OLAP and Data Mining), as well as Reporting Services and Data Transformation Services (DTS).  Read more...

Get hands-on exposure to the use of the "Equal Areas" discretization method in Analysis Services. Join BI Architect Bill Pearson as he continues to explore Attribute Discretization, within his extended examination of the dimensional model lying at the heart of the integrated Microsoft Business Intelligence solution.  Read more...

This installment of "Windows PowerShell and AMO" covers how to script a cube from a SQL Server Analysis Service instance to XMLA format file.  Read more...

Join BI Architect Bill Pearson as he continues his overview of Attribute Discretization, within his extended examination of the dimensional model lying at the heart of the integrated Microsoft Business Intelligence solution. In this article, we begin a hands-on overview of the use of the Automatic discretization method.  Read more...

When defining the attribute, we always specify the surrogate key as the key column for any attribute. I was just thinking if we could make use of the natural key instead of the surrogate key. i.e., in case of a product attribute, the surrogate key say...  Read more...

Continuing with his discussion of how to implement a date dimension in SQL Server Analysis services, expert warehousing expert Vincent Rainardi discusses how to use this dimension as a reference dimension as well as other advanced topics.  Read more...

SELECT statements should be the most popular query in SQL Server, so why are they unpopular? It's the complex, confusing MDX SELECT statement that warehousing expert Vincent Rainardi is writing about.  Read more...

Data warehousing author and expert, Vincent Rainardi, brings us a new article that looks at one of the most frequently used dimensions in Analysis Services.  Read more...