Browse by Tags

All Tags » SSAS (RSS)

SSRS Drillthrough for SSAS cubes, how to pass a parameter to an MDX dataset by MartinIsti

Yesterday I had a chat with my boss about drillthrough reports. I told him that with SSRS 2008 it can be done easily. Yep, I was right in terms of a SQL Server data source (or other relational I presume) but it cost me almost a day to figure out how to do it if you have two reports based on an SSAS OLAP cube!...

Books to read by MartinIsti

This post is mainly for fellow BI folks such as me who feel that they are only at the beginning of this road: First I show you what I've already read (or at least have learnt a lot from): The 70-445 Training Kit - it's a great book, teaches a...
Filed under: , , , , , , , ,

Time hierarchy - desc order by MartinIsti

Yesterday I received the task to change the order of our time dimension from ASC to DESC. As easy it is in SQL that difficult it is in AS. Or so it seemed. First I tried looking for a solution among the properties. After finding nothing I began thinking...
Filed under: , ,

Star or Snowflake i.e., 1 or 2 Dim tables? by MartinIsti

Last week I had to design and sketch a more or less simple OLAP solution during which I had to face a certain dilemma. But before going into details I'd like to share some background. The OLTP source system is in Oracle: The first fact table row points...
Filed under: , , , ,

Default Members vs Excel by MartinIsti

Today we ran into an old problem again. Let's start an AS database with a single Sales CUBE and a TIME dimension (+ several other dims). The TIME dim has a default member: [TIME].[Date].Lastchild) It works perfectly when browsing it in BIDS or SSMS...
Filed under: , ,

Exam 70-445 by MartinIsti

It's a quite an exciting story for me As many of you might know Microsoft has a second shot offer that lets you try an exam once more free of charge. The current offer is valid until the end of this year and the 2nd exam can be taken until June 2009...
Filed under: , , , , ,

for starter ... by MartinIsti

How and why I started this blog...
Filed under: , ,
Powered by Community Server (Commercial Edition), by Telligent Systems