Search
BWFreak - Journey to the center of Business Intelligence

Archive for July, 2009

I almost jumped up when I heard the word “BI” from our newly appointed IT lead (CTO, CIO, Senior Excutive of IT, whatever the title). Then, a slide, a pyramid with Data Warehouse in the middle and Business Intelligence at the top…… His introduction speech  turned into a BI awareness session.
This is unusual. I haven’t heard BW/BI mentioned [...]

Famous Quotes

Posted on July 1st, 2009

Success consists of going from failure to failure without loss of enthusiasm. —Winston Churchill
Be yourself; everyone else is already taken.  —Oscar Wilde
Eighty percent of success is showing up.  —Woody Allen
I don’t know the key to success, but the key to failure is trying to please everybody.  —Bill Cosby
The very best thing you can do for [...]

BW customer exit

Posted on July 1st, 2009

Customer exits that we can use to create variables — characteristic value variables, hierarchy node variables, hierarchy variables, formula variables, and text variables in BW. 
Bw exit Types
EXIT_SAPLRRS0_001              Customer Exit Global Variables in Reporting            
EXIT_SAPLRRS2_001              BW: Moving Characteristic Values                       
EXIT_SAPLRSBBS_001             BW: RRI Field Mapping                                  
EXIT_SAPLRSBBS_002             BW: RRI Customer Exit Called before Jump into R/3      
EXIT_SAPLRSSBR_001             Customer Exit Authorization Values for Users           
EXIT_SAPMRSRU_001              BW: Definition [...]

I started to create aggregates on several big cubes about a year ago, and since then, I’ve been really fond of this technology. I didn’t spend much time on it and make the query run-time acceptable.
However, it finally threw me off-guard.
Last Thursday, I found out a huge cube wasn’t all compressed. So I did the compression. I thought it’s totally harmless, [...]

Canada Day Celebration

Posted on July 1st, 2009

Today is July 1st, Canada Day, statutory holiday. Sunny now, rainy later, 14 – 19 C. Mandarin Restaurant, a famous Buffet Chain in Ontario, is free for all Canadian Citizens. I appreciate the offer, but don’t want to test the lineups. I’ll continue working on my robot arm project, ”The Canada Arm”, and read.
Immigrating to Canada from P. R. [...]