MicroStrategy Free Form SQLs simplified

I got up so late today. It was 10:05. I’m supposed to be in office by 10:00. I straight jumped into shower, got dressed, had Idlies in breakfast and reached office by 11:15. There is reason for being extra late. ;-) Working on the report of Game-bookers KPI, I gave some final touches to the SQL. I really enjoyed making final touches, because I made changes to Free Form SQL reports myself alone. I had to depend upon some one knowing the SQL well to do the same. I removed one complete join that was a great achievement. The joy was only short lived. I had to redo that join due to one separate WHERE clause. I spoke to Adi about my planned leaves in November and I didn’t get any positive reply. Ritesh also told me about the rules that I must follow while creating free form SQL report in MicroStrategy, as no other guy would be bale to make or create any schema change till I’m done. I hope I would be able to keep it, because after today’s tweaking the SQL my confidence level is increased very much. I printed the Rent receipt to be sent to Saama Technologies, my ex-employer, and got sign of landlord, Mr. Neeraj Jamwal, too. ;) I took the help of a site for the same. Here is the link. http://www.vakilno1.com/forms/delhirentcontrol/form_b.htm