while building cube two things that can make cube creation fast is i) making datasource which is bringing fact ..UNCHECK GENERATE CATEGORIES.Only dimensionsal source should populate categories and not the fact source. ii) If last level in dimensions which is defined unique using the surrogate key then make sure that you remove - VERIFY UNIQUNESS selection for that dimension. |
No comments:
Post a Comment