*Reposting* Hi, I am creating SAS VA dashboard in SAS Viya 3.4 For one of the dashboards, I need to calculate Rate which is "count(Store_ID with sales)/ Count(all Store_ID)". Count Store_ID with sales is coming from fact_sales table which is having 2.7million records (around 7 GB). and the denominator Count(All store_id) is coming from dimension table which is having 30K records when I left join these 2 tables (left table is the Dimension table) and create another table the table size grows to 64 GB, which causes a massive slowdown. What is the best way to achieve this. Please suggest. In the above screenshot, if i left join for every date there will be min 30K records per day. For 2 years the the number of rows will be 730*30K.
... View more