It would be interesting to see if anyone can tell me a couple of things about how SSAS works. If not, at least it would be very nice if anyone could hook me up with a SSAS product team member, who can shed some light…
1. Write-Back Tables
How does SSAS create a write-back table for a partition? More specifically, if you have a role-playing dimension (I’ll use an example with a Date), you will get two Date keys with _ suffixes. How do these suffixes get generated? Is there any
logic which SSAS applies consistently? This would be very helpful when moving data from the write-table to the fact table.
2. Measure Expressions
There are two conflicting blog posts by Christian Wade and Teo Lachev about how Measure Expressions work. According to Teo Lachev, Measure Expressions get calculated at runtime, while Christian Wade writes that the calculation results are stored on disk
(assuming during processing). It would be good to confirm this as it may matter in some specific cases (Currency Conversions with heaps of data).
Boyan Penev --- http://www.bp-msbi.com
View Complete Post