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

Reporting Services Timeout in Sharepoint

by Davy Knuysen 3 March 2010 07:05

Recently someone asked me to check a Reporting Services report that always resulted in an Unexpected Error. The report server was configured for Sharepoint Integrated Mode. I came to the conclusion that the server always returned this error after exactly 2 minutes, so it had to be a timeout exception. The report was kind of big, so [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: bi, moss, reporting services, sql server, data, sharepoint

Davy Knuysen

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

Connect to SSIS Service failed: Error loading type library/DLL

by Davy Knuysen 18 September 2009 09:44

After installing SQL Server Integration Services on an existing 64-bit SQL Server, I was unable to connect to SSIS using Management Studio. The database engine and Analysis Services was already installed on this server. I added the SSIS service without Service Pack and applied SP3 afterwards. When trying to connect, Management Studio returned the following error [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: bi, integration services, sql server, uncategorized, data

Davy Knuysen

Administrator has no access to the Report Manager (SQL2008 R2 and Windows7/Vista)

by Davy Knuysen 11 September 2009 19:19

Today I wanted to start playing around with the new Report Manager of SQL 2008 R2. After installing and configuring R2, I opened Internet Explorer and entered the URL of the Report Manager. In my case: http://localhost/reports_r2 I got a very empty Report Manager : Okay, something is wrong. I tried to connect to http://localhost/reportserver_r2 : No [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: bi, reporting services, sql 2008 r2, sql server, data

Davy Knuysen

Excel Services: Data Refresh Failed

by Davy Knuysen 12 August 2009 22:41

After deploying an Excel file to Excel Services on a new MOSS Server I got the following error: Data Refresh Failed: Unable to retrieve external data for the following connections: <<connection>> The data sources may be unreachable, may not be responding, or may have denied you access. Verify that data refresh is enabled for the trusted file location [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: bi, excel, excel services, moss, data, sharepoint

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

Blog N-Technologies

XMLA script to deploy MDX Calculations

Reporting Services Timeout in Sharepoint

SQL Server Day 2009 videos now available on Chopsticks

SSAS: Custom format string for “duration” using MDX

Connect to SSIS Service failed: Error loading type library/DLL

Administrator has no access to the Report Manager (SQL2008 R2 and Windows7/Vista)

Excel Services: Data Refresh Failed

OLAP Reporting with Excel 2007: Use Member Properties!!

RecentPosts

Blog N-Technologies

Tag cloud

RecentPosts