A short guide showing the steps involved in installing the Sharepoint Web Front End on a Report Server (i.e. your Business Intelligence server). First you will need to install the Sharepoint 2010 SP1 Prerequisites. If this is a SQL Server 2012 server, of course you would be installing these prerequisites prior to installing any SQL Server […]
Thanks David for this post http://metadeveloper.blogspot.com.au/2006/03/remove-carriage-return-line-feed-tab.html on how to remove carriage return, line feed and tab from a string in TSQL. The snippet below will substitute these characters with a space and grab only the first 100 characters.
That is a terrific question. But first when we talk about Sharepoint integration, we are talking about Reporting Services and Powerpivot. Both Reporting Services and Powerpivot are implemented as distributed applications with components that run on the Web Front End (WFE) and Application tiers, whilst application data is stored in the Data Tier. These components […]
Reporting Services provides some nice options to allow user’s to feel like they are interacting with the data, by expanding lower levels of detail when they click on the plus (+) sign in the report’s tablix. You can also set the initial Toggle state of report items as expanded i.e. (-) sign. There is a […]
The Analysis Services Command Line Utility is one of the 5 methods of deploying Analysis Services databases. ichi, ni, san, yon, go … http://msdn.microsoft.com/en-us/library/ms175446(v=sql.105).aspx The deployment wizard is a brilliant piece of work taking the headache out of cube deployments. However the Next, Next, Next does get tiresome, you will reap the rewards in […]
You attempt to deploy calculation changes to your Analysis Services cube and get the error “The Measures Cube Either Does Not Exist or Has Not Been Processed”. It is likely one or more of your MDX Create Member constructs are missing CURRENTCUBE i.e.
You are running Analysis Services 2008 R2 and have created some calculated measures involving a dynamic set. When you browse the cube and add a second filter to these measures, you get the error “Unable to Apply Filter – Internal Error: An unexpected exception occurred”. It is likely you are still on the RTM […]
Previously I had published a link to my favourite SQL Server version site but it seems the boys at SQL Team no longer have the latest and greatest link. Check out this link that provides a nice pivot table view of all the latest service packs for each edition of SQL Server. The page […]
If your lower environments feature a different domain name to production, there could be a requirement to remove the ‘DOMAIN\’ portion of the string that is returned by the Reporting Services User!UserId report collection value. The following code segment demonstrates how this could work in a stored procedure that uses this variable as a parameter.
A link to interact with some interesting World economic and demographic data ideally for putting your business intelligence skillset through its paces ! http://databank.worldbank.org A nice feature is you can browse the data you are interested in first, then select for Download in Excel, CSV or Tab Delimitted Text.