I was stuck in this issue and I think I should share the knowledge out, just in case any of you face similar problems.
This issue happen because the Inventory cube is not compressed, and you’re building an aggregate over it, rollup takes long time, query runtime is extremely slow. You tell your user to restrict more selections when running the report, especially posting date/key dates try to put shorter duration. But the report is still so slow. Why? Because U do not have compression LOH.
What happens when you compress your data in Cube is that fact table lines will be transferred from F to E table. What significant outcome will you get by moving the data across another table? The answer is PERFORMANCE. Just follow the best practice :-
A maximum number of 20 – 30 partitions per f table are recommended (that figure comes from a “one load a day and 30 days a month” scenario).
Partitions on the E fact table may be more numerous because in queries there usually will be time restrictions that reduce the number of partition accesses (partition pruning) because the partitions on the E facttable are by some time criterion (OCALMONTH or 0FISCPER).
On the F table, every partition must be accessed for every query because there is no effective restriction on the p-dimension partitioning key on the F facttable, and due to load performance the Indexes on the F table are all local indexes. This will cause unacceptable query response times if there are too many partitions.
What is wrong with the current architecture is… there is no compression! we overcome slow query runtime by implementing aggregates, aggregates and aggregates. We have even aggregates with mean value 2 with Valuation —–|
So the best approach is to use simple technique like compression. Aggregation gives even more problem. I later found out why the previous consultants from 1 of the Big 4 did not use Compression is because “the value went wrong after compression” hence they avoided compression until now. I wonder where these Big 4 get their SAP CONsultants from,
Today I was helping this Manager with her reports. She is Happy. She gave me something as a show of gratitude.
I am happy liao. If only DKSH user were appreciative enough, I’d be drown in Ferero Rochers already.
Happy April fool day !!! Have you fooled anyone today? I had just pulled out a prank on someone and it was a success LOL.
Roll Off Day
Anyway, today was D team’s last day and they’re now officially rolled off. It is normal for consultants to come and leave, but this time I felt weird; It was like being dumped and I feel kinda lonely.
I can imagine how boring it will be in the office, and I guess I’ll be demotivated for quite some time. Everyday used to be so busy with all those issues, full loads, remodelling, aggregates, re-architecture, transports, blablabla… all sorts of discussion happening around the Project Room and especially the BI team (5 ppl) But tomorrow onwards, it’ll be only 2 person left in the team.
I’ve never felt like this before. Maybe because all these while I’m the person who leaves the client site, my roll off day was very fun and I was looking forward to my new project or back to Office. Now I finally understand how does it feel like to be the person who were left behind. Maybe because this time, I’m left to do the shits alone while the rest can happily leave this place 
2 Weeks later, I will be handling all SAP BI stuff alone for a month. Because the permanent staff all either holiday or maternity. Sigh man, I still got 5 months to go…. so long.
Btw, I really learnt a lot from these guys. From tomorrow onward I’ll be the only Consultant here liao :-s
I better start getting organized myself, because nobody is gonna keep track of me and keep me organized liao.
Customer A has requested for a COPA report. You just received an email containing the requirements and specifications for the report.
First, you login to the Query Designer (2:00pm).
Second, you select an existing COPA InfoProvider (2:02pm).
Thirdly, you start dragging the relevant Objects to the rows(2:06pm).
Fourthly, you drag the entire structure for key figures to the column(2:24pm).
Fifthly, you save your query and give it a nice name(2:30pm). You’re done ! All in 30 minutes.
You then send an email to Customer A and CC the finance department.
Dear Customer A,
We have review your Development Change Request(DCR) for a new COPA report, and would like to inform you it is feasible and able to be developed.
This development requires extensive COPA objects and modeling, hence we’re quoting RM65,000 for this development.This development will require 5 working man days to complete.
Please review the DCR and approve the DCR if you’re satisfied with the proposed timeline and DCR charges, and we’ll get the green light to start this development.
Thank You.
Yours Faithfully,
Con-sul-tant
Normally the customer will just accept to pay the quoted price and timeline.
So you can spend ur 5 days time spamming facebook and forum, by the end of the 5th day, you send an email to the Customer A and tell them the development has been done and is within the proposed timeframe and SLA has been met. Your company is now richer by RM65,000.
Easy money huh 
It’s the Year 2010 liao. If I recall correctly, it has been 4 years since I started working. My work was fun, I was very passionate with my work. It wasn’t for the money, because all those years I’ve been getting a very low pay and doesn’t qualify to be taxable at all. It’s the passion and love towards my work that made me persevere and strongly motivated to stay on for so long. It was hard and miserable at first, but slowly I’m able to taste sweetness from beneath the sour and bitterness along the journey.
I am somewhat stagnant now. I despise Office politics and was unwillingly dragged into one. Despite my ability to self learn and perseverance, I am not able to grasp the new emerging technology and not able to perform well. Perhaps it’s the age factor. I realize I’m too old to learn something new already. It is time for me to move on, towards a more of less-challenging tasks with less brain-oriented activity and most importantly away from politics.
Hence, my new job :-
as a Warehouse Assistant Fork-lift Operator & sometime i help becum Cashier liao
Wish me all the best in my new career !
I will work to my fullest !
For more than 2 yrs these kind of emails always appear at least once every month. I thought all of the mails are similar as if they were copying from the Internet. I never imagine that I’d be scratching my head thinking how to compose a farewell email. I tried to draft mine, and I think it’s not easy.
I feel like typing “Finally I have the chance to send out this farewell e-mail, after getting so many farewell from those lucky fellas who left here. I am so happy for a moment like this, because it’s farewell to Hell. All the best to you guys. BTW Chingyin, Ally is earning rm1k more than you =P”
But maybe not
We finally moved to BI 7 yesterday.
It was great.
Not for me.
I don’t have much confidence with what I do in live. I can’t speak as if I know everything. I can’t spend lavishly as if I am loaded with cash. But when it comes to BW3.5, I can proudly say “I know” because it’s my ‘periuk nasi’ (source of income).
But today, I realize my ‘periuk nasi’ has become ‘periuk bubur’. What used to be so easy is now so different, at least the icons are still recognizable. There are a lot of new concepts and old concepts has been obsolete thus missing from the workbench. I can’t find the frigging PSA 
This is what I hate about the ‘prophecy’.
According to the ‘prophecy’ that I used to hear all the time before I graduate. “IT field very hard one, you need to constantly study when new technology come out. Unlike a doctor, once you learn something, the concept will last til the day you retire”. Which means, being in IT field you need to keep study-ing because new technologies are being invented everyday. If not, you will be left out and obsolete.
I was a BW ’specialist’ yesterday. But as of today, I’m a BI ‘noob’.
Here comes ‘test & trial & error” again… no training provided T.T
Life in IT is indeed like a fast lane, gotta catch up with the speed.
Recent Comments