Hi All,
I have a cube that takes 40 mins to process, i tried processing the corresponding DIMS and then the CUBE, still the same time. The FACT has 60million rows. I looked at the partition and it is TABLE binding, i want to do it as a SQL binding on DATE, but there are multiple dates and i am not sure how to do it . Please advice.
Thanks