Geeks With Blogs
DevJef's Mumbo-Jumbo «There's a bit of SQL in all of us» SSRS
Create XMLA file for OLAP Cubes
In order to refresh your OLAP Cubes (SQL Server Analysis Services), you need to create XMLA files. These XMLA files can be used in a SQL Server Agent Job, so that the Cubes are refreshed and re-processed. To accomplish this, you need to follow the next steps: 1) Deploy your Cube to your SQL Server 2) Right click on the database, and choose “Script database as” –> “Alter To” 3) Add the following node to the top of the XML: <Batch xmlns="http://schemas.micro... ......

Posted On Tuesday, October 25, 2011 2:13 PM

Deploying Report Builder 3.0 reports on 2005 Report Server
How fun is it to use new software? As a developer you always want to use the latest software, and in many cases it’s backwards compatible. This (unfortunately) isn’t the case with Report Builder 3.0 and SQL Server 2005 Reporting Services. This is a “by design” issue, but it’s such an annoying “feature”. If you try to deploy a Report built in RB 3.0, you will get the error: "The report definition is not valid. Details: The report definition has an invalid target namespace ' ......

Posted On Monday, September 26, 2011 3:06 PM

Parameters in Report URL
A colleague asked me if it’s possible to set the parameters of a Report in the URL, so that he could send it to an end-user. I didn’t know the answer, and after some research I came to the conclusion that it’s possible. Just like your used to, you pass parameters into the Report by modifying the URL. An example of a normal Report URL looks like this: http://<ServerName>/R... In order to use parameters in the URL, you need to use the Service URL. The Service URL has the possibility to add ......

Posted On Friday, September 23, 2011 3:05 PM

Copyright © DevJef | Powered by: