Essbase Data load process taking much time on clearing data
Hi,
Is someone came across such kind of situation? Our Data Load Job is taking much time in Production environment. Particularly it is taking more time for deleting data for particular combination. Is there a way to reduce the load time taking to delete the data? This is killing our load time because our whole data itself gets populated into the Essbase cube within 3 to 5mins, But the below maxl clear process alone processing almost for 20-25 mins. Because of this our overall data load time got increased. Kindly someone advise to resolve this. We use ODI to Push data