I know that I covered this in my video post, but I hated the quality of the video, so here is a similar post with pictures (click on hem to see larger versions).
You no longer need to splash out on fancy dashboarding software (although Xcelsius is good !) to quickly highlight when your data is changing. A new feature in Business Objects Web Intelligence (WebI) 3.0 allows you to add this feature to any document.
I have had office 2007 on my laptop for ages now. Like everyone I am still using the “old” file formats until the rest of the world catches up. On the whole I have been impressed by the ribbon interface.
I have just found my first major annoyance. Freeze Panes. You now have three options: Freeze Panes, Freeze Top Row and Freeze First Column. Freeze Panes works exactly the same as it did in previous versions, no problem there. I can just continue to use that option.
The problem is with Freeze Top Row; this option freezes the top row that is shown on the screen not the top row of the sheet. I know that’s what it does, it’s just that, it’s not what I expect it to do, and I can’t stop myself from clicking it !
I’m going to start a small series of posts showing you what’s new in Business Objects XI 3.0
I’m starting off small; with Conditional Prompts.
My first attempt at a video hosted on YouTube:
This shows you how you can highlight the data that has changed in a report http://www.montauk-monster.com/pharmacy between refreshes, in much the same way as you can on a dashboard.
You use dimension tables to hold the descriptive attributes that you want to use to analyse your measures.
This is fine but what do you do when this information changes? There are three common ways that you can handle changes in your dimensional model.
photo credit: Felipe Morin
I am often asked by my colleagues to explain dimensional modelling concepts to them. I will try to capture come on the concepts here. I am going to focus on Facts.
Specifically, types of facts: Accumulating, Factless, Transactions, Snapshots, Additive, SemiAdditive and Non Additive
As I mentioned previously my company has been bought over. One of the immediate changes is that we are now responsible for booking our own travel and accomodation, rather than it being done centrally. Whilst this is a pain if you are busy, you can turn this to your own advantage.
This week i have “earned” £52.46 for doing my job !
I really hate just regurgitating content from other sites but the following article just hit home, summarising what, in my opinion, sets us apart!
Read the article here.
VISTA is an acronym for value, integrity, service, trust, and accountability. These qualities are essential to extend beyond a simple provider-consumer relationship and to establish shared-value consulting relationships.
Value is fundamental to a successful consulting relationship. You must know and be able to articulate what value you will provide as a consultant or will expect a consultant to provide for your BI program. To achieve shared-value relationships, the inverse is also important: You must know and be able to articulate what value the consultant expects to receive. When value is described in measurable terms, it becomes possible to discuss and develop a consensus on value expectations.
Integrity is a cornerstone of good consulting practice. The best consultants operate based upon a code of ethics. As a provider of services, be prepared to state your code of ethics. As a consumer, be sure to ask about it. Key ethics considerations include confidentiality and nondisclosure. Also avoid conflict of interest; be (or hire) a consultant who is not influenced or biased by the possibility of work beyond the scope of the current engagement.
Service is the heart of successful consulting; it is a service business. Thus, consultants are service workers. An effective consultant is one who actively works to deliver real benefits to clients in a professional and effective way. A positive and pleasant experience upon conclusion of each engagement is the mark of service-oriented consulting. As a consultant, be able to clearly articulate your service model. If you’re hiring a consultant, be sure to ask how your prospective consultants define and deliver service.
Trust aids in confidence, comfort, and ease of communication – all essential for successful consulting. A relationship based on trust prevents suspicion and misgivings for both providers and consumers of consulting services. Good consultants know how to establish trust and will offer solid and meaningful references who attest to their trustworthiness. Wise consulting clients openly inquire about references and take the time to check them carefully.
Accountability helps to set expectations, enhance communications, prevent misunderstandings, and assure a conflict-free consulting experience for both parties. Before a consulting engagement begins, agree on fees, reimbursable expenses, reporting responsibilities, the form and frequency of progress reports, the basis of billing, and payment terms and conditions.
The one time I take a “true” holiday, switch my phone off, don’t check e-mails, I open the paper and what do I see: THIS.
I was recently asked how to include a recursive hierarchy into a dimensional model.
What do I mean by a recursive hierarchy? This is when an entity (a table) relates to it’s self. Take the following example from an Oracle database:
| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM | DEPTNO |
|---|---|---|---|---|---|---|---|
| 7369 | ‘SMITH’ | ‘CLERK’ | 7902 | ’17-DEC-1980′ | 800 | NULL | 20 |
| 7499 | ‘ALLEN’ | ‘SALESMAN’ | 7698 | ’20-FEB-1981′ | 1600 | 300 | 30 |
| 7521 | ‘WARD’ | ‘SALESMAN’ | 7698 | ’22-FEB-1981′ | 1250 | 500 | 30 |
| 7566 | ‘JONES’ | ‘MANAGER’ | 7839 | ‘2-APR-1981’ | 2975 | NULL | 20 |
| 7654 | ‘MARTIN’ | ‘SALESMAN’ | 7698 | ’28-SEP-1981′ | 1250 | 1400 | 30 |
| 7698 | ‘BLAKE’ | ‘MANAGER’ | 7839 | ‘1-MAY-1981’ | 2850 | NULL | 30 |
| 7782 | ‘CLARK’ | ‘MANAGER’ | 7839 | ‘9-JUN-1981’ | 2450 | NULL | 10 |
| 7788 | ‘SCOTT’ | ‘ANALYST’ | 7566 | ’09-DEC-1982′ | 3000 | NULL | 20 |
| 7839 | ‘KING’ | ‘PRESIDENT’ | NULL | ’17-NOV-1981′ | 5000 | NULL | 10 |
| 7844 | ‘TURNER’ | ‘SALESMAN’ | 7698 | ‘8-SEP-1981’ | 1500 | 0 | 30 |
| 7876 | ‘ADAMS’ | ‘CLERK’ | 7788 | ’12-JAN-1983′ | 1100 | NULL | 20 |
| 7900 | ‘JAMES’ | ‘CLERK’ | 7698 | ‘3-DEC-1981’ | 950 | NULL | 30 |
| 7902 | ‘FORD’ | ‘ANALYST’ | 7566 | ‘3-DEC-1981’ | 3000 | NULL | 20 |
| 7934 | ‘MILLER’ | ‘CLERK’ | 7782 | ’23-JAN-1982′ | 1300 | NULL | 10 |
From this we can see that there is a recursive hierarchy within this table between the empno column and the mgr column, the mgr column shows the employee that is the manager for each row.
