Peter..............

About to finished the report that Peter explained to me. And now Peter pings me about some correction in some report. God knows what does he want!! He changes his requirement every now and then. Chatted with me to do something that he could have had done by just dragging some object (intentionally) hidden from reports. These OLTP guys are really big problem. How much time it takes to write a report on OLTP system. May be 10 minutes. The same would take 1-2 days or may be even more. If not possible then go for Freeform SQLs. Man. how he is chatting with me. I do not know the answers, so ask Ritesh. He was busy with Adi due to last day of week. He asks to ignore him. Well I just did that. 5 minutes later phone rang. That was Mayank asking about the same. Peter wanted a confirmation about the possibility of the same. I was witless, due to not having any information about the table used in the report. He was asking to make that report as he has seen in OLTP system, which we don't see. So can't comment on it. So finally the report guru Sachit comes. HE was the one who made the report about which Peter was fretting. I gave up. Sachit asked me ask Peter to chat with Sachit. Well Peter was still insisting that I should let Sachit know all that. I told his he was the person who created the report so it is better to ask him. Well 1 minute after that Peter said, "When you were not the person having created the report, why were you answering the question?" Bouncer... no beamer....


Just in one day the misunderstanding was cleared…

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.