|
|
MDX and Analysis Services
MDX and Analysis Services
-
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
|
-
For a OLAP based report I needed to get numbers for an employee for 4 weeks this year and the corresponding 4 weeks last year, and show it in a Reporting Services report based on a matrix. Creating the basic mdx was not the hardest part, but getting Read More
|
-
For a report, I needed to find out when employee X last registered an hour.
My measure is called Total Hours (hours can be billable or non billable, but the Total hours will calculate both types, and both types are valid in this report.)
My Date Read More
|
-
My techie husband Bernt Lervik has just written a set of blog posts on how to set up unattended installation of SQL Server 2000, Analysis Services and Reporting Services, and adding the right service pack for each install. Why he wrote it? Because of Read More
|
-
So, migrating an OLAP cube / database from AS 2000 to AS 2005 seemed like a breeze. Most of it is, anyway. But for some reason, my Time dimension gets all messed up in AS 2005. It's broken into Year, Month and Day. THere are some days and months in Read More
|
-
About one year ago, I started working with Reporting Services for SQL Server 2000. I did lots of mistakes and silly things with my first set of reports, but I also figured lots of things out. Some time this summer I felt pretty confident about my RS Read More
|
-
Sometimes when working with Analysis Services databases, I want to use the same database from a cab-file, but giving it a unique name and a different data source. It's no intuitive way to rename a database, but today I found this answer from Microsoft's Read More
|
|
|