I have 3 tabs with 2 graphs each tab , and the data model have some synthetic keys , the performance of the application is pretty slow, when i change the filter values the graph seems to take much time to refresh , this did not happen when i was having 1 tab , as i add tabs my application performance is getting worst ...could anybody please help me in handling this...
I dont have any macros running in my application ,
I'm pretty sure synthetic keys can really slow down chart calculation times but it really depends. I can't really say if that is your problem or not without looking at it (and even if I was looking at it, I wouldn't be able to tell you but somebody else probably could if they actually saw it). Do you have any calculated dimensions? I had a huge calculated dimension that made the whole sheet incredibly slow to the point where you really couldn't even click on anything. Once I figured out what I was doing and I put it in an expression instead, everything was fine.
