Monday Jul 14, 2014

Managing Hierarchies in Financial Applications with DRM

Hierarchies and related links are fundamental to using financial, and indeed many other applications, for example:

  • When a new Chart of accounts is designed, linking an account to its parent is key for future aggregation of data.
  • When legal entities have to be sorted, hierarchies can be built according to dimensions such as geography or organizations.
  • In a General Ledger, every accounting flexible field is a potential analytical dimension.
  • Respecting relationships is also very important when reorganizing sales territories taking into account geography dimension, human resources, client or product information.

That’s why partners have a great opportunity to help their clients to better manage these hierarchies and relationships which are often used in EPM (Enterprise performance management) and Business intelligence. Financial Applications share entire or partial hierarchies with different levels of detail, different points of view. So, “Financial MDM” helps companies to be more efficient because hierarchies and their relationships are managed in a single place. Every modification impacts all applications at the same time. This increases consistency and data quality among all hierarchies.

Financial MDM has got the same DNA as other MDM domains and is a key tool to help partners implement new systems, upgrades and migrations for their clients because it accelerates deployment based on these coordinated and validated hierarchies. Financial MDM manages specific types of master data, such as:

  • Charts of accounts: consolidated, corporate or local. They can be different depending on application type. For instance, granularity is not the same for actual accounting or forecasting. They can be designed to meet different regulatory requirements: local, IFRS, GRI sustainability reporting or Solvency II in the insurance industry
  • Legal entities including different dimensions: geography, activities
  • Organizational dimensions : departments, business units, cost and profit centers
  • Analysis dimensions: using general ledger accounting flexible fields such as sales channels or projects
  • Reference data: time, currencies, taxes.

Financial master data needs to be quickly and easily adapted to business changes at the fast pace of business. Financial MDM is essential not only for minor modifications in day to day business, when creating a new cost centre or modifying an existing attribute for a legal entity, but also when making major changes such as mergers, acquisitions, reorganizations or regulatory changes.

Flexibility is the key to allow business users to easily make their own updates, plus these changes have to be part of a data governance process. A workflow is required to define roles and responsibilities.

Five reasons to invest in a Financial MDM

  1. Empower financial business users
  2. Ensure consistency in business hierarchies and related links
  3. Link local needs to corporate standards and consolidate all lines of business
  4. Accelerate Mergers & Acquisitions
  5. Analyze your master data across heterogeneous environments

See more at:

Wednesday Jul 02, 2014

What If You Could Use SQL For All Your Big Data?

See a short introduction to this on YouTube @ link, and then view the discussion and product launch of “Oracle Big Data SQL” from the 12 minute webcast-replay (originally 15th July 2014).

Then read more about Oracle Big Data SQL, which can now:

  • Provides a single, optimized SQL query for distributed data
  • Supports multiple data sources, including Hadoop, NoSQL and Oracle Database
  • Includes automatic, extensible Oracle Database external table generation
  • Provides Smart Scan on Hadoop to minimize data movement and maximize performance
  • Ensures advanced security for Hadoop and NoSQL data

Benefits

  1. Use the SQL skills you already have to query any data source
  2. Access Hadoop and NoSQL using existing applications with SQL
  3. Extend Oracle Database security to Hadoop and NoSQL

Goto @ www.oracle.com/goto/bigdatasql

Friday Jun 20, 2014

Oracle BI Mobile App Designer v2 is Now Available

Oracle BI Mobile App Designer (BIMAD) v2 is a major release that incorporates significant new capabilities, including new map visualization and better navigation and contextual awareness:

· New Map Visualization

It is designed from the ground up for business users to easily visualize their data with Maps and to interact on mobile devices to zoom, filter, and drill down.

· New Custom Map

On top of the pre-seeded map types for countries, states, & counties, etc, it allows customers to add their own regions and maps by simply uploading their own geoJSON files for polygon boundaries. Flexible custom keyword matching is also included as well as support for native interaction and filtering.

· Completely Redesigned Authoring UI

Redesigned, modern and easy to use property pane, simplified toolbar, consistency across various components and support for multiple component selection to set and update configuration all at once.

· Application Level Calculated Fields and Filters

Filters and Calculated Fields can now be created and managed centrally at App level. Users can drag and drop to assign Calculated Fields to any component and assign Filers from the newly re-designed Property.

And much more....

For more information:

Thursday Jun 12, 2014

Oracle Database In-Memory

Larry Ellison unveiled the next major milestone in database technology, Oracle Database In-Memory, on June 10, 2014.

Oracle Database In-Memory will be generally available in July 2014 and can be used with all hardware platforms on which Oracle Database 12c is supported.

  • This option will accelerate database performance by orders of magnitude for analytics, data warehousing, and reporting while also speeding up online transaction processing (OLTP).
  • It allows any existing Oracle Database-compatible application to automatically and transparently take advantage of columnar in-memory processing, without additional programming or application changes.

Benefits

  • Fast ad-hoc analytics without the need to pre-create indexes
  • Completely transparent to existing applications
  • Faster mixed workload OLTP
  • No database size limit
  • Industrial strength availability and security
  • Robustness and maturity of Oracle Database 12c

To find out more see

 ... and I will let you know how this unfolds in regards to advantages for OBI11g and Exalytics and Big Data over the coming months.

Friday May 09, 2014

Oracle BI Applications 11.1.1.8.1 Now Available

Oracle Business Intelligence (BI) Applications 11.1.1.8.1 is now available on the Oracle Software Delivery Cloud (eDelivery), and on the Oracle BI Applications OTN page. This is the second major release on the BI-Apps 11g code line leveraging the power of ODI, and certified with the latest version of Oracle BI Foundation 11.1.1.7.

What’s New

Significant expansion of content improves existing Oracle BI Applications including:

· Oracle Human Resources Analytics expands analysis on HR programs and workforce performance with the introduction of Talent Management Analysis, to help HR and business managers assess talent strengths and build potential leaders by delivering greater insight into job profiles. Improvements to Absence Management, new support for Workforce Frozen Snapshots and Workforce Flex Fields are also available.

· Oracle Financial Analytics improves company Financial Performance with the new Sub-ledger Accounting Module, providing complete account balance analysis, including supporting reference balances and drill down to accounting transactions. Aging Snapshot restoration for Receivables and Payables, drilldown from Payables to Purchase Orders, and Fixed Assets support for GL Posting Status are features also included in the release.

· Oracle Project Analytics expands insight into project-based data with new Earned Value Management Analysis, providing visibility for Project Stakeholders into Planned Value, Earned Value, and Actual Cost. Analysis of variances and indices, derived from Cost and Schedule Variance, CPI, TCPI, SPI and TSPI, is also available.

· Oracle Supply Chain & Order Management Analytics introduces Costing and Inventory Turn support for Oracle JDE EnterpriseOne. In addition, the ability to save and restore the Inventory Snapshot when executing a full load is now supported.  There is also a new adapter that provides out-of-box integration between Oracle Procurement and Spend Analytics and Oracle’s JD Edwards EnterpriseOne.

· Oracle Student Information Analytics introduces new Financial Aid Analysis, containing term-based detail information associated with a student award such as amount, status, disbursement, and aid type.

· Oracle Manufacturing Analytics and Enterprise Asset Management Analytics have been re-introduced into the BI Applications data model. Although new with ODI, both modules provide now the same broad functionality available with BI Applications 7.9.6.4

· Unstructured Data for Information Discovery – The BI Applications Data Model has been extended to include unstructured CRM and ERP text fields. Sample Information Discovery templates – including ODI interfaces and runtime security definitions –provide the ability to quickly create sample Information Discovery Applications from combined structured and unstructured data. See the Supporting Files for Endeca Sample Applications for BI Applications 11.1.1.8.1 on OTN page.

New Utilities and Enhancements to increase productivity and drive down TCO

· New Data Lineage Tool allows customers and implementers to track lineage from source to target – improving information transparency across their enterprise

· Configuration Management expands System Setup and Load Plan definition capabilities, including the registration of multiple instances for the same Product Line Version, UI enhancements to support DW connection configuration and Load Plan definition, and Load Plan definition migration.

· Fact Partitioning IKMs and Parallel Index Builds are key performance Innovations introduced with this release. The former enables a feature that tags partitions so that only the indexes that need to be re-built during incremental loads are executed. The latter uses ODI parallel process so that Indexes can be built using multiple session (faster than and in addition to DB parallel).

Where can I find more information?

Tuesday Jan 21, 2014

Planning and Budgeting Cloud Service Demos

For Finance executives who are drowning in spreadsheets or strapped to legacy applications, a cloud-based performance management solution offers an easy on-ramp, lower IT resource requirements and accelerated time to value.

You can now see this set of Enterprise Planning Demos and Videos on cloud.oracle.com

On 30 January 2014, at 14:00 h GMT/ 15:00 h CET we will also be starting a series of webcasts on “Profitable Growth with Oracle Planning and Budgeting Cloud Service – for this you can Register Now.

Otherwise, right now you can see the Planning and Budgeting Cloud Service - Partner Webcast Replay.

For more information see on Oracle.com @

Tuesday Dec 31, 2013

New Version Oracle Data Integrator and GoldenGate 12c

Oracle recently announced Major Updates to its Data Integration Portfolio. Oracle Data Integrator 12c and Oracle GoldenGate 12c were both released, plus the availability of the Oracle Warehouse Builder to Oracle Data Integrator Migration Utility, all tightly integrated with Oracle Database 12c and Oracle Applications.

See here this interview with Mark Rittman commenting on these updates in a video: Rittman Mead Evaluates Oracle Data Integrator 12c

We are also delighted to invite EMEA OPN partners to the first Oracle Data Integration (“DIS”) EMEA Partner Community Forum on 11th - 12th February 2014 in Prague, Czech Republic.

Oracle DIS is easy to position, learn and implement. Existing and new partners have experienced quick returns very soon after investing into our products and solutions. Within DIS projects, there is traditionally a high ratio of services revenue vs. license revenue.

REGISTER here NOW

· Hear about the latest news on Oracle DIS v 12c and benefit from gaining insight into Oracle’s business and technology strategy.

· Meet and interact with the Oracle EMEA DIS field operations and corporate product management executives and explore more on a strategic partnership for joint go-to-market. This event also provides dedicated time for one-to-one meetings.

Friday Nov 08, 2013

New Version 3.1 Endeca Information Discovery Now Available

Business User Self-Service Data Mash-up Analysis and Discovery

integrated with OBI11g and Hadoop

Oracle Endeca Information Discovery 3.1 (OEID) is a major release that incorporates significant new self-service discovery capabilities for business users, including agile data mashup, extended support for unstructured analytics, and an even tighter integration with Oracle BI.

· Self-Service Data Mashup and Discovery Dashboards: business users can combine information from multiple sources, including their own up-loaded spreadsheets, to conduct analysis on the complete set. Creating discovery dashboards has been made even easier by intuitive drag-and drop layouts and wizard-based configuration.  Business users can now build new discovery applications in minutes, without depending on IT.

· Enhanced Integration with Oracle BI: OEID 3.1 enhances its’ native integration with Oracle Business Intelligence Foundation. Business users can now incorporate information from trusted BI warehouses, leveraging dimensions and attributes defined in Oracle’s Common Enterprise Information Model, but evolve them based on the varying day-to-day demands and requirements that they personally manage.

· Deep Unstructured Analysis: business users can gain new insights from a wide variety of enterprise and public sources, helping companies to build an actionable Big Data strategy. With OEID’s long-standing differentiation in correlating unstructured information with structured data, business users can now perform their own text mining to identify hidden concepts, without having to request support from IT. They can augment these insights with best in class keyword search and pattern matching, all in the context of rich, interactive visualizations and analytic summaries.

· Enterprise-Class Self-Service Discovery: OEID 3.1 enables IT to provide a powerful self-service platform to the business as part of a broader Business Analytics strategy, preserving the value of existing investments in data quality, governance, and security. Business users can take advantage of IT-curated information to drive discovery across high volumes and varieties of data, and share insights with colleagues at a moment’s notice.

· Harvest Content from the Web with the Endeca Web Acquisition Toolkit: Oracle now provides best-of-breed data access to website content through the Oracle Endeca Web Acquisition Toolkit. This provides an agile, graphical interface for developers to rapidly access and integrate any information exposed through a web front-end. Organizations can now cost-effectively include content from consumer sites, industry forums, government or supplier portals, cloud applications, and myriad other web sources as part of their overall strategy for data discovery and unstructured analytics.

For more information:


Monday Oct 07, 2013

New Bigger Model Exalytics T5-8 Introduced

You can read here the full Press Release for the new Oracle Exalytics T5-8.

We now have two Exalytics models on the price list, the X3-4 and the T5-8, which in summary offer:

  • Exalytics X3-4 – 40 cores, 2Tb Ram and 2.4 Tb of flash storage, running Linux
  • Exalytics T5-8 – 128 cores, 4Tb Ram and 3.2 Tb of flash storage, running Solaris

Also check out the other New Exalytics In-Memory Software License Changes on the price list. And some external to Oracle comments:

With this enhanced storage and processing power, the ExalyticsT5-8 supports massive server and application consolidation to run combinations of OBI Foundation, BI-Apps, Essbase, Endeca and Hyperion applications together, while scaling to many thousands of users with overall lower total cost of ownership.

· Oracle Exalytics In-Memory Machine

· Oracle Exalytics T5-8 Data Sheet

· Oracle Business Analytics

· Oracle and Big Data

Thursday Sep 12, 2013

HTML5 Oracle BI Mobile App Designer

I did report this last month, but it is too good to miss, and if you did, then please check it out with latest hints and tips @ Oracle BI Mobile App Designer.


Apps generated by Mobile App Designer are in HTML5 format. That means you can open the apps with any modern browser on any type of mobile device without installing anything. Not only can you always access the latest version of the apps but also now you don't need to worry about what mobile device to support for your audience. You can even open the apps from your laptops and desktops.

And see more at New Self-Service Mobile Analytical Application Design Tool

Tuesday Sep 03, 2013

New Version of Hyperion Financial Data Quality Management

We are pleased to announce the immediate general availability of Oracle Hyperion Financial Data Quality Management, Enterprise Edition (FDMEE) 11.1.2.3 Patch Set Update 1 (PSU1 – 11.1.2.3.100)  available on “My Oracle Support” for partners and customers at http://support.oracle.com (Search for patch 16681929).

This is a significant release for the product because it now provides scripting that allows you to extend and customize the product for implementation specific business rules related to the processing of source data.  A high level description of the new features is provided below, with a detailed description provided in the user documentation.

Scripting

  • Jython based import, mapping and event scripting
  • Visual Basic event scripting

Financial Management

  • Support for journal loading via excel templates
  • Additional application options
  • New intersection check reports

Custom Target Applications

  • Provides the ability to export data from FDMEE into a user defined flat file format
  • Replaces the data mart and tax adapter features from the legacy FDM product

Additional Features

  • File append and replace methods
  • Load data and mapping rules from an excel formatted file.  Prior releases only supported files in csv formats.
  • Execution of custom calculation scripts for Planning or Essbase
  • Open Batches
  • Batch report execution

Tuesday Aug 27, 2013

New Self-Service Mobile Analytical Application Design Tool

Empowers Business Users with Easy to Create and Delightful to Use Custom Built Analytical Applications Available on any Mobile Device

Read the full press release about the new Oracle BI Mobile Analytical Application Design Tool, and get the collateral and details at Oracle BI Mobile App Designer.

This is a new design tool with which business users can easily create stunning and interactive analytical applications for use on any major mobile device. With this release, Oracle adds major innovations to Oracle Business Intelligence (BI), extending the capabilities of the Oracle BI Mobile solution, and reinforcing Oracle’s commitment to empowering organizations to stay connected to their businesses with real-time insights while on the go.

The apps created using Oracle BI Mobile App Designer run using HTML5 on iOS, Android, and Windows Mobile smartphones and tablets. Automatic rendering for differing screen sizes ensures visualizations display optimally with a write once, run anywhere model. Oracle BI Mobile App Designer is an integral component of Oracle Business Intelligence Foundation Suite, and also is available with the Oracle BI Mobile option to Oracle BI Enterprise Edition.

Partners can start using this now by downloading the software and follow the tutorials on OTN.

Supporting Resources

Monday Aug 05, 2013

New Exalytics In-Memory Software License Change

In the latest Oracle Engineered Systems Price List, there are some changes to the licenses for Oracle software products running on the Exalytics in-Memory system.

· There is a new “Exalytics In-Memory Software” product which is now mandatory for all valid configurations of OBI and EPM software running on Exalytics (but not for Endeca only configurations). This Exalytics In-Memory Software includes the software-specific enhancements created and enabled on Exalytics including Summary Advisor, hardware accelerations for OBI Server and Essbase and enhanced BI-Publisher bursting.

· If licensing by Named User Plus (NUP), the minimum is now 20 NUP licenses per Customer. The licensing prerequisites for Exalytics In-Memory Software are Business Intelligence Foundation Suite, or Business Intelligence Foundation Suite for Oracle Applications, or Business Intelligence Suite Enterprise Edition Plus or Business Intelligence Suite Enterprise Edition Plus for Oracle Applications and / or Essbase Plus and / or Hyperion Planning Plus.

Tuesday Jul 16, 2013

New Exalytics X3-4 System and Patchset 3 Released

Just announced, we have the news of Oracle Exalytics X3-4 Powers Real-Time Analytical Insights (July 15, 2013). This launches a new release of the Oracle Exalytics In-Memory Machine, called the “X3-4” model. The new system features significant software enhancements and hardware updates, dramatically expanding the capabilities of this high-speed engineered system for business analytics.

The new Exalytics X3-4 system features 2 TB of main memory, 2.4 TB of flash storage, and 5.4 TB of hard disk. Oracle also released system upgrades to increase memory capacity for existing Exalytics X2-4 customers, and updated software for all Exalytics customers.

Oracle Exalytics Patchset 3 Software is Now Available

The fourth major release of Exalytics software and associated certifications is  now available for use with Exalytics X2-4 and X3-4 engineered systems. 

What’s New

The new patchset includes a full software version stripe for Exalytics that has been tested together and is delivered as one Engineered System.  Exalytics customers can now access significant enhancements across the whole complement of Exalytics software.  

· New Software improvements of Oracle Business Intelligence Foundation Suite 11.1.1.7. This release has more than 200 enhancements across the suite and many features targeted exclusively for Exalytics, such as extremely fast ‘hot-data’ recommendations from the database cardinality estimate feature, and BI Publisher high-volume bursting that can enable the generation of an extremely large number of personalized reports and documents for business users in time periods that were previously not achievable. In addition, Essbase, a component of Oracle Business Intelligence Foundation Suite, benefits from Flash memory and expanded main memory available with Exalytics X3-4 or with hardware upgrades for Exalytics X2-4. Multiple cubes can run concurrently with up to 25X improvement in load times and 9X improvement in calculation times when compared to the previous release running on Exalytics X2-4 without Flash storage.

· New release of TimesTen In-Memory Database 11.2.2.5 enhancements and new functionality for Exalytics, including a new TimesTen import utility for analyzing data in the Oracle Database and importing to TimesTen in Exalytics with recommendations for optimal data types, columnar compression, and indexes, enhanced parallel inserts for compressed tables and data loading time reduction. These capabilities speed up data load times. In-memory join optimizations in TimesTen result in up to 3x improvement over regular workloads in BI Applications, for instance.

· New Software Certification of EID 3.0.  Exalytics now supports the new, major release of Oracle Endeca Information Discovery, which enables rapid insights into structured and unstructured data including social media, websites, content management systems, raw text from documents, email, and more. By correlating this data to the structured data in data warehouses and enterprise applications, users will be able to more accurately manage data and meaning form unstructured sources, ultimately driving better business decisions and innovations.

· New release of BI Applications 11.1.1.7.1.  This major release features new content across all the BI Applications, two new analytic applications—Student Information Analytics and Indirect Spend Planning—and new use of Oracle Data Integrator and GoldenGate. 

· New Software Certification of EPM 11.1.2.3 Exalytics now supports the latest version of Oracle Hyperion EPM.  In addition to taking advantage of all of the new user experience, integrations and functional enhancements Exalytics now supports 11.1.2.3 versions of Hyperion Planning, Hyperion Profitability and Cost Management and connections to Hyperion Financial Management.

· Support for Hyperion Planning 11.1.2.1: Hyperion Planning customers with EPM 11.1.2.1 deployments can now take advantage of Exalytics without needing to upgrade to EPM release 11.1.2.2 or 11.1.2.3. With an existing deployment of Hyperion Planning 11.1.2.1, customers can now leverage the performance and scalability of Essbase deployed on Exalytics. 

· NEW Exalytics In-Memory Software.  Software optimizations specific to Exalytics, and not available on generic hardware or other Engineered Systems, are now packaged as part of a new priced item, “Exalytics In-Memory Analytics”.  This new line item provides rights to use Summary Advisor, Essbase Flash optimizations, BI Publisher enhanced bursting for Exalytics, TimesTen for Exalytics unique features, and other capabilities unique to Exalytics In-Memory Machine.

For more information:

· Oracle Exalytics In-Memory Machine

· Oracle Exalytics X3-4 Data Sheet

· Oracle Exalytics In-Memory Machine White Paper

· Webcast: Lowering Your Total Cost of Ownership with Oracle Exalytics In-Memory Machine

Friday Jul 05, 2013

Updated Processor sub-capacity License Policy for Exalytics

Until now the policy for Oracle Processor sub-capacity licensing on trusted partitions (Oracle Virtual Machine with Oracle Enterprise Manager) for Exalytics was “socket bound”. The prior policy was that sub-licencing could only be in multiples of 5 “processors”: this has now changed.

Oracle Processor licenses for Exalytics can now be procured as increments of two physical cores (one physical core is counted as the equivalent of two virtual CPUs in OVM). As the Exalytics comes with Intel processors and our current “core factor” for Intel Processors is 0.5, the customer can now buy in increments of one “Oracle Processor license”. Note: this change has no impact on named user “NUP” licensing.

About



Search

Archives
« May 2015
SunMonTueWedThuFriSat
     
1
2
3
4
5
6
7
9
10
11
14
15
16
17
20
21
22
23
24
25
27
30
31
      
Today