|
|
MDX and Analysis Services
MDX and Analysis Services
-
I've played around with Vidas Matelis' PowerShell scripts for processing SSAS databases the last couple of months. The scripts have all sorts of useful output, but I've been looking for a way to write the error messages to the Event viewer instead of Read More
|
-
Found this tip today over at
Microsoft SQL Server Analysis Services 2005/2008 Tips
Process only one partition so you can browse the cube by Nicholas Dritsas.
So if what I need to do is to check what one dimension looks like, I can just process Read More
|
-
Learning how to read cube metadata through SQL Server queries sparked a few ideas, so today I had to find more information about this.
Once again, Vidas Matelis provides interesting information.
SSAS 2008 DMVs – querying from the SQL Server and Read More
|
-
Sometimes you just want a list of when were my dimensions last processed, or when was the schema updated last? You can always right click on the dimension and look at the Properties, but if you want to check for more than 1 dimension, that's kind Read More
|
-
Sometimes, you want to process all your dimensions in one go, before processing your cube. This isn't an option in SSMS, you either do the dimensions one after the other manually, or you go for the whole database.
Fortunately, Vidas Matelis has Read More
|
-
Sometimes you might need to download a live SSAS database into a Visual Studio project. Like if someone build an SSAS solution and then deleted the development project.
Here's an explanation on how to do it:
How to: Create an Analysis Services Read More
|
-
One of the biggest problems I've been having with upgrading my mad reporting skills from RS 2000 to RS 2005 has been with cascading parameters in OLAP reports. WIth the new and "user friendly" connection method to Analysis Services, I couldn't Read More
|
-
Yesterday I ran into a small problem with adding parameters in a report's URL. All parameters were based on MDX queries. One parameter was for time, and the parameter usually looks like this "[Time].[YMWD].[Month].&[4]&[2007]". When I did Read More
|
-
During the last few weeks, I've installed SQL Server 2005 and Microsoft Office SharePoint Server 2007 countless times. It's getting old. So now I think my next project will be to create a package and script to:
install SQL Server 2005 with Analysis Read More
|
-
During the last two years, I've gotten used to excluding certain words when searching the internet. When I'm looking for something related to MDX (Multi dimensional expressions, used to query OLAP cubes), I usually add –acura to any search strings. Read More
|
-
The last few days, my ego has been really, really bruised. I've been working on OLAP based reports in Reporting Services 2005 again. Being fairly experienced with RS / AS 2000, I ran into all sorts of problems when RS just didn't behave quite like Read More
|
-
Today I found something usefull while surfing, a tool called BI Documenter.
http://www.bidocumenter.com/Public/Default.aspx
The current version can't be used for Reporting Services documentation, but the next can, according to the developers' blog. Read More
|
-
SQL Server 2005 sp 1 was released on April 18th. Information can be found at http://www.microsoft.com/sql/sp1.mspx
Download SQL Server 2005 Service Pack 1
And then there are some new tools and SP1 for SQL Server 2005 Express Edition at http://msdn.microsoft.com/vstudio/express/sql/download/. Read More
|
-
When I work with Reporting Services reports against OLAP cubes, I usually use the MDX Sample Application to write my mdx queries. And some of the things that annoy me is to always have to type in the server name to the Analysis Server. Last week I decided Read More
|
-
I found this new subgenre of fun poetry at Chris Webb's BI site: MDX Limericks.
Chris' first limerick:
WITH MEMBER [Date].[Day Name].[TODAY]
AS 1 + [Date].[Day Name].[THURSDAY]
SELECT [Average Rate]
ON 0, [Date].[Date]
ON 1 FROM [Direct Sales] Read More
|
|
|