June 23, 2011 at 5:07 pm
Hi everybody-
I have a fact table of service calls that is basically an accumulating snapshot fact table. Each record represents one call, has dimensions of things such as facility, the person who requested the call, the type of service to be performed, etc. Then the date keys represent each step of the pipeline (created, first response, finish, close out). The customer has a specific set of these calls that they want to track as 'finished in time', and they want it measured by a rolling 30 day window. I created another fact table that is that 'finished in time' measure, the snapshot date, and a foreign key back to the original service call fact table, so that all of the calls over the rolling 30 days can be connected back to that table.
I thought that with this model, I would be able to slice this 30 day snapshot fact table by the original dimensions, since the fact tables are connected. I can do this with SQL on the actual database, but I can't get SSAS to do this correctly. What kind of relationship is this that I'm missing?
June 23, 2011 at 6:00 pm
I did something like this for now on the smaller rolling 30 day fact table-
http://gopika-lasitha.blogspot.com/2010/05/how-to-combine-two-fact-tables-in-ssas.html
It seems like there's a more intuitive relationship there - is there one, or is this the best option?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply