Hello Experts,
I am looking at implementing SCD Type 2 in analysis server. I have
handled it in SQL Server Dimension tables by adding extra records but
bit confiued how it can be delivered through the cube.

Option 1: Under Dimension Table, I can add "Effective Year" and
"Effective Month" for example "Customer" Dimension. The lowest level
customers moves into different parent level yearly and monthly. So I am
interested to see "What is my sales figures for this year vs last
year....".

Now this "Effective Month" can join back to fact table with
transactional time becase in the fact table, I have month and year for
a
particular sale for that customer. Which also means, I am having 2
joins
for customer table back to fact table in the star schema. One is
Customer Surrogate Key
back to Fact Surrogate key for Customer. In this instance "WK_Cust" and
then "Effective Month" of Customer table back to "Month" in fact table.

The cube then handles current data and historical snapshot by just
using
its Time dimension. If I plug Excel Pivot table against the cube and
take Customer on Row and Time on colums, it does shows correct numbers.

Now, I want to know whether this is a best practice before I sell this
to my customer. Can you please please reply me with some suggestions?

Thanks for any help.
Regards

Soumyadip
Melbourne