مطالب مرتبط با «ssas using multiple fact tables» در back soft | نویسنده: استخدام کار
SSAS Multiple Fact Tables
Vote count: 0 I have the following dimensions: dim_date dim_customer dim_products fact_sales_history fact_lifetime_sales The dim_date is a standard time dimension The dim_customer dimension holds attributes about customers in the database The dim_products dimension holds attributes about products fact_sales_history is all order history for customers fact_lifetime_sales holds the total spend for the customer regardless of time I've modelled this and in theory it's working correctly however from an end users' perspective it isn't. The user wants to select sales for yesterday and filter on some dim_product attributes. Then they want to display a list of the customer numbers who've purchased and...
ادامه مطلب
