So many weeks have passed since I was mulling over the SQLScript problems. Eventually it turned out that SAP HANA does not support nested queries over OLAP views. In slighter simpler words, it means that if you make an Analytical view in HANA and try to make a Calculation view with a nested query, the compiler will block it. As per SAP internal developer comments, this feature will be supported in future versions of HANA.
I went through lot of tribulations to complete my HANA design, develop a complex load program and then work on BOBJ for making the Xcelsius dashboard shine. Therefore, I am thinking of writing a short tutorial to take a newbie from A to Z through HANA and associated systems. Time is scarce as my HANA use case is on top priority.
These days I am working on a re-design of my original SAP ISU use case. It has gone through several rounds of management review by IBM executives and looks like it will shine at SAP Sapphire conference next month. Keeping my fingers crossed.