Hello All,
Currently i am facing some serious issue with Query performance.
Cube is having data accurate and latest data, but when i am executing query for even one day it is running for hours and hours and finally it is giving dump.
TSV_TNEW_PAGE_ALLOC_FAILED
I have also checked whther we can create any aggregate on cube, but there is no possibilty for creating aggregates as users are using data based on cal day.
I am confused that why suddenly we are query performance issue...
Regards,
Pankaj Naik