7 days and 30 Days. 3D Reports (I love myself)

Marketing and Sales are the most ideate guys that you come across in your professional life. Jinx broken with some doubts. Peter had given some reports to be complete ASAP about the user trends. I could say that the main report was very tough. There are total 4 reports. Size keep on decreasing but the difficulty level remains the same. The biggest report was almost completed by Raj. Really very good work. I was given that report in my down time but my approach was incorrect due to set of attributes picking date from different table and it was must to be taken from different tables s that’s how the WH was evolved. Well. I was trying to explain to Ritesh about the second report. They wanted approval % and $ of various card payment methods. Flat report was already present. Btu they wanted the average of same to be compared with last 7 days and last 30 days. After having understood this problem, I explained it to him rotating my finger less in case of 7 days and longer in case of 30 days, as if we were seeing reports. He found it very funny and wanted me to do it again... :)) Well Sriram came to help me out and told me that I can achieve it by "Apply Simple"ing the whole metric. Total bouncer. So He sat with me. Got the SQL. Edited it. And told me to the fine level what to be made "apply simple" [FYI, Apply Simple is the way to use database supported function directly in MicroStrategy. Highly highly NOT recommended by MicroStrategy Inc] Yup. By 4:30 I achieved it. I felt so great. By 5:30 it was tested and found to be correct. Now comes the pick on the day.

I started looking into 3rd report. This has very cryptic column name. I asked Sriram if he knew anything about it. He told me about the entire column he could explain, but he insisted to ask requester of report to verify. Well I pinged Peter on yahoo chat for it. When I told him I could not get 2nd column, rest column were depended upon it directly or indirectly, he just asked my ext. Voila, here is Peter calling you on phone. This thing that I could not get was Monthly Projection and they had written monthly estimates. He explained to me how is that calculated. I could not get it and I could not listen to him well due to my neighbor chatting too much. He is a complete chatter bug. He I just asked him to explain again. Well, He explained it to me all over again. I covered my other ear to hear him properly. (I don't know but this strange thing of not able to talk well happens whenever there is an overseas call, inbound or outbound). Contrary to the feedback I had got about him, I would him excellent.

Sriram and Peter were hero of day for me. Sp. Sriram for making things Simple.

Zero of the Day. Sify Braodband. This blog was supposed to come yesterday but hey someone stole his wire and I was connectionless. Such thing happens in India. My broadband operator in Mumbai had accepted doing such thing.