BusinessObjects Topics

Search This Blog

BusinessObjects Topics

Saturday, February 27, 2010

IBM Releases Cognos Analytics Upgrades

Over the last two years the Dow Jones Industrial Average has ranged between 14,000 and 6,600 and the cost of oil has ranged between $140 and $35 per barrel. Corporate finance types have barely kept up. No sooner are budgets and projections created than they end up in the digital equivalent of a waste basket.

Aiming to provide better coping mechanisms, IBM today introduced improved IBM Cognos tools designed to support faster, more flexible financial analysis. The elements of the three-part release include new scenario-planning options, new financial consolidation capabilities, and new pre-built models for vertical-industry scenarios.

It has always been possible to create scenarios in the IBM Cogno TM1 in-memory analysis tool, but an upgrade released today supports unlimited, dynamic hierarchies that let planners consider a range of possible scenarios in their budgets and forecasts.

"It's very common for companies to consider new groupings of products, product lines and market areas to focus on growth and profit," said Doug Barton, vice president, financial performance management at IBM. "Before you make any final decisions, this new TM1 capability lets you look at multiple scenarios to consider all the financial implications."

A key point is that these scenarios can be retained in a personal sandbox environment or shared with others to encourage collaboration. They can also flexibly become the adopted approach to organizing budgets and plans. The scenario approach lets executives quickly respond as conditions change.

The new financial consolidation capabilities delivered in today's IBM Cognos 8 Controller release include enhanced allocation and formula-calculation features said to easy financial reporting. In addition, the vendor has also gone beyond conventional, pixel-perfect "blue book" reporting by enabling financial results to be published through the TM1 analysis engine. "This will enable analysts to use TM1 to derive new insights on operations so they can look at trends in detail," Barton said.

The new pre-built blueprints introduced today address product profitability analysis, demand planning for the consumer packaged goods industry, and development of executive dashboards for insurance underwriting. The blueprints give companies a head start on building company-specific analytic solutions, but are they extensible and upgradable as the underlying BI tools change?

"When we release a new version of TM1, the models customers have created with their own hierarchies and data based on these blueprints will automatically upgrade as customers would expect," Barton said. "If we create a new version of a blueprint to introduce new capabilities, that's when it will be up to the customer to decide whether they want to rebuild to weave new capabilities into their solutions."

IBM Cognos customer Quiznos, a fast-growing restaurant chain with more than 5,000 outlets, is using the TM1 analysis engine to simplify financial reporting and planning. "With the new IBM Cognos software, all of our business units will be able to use the same assumptions and the same drivers when building budgets and making key financial decisions," stated Michael McConnaughey, financial systems applications developer at Quiznos. "Teams will also be able to view business variances and use predictive insights to understand the impact on the organization."

The IBM Cognos TM1 and Controller upgrades, and the new industry templates are all available immediately.

Read more »

Friday, February 12, 2010

Evolution of the BO XI platform – from XI R2 to XI 3.1 SP2

Where were we with XI R2:

• Change to Crystal service-oriented platform (Crystal 10 architecture)
• Ability to plug Crystal Reports, Web Intelligence, Desktop Intelligence, OLAP Intelligence, Dashboard Manager, Performance Manager directly into the framework
• Single repository, security, system management, publishing, portal
• Infoview (Replaced old BO Infoview and Crystal ePortfolio)
• Central Management Console (CMC)
• Import Wizard (upgrades from BO 5, 6, XI, Crystal 8.5, 9, 10)
• Desktop Intelligence (new name for BO full client + ability to query and display Unicode data)
• Publishing, Encyclopedia, Discussions, OLAP Intelligence, Performance Management
• Changes to Data Integrator, Composer, Metadata Manager

XI 3.0

• All administration moved to the Central Management Console – CMC – with new GUI
• Bulk action support in CMC
• Central Configuration Manager – CCM is still there (to manage multiple nodes) with 2 entries : Tomcat & SIA
• Server Intelligence Agent (SIA) – handles service dependencies
• Server Intelligence in CMC – clone server deployments
• Repository Federation – replicate repository on other BO cluster
• Repository Diagnostic Tool (Infostore vs FileStore – repair inconsistencies between CMS database entries and files in FRS)
• Improved Import Wizard
• Web Intelligence Rich Client (offline viewing of WebI reports, no session timeout)
• Data change tracking in Web Intelligence
• Designer – “Database delegated” projection on measures
• Universe based on stored procedures
• Prompt syntax extension (persistent/primary_key undocumented features, finally!)
• Personal data provider – combine data from Excel, text, csv and get into a single report
• Smart cubes – support for non-additive measures (percentages, ratios) and RDBMS analytical functions
• Multi language support – dimensions, measures, prompts automatically localized to report viewer’s language
• Native Web Intelligence printing (without PDF)
• Enbed image in Web Intelligence report
• Hyperlinks dialog box makes links easy to create – syntax generated by WebIntelligence (remember opendocument()?)

What’s new in XI 3.1

• Support for multi-forest Active Directory authentication
• IP v6 support
• Lifecycle Management Tool (LCMBIAR files, replace Import Wizard)
• Saving Web Intelligence documents as CSV (data-only files) – new sheets for every 65K rows of data
• Web Intelligence Autosave
• “Begin_SQL” SQL prefix variable
• Prompt syntax extension (support for key-value pairs!)
• Business Objects Voyager enhancements
• Live Office enhancements
• WebIntelligence – Automatic loading of cached LOVs, interactive drag-drop, report filter bar, cancel refresh-on-open

What’s new in XI 3.1 SP2

• WebIntelligence Input controls
• OLAP universe based access to SAP BW using MDX
• BI services – expose WebIntelligence document components as web services
• Query on Query
• Fold-unfold UI improvements
• New SDKs – WebI Calculation Extension Points, Custom Data Provider plugin, Interactive viewing extension and integration points
• New universe SQL parameter SMART_AGGREGATE allows using most detailed aggregate tables
• @Prompt editor in universe Designer
• Backward compatibility is broken. Web Intelligence documents created using BO XI 3.1 SP2 cannot be opened in BO XI 3.1




Ukraine bride

Read more »

Wednesday, February 10, 2010

Why Business Intelligence Projects Fail -- And What To Do About It

Read more »

Tags