XMLA script to deploy MDX Calculations

by Davy Knuysen 5 May 2010 16:13

At a current project I needed to create a deploy script for the MDX calculations of a cube. SQL Server Management Studio makes it very easy for you to create XMLA-scripts to create or alter cubes, dimensions, etc… But it’s not possible to use Management Studio to create an alter-script that only contains the MDX calculations. [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: analysis services, bi, mdx, sql server, sqlserverpedia, data, olap

Davy Knuysen

Parent-Child hierarchies in Reporting Services

by Davy Knuysen 16 April 2010 10:28

Reporting Services 2008 is a great reporting tool, but displaying Analysis Services data with Reporting Services doesn’t always display the data as you would expect. A Parent-child hierarchy is one example of this: When you browse Parent-child hierarchy from an Analysis Services cube with Excel, Excel automatically displays it with nice drill-down functionality. But when [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: analysis services, mdx, reporting services, sql server, data, reporting

Davy Knuysen

Your First OLAP Report

by Valentino Vranken 24 January 2010 14:28

Introduction This article is aimed at report developers who are used to develop reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Server Reporting Services 2008 with data coming from an OLAP cube running on SQL Server Analysis Services 2008. The OLAP [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: analysis services, reporting services, data, mdx, reporting services 2008, ssas, ssrs, tutorial

A Developer's Blog

SQL Server Day 2009 videos now available on Chopsticks

by Davy Knuysen 16 December 2009 10:10

Microsoft has made the sessions presented on SQL Server Day 2009 available on Chopsticks Opening Keynote by Wesley Backelant and Ritchie Houtmeyers Best Practices for SQL Server Consolidation by Tom Van Mulders Breaking the ETL world record with Integration Services by Henk van der Valk Designing Effective Aggregations in Analysyis Services 2008 by Chris Webb [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: .net, analysis services, bi, event, events, excel services, integration services, mdx, moss, office, powerpivot, reporting services, sql 2008 r2, sql server, sqlug.be, chopsticks, sharepoint

Davy Knuysen

SSAS: Custom format string for “duration” using MDX

by Davy Knuysen 7 December 2009 21:38

I recently struggled with the following challenge in Analysis Services: In one of the fact tables there was a field duration which actually was a duration of a certain status in seconds. I needed to display this in a readable format, like “2 days 22:15:59″. bing brought me to the following great article, where Mosha explains how [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: analysis services, bi, excel, mdx, sql 2008 r2, sql server, data

Davy Knuysen

OLAP Reporting with Excel 2007: Use Member Properties!!

by Davy Knuysen 3 August 2009 20:55

Excel 2007 is great tool for browsing OLAP cubes. But 1 thing a lot of people don’t know about or at least don’t use enough, is Member Properties. When they want to add a property of a specific attribute, they just check this item in the field list. By using it this way, you’re kind of [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: analysis services, bi, excel, data, olap, pivot table, reporting, sql server

Davy Knuysen

SSRS and MDX: Detecting Missing Fields

by Valentino Vranken 6 July 2009 18:15

For this example I’ll be using the Adventure Works cube running on SQL Server Analysis Services 2008 and Reporting Services 2008. In case you don’t have the AdventureWorks databases and cubes yet, they’re available at CodePlex. Scenario The sales department has asked for a report that displays the number of product items sold during a selected period. As [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: analysis services, reporting services, data, mdx, sql server, ssas, ssrs

A Developer's Blog

Stop that MDX query!

by Valentino Vranken 9 January 2009 18:12

Have you ever had the situation that you wrote an MDX query to get some data out of a cube in Management Studio and executed it and waited and waited and the query never seems to end so you decide to cancel it so you click the red square button and then you wait and [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: analysis services, sql server, bug, data

A Developer's Blog

Blog N-Technologies

XMLA script to deploy MDX Calculations

Parent-Child hierarchies in Reporting Services

Your First OLAP Report

SQL Server Day 2009 videos now available on Chopsticks

SSAS: Custom format string for “duration” using MDX

OLAP Reporting with Excel 2007: Use Member Properties!!

SSRS and MDX: Detecting Missing Fields

Stop that MDX query!

RecentPosts

Blog N-Technologies

Tag cloud

RecentPosts