Recent Posts Tagged With 'analysis services ssas'

• Exploring New Features of SQL Server 2008 R2 with Excel 2010

  Posted on Monday November 23rd, 2009 at 06:55 in business intelligence, analysis services ssas

  SQL Server 2008 R2 November CTP is released and can be downloaded from here .There is a lot of new functionality available with Business Intelligence with SQL Server 2008 R2. In this article, we will use Excel 2010 as a client for SQL Server Analysis...

• Creating a Cube and Dimension using SSAS

  Posted on Friday October 30th, 2009 at 23:08 in analysis services ssas

  In my previous article, we took an Overview of SSAS and its various components. In this article, we will create a cube by using Business Intelligence Development Studio (BIDS).We will continue with the example we discussed with SQL Server Integration...

• Overview of SQL Server Analysis Services (SSAS)

  Posted on Wednesday October 28th, 2009 at 10:06 in analysis services ssas

  In a previous article, we discussed SQL Server Integration Services, its components and how to create package by using Import Export Wizard. In this article we will take an overview of SSAS and its various components. With SSIS, we discussed how data...

• Exploring Additional Multi Dimensional Expression (MDX) Functions in SQL Server Analysis Services – Part 3

  Posted on Saturday September 12th, 2009 at 06:55 in analysis services ssas

  I recently wrote two articles on MDX in SQL Server Analysis ServicesExploring MDX (Multi Dimensional Expression) in SQL Server Analysis ServicesExploring Additional Multi Dimensional Expression (MDX) Functions in SQL Server Analysis Services – Part...

• Exploring Additional Multi Dimensional Expression (MDX) Functions in SQL Server Analysis Services – Part 2

  Posted on Thursday September 10th, 2009 at 06:45 in analysis services ssas

  SQL Server Analysis Services - Additional functions in MDXIn my previous article Exploring MDX (Multi Dimensional Expression) in SQL Server Analysis Services, we discussed how to write simple queries with MDX to query multi dimensional cubes. In this...

• Exploring MDX (Multi Dimensional Expression) in SQL Server Analysis Services

  Posted on Tuesday September 8th, 2009 at 06:55 in analysis services ssas

  Introduction to MDXMulti Dimensional eXpression (MDX) is a language created to allow the users to work with multi dimensional data in Microsoft SQL Server Analysis Services. It works as a query language with OLAP (Online Analytical Processing) cubes....

• Working with SQL Server AMO (Analysis Management Objects) – Part 2

  Posted on Monday August 17th, 2009 at 06:55 in analysis services ssas

  In the first part of this article, we saw how to connect to the analysis server and list all the databases. We then chose a database and displayed the cubes, measures, partitions and dimensions in a ListBox.In this part of the article, we will see ho...

• Working with SQL Server AMO (Analysis Management Objects) – Part 1

  Posted on Saturday August 15th, 2009 at 06:55 in analysis services ssas

  AMO provides us with a collection of classes with which we can manage objects of a running instance of SQL Server Analysis Services programmatically. These classes are available in namespace Microsoft.AnalysisServices. The assembly is available at th...