BrightStar Partners Logo

December 2008 Newsletter
In This Issue
Season's Greetings from BSP
Are You a Chicken or a Pig?
How We're Turning Heads
Technical Tips and Tricks
IBM Cognos Articles of Interest
Did You Know...

News

Have a look at our Professional
Services offerings here.
 
View our Implementation-Based Product offerings here.
 
Join COGNOiSe.com, the largest independent, worldwide FREE IBM Cognos Support Community by clicking here.
 
Cognos, an IBM Company, becomes a BSP Customer. See here for more information.

Past Newsletters

 IBM Cognos Gold Technology Partner
 
IBM Cognos Silver Reseller
 
Powered by IBM Cognos 
Join our mailing list
Greetings!
 
Welcome to this month's BSP Newsletter.  We appreciate all of the great feedback we've received on the newsletters, and this month in addition to our discussions on IBM Cognos FPM (IBM Cognos Planning / IBM Cognos TM1) and IBM Cognos PM (IBM Cognos BI), we have included a few additional tips and tricks per your requests. 
 
This also marks the last newsletter of 2008.  We'd like to thank each and every one of you for spending a little time with us each month reading articles prepared by various BrightStar Partners employees.  We hope you enjoy the content, and we look forward to bringing more articles of interest in 2009!
 
As always, we enjoy hearing your suggestions regarding the content you'd like to see.  Please e-mail us if you have a topic you'd like to see discussed in future newsletters.
Season's Greetings From BSP
 
Season's Greetings from BrightStar Partners and BSP Software 
 
Please click on the envelope for a special year end message from us to you!

Are You a Chicken or a Pig?

 - Contributed by Katie Kalk, Senior Consultant -
 
A pig and a chicken are walking down a road. The chicken looks at the pig and says, "Hey, why don't we open a restaurant?" The pig looks back at the chicken and says, "Good idea, what do you want to call it?" The chicken thinks about it and says, "Why don't we call it 'Ham and Eggs'?" "I don't think so," says the pig, "I'd be committed but you'd only be involved."

This is the joke that the terminology 'Pigs and Chickens' comes from, it was included in a book written by Ken Schwaber called Agile Project Management with Scrum
 
Pigs and Chickens are key components of Scrum methodology.  What is Scrum?  Scrum is a development methodology initially developed to speed getting software to market in a highly volatile environment.  BSP's Thin Slice methodology incorporates principle concepts of Scrum.
 
The core concept of Scrum is that projects are divided into Sprints, or groups of requirements that can be broken into logical sections and from which deliverables can be driven. These iterative sprints provide for quick wins for the project team.

The Scrum methodology also separates the team into two distinct groups, Pigs and Chickens.  Which of those two would you think is more committed to the project?  If you said Pigs you are correct.  Pigs are the doers and the Chickens are typically the individuals driving requirements. 
 
There are several concepts that make up a true Scrum environment.  They include the principle that once requirements and scope are defined, changes are controlled and the risk that change has to the project mitigated by minimizing the change.  Another key concept is that it is fast past and virtually all obstacles are removed as they occur.  The way that this is accomplished is by identifying the obstacle as soon as it occurs, in daily stand up meetings.
 
These meetings are designed to identify three things:
  • What did I do since yesterday
  • What am I going to do today
  • What is preventing me from doing what I need to do

These are very simple questions that take minimal effort to identify the answers but the answers are keys to keeping the project fluid.   The standup meeting also promotes a team environment and keeps momentum moving.

In a BI Reporting environment, BSP's Thin Slice works very well, with continuous delivery of reports to the user base.

Utilizing the Thin Slice or Scrum methodologies, the deliverables become the building blocks for the next Sprint.  The concept of controlling change is probably the most difficult but is also the most important.  This control lies in the responsibility of the Pigs.  This pretense conflicts with how many implementations are done.  Generally the project content, including change, is driven by the key Business Users or Project Sponsor, the Chickens. 

How does your company manage change?  Are you a Pig or a Chicken?
Not Only Did We Dispel the Myths, But We Turned A Lot of Heads!

Well over a hundred IBM Cognos customers joined us on December 3rd for our most recent webinar dispelling the myths about MetaManager.  Not only is MetaManager a metadata management tool, but in the version 3.0 preview, the audience was able to see how MetaManager can secure content with ease, backup, restore and deploy with the click of a button, identify and fix broken reports, document and so much more.
 
With 12/31 quickly approaching, we are also on the cusp of releasing the most powerful and affordable asset to any IBM Cognos customer's arsenal.  MetaManager 3.0 builds upon an already amazing suite of capabilities, adding:
  1. Entirely new user interface that is more powerful and intuitive
  2. Support for unlimited number of IBM Cognos environments with any number of LDAPs securing them.
  3. Support for any security methods supported by Cognos (basic signon, OS Signon, SiteMinder protected, etc.)
  4. Fix now support in Report Validator to let you fix one or more reports by dragging the appropriate query item from the current package when packages have been updated and reports are impacted.
  5. Powerful new impact analysis that allows previews to content to be viewed side by side with current content either graphically or with a file compare of the underlying XML.  Once approved, changes can be applied.
  6. New content store tree that allows for sophisticated object search through UI or advanced SearchPath mode.
      a. Favorite searches can be saved
      b. Favorite locations in the content store (public and personal) can be saved.
  7. Powerful and unlimited find / replace capabilities within any type of object (scoped at the entire specification).
  8. Multiple search replace capability simultaneously.
  9. Ability to add or remove Portal Tabs, and set Portal Tabs as homepage
  10. Support for more types of objects in all modules.
  11. Command line support for all modules
  12. Tremendous performance improvements.
  13. Hundreds more!

In the event you missed it, we will be hosting one final webinar for 2008 on Friday, December 19th.  Register here.

'Software Exception' Error in Data Manager

- Contributed by Greg Jungels, Senior Consultant -
 
 
When working with large tables in Data Manager you can encounter a very cryptic error message which just says "Software exception." We encountered this error in the following situation.

Environment:
 
SQL Server
  • Dual 2.66Ghz Quad-core processors
  • 16GB RAM
  • Windows 2003 Enterprise Server x64 R2 SP2
  • SQL Server 2005 Enterprise x64
Data Manager Server
  •  Dual 2.66 GHz Quad-core processors
  • 12GB RAM with /PAE - Physical Address Extensions enabled to allow access to more than 4GB server memory
  • Windows 2003 Enterprise X32 R2 SP2
Problem:
  • MATERIAL Dimension DimBuild fails after approx. 4.6 million (consistently) reference level members.

We kept getting a cryptic error message "Software Exception."  We were monitoring the SQL Server, as well as the DM Server, and all looked fine, then everything just stopped. When we checked the box to "Use file caching for attributes," it ran fine and reported that it 'created' a 4+GB file for the attributes, yet only used about 750MB of memory.

Suggestion
 
Use this switch on any lookups that could be rather large.
 
Additional Information
 
Looks like DM, somehow, was not able to access the extended memory available to Windows (after enabling /PAE).  Even though both servers appeared to have plenty of memory, DM was crashing.  By enabling the file caching, we were able to offload most of the data thereby freeing up valuable memory space.

IBM Cognos Articles of Interest

Performance Management
 
 Performance Management in a weak economy
 
SUPPORTLINK
Interesting Supportlink articles:

Did You Know...

In Cognos TM1 9.4... 
  • You can create processes to populate dimensions.
  • The processes to build dimensions and cubes can be scheduled to run at pre-determined intervals..
  • You can create a process using a variety of data sources including a TM1 Cube.

About Pencils...

  • The word pencil derives from the Latin "penicillus," meaning -- not so sensibly -- "little tail."
  • Pencil marks are made when tiny graphite flecks, often just thousandths of an inch wide, stick to the fibers that make up paper.
  • Graphite, a crystallized form of carbon, was discovered near Keswick, England, in the mid-16th century. An 18th-century German chemist, A. G. Werner, named it, sensibly enough, from the Greek "graphein," meaning "to write."
  • The average pencil holds enough graphite to draw a line about 35 miles long or to write roughly 45,000 words. History does not record anyone testing this statistic.
  • French pencil boosters include
    • Nicolas-Jacques Conté, who patented a clay-and-graphite manufacturing process in 1795;
    • Bernard Lassimone, who patented the first pencil sharpener in 1828;
    • and Therry des Estwaux, who invented an improved mechanical sharpener in 1847.
  • French researchers also hit on the idea of using caoutchouc, a vegetable gum now known as rubber, to erase pencil marks. Until then, writers removed mistakes with bread crumbs.
  • In 1861, Eberhard Faber built the first American mass-production pencil factory in New York City.
  • Pencils were among the basic equipment issued to Union soldiers during the Civil War.
  • More than half of all pencils come from China. In 2004, factories there turned out 10 billion pencils, enough to circle the earth more than 40 times. 
  • Pencils can write in zero gravity and so were used on early American and Russian space missions -- even though NASA engineers worried about the flammability of wood pencils in a pure-oxygen atmosphere, not to mention the menace of floating bits of graphite. 
  • The world's largest pencil is a Castell 9000, on display at the manufacturer's plant near Kuala Lumpur. Made of Malaysian wood and polymer, it stands 65 feet high. 
  • If a normal pencil can draw a line 35 miles long, how far would the 65-foot-high Castell 9000 go?
  • There is no risk of lead poisoning if you stab yourself (or someone else) with a pencil because it contains no lead -- just a mixture of clay and graphite. Still, pencil wounds carry a risk of infection for the stabees, lawsuits for stabbers.
BrightStar Partners is committed to bringing you quality content month after month. If you have ideas for topics or if there is something you'd like to learn more about, please contact us and we'll do our best to address your request!  We hope you enjoy this newsletter as much as we enjoy bringing it to you.