I have one fact table and 7 other tables which are connecting to fact table through left Keep. When I am applying left join then It is giving me General Script error, may be due to data size as data size in fact table is 67 million. That's why, I am using left keep.
I am creating adhoc report in which one measurement is there (Count(Distinct A)) but performance is quite bad. Can anyone give me some idea to improve the performance.