The script is not responding despite of complete execution and the application is hanging what may be the reason
Hard to say - here are some ideas:
Complex calculation(s) with use of expensive calculation constructs like sum(if()) or aggr().
Expressions that span large tables that are incorrectly associated or not associated at all
Complex and unwanted synthetic key(s)
As Jon suggested one there could be couple of reasons.
1. Huge amount of data
2. Complex calculations
3. Bad data model
Also i would recommend you to check your RAM utilization at the same time, if it is reaching its limits then you have find a solution to optimize it.
Also i can see some tables on the load page, tables take more ram while loading. Try to create a welcome page with no charts on it and then do the load again.
Please provide the below information:
1. qvw size
2. Amount of data loaded
3. Data model snapshot
4. Expression and dimension used in the tables
It is very difficult to identify the root cause with out seeing the actual qvw
data modelqvw size expression and dimensions
sum(if(Sold_Date <= MakeDate(Prev_Year,month(To),day(To)) and Sold_Date >= MakeDate(Prev_Year,month(From),day(From)), [inv value]))/Sales_INR_Unit,
'#,##0.0') and so on.....
Issue seems to be your expressions. Try to avoid sum(if( expressions.
Use set analysis.