Hi Ron.

Great subject as I am now in the same boat. Your example simply describes what SCD-2 is. So great, let's follow it. Let's assume that there is a fact table using the dimension in question and let slice it just by that dim. Writing a star-query in SQL would allow me to do two things:

1-easy. Create a list of transactions (events) along with their dimensional attributes as they were at the time a transaction occurred. So

Manger_A with EmpID=10 (sold) $5

Manager_A_changed with EmpID=10 (sold) $20

Total is $25

2-harder. Using some SQL and/or Dim design trickery I can get the same $25 showing as either for Manager_A, or Manager_A_changed. In other words a query sliced by a dimension as of some point in time.

So the question is how can one do that in SSAS?

A somewhat easier option is to slice by the Name (NOT the EmpID) defaulting to a specific version, and a harder option is to allow users to choose the version of a row in an SCD. Let's assume that a date is a suitable criterion for selecting a version, e.g. first day of a fiscal calendar. And, of course, how can I get option 1 above, i.e. slice by name and date get two rows, one for each incarnation of Manager A?

Thank you!