Hi, During cube building, we can partition based on date and build the cube for specific date range. It works fine when fact table has date column. But if it has surrogate key pointing to lookup table of date dimension, we can't directly give date format since surrogate key is just an integer and partition only considers fact table.
Is there any way we can overcome this? Best Regards, Hari
