Oracle User Group Conference – Oracle Development Tools Training Conference

Cloud technologies like Amazon Web Services and the new Oracle Cloud allow for rapid application development using distributed teams. This session will walk through the set up and best practices for developing in the cloud while walking through a real world case study.

Oracle User Productivity Kit (UPK) allows companies to develop, deploy, and maintain content for training and testing. It can help mitigate project risk, reduce deployment and project timelines, and assist with end-user adoption. This presentation will review the basics of UPK, different use cases for implementing it, and how to leverage it for testing and training purposes. In addition, this presentation will include tips and tricks for getting started and will highlight both the administrator and user perspectives.

Showcase the power and flexibility of MDX within ASO as a "calculation" engine by using MDX to dynamically calculate annualized investment returns for any given user-selected time horizon.

This session will focus on CPU monitoring and capacity planning. The session will highlight scenarios that are typically encountered on a massively consolidated environment, where, let's say you have over thirty databases and you want to know how much CPU cores they are using at a particular time interval. Before touching on the cool tricks, a deep dive into important CPU metrics is a MUST. In Oracle world the CPU is not just the "Green Thing" in the Enterprise Manager. It's actually much more than that. The session will discuss the usual CPU monitoring tools in OEM, visualization enhancements that can be made by AWR analytics, and how these can be applied to critical capacity planning scenarios.

In today's competitive business climate, companies are under constant pressure to reduce costs without sacrificing quality. Many companies see database and server consolidation as the key to meeting this goal. Since its introduction, Exadata has become the obvious choice for database and server consolidation projects. It is the next step in the evolutionary process. But managing highly-consolidated environments is difficult, especially for mixed-workload environments. If not done properly the quality of service suffers. This session will tell the tale of a large real estate investment company that successfully consolidated their global operations onto a Maximum Availability Architecture Exadata platform. Applications sharing this environment include PeopleSoft Financials, PeopleSoft HR, Portal, and OBIEE. Accurate provisioning and management of system resources was absolutely essential to their success. This session will share lessons learned and the tools you'll need to ensure that your consolidation story has a happy ending. 2 part presentation (1 hour for each session): -------------------- 1st part - Consolidation Planning/Provisioning Deep Dive 2nd part - Implementation Tools, War Stories, Resource Management

Simplify your user experience. Lower implementation costs. Increase productivity. Delight your users. Are you looking to wow your employees with a user interface that is simple, modern, and compelling? Learn how Oracle's drive toward enhancing productivity helps you achieve value from your application's investment. This session will show you how you can exceed your employees' desire for enterprise data, delivered on any device, and then explain how to reduce the cost of your user interface customizations, configurations, and extensions.

"Where is this number coming from?" "Why doesn't this look right?" "How do I explain these variances?" "Can you show me this data in a different way?" These are all questions our managers ask, and we are expected to answer with Essbase. Yet sometimes, staring at an empty spreadsheet or at a report someone else created, we may not know what do to next. Watching someone else do analysis may leave our heads spinning. Even if things aren't quite that bad, we may feel we're taking the long route to our answers, or that there might be technique we're missing from our repertoire. This session covers the basic methods of ad-hoc analysis for different modes of exploration. The session will discuss the various options, when to use them, and when not to. The session will talk about what kinds of questions lead to what kinds of analysis modes. The session will review techniques for efficiency and lesser-known features. While the session is aimed at the less experienced, there's a good chance even experts will hear something they didn't know. Smart View and Classic Add-In will also be covered.

There has been some buzz around the Essbase world in recent years, much of it promulgated by the presenter of this session, about automation using the Java API with the Groovy language. Now that people know about Groovy, and are learning a few things about putting it to use, it's time to start sharing code. This presentation will talk about the oddities and absurdities of the JAPI and what we can do about them. With Groovy metaprogramming, we can fix them and make the JAPI easier to work with than ever before. Come see the code and the techniques being used to tame the JAPI more and more and to do some truly exiting automation work, from metadata extracts to UDA manipulation to full system backups. Learn how to use the code yourself to do powerful operations simply.

APEX 4.2 is once again an important major release. The marquee features are mobile applications, support for HTML5, packaged applications, and RESTful Web Services. These features are talked about a lot. But aside from that there are once again so many useful improvements to the APEX engine worth talking about. These features include read-only attributes at page and region level, shared session state across applications, debug API improvements, better JavaScript ajax functions, and improvements to interactive reports, websheets, dynamic actions, and plug-ins.

Security is an increasingly important requirement of web applications. While performing security assessments for a diverse range of sites that used Application Express the presenter observed a common theme: SQL Injection vulnerabilities that allow attackers to access and manipulate sensitive data. Complex APEX applications have a lot of custom PL/SQL code behind the scenes that can introduce vulnerabilities into the system. The session will demonstrate the power of a SQL Injection vulnerability in the hands of an attacker. The session will then present the four forms of SQL Injection commonly seen in APEX applications, along with code examples taken from real-world systems, and discuss the ways in which the code can be restructured to mitigate the security threat.

ADF Task Flow is the most important and essential feature of ADF development which makes ADF unique in the battle of frameworks. This session will help you to understand different components and techniques to build task flows and will discuss some use cases.

Oracle support for regular expressions has been around since version 10g Release 1. However it's common to find developers that aren't aware of this powerful functionality. Oracle SQL support for regular expressions lets application developers implement complex pattern-matching logic in the database, which is useful for these reasons: By centralizing pattern-matching logic in the database, you avoid intensive string processing of SQL results sets by middle-tier applications. By using server-side regular expressions to enforce constraints, you avoid duplicating validation logic on multiple clients. In this session we'll talk about common used operators, pattern matching conditions and functions provided by Oracle.

In this session discover how Amerigroup replaced a black box HAL process with FDM & ERPi to load their Planning application. During this session the presenter will review the decision to use ERPi in conjunction with FDM to enable drill through to PeopleSoft. The session will highlight the automation that provides flexibility to process data for the entire company or a single business unit. Finally the session will demo the drill-through capabilities that ERPi provides - not only to the ledger but also to the subledger.

Ever wonder "what would happen if I..." did something in HFM? Oracle ACE Chris Barbieri takes a "Mythbusters" approach to explaining how HFM works by showing you how to break it. What would happen if I deleted the first few years of data in the application? What if I made a base member a parent, or vice-versa? How about renaming an entity? Enabled the Org By Period setting after the app was live? This session will explore which actions you should or shouldn't try at home, and more importantly, explain why.

HFM application performance is a complex function of application design, data volume and quality, user process, and infrastructure design. Chris Barbieri reviews each of these aspects of system performance, explaining the relationship between application design and performance, along with updated application statistics to answer the question "what's normal?" More than just statistics, Chris describes how HFM behaves according to variations in design. He'll present statistics on data volume and discuss the impact of data on performance, particularly compared with rules performance. Finally Chris will review some common tuning parameters related to consolidation and reporting performance.

Collections (array-like structures in PL/SQL) are used in two of the most important performance features of PL/SQL: BULK COLLECT for data retrieval and FORALL for data modification. Collections are also used in Table Functions, leveraging all the PL/SQL power in the SQL environment. In this session you will learn the basics about the collections and how to use them. The session will touch on the similarities and the differences between the different types.

Upgrades and migrations are the perfect time to not only evaluate the latest and greatest technology features, but also to review your organization's business intelligence processes to make sure that you are working effectively and efficiently. The session will review how to "sell" your leadership on why to migrate; thoughts on best practices in upgrades; the difference between a "migration" and an "upgrade"; important items to note as you're thinking about this major change for your organization; migrating existing Oracle Hyperion Intelligence or Discoverer reports...or content from another vendor's BI solution...to OBIEE or BI Foundation; and much more!

This session will define the process and design for Project Financial Planning. You will learn everything you need to know about implementing the solution that is designed to support financial planning and forecasting for contract, capital, and indirect projects. Find out the key benefits that the Project Financial Planning tool provides to an organization tasked with planning projects for all aspects of its financial statements, from Revenue Planning, Employee Planning, Expense Planning, and CapEx Planning. Also learn what industries are applicable and what is configurable as opposed to what is not.

Hyperion users deserve peak performance to do their jobs. Understanding exactly what your users are doing, how your system is performing, and having correlations between all of the moving parts is the key to delivering this performance. Accelatis Ascension Suite is the premier Oracle Hyperion Toolkit for finance and IT administrators. This session will discuss challenges that are common to Hyperion administrators and how Accelatis addresses them proactively and effectively.

Performance monitoring is a black art to many. The health of an Oracle Hyperion EPM deployment is dependent on many factors: Component & Network Connectivity, User Activity, System Metrics, Application Data & Configuration. Any aspect can cause poor performance and downtime. See how to leverage metrics to gain insight into system performance and take a scientific approach to identify opportunities for performance improvement.

This presentation will teach non-DBAs how to use one of the most powerful tools in the HFM arsenal, Extended Analytics. The session will show you how to configure EA, the types of extracts that can be created, and user tools for accessing the data. The session will show you how to create efficient extracts and include all the sample queries you need to get up and running. The session will also illustrate how EA is an essential tool for an HFM admin that can be used to, among other things, rapidly tie out an entire HFM application or analyze application performance. Finally, the session will compare EA to Essbase Analytics Link to help you identify which is the best tool for your circumstances.

Currency translation can be one of the most confusing parts of an EPM system. The accounting requirements can be intricate, each tool handles the process differently and distributing the results across systems can be tricky. The session will start with a short primer on accounting translation for non-accountants. Then the session will go into a detailed, technical review of the very different methods HFM and Essbase use to translate, highlighting the capabilities, strengths, and weaknesses of each. Finally, the session will discuss the challenges you'll face (sharing data, avoiding duplicate translation) when building a multi-currency EPM system and the options for handling them.

While the Financial Management Client program that ships with HFM provides key functionality is quite reliable, there are many areas where it could be improved. Fortunately for us, the Financial Management Client is a great example of a program that implements the HFM COM API as many of the program's features are directly attributable to API functions. Due to this fact, we can focus on adding value without having to completely reinvent the wheel. This session, which builds off of last year's API session, will walk the audience through a complete program build utilizing HFM COM API functionality and Microsoft Visual Studio .NET. Fully working code will be provided as well for attendees.

As environments grow in size and get increasingly complex and fragmented, the number of administration tasks and the associated costs increase rapidly. To address this, Oracle Enterprise Manager 12c offers business-driven application and systems management from a single pane, across your entire Oracle stack. In this session we'll take a deeper dive into management best practices with Enterprise Manager Cloud Control and how it can be used to simplify and speed up troubleshooting of systems and components that arent performing or behaving as expected. We'll look at how we can find bottlenecks by mimicking end-user behavior and how to drill-down and correlate across the stack if issues occur as well as what preventive and proactive measures we can take to help reduce the time and effort spent fighting fires.

Would you like to obtain greater detail in your planning or forecasting process - e.g., to plan for greater product or customer granularity, more periods, etc.? But you're afraid that your Planning application just won't be able to cope with these requirements? In this session, you will hear how an organization's desire to forecast a large number of detailed items for a long period of time led to some innovative solutions built to enhance their Hyperion Planning application.

Don't know your @ABS from your @Xwrite? This session will clarify the calculation basics starting with the simplest calculation margin, and building on it to really explain what calculations really do. @children, @descendants, limiting syntax, the difference between dense and sparse calculation are all discussed and more. You will come away from this session with a more in-depth understanding on how and why you would want to write calculations certain ways. This session is also great for Planning users to understand their calculations.

This session will be a survey of calculation scripts and a comparison of speed of different form and functions. Should you use @UDA or @MATCH? For custom currency is FIX on @UDA faster than an IF statement with @ISACCTYPE. Should you transfer data with @XWRITE or @XREF?

Join Essbase exports for an open forum on Essbase BSO Optimization.

Are managers and executives at your company asking for Hyperion-based dashboards and reports to be delivered via the web, iPad, or Android devices? If so, then you are not alone! During this session, you will learn how the CXO-Cockpit Reporting Suite helps Hyperion customers like Hanesbrands and Teletech to address and solve that question. Hanesbrands and TeleTech will discuss how they have integrated CXO-Cockpit dashboards and reports with their HFM and Essbase environments in less than two weeks! This session will also include a fifteen-minute live product demonstration. We invite you to join us for this session and to visit our booth at Kscope as well. In the meantime you can also visit our website (www.cxo-cockpit.com) to learn how other Hyperion customers like Apex Tool Group, BIC, ING, Rabobank, AkzoNobel, Kaiser Aluminum, Flint Group, Aleris, PRA, Materion, and many others benefit from CXO-Cockpit. For more information please feel free to contact Mike Williams, RVP for CXO-Cockpit in the USA at mike.williams@cxo-cockpit.com. Presenters: Kyle Tennant, Hanesbrands; Tiffany Briseño, TeleTech; Mike Williams, CXO Cockpit; Wouter Born, CXO Cockpit

One of the most challenging tasks when developing an ADF application is achieving a proper layout. Both stretching components and the ones that don't stretch can make a developer's life into a nightmare. In this session you will learn best practices for creating complex layouts with ADF Faces. You will see how to use the various ADF Layout components and build the layout that you need.

There are many web-based or device-native techniques to create mobile applications. To support multiple devices, such as iPhones, iPads, and Android phones and tablets, an application needs to be developed several times, using multiple tools, languages, and platforms. This dramatically lowers the ROI. Oracle JDeveloper and Oracle Application Development Framework (Oracle ADF) allow you to create one single application, based on HTML5, that runs on multiple mobile device platforms. This session demonstrates how to create a mobile application that can be used 'on the road' to perform relevant tasks, no matter what device is used. You will learn best practices on how to connect with server side datasources and the on device database. Finally you will learn how to integrate with device services such as calendar and camera.

For ages we have known that reinventing the wheel is not a smart thing to do. However, we as software developers tend to do this all the time. In this session you will learn how to avoid this by taking advantage of the reuse capabilities of the ADF Framework. You will see how to create Page Templates and use them throughout your application instead of creating the same complex layout over and over again. Next you will see how to create a reusable skin to use in your applications. Finally you will see how to extend the ADF Component Library with your own reusable declarative components and reuse them throughout your application.

Oracle BI Publisher has the power to amaze users and save time in producing highly formatted and high-volume reporting. So why do many OBIEE implementations neglect to include this important capability? Learn how BI Publisher can play a key role in unlocking the value inside your OBIEE investment. Explore new capabilities such as mobile device publishing, Excel-based templates, and enhanced MS Office integration. Understand what it takes to include BI Publisher in your OBIEE solution.

With each step in the evolution of OBIEE, Oracle has added powerful new data visualization capabilities that turn raw data into insightful information. With that power comes great responsibility. This session will explore the far corners of OBIEE's presentation options and demonstrate best practices for the creation of BI content. Avoid reporting atrocities and examine how the teaching of gurus such as Tufte and Few translate into the OBIEE toolset.

Supporting a deployed application can be quite expensive and disruptive. This presentation will discuss building key types of instrumentation into an application in order to reduce the time and expense involved in remotely debugging issues. Setting module, action, and identifier in your application is only the starting point. The presenter builds context into queries by making judicious use of comments and by encoding a "query type" into the correlation for the driving table of a query, making the AWR and ASH data that much more meaningful. The functionality built into the applications includes: o Analysis of the AWR and ASH data within a user-specified interval, leveraging knowledge of concepts in data model and query generator. o Analysis of customer data for significant skew and variations. o Analysis of customer changes to the out of the box data model. The presentation will cover the basic methodology for building this functionality, as well as their approach for obtaining the information from the customer. (An end user with the appropriate permissions navigates to the tools page in the browser, selects a few options, clicks a button, and downloads a zip file through the browser.)

The presentation will clearly articulate the benefits and project approach for implementing Oracle-Hyperion Data Relationship Management (DRM) within ABC Company as it undertakes a chart of accounts redesign, ERP upgrade & consolidation, and Hyperion applications(s) redesign initiative.

Financial transformation can open the door to unanticipated projects that can multiply complexity fast. Finance Transformation (FT) is difficult and time-consuming work. Many of the challenges and obstacles faced by FT managers can be negotiated much more easily with the right game plan. One of most important aspects is the maintenance and synchronization of master data throughout the enterprise. Oracle's Data Relationship Management (DRM) software can be used to simplify this process with respect to master data, especially in these highly complex financial transformation projects. DRM helps in the following ways: 1. Enables consistent reporting: Reliance on end user applications to digest intermittent system data extracts leads to questions regarding inconsistency from one report to the other. Reliance on reports generated from governed processes using DRM reduces the inconsistencies experienced. 2. Improved risk management: More trustworthy and consistent financial information improves the business's ability to manage enterprise risk. 3. Improved operational efficiency and reduced costs: Replication of data often is linked to replication of activities associated with managing those data sets. DRM helps to reduce the replication/duplication of those activities. 4. Improved decision making: The information consistency provided by DRM across applications reduces data variability, which in turn minimizes the organizational data mistrust and allows for clearer and faster business decisions. 5. Regulatory compliance: Information auditing is simplified with effective information controls such as SOX compliance. 6. Improved business productivity: DRM helps organizations understand how same data objects are represented, manipulated, or exchanged across applications within the enterprise and those objects relate to business process workflows.

This presentation is designed to give both a basic and an in-depth insight into interactive reports. It will highlight the full functionality available while developing an application using interactive reports and demonstrate how interactive reports can be fully utilized by the users of an application to create customized reports and charts. The presentation will demonstrate how the APEX API can be used to create filters dynamically when the page is loaded and how to clear any filters that previously existed. It will show why interactive reports are one of the most powerful features of APEX for developers and users alike.

It is common for a variety of back office applications to be required for a given job role to complete their work within an organization. Within each of these applications there are frequently numerous interface layers that a user must navigate through in order to access key information. For a given role it can make sense to optimize their view into the disparate systems through a single interface, reducing their time, effort, and ultimately cost. Attend this session to learn how the declarative power of ADF and WebCenter Portal can simplify the creation of unified views on top of your enterprise information. The session will deconstruct a live dashboard and show how to consume information from web services, databases, and content repositories, ultimately presenting it to end users leveraging master detail views in a role-based dashboard through WebCenter Portal.

The release of OBIEE 11.1.1.7 provides the ability to develop an Oracle BI repository as a collection of XML documents instead of a single binary RPD file. Included in this functionality is the ability to configure the OBIEE Admin Tool to interact with third-party Source Control Management (SCM) systems as a way of version-controlling the repository development process. This presentation will explore MDS XML functionality in the OBIEE Admin Tool, including how to generate the MDS XML files from an existing RPD file and configure the repository to work with Subversion as a sample SCM system. The session will also explore how this new feature extends the capabilities of multi-user development for Oracle BI repositories, and how it compares to other pre-existing development options.

In OBIEE (Oracle Business Intelligence Enterprise Edition), you can create models against multiple disparate sources that pull metadata and facts from relational databases and multi-dimensional sources. A particularly powerful combination is to use Essbase for pre-consolidated cube data with an Oracle database along side for transactional information. This session will utilize the power of both sources to build on the strengths of each. Join Oracle ACE's, published authors, and presumed experts Stewart Bryson and Edward Roske as they demonstrate the fun of metadata development against a sample Essbase database sourced from an Oracle database. Attendees will leave the session knowing how to model complex Essbase options and integrate those with relational sources like the Oracle database.

In OBIEE (Oracle Business Intelligence Enterprise Edition), you can create models against multiple disparate sources that pull metadata and facts from relational databases and multi-dimensional sources. A particularly powerful combination is to use Essbase for pre-consolidated cube data with an Oracle database along side for transactional information. This session will utilize the power of both sources to build on the strengths of each. Join Oracle ACE's, published authors, and presumed experts Stewart Bryson and Edward Roske as they demonstrate the fun of metadata development against a sample Essbase database sourced from an Oracle database. Attendees will leave the session knowing how to model complex Essbase options and integrate those with relational sources like the Oracle database

Regulatory reporting requirements are more complex than ever, and require submissions in XBRL-formats. Organizations must decide whether to utilize third party publishers to perform this vital task or to bring it in house. Come to this session to learn how The J.M. Smucker Company uses Oracle Disclosure Management to format their external reports, perform XBRL tagging and XBRL instance generation to successfully file their reports with the US SEC. Smucker will share key insights into successfully implementing and using Disclosure Management as well as a the cost/benefit of bringing this critical and required business activity in-house.

APEX Tabular Forms are handy and quite powerful right out of the box, but when your business rules take you outside of the wizards, implementing certain features be scary. Complex validations, row-based validations, cascading lists of values and other-column-dependent data selections can be terrifying. Fear no more -- this session will give you an in-depth APEX 4.1+ tabular form anatomy lesson and walk you through examples of the most common outside-the-wizard tabular form business requirements. You'll leave armed with sufficient knowledge to tackle most tabular form requirements either via APEX features or building your own custom modules with confidence.

Are you considering an implementation of HFM, Planning, Essbase, and DRM? This presentation will cover the successful implementation of the Oracle EPM Suite implemented at McAfee. Hear first-hand from the client, not just the consultants, about what to expect when implementing the Oracle EPM stack in a complex international environment. Data moves smoothly around from SAP to HFM, from HFM to Planning, and from Planning to Essbase. Meanwhile, all of the meta-data for all of the applications regardless of technology is managed in DRM. If you are considering implementing Oracle EPM or you are already in the process, this presentation will be worth your while.

Understanding the areas in Oracle APEX that typically result in security problems is essential to building robust solutions. This talk will take an in-depth look at cross-site scripting, undoubtedly the most prolific problem facing APEX applications today. The session will be demonstrating the security impact of insecure applications as well as required fixes based on real-world examples. The power of Cross-Site scripting attacks are regularly underestimated. This session will demonstrate complex Cross-Site scripting attacks against APEX applications and use API calls and item settings to ensure the data within your APEX applications remains secure.

This is a case study on a growing independent energy company primarily engaged in natural gas exploration, development, and production. This oil and gas company successfully implemented the Hyperion System 11 suite to create a world-class financial systems platform to support the needs of a rapidly growing organization.

One of the biggest investments a company can make is in their decision to implement Oracle Planning as their new budgeting and forecasting system. Every company has similar goals: the project is completed on-time and within budget; all business requirements are satisfied; and the system is flawless and your end users are happy with the rollout of a new system. Join the panel of interRel gurus, including Edward Roske, Tracy McMullen, Glenn Schwartzberg, and Glen Chang, as they share some lessons learned and tips to help you avoid common pitfalls when implementing Oracle Planning.

Gartner research states that organizations that have implemented Performance Management more broadly are nearly four times more likely to be among the most competitive organizations in their industry. Hear from a number of Oracle EPM customers that have each implemented a wide range of applications about what they have done and the successes they have achieved. Hear from our customers -- Ensco, General Dynamics and McAfee.

From entities to tables, see how SQL Developer allows you to get 'the data right,' before you even write a single line of application code. Learn how to build your logical model, forward engineer it to a relational model, split entities to multiple tables, design relationships, enforce business rules, tackle physical storage issues like partitioning, manage domains, and check your models for common design issues - all while versioning and coordinating your work with your fellow developers.

The purpose of this session is to demonstrate best practices of integrating OBIEE 11g reporting with Hyperion EPM products Essbase, Planning, HFM, DRM, and Essbase Studio.

It's time for a better approach to managing Hyperion EPM dimensions and hierarchies. This Hyperion EPM metadata (also known as master data or reference data) symbolizes the points of consolidation for your company's: * Charts of accounts * Organization or cost center structures * Legal entity & ownership hierarchies * Product hierarchies Orchestra Networks' MDM for Oracle Hyperion EPM puts business-user-focused tools in the hands of your finance teams to support: * Out-of- the box data models and adapters for HFM, Planning, and Essbase * Collaboration and workflow for governing change * Hierarchy management including the ability to support multiple hierarchies without maintaining separate copies of your metadata * Support for past, present, and future (draft) versions of your metadata * Full tracking of history * Role-based, fine-grained security * Import/export from/to HFM, Essbase, and Planning Join this presentation for a hands-on demo and review of customer case studies describing why Hyperion EPM users are choosing Orchestra Networks' solution over DRM and other alternatives.

Oracle Application Express (APEX) is a rapid application development framework that efficiently builds web-based applications on top of an Oracle database. The learning curve for Oracle Application Express (APEX) is relatively shallow when compared to other web-based development technologies; however, since the first APEX production release in 2003 (as HTMLDB 1.5) the learning curve has become significantly longer due to the many new features that are now available in the current version, APEX 4.2. This presentation outlines a training plan for adopting APEX. The plan lists the areas where discrete training may be required together with time and cost estimates for both self directed and classroom training. The audience, developers, and managers who are considering APEX or who are new to the technology, can use the training list as a benchmark for evaluating their APEX training needs. Training needs span the gamut from the newbie's need for ground up training to the experienced developer who is in need of a refresher or who needs to fill in some holes in their APEX knowledge. Effective APEX training enables developers and IT shops to take full advantage of the incredible productivity that is inherent in the APEX framework.

Steve Cioffi, Senior EPM Manager at PepsiCo, will lead a panel of Business Analytics experts from Hyperion clients around the world as they discuss best ways to invest in IT and plan for their strategic spending. As you prepare your roadmap for the future of BI and EPM at your company, come participate in this free-wheeling, informative, and dare I say, presidential discussion that just may give you the insight you need to take your company into the 22nd century.

The effective management of master data is a key component to the success of EPM and Analytics projects. Oracle Hyperion DRM provides the data visibility and functionality to manage and broker master data across the organization. Learn how the award-winning General Dynamics BI Collaborative, the General Dynamics BI/EPM Center of Excellence, has leveraged DRM in concert with Oracle E-Business, Oracle BI, and EPM solutions to provide an easy-to-use and effective master data management solution to their customers.

This presentation will demonstrate the practical application of Activity Based Costing and how to leverage HPCM, along with Hyperion Planning, to take the fear out of implementing ABC. From Shared Services to Product/Customer Profitability, this session will discuss how to make it happen with HPCM and the rest of the Hyperion product suite. * Cost Management = Profitability Analytics * Cost Management - Why "managing dollars" isn't good enough * Allocations done wrong * What is a driver-based model? * Managing actionable cost instead of line item cost * Strategic Cost Modeling (ABC) * HPCM & ABC demo.

The most powerful way to alter an execution plan is via hints; but knowing when and how to use hints correctly is somewhat of a dark art. This session explains in detail how Optimizer hints are interpreted, when they should be used, and why they sometimes appear to be ignored. By attending this session you will arm yourself with the knowledge of how to apply the right hints, at the right time.

This session shows the process of analyzing and resolving the most common SQL execution performance problems including, poor cardinality estimations, bind peeking issues, selecting the wrong access method, and more. You will learn how to identify and quickly resolve these issues and develop a toolkit of queries and techniques to determine the root cause of any plan regression.

With each new release the Optimizer evolves as we strive to find the optimal execution plan for every SQL statement. Understanding how the Optimizer operates and what influences its choices helps you provide the necessary information to make that nirvana a reality. This session explains in detail, how the latest version of the Optimizer works and the best ways you can influence its decisions.

Knowing when and how to take advantage of each of Exadata's performance enhancing features can be a daunting task even for the Oracle Optimizer, whose goal has always been to find the optimal execution plan for every SQL statement. This session explains in detail how the Oracle Optimizer costing model has been impacted by the introduction of the performance-enhancing feature of the Exadata platform. It will show through the use of real-world examples what you can do to ensure the Optimizer fully understands the capabilities of the platform it is running on without having to mess with initialization parameters or Optimizer hints.

This session will discuss and demonstrate the value of an analytic platform, such as Oracle Exalytics, as compared to the more static views delivered via reports, dashboards, and spreadsheets. The real value of data modeling lies in the three what's - what happened, what about, and what if. True modeling allows for both a driver basis and flexible query.

Extracting the maximum value from your Planning implementation means going beyond the basics, sometimes way beyond the basics. Whether fully exploiting in-built functionality or going outside the Planning box, this session covers the concepts, tips, and techniques you need to get the most out of your Planning system. This session will cover Planning good practices from a design and technical perspective as well as 100 percent-unsupported-but-totally-cool hacks that make Planning even better. Topics include: focused aggregations, inherited security, METAREAD filters, automated migrations, truly exploiting form validations, Task Lists, and Process Management, and of course how to review an existing Planning application. Does this sound like too much for a single session? It is, but that's okay because you are going to vote on which topics we present on (four out of six). No worries -- the balance will be posted to the web page and we pinky-promise to do webinars on those other subjects. This is a democracy of Planning practitioners and *you* get to decide what tips/hacks/general awesomeness we present at Kscope13.

As Oracle Database 12c is adopted by many organizations there will be struggles to understand the new architecture of pluggable Oracle databases and how this architecture will benefit the organization. Oracle has enhanced Oracle Database 12c to help organizations reduce costs while providing a scalable solution for business needs. In this session, you will learn tips and workarounds with implementing Oracle Database 12c along with how your organization should be thinking about Oracle Database 12c. Takeaways: * Overview of Oracle Database 12c Pluggable Database Features * Overview and tips for upgrading to Oracle Database 12c -- single instance * Tips and workarounds for implementing pluggable database with Oracle Database 12c * Tools used to monitor pluggable databases -- EM Express and OEM 12c

Moving your database into the cloud is a popular option within organizations for development all the way through to hosting production applications. There are several large cloud service providers that offer Database as a Service solutions, Amazon being one of them. This presentation will guide you through setting up an Oracle database on Amazon's Web Service (AWS) Relational Database Service (RDS) platform and setting up web servers to host APEX environments. Other areas to be discussed will be usage for secure development, offline production calculation, other AWS features, and comparisons with other cloud service providers.

With the proliferation of mobile and tablet devices there's a need to build applications that scale gracefully for each device and viewing mode. APEX 4.2 introduced features to support building applications with responsive design. This presentation will be an introduction to responsive design. Items covered include: what responsive design is, how responsive design works, and how APEX 4.2 supports responsive design. This is the 1st talk in a 4 part series on responsive design in APEX.

A typical tech shop is at the mercy of "patch and pray," so to get out of this cycle one needs a development environment to try things out. Using virtualization we have a sandbox to test patches and upgrades for the Oracle Database and Middleware applications. This session will discuss the virtual offerrings from VMware and Oracle VM and how it applies to their production cycle.

For Union Investment the presenter realized a challenging APEX 4.1 project with tough requirements that made it necessary to go way beyond the standard "point & click" approach with which APEX has become famous. This presentation will demonstrate the application and give the audience an overview of some of the key features from a technical perspective.

Nowadays testing is a crucial and integral part of programming software. But how do you apply testing techniques in the complex world of PL/SQL programming? Testing PL/SQL is challenging because the PL/SQL programs are often larger than Java programs and the outcome of tests are dependent on data in the database. This session shows you their test strategy, which starts at the programming stage. Their strategy includes special test procedures for PL/SQL programs, an API for creating sets with test data, and the use of a debugging framework to resolve issues efficiently. In this way they created high-quality software, which can be easily tested and maintained.

With Hyperion 11.1.2.3., Calc Manager is the only option to develop and deploy Business Rules. This is a fantastic opportunity for developers to leverage its latest advancements. This session will examine key features and functionality in Calc Manager and demonstrate how to successfully achieve your goals while improving quality. It will also include best practices, tips, tricks, and techniques that consultants, administrators, and end users can leverage to make completing projects and daily tasks easier.

TBD

TBD

While it is relatively trivial to both convert MapReduce code into pipelined PL/SQL functions and (in 12c) even run Java-based MapReduce code inside the Oracle database, one can often do better by converting MapReduce algorithms into basic SQL statements which leverage the Parallel Query processes. This session will cover the fundamentals of the MapReduce implementation primitives and how they map to straightforward SQL commands. The attendee will benefit by learing how to seamlessly adapt in combined Oracle / Hadoop environments where workload can be moved between Oracle and Hadoop.

Hierarchical queries in Oracle have always been a challenge, even for advanced SQL practitioners, with Oracle-specific SQL language elements which are not part of the SQL standards. Beyond the SQL-92 standard, the ANSI SQL:1999 standard added the definition of a recursive query which has now been adopted by Oracle. This presentation will talk about how to translate common CONNECT BY statements and use the new construct to solve more esoteric problems. The attendee will benefit by using this new standard, portable construct for hierarchical queries in Oracle and other databases.

Many database developers are familiar with the basic SOUNDEX function used to provide basic similarity matching for names. This presentation goes beyond SOUNDEX to examine more advanced approaches for string and name matching, including details about the UTL_MATCH built-in package. The session will also explore implementations of the NYSIIS, MetaPhone, and Caverphone phonetic matching algorithms in SQL and PL/SQL. Finally the session will explore how combinations of these techniques can be used for data cleansing in large-scale environments.

Smartphones and tablets are becoming commonplace and offer endless possibilities for organizations wishing to empower their employees and serve their customers better. Mobile applications, however, do not exist in a vacuum. They always connect to some back-end in one way or another. Experience has shown that an under-performing or poorly designed back-end will make even the best mobile applications useless. This session will show you how to build flexible and SOA-compliant back-ends using Oracle ADF in order to withstand the rigors of the mobile universe. It will also highlight how other Fusion Middleware products, such as Oracle SOA Suite, can provide more robustness and scalability to your back-end.

Your prayers have been answered; after years and years of waiting, you can now build and deploy ADF applications without having to pay one cent to Oracle. This is great news, but now what? The aim of this session is to explain what ADF Essentials is and to give you an overview of the Glassfish application server on which such applications will be deployed.

Introducing new software technologies like ADF in organizations is accompanied by an increased risk during the initial roll-out phases, often because of insufficient skills within the development and operations teams. Training and experienced consulting support is certainly one way to reduce such risk but by avoiding "Big Bang" deployments and allowing an iterative phased approach to introduce new user-interface concepts probably enables the highest changes on project success. The latest versions of Oracle Forms allows integration with ADF technologies and enables, therefore, a phased transition from the old to the new technology. Learn how a Forms application can seamlessly integrate with ADF application based on the common WebLogic platform. The presentation includes a live demo of a customer case study with a highly-flexible calendar ADF application and its interaction with existing Forms Modules.

Installing an Oracle EPM environment is a complicated undertaking. There is not any good information available on how to install Oracle EPM as one would in a real world implementation. A real world implementation involves installing the software in a distributed environment and not just on a single server like the manuals and training classes demonstrate. This session will help participants plan and execute a distributed installation of the latest release of Oracle EPM. It will include a live configuration of a distributed multi-product installation.

TBD

Oracle's User Experience and ADF teams have worked together to produce a set of mobile design patterns that allow the development of intuitive, easy, and productive to use mobile applications. The patterns range from how to design your navigation, to list layout, to editing a business object, to how to invoke actions that yield a simple and apparent way to complete a task. These patterns work well across platforms (e.g. iOS, Android, and BlackBerry) and are supported by ADF. The patterns have been vetted in Oracle's own mobile products (e.g., Sales, Time Entry, Expenses, Field Service), and work across different user roles and product lines. In this session you'll see a practical example of building a mobile application using these scientifically proven UX design patterns to solve a real customer use case: a conference feedback application. Using ADF Mobile one hybrid mobile application will be developed for deployment both as an iOS and Android mobile app. The session will include a discussion on how the design patterns were used in approaching the problem by both the customer and ADF and UX teams and how this same approach is used for Oracle Fusion Applications. It will be jointly presented by Susan Duncan who leads Oracle's Mobile Development Program office and Debra Lilley, Oracle Customer/ACE Director instrumental in the Fusion User Experience Advocates Program: both active in mobile application design and development in their respective roles.

iOS, Android, RIM, native, hybrid, web-based, ADF Mobile, device-native, HTML5, AMX, PhoneGap, Cordova, iTunes, GooglePlay, XCode - if you're looking into mobile application development, this is just some of the vocab you're probably trying to get your head around. The different mobile developer programs can seem daunting and vary in complexity; for instance with iOS you need to understand and consider developer licenses, developer certificates, profiles, device registration, and work within the iOS portal. What about your teams and the mobile paradigm; do you need new skills, processes, and IT procedures and even hardware to be successful in mobile? Are there best practices and design patterns to follow? How and where do you test and distribute your mobile applications? Are you ready for rolling updates of iOS/Android requiring instant fixes to your app? Join this session for a introduction to making the most of mobile. As lead of the Oracle Mobile Development Program office, Susan has first-hand experience in navigating and making sense of the terminology and challenges that face teams stepping into the mobile development world. Benefit from her insights and experience and learn how to quickstart your mobile development. And the good news? It's not as daunting as you think - if you're an Application Development Framework (ADF) or Fusion developer you are already a mobile developer. If not, come and see how you can be!

This session will provide an architectural deep dive and discussion of best practices for deploying Oracle virtual machines on Exalytics.

Attend this session to gain an understanding of how the OBIEE EM management functionality really works and how an understanding of the underlying technology can make your life as an OBIEE administrator easier.

Looking into bringing an Exalytics machine in house? In this presentation, Jonathon Eastman, director of EPM at WellPoint, will guide you through his experiences from the data center to Essbase performance. The session will detail their hands-on experiences with exalytics, their performance benchmarks, and lessons regarding performance tuning. Hear how WellPoint went from top-line AIX servers to blisteringly awesome performance with Exalytics and the steps you should follow to make sure your Exalytics proof of technology goes extremely well.

Have you been told "That can't be done with APEX!", but later find out it is actually pretty easy? Plug-ins have enabled the APEX developer a method to power boost their applications. This presentation will review various plug-ins that have made the developer's life easier. Also discover a few APEX components that you may never have known existed to help with your everyday APEX development efforts.

Does it take days or weeks to get ready for your next planning cycle? Do you have to edit forms, rules, reports, and more just to be able to have the system open for users? Instead of a static design, learn some best practices for the dynamic implementation of Hyperion Planning. Embracing a dynamic methodology makes the administration of your planning cycle painless. By using dynamic techniques, forms and calculations may be maintained quickly and effortlessly. Nightly maintenance and defragmentation of the Essbase databases can be automated. Financial Reports will become virtually maintenance free. Empowering users can be controlled while offering flexibility. While learning best practices this session will include demonstrations of solutions.

In this hands-on session, you will learn how to use Calculation Manager with HFM. You will also learn how to navigate the software and build common HFM rules, including how to use variables, objects, and rulesets. Once built rules will be deployed to HFM and backed up. Lastly, converting from Classic script to Calculation Manager will be covered.

Application Express generates applications built on the PL/SQL language. APEX developers write additional PL/SQL code to handle complex requirements. There is always a tendency when writing code within a UI-driven environment to treat that code rather casually; after all, it is not the main part of the application. That is a big mistake because this custom code must be maintained and enhanced. If you don't write it well, that maintenance becomes a nightmare. Have fun building those cool screens with the APEX point-and-click interface - but realize that you WILL be writing PL/SQL code and you can make a big mess of your beautiful APEX application in no time unless you take care and apply best practices to writing PL/SQL within your application.

Users hate to wait - for anything. For our applications to be successful, they not only must be correct (meet user requirements) and maintainable, they must also execute efficiently enough to avoid user frustration. This session reviews the most important techniques for improving PL/SQL performance, including data caching, FORALL, and BULK COLLECT. After attending this session, you will be able to proactively identify opportunities for applying techniques that will most dramatically (generally, an order or magnitude or more) improve the performance of your PL/SQL code.

Oracle Database 12c offers an array of exciting new features for PL/SQL developers. The function result cache has been enhanced to support functions defined with invoker rights. Use the ACCESSIBLE BY clause to define "whitelists" of the program units that can execute subprograms in a package. Grant roles to PL/SQL program units, rather than to schemas, giving you much greater flexibility over access control. Design a procedure to implicitly return a result set, much like you can do in SQL Server (useful for migration projects). Define a view with BEQUEST CURRENT_USER so that it behaves like an invoker rights unit. Declare and call PL/SQL functions entirely inside the WITH clause a SELECT statement. And more!

Oracle XSQL is a way to get XML into and out of the Oracle RDBMS by just writing SQL or PL/SQL. It is also built into JDeveloper and can be used with ADF applications. This presentation will explain and demonstrate the many ways that XSQL can be used to enhance your web applications.

Learn how developing financial reports with best practice methodologies results in successful implementations and efficient solutions. This session will utilize Oracle/Hyperion Financial Reports to demonstrate time-saving features including Row & Column Templates, Saved Objects, and Rolling Year Reports. Attendees will realize the benefit to using Annotations for commenting on results and related content to provide additional detail. Efficiency accelerators aimed at Reporting Standards and Change Impact will be covered and distributed. Attendees will leave this session with collateral and concepts that can be quickly applied into their environment.

This session will discuss how to load test an APEX application using open source tools.

Oracle TimesTen In-Memory Database for Exalytics drives the server's superior performance. Little attention has been given so far as to how the TimesTen database can be used best. This presentation discusses relevant aspects regarding the application of TimesTen for successful BI implementations on Exalytics. Areas that are covered are: - when to use TimesTen, instead of reading directly from source systems - what to cache in TimesTen and what not to cache - when to compute aggregates in TimesTen, instead of doing it in source systems - assessment of different ETL and interfacing strategies, e.g. cache groups, ODI etc.

Database release 11 added dynamic behavior to parallel execution, allowing the optimizer to decide what DOP a statement shall be executed with, whether to execute it immediately, or to queue it until the required resources become available. Release 12c extends the dynamic parallel execution framework and introduces revolutionary new features to the optimizer. This presentation reviews the 11g parallel execution features, compares static and dynamic parallel execution scenarios, and gives best practices. Integration of dynamic parallel execution with Oracle Resource Manager, improvements of the parallel execution framework in Oracle database release 12c, the new 12c data distribution feature for parallel execution, and the 12c optimizer feature 'adaptive execution plans' are discussed.

Cash flow in HFM should not be difficult. Oracle ACE and HFM expert Peter Fugere will show how to build a better cash flow reporting in HFM, faster and easier.

This session will cover how to use Oracle Data Integrator and Oracle Hyperion Planning metadata repository to build dynamic, flexible, and reliable processes to maintain metadata, load, and extract data from any number of applications with a single generic component.

What is Big Data about? And how does it fit with APEX? In this session, Dimitri will explain the basics of Big Data and how to integrate it with your APEX application.

In this presentation we will only briefly recapture why you want to use Responsive Design and how to do it. Most of our time will be spent on the problem with Responsive Design that continues when used for mobile devices: the browser still to loads all the excess weight that is not required or necessary. So the industry came up with "RESS" or "Responsive Design + Server Side components", which we will take a closer look at in combination with APEX. We will also go deeper in how to detect if the rendering device or browser is able to use certain features and what to do when they are not able to use them. This is the 4th talk in a 4 part series on responsive design in APEX.

With many General Dynamics Business Units engaged in multi-year capital-intensive contracts, General Dynamics sees cash management as a key strategic financial imperative. Yet managing the Cash Forecasting and Reporting process is a daunting task due to the inherent complexities of Cash Planning, including timing, and various contract types. GD Land Systems successfully leveraged Oracle | Hyperion Planning to improve and ultimately fully control this process. This presentation will focus on how the Cash Forecasting and Reporting process can be managed differently, to provide organizations with immediate access to critical data, and provide full control and desired transparency. Specifically, the presentation will: - Outline the challenges faced by A&D organizations in managing cash - Provide a proven methodology to address these cash management challenges - Showcase how General Dynamics Land Systems achieved a standardized and efficient cash management solution that provides the ability to forecast, model, and integrate cash planning into their financial plan

Maintaining Hyperion Planning environments can be so time-consuming that there is little time for development. We are constantly being asked to do more with less. Understanding some of the utilities and options to automate redundant operations can significantly improve your ability to react to change. It allows more time for new development, eliminates human error, and increases productivity and system stability. Find out what options are available, how to use them, and see real world examples you can take home.

We're all into building modular reusable code, but like many situations, often accomplishing the mission brings up other issues. How can application code be "registered" within the database so that commonly-used PL/SQL code and SQL statements can be differentiated by how they're used within different program modules? The built-in packages DBMS_APPLICATION_INFO, DBMS_DEBUG, and DBMS_SESSION have several ways to make applications easier to debug, tune, improve, understand, track, and administer. With advantages like that, what's not to love? This presentation will provide SQL and PL/SQL code examples and templates as a reference point for use back at work.

Dimensional data models (a.k.a. star schemas) are a crucial component of the presentation layer of data warehouses and data marts, because that is the format in which business intelligence analysts expect to find their data. Yet, so many decision-support environments based on Oracle attempt to live with star schemas without using star transformations. The reasons vary from lack of understanding to practical impediments related to ETL processing. This presentation will explain the justification for the star transformation mechanism, including comparisons to other execution plans, how to implement, how to optimize, and how to troubleshoot.

Most people think data modeling booooorrring, right? While data architects the world over all agree that data modeling is a critical success factor to any well-engineered database or data warehouse, many struggle with how to get their organizations to support their efforts. What if you could make data modeling sessions more engaging for the business folks? The end result would be better data models. Using some common games and concepts, this session will show you how to make data modeling fun. This will be a very interactive session complete with audience participation and maybe some prizes!

This session will interview the users, design a reporting model, and follow up with mounds of ETL development, keeping the user community in the dark during that development. Familiar? This presentation will demonstrate an alternative approach using the Data Vault Data Modeling technique to build a "Foundation" layer in our data warehouse with an Agile methodology. Using the Business Model and Mapping (BMM) functionality of OBIEE, we can virtualize a dimensional model using the Data Vault Foundation layer to decrease the time it takes to get BI content in front of users. Attendees will see a sample Data Vault model designed iteratively and deployed to the semantic model of OBIEE.

Oracle SQL Developer Data Modeler (SDDM) has been around for a few years now and is up to version 3.x. It really is an industrial-strength data modeling tool that can be used for any data modeling task you need to tackle. Over the years, the presenter has found quite a few features and utilities in the tool that he relies on to make him more efficient (and agile) in developing his models. This presentation will demonstrate at least ten of these features, tips, and tricks for you. He will walk through things like installing the reporting repository, building a custom report on the repository using Oracle SQL Developer, modifying the delivered reporting templates, how (and when) to use the abbreviations utility, how to create and apply object naming templates, how to use a table template and transformation script to add audit columns to every table, how to add custom design rules for model quality checks (heck how to use the built-in quality checks), and several other cool things you might not know are there. Since there will likely be patches and new releases before the conference, there is a good chance there will be some new things for the presenter to show you as well. This might be a bit of a whirlwind demo, so get SDDM installed on your device and bring it to the session so you can follow along.

The Oracle Database Cloud went live in 2012. This session will give an overview of the progress of the Database Cloud, including discussions on initial rollout, subsequent enhancements, customer adoption and best practices for working with your own Database Cloud Service. In addition, the session will discuss some general direction for the Database Cloud, as well as act as a forum for your ideas for this Cloud platform

This hands-on lab will teach the new Oracle APEX Listener and Oracle Apex 4.2 RESTful services. REST can be accessed from any client, any language making database applications more accessible than ever. The new RESTful services make this easier than ever compared to many other options. Labs Include: * Learn how to write REST services with the Apex Listener

As a molecular biologist, bioinformatician, Oracle DBA, and APEX advocate, the presenter will demonstrate how using APEX functionality within the Oracle database can be used in individualized and high-throughput personalized medicine.

Superior Energy Services, a $4.6B firm, serves the drilling, completion, and production-related needs of oil and gas companies worldwide through a diversified portfolio of specialized oilfield services and equipment. This presentation will focus on a case study, the objective of which was to provide easier access and a unified view of G/L financial data supporting the divisions' operational reporting and corporate accounting close process. In this presentation you will learn how insights can be gained by improving enterprise performance reporting, utilizing Essbase, HFM, and OBIEE.

Database virtualization allows the same datafiles to be shared by multiple copies of a source database allowing almost instantaneous creation of new copies of databases with almost no disk footprint. Along with storage inefficiency, database virtualization allows agile management of database copies. Virtual databases can be created, refreshed, rolled back, and deleted in seconds. Virtual databases can be provisioned from any second within the source databases retention window which is typically several weeks. Every developer can have their own full copy of production databases; production databases can have fifty days of backup live online in the space of one backup. Backups can be brought online in seconds, data reviewed or extracted, and the copy removed in seconds. QA teams can go from one test environment to multiple full copies of production database allowing running QA tests in parallel.

In this hands-on lab, participants will be introduced to the OBIEE 11g interface and learn how to create, view, and modify basic analyses. Delegates will learn how to filter their results and how to add custom views such as charts and pivot tables to their report layout. Participants will build an interactive dashboard with prompts to filter dashboard data in this session. Attendees will also discover how to work with hierarchical columns, a new feature in 11g. No prior knowledge of OBIEE is required.

This hands-on session is intended for delegates with some prior knowledge of OBIEE. Participants will discover how to work with the Map Viewer feature of 11g and learn advanced filtering and prompting techniques, including filters based on a previous analysis, prompt defaults and constraints, different types of user input and slider prompts. New query features available in OBIEE 11g will be covered, such as selection steps and custom groups. We will also learn how to create an analysis from multiple subject areas and how to combine analyses using set operations.

AllScripts needed a more efficient and centralized way to monitor and complete their monthly account reconciliations. Come hear how they were on the cutting edge as an early adopter of ARM (Oracle EPM Account Reconciliation Manager) and the second company to go live with an account reconciliation solution that achieved the following benefits: - Enabled over fifty users around the world to use a common format and process for submitting and tracking account reconciliations, allowing them to eliminate hundreds of spreadsheets and countless wasted hours - Allowed for multiple account review levels based on thresholds - Auto reconciling for accounts with no activity - Used ERPi to source data directly and automatically from both Oracle EBS as well as other GL systems - Allowed for daily email alerts indicating overdue account reconciliations or changes to ones previously completed - Provided instant status so all users know exactly where each account reconciliation is at in the process

Have you ever needed to write a complex Essbase member formula in an ASO cube? Have you struggled with getting the MDX right for the formula to work? This session will go over the types of MDX formulas available, some of the more commonly used MDX formulas, and discuss when each one should or could be used. A framework will be provided on how to methodically approach building an MDX member formula to ensure you get accurate results and allow you to build a super complex (and hopefully efficient) member formula to be used in your ASO database.

Change is a good thing. But what happens when business requirements change and the cube no longer fills the necessary requirements?Sometimes the change is as simple as a few outline updates. Sometimes, it is back to the drawing board and you are redesigning your existing cube. This session outlines what one company did to drastically redesign a cube to meet changing needs, while still maintaining and updating the existing history. See a way to harness the power of Essbase in your validation process of millions of updated rows of data. Find out how you too can take on a major rebuild to realize synergies within the business and add additional value to your business owners.

For organizations wanting to support ALL reporting needs directly within OBIEE, financial reporting can be very difficult (or nearly impossible) depending on your financial report layouts and/or specifications' complexity. If you don't have Oracle Hyperion tools such as Hyperion Financial Reporting (HFR) or Essbase that comes included in Oracle Business Intelligence Foundation Suite (OBIFS), then you need a different approach to generating financial reports in Oracle BI. Leveraging OBIEE for the data set generation and BI Publisher for layout creation, you can (at least a little more easily) create these types of reports and keep everything within the OBIEE consolidated infrastructure.

Learn how to build a native looking web application for mobile devices, from start to finish!

Learn how to use automated front-end/user interface testing in an APEX environment, making your project (even) more professional with a reliable outcome.

Oracle Data Integrator (ODI) is a powerful data integration suite which allows you to build integration processes with enormous productivity gains over conventional tools of the same breed. In this session you will gain insights in how ODI works and what you should consider to build master-class integrations. Learn about tricks and tips on architecture, Knowledge Module optimization, migration, flexible load processes, and many other areas that your organization should be aware of when working with ODI.

Are you wondering if you could manage your (financial) data more efficiently? Often, the answer is yes. In this session you will see how other organizations found unusual ways to improve their financial processes. Looking at the bigger picture often allows discovery of new solutions to either automate more effectively, increase transparency, or improve your ability to adapt to change faster. Join this session to learn about unconventional ways to use Hyperion products and OBIEE.

Oracle ACE Director Eric Helmer dissects the last major releases of the Oracle EPM Suite from an IT perspective giving you all the information you need to know when choosing the best version from you. He also covers the newest IT techniques and trends for EPM systems including world class strategies on optimizing availability and performance while keeping it simple and easy to maintain. Included are discussions around virtualization, cloud, Exalytics, disaster recovery, and data center failover.

Block storage cubes are great for calculations; aggregate storage cubes roll up large dimensions in a heartbeat. Use BSO cubes for input and calculation and see the rolled up results in the BSO cube in real time. This session will present design considerations for pairing BSO with ASO to get the best of both worlds.

St. Jude Medical forecasts in a large Planning application. The cubes have NO upper level blocks. Over 2500 form saves a day, the app delivers rolled up data right away. How? Data makes a "round trip" to a twin ASO cube and back. Depreciation, payroll, and FX translation calcs happen in the Planning BSO cubes; dimensions roll up in the ASO cube. This presentation will cover the design -- CDFs, high performance push process, ASO optimization, and transparent partition considerations. Production results, monitoring tools, performance stats, and end-user feedback will also be covered.

Oracle offers two different tools that operate as a single point of maintenance for metadata: Enterprise Performance Management Architect (EPMA) and Data Relationship Management (DRM). The EPMA does light duty and DRM handles more complex metadata management needs. Sometimes the tools work best on their own, and other times they are complementary. Using real world examples, this session will review the best tool to use for managing your metadata---EPMA or DRM---and when it is best to use them both together. It will compare and contrast feature sets, automation possibilities and scalability, examine gotchas, alternatives, and workarounds, and offer tips and tricks for how to get the most out of either tool.

MDX may seem like a foreign language, but Essbase and Smart View enthusiasts are just steps away from the path to becoming MDX experts. The central message of this presentation is that one can effectively write MDX and increase productivity with a very small inventory of keywords and patterns. These can be learned quickly, especially if one is not distracted by things that are irrelevant to the task at hand. This presentation organizes the content into layers, first building a foundation and then becoming increasingly sophisticated. Build your MDX vocabulary from the ground up by following an easy to navigate path to MDX mastery.

In this session, learn how Carrizo Oil and Gas reviewed their unique financial and reporting needs and selected Oracle's Hyperion Financial Management to perform their financial close and external reporting process and leveraged Oracle's Hyperion Essbase to perform their detailed operating and management reporting. See how the Essbase solution addressed their needs of reporting their lease operating statements for gross and net dollar amounts and reporting based on general ledger and production dates.

Does it take seconds too long to load some of your pages and you cannot figure out why? Is speed important and do your users demand a fast, responsive application? This session will explain how you can track and collect crucial information about the performance of your ADF application in a production environment. The session will demonstrate how to diagnose, report, and solve performance-killers, inefficiencies, and violations of ADF's best practices and how to derive quick-wins, statistics, and trends. Based on previous experience the load time of (slow) pages can be made seconds faster (depending on their construction), and you will be in full control of your ADF application.

Learn how to develop iOS and Android applications with Oracle ADF Mobile. No prior ADF experience required. Learn how Oracle ADF Mobile simplifies cross device mobile development with declarative development approach. See how to present data and interact with device features such as camera and SMS in this hands-on lab.

Mobile development poses challenges for application developers because the space continues to evolve quickly and each platform has its own set of tools and frameworks. This session discusses how Oracle Application Development Framework (ADF) Mobile and JDeveloper enable development in a consistent declarative manner. A hybrid, on-device application can be developed once and packaged for both iOS and Android deployment. This session will walk through the ADF Mobile feature set, including Android support, and will also talk about real-world use cases. The session will include demonstrations of both the ADF Mobile design time in JDeveloper as well as applications built with ADF Mobile running on iOS and Android.

You already know Oracle ADF Mobile can build powerful and compelling mobile apps across multiple mobile platforms. But what if you need to instantly push notifications to mobile users? Or if you need to integrate different contents such as your own HTML pages into an ADF Mobile application? One of the most powerful feature of ADF Mobile is its ability to support advanced application functionality. In this session we'll go beyond the basics and discuss such topic as: * Seamlessly integrate device native push notification capabilities into an ADF Mobile application. * Display file content or integrate local or server-generated HTML content. * An early look at how to extending device integration with PhoneGap/Cordova plug-ins, and a few other features planned for the next version of ADF Mobile.

A lift and shift of an Oracle database to Exadata can provide extreme performance for all types of queries, however, with some amount of re-engineering work like adjusting the data model, tuning SQL queries, and using some of the database features can further elevate the game for Engineered Systems customers. This presentation focuses on maximizing the use of the Oracle Parallel Execution capabilities to get game-changing performance for analytics and data warehousing type of queries. The presentation will provide several best practices to leverage Oracle Parallel Execution features available with Oracle 11g Release 2 like Automatic Parallelism, Parallel Statement Queuing.

The company needed an inexpensive Essbase reporting solution. The presenter investigated the Report Writer included with the Essbase license. Combining Report Scripts, MAXL, MDX, DOS, and VB, the solution produces 3,500+ unique, fully-formatted reports (1 to 400+ pages) in less than one hour.

Hyperion Planning Process Management (newly renamed Approvals for 11.1.2.1) has been significantly enhanced for 11.1.2 and subsequent releases. This often under-utilized functionality of Hyperion Planning includes new features such as the ability to manage and customize planning units at a much greater degree of detail than previously possible, as well as integrate new web form validation rules into your approvals process. Attendees will learn how to use the new functionality as well as enhanced design considerations. The presentation will cover the following topics: * Promoting planning units based on entity and secondary dimensions * Difference between bottom-up budgeting, distributed budgeting, and free-form budgeting templates * Managing planning unit status * Using Out Of Office wizard to set delegate, promote, and reject actions * Use validation rules to dynamically assign owners and reviewers

Hyperion Planning now includes the capability to directly map dimensions between source Planning applications and target reporting applications. This relatively new functionality allows Planning applications the flexibility to link data to multiple reporting applications, as well as the ability to map Smart Lists from Planning to a target reporting application. The audience will learn when Aggregate Storage Option is best used as well as advantages of this under-utilized functionality.

This session will give an introduction to using the new Essbase Web Services feature that has recently been added to the Essbase stack. Attendees will be given an overview of functionality available and practical methods of using the available technology effectively. This presentation will be geared towards users that are familiar with basic programming concepts.

Have you been hearing all this talk about Oracle Hyperion? Are you wondering what exactly an Essbase is? This is the session for those who are looking for an introduction into Business Intelligence and Enterprise Performance Management. We'll start with the core business problems that are addressed with these products. The session will then include an overview of all the products that cover the Oracle Hyperion Suite and what each is best used for. We'll finish this session covering a variety of reporting options including OBIEE.

This presentation will address how to automate the entries required for partially owned entities using HFM. Partially owned entities including functionalities around discontinued operations, non-controlling interest entities, and equity pickup will be discussed.

Oracle Forms is a strong product with years of future. But, Oracle Fusion Applications use JDeveloper and Oracle Application Development Framework (ADF). JDeveloper has become a robust development tool for Java, and ADF has become a useful Forms-like application development tool. This session illustrates how Oracle Forms Developers can use JDeveloper and ADF to create Java-based web applications.

Oracle's Application Development Framework (ADF) is an excellent tool for creating robust applications. Part of ADF's strength is the built-in Model-View-Controller (MVC) design inherited from Java Server Faces (JSF). Using a series of XML files (of course) the flow of ADF Faces applications can be managed by the controller properly. The Task Flow process seems a little unwieldy to experienced UI developers, but the advantages of "not breaking" the Controller are worth it. In this session you will see how ADF's Task Flow may be used to quickly and easily manage the flow of an application.

Oracle EPM requires a knowledgeable team to provide production support due to its criticality as a service. Typically skill levels vary in the team as resources are pulled from other areas or are required to support multiple services. Consequently, the need for infrastructure training is a recurring theme in an organization. This presentation covers how to explain Hyperion and its architecture in a way to fully engage new support staff. It includes getting started with EPM modules, logs, and troubleshooting.

New features of the Oracle database geared to developers will be discussed and demonstrated. Attendees will be introduced to the new and improved features of Oracle that directly impact application development. Oracle Database 12c is not in production at the time of this abstract's submission. If Oracle 12c has not become generally available by the start of the conference, this session will discuss Oracle 11c features exclusively.

If you've been an Essbase/Hyperion, Applications, or BI user you may wonder what all the "hubbub" on the other side of Kscope is all about. Or maybe you're curious -- "I know there's a database under the covers and lots of developers; what do they do?" If you want to know about the underpinnings of your favorite Oracle software, this session is for you. We'll talk about how it all fits together: database, SQL, PL/SQL, ADF, Forms, APEX, and more (without too many boring details)! Attending this session will improve your understanding of and ability to communicate with the "bit-twiddlers" in your organization.

This presentation explains and shows what kinds of development methods you will use when working with Application Development Framework (ADF) in JDeveloper. It provides guidelines for how much you need to know about the various languages used and the core ADF technologies: ADF Business Components, ADF Faces, and JavaServer Faces. It also describes and shows the files you will use to build an application and to test the application. In addition, the presentation offers advice on how to learn what you need to know before starting Java web development in JDeveloper.

This presentation addresses how you can implement a layout design using Application Development Framework Faces Rich Client (ADF Faces RC) components. It explains the different categories of ADF Faces layout components and their properties that allow the developer to work declaratively. The presentation also discusses the embedded support for visual editing, including some little known features like the Design This Container. It also explains and demonstrates container component techniques such as modifying the standard tab order. The session ends with some advice about how to approach creation of a specific layout including using resources such as cheat sheets, component guides, and component documentation.

Designing user access to specific parts of your application is important for all types of applications, but security plays an even larger role in web applications that are usually open to access from a wider user base. Oracle WebLogic Server, a Java EE runtime container, provides Oracle Platform Security Services, which enables developers to use standard Java security libraries to implement access control in their applications. This session explains application security concerns and techniques and discusses and demonstrates how to set up ADF Security for ADF web applications. It also discusses how to store test user credentials, tap into existing Lightweight Directory Access Protocol (LDAP) providers, and declare access for resources such as pages, task flows, and business components. It also describes how to set up declarative properties to hide or disable items based for specific user roles.

Oracle is now in charge of the Java language and has implemented many database and development features based on the Java. So you may now be more interested in learning more about Java. If you are familiar with PL/SQL, your first view of Java may be a bit discouraging because its object-oriented core makes it look very different. Also, you may be wondering about where Java fits in the industry and how much Java you really need to know to create web applications. This presentation explains to PL/SQL developers who have had little or no exposure to Java, the basic concepts of and terms used in Java. The presentation provides an overview of the language and reviews the concepts of object orientation upon which Java is based. It also discusses the fundamental Java code structures -- classes and methods -- as well as control statements; exception handling; datatypes; and variables. Finally, it describes how Java is used in modern web applications.

In this session, find out about the latest enhancements and new features that have been added to Oracle Hyperion Financial Close Suite over the past twelve months, plus get an inside look at the future product direction.

The Tax Provision is a key requirement in your Financial Close. But, many companies continue to use spreadsheets, or stand-alone software, to address their Tax Provisioning requirements. This results in inefficiency, redundant processes, and stale data. In fact, the lack of integration between accounting and tax is a frequent contributor to internal control weaknesses as cited by auditors. At this session, Oracle product experts will introduce a new Hyperion product - purpose-built to deliver a world-class tax provision process that leverages your investment in Hyperion Financial Management (HFM) and the whole Financial Close suite.

This session will uncover how to get the most out of your Planning implementation by discussing functionality, optimization, and other features that were used in the Hyperion Planning implementation at Chesapeake Energy. The session will talk about tips for your Planning implementation, including application design, data loads, web form design, use of Business Rules, Financial Reporting design, smart lists, and more. This presentation will provide information to help you take your current use of Planning to the next level.

Do your users keep bringing new gadgets to work? Not just the latest tablets and smartphones, but wearable smart devices, and even cyborg-like glasses? Your users are no longer tied to their PCs, and neither are enterprise applications. See how Oracle's Applications User Experience team is bringing Fusion Applications data to new devices and platforms. Find out what technology trends we are paying attention to, and what our own applications developers are exploring for the future.

This session will look at various database features in the latest generation of database technology every developer needs to be aware of - and how to implement your application with security in mind.

The session will be taking a look at the latest generation of database technology and zeroing in on twelve high-impact capabilities, looking at what they are and why they are relevant.

A detailed introduction to Essbase partitioning of BSO cubes with step-by-step instructions of partition creation and actual examples. Advanced mapping techniques illustrating how to partition cubes with different dimensionality will also be introduced. This session is geared towards both the beginner and intermediate Essbase administrator.

An EPM system has three main parts: calculations, metadata, and of course, data. You code the logic, design the dimensions, and scope the data. You translate business rules and definitions into logic -- how do you actually source the needed data and metadata? If your answer is, "Ask IT for it," then you have entrusted your system's success to a possibly uncaring and certainly extremely busy set of strangers. And where will IT source your information? From the same relational data sources, you too can query with just a little SQL knowledge. This session shows techniques, tips, and good practices for common SQL tasks in EPM application creation, maintenance, and reporting.

Many of us still live much of our Essbase professional life in the BSO world. Blame inertia, Planning, or fear, but regardless of cause, ASO is still terra incognita. What's it like on the other side? How do we understand what's there? This session will include a step-by-step conversion of that deceptively easy and definitely familiar sample. Basic BSO stalwart to Essbase will act as a mechanism to illustrate and explain ASO good practices. The final converted database will calculate the same values, but in a very different way.

This session will build from a brief DRM introduction into a discussion around the benefits to DRM and how it unlocks value for organizations who use it correctly. Answer questions such as: Where does DRM fit in our company? What is the true value of DRM? Is DRM an administrative tool? How hard is DRM to implement?

Windstream Corporation utilizes Essbase and Essbase Analytic Link to unlock analytic value from their HFM application. This presenation will detail how Windstream implemented Essbase and Essbase Analytic Link with drill through to transactional detail via FDM. See the architecture, the data flows, and how this environment was built, and hear the lessons learned about Essbase Analytic Link.

Stanford University creates thousands of accounts annually to effectively manage financials for schools and departments, research grants, capital projects, and major gifts. Request for these accounts were initiated on paper forms by distributed financial staff and approvers and manually entered by centralized financial departments into Oracle Financials. In 2012, a custom Application Express application was built and integrated with Oracle Financials to automate this complex and data- intensive manual process. This session, presented by the project manager and development manager, will cover the project perspective, application architecture & design, development challenges, and project benefits.

APEX 4.2 introduced declarative "grid-layout" functionality to simplify responsive web design - an approach which dynamically scales and adjusts page layouts to suit the browsing device. So how do you integrate a popular responsive design framework like Twitter Bootstrap into APEX 4.2? What are the issues? How well does it work? This presentation discusses responsive design, the integration process, and design considerations to help build an application that dynamically adjusts screen layout to work on desktops, tablets and smart-phones. This is the 3rd talk in a 4 part series on responsive design in APEX.

This presentation will show you how powerful UDAs, substitution variables, and attribute dimensions can be in the Essbase world. UDAs can be used to customize security, calc scripts, export scripts, and much more. Explore the differences between attribute dimensions and UDAs and when you may want to use one vs. the other. Examine multiple uses for substitution variables and see how combining these techniques can empower you to create parametrized scripting and simplify your maintenance.

This session will explore the features and functionality released in Exalytics. Additionally it will describe some of the features we are currently working to develop for future iterations of the solution. There will be a definitive slant towards Essbase functionality throughout the session.

With the release of 11.1.2.3 of the EPM suite and the Exalytics engineered system launch several configuration settings and other commands were introduced. This session intends to describe them and their application in order to achieve optimal performance.

Oracle's User Experience and ADF teams have worked together to produce a set of mobile design patterns that allow the development of intuitive, easy, and productive to use mobile applications. The patterns range from how to design your navigation, to list layout, to editing a business object, to how to invoke actions that yield a simple and apparent way to complete a task. These patterns work well across platforms (e.g. iOS, Android, and BlackBerry) and are supported by ADF. The patterns have been vetted in Oracle's own mobile products (e.g., Sales, Time Entry, Expenses, Field Service), and work across different user roles and product lines. In this session you'll see a practical example of building a mobile application using these scientifically proven UX design patterns to solve a specific use case: an HR application. Using ADF Mobile one hybrid mobile application will be developed for deployment both as an iOS and Android mobile app. The session will include a discussion on how the design patterns were used in approaching the problem by both the customer and ADF and UX teams and how this same approach is used for Oracle Fusion Applications. It will be jointly presented by Susan Duncan who leads Oracle's Mobile Development Program office and Debra Lilley, Oracle Customer/ACE Director instrumental in the Fusion User Experience Advocates Program: both active in mobile application design and development in their respective roles.

Oracle Fusion Applications are here today providing the next generation of applications. They are about having everything the user needs in one place, and that includes information. Fusion Applications is a window on Oracle's Fusion Middleware stack and a very big part of that is BI/EPM and analytics. This presentation will include a small demo of how Fusion looks and is designed to give you an appreciation of how BI/EPM is embedded in Fusion. For anyone thinking of Fusion in the future it will underline that your B/EPMI investment today is an investment in that future and protected.

For years we have been locking down the software to protect information. This presentation puts the focus where it belongs: identifying, protecting, and selecting the correct tools to protect your data.

Allocations are often an integral part of any consolidation and reporting process. Companies may need to allocate corporate expenses across subsidiaries, projects, or products. Hyperion Financial Management has the flexibility to accommodate all such allocations but we must ensure that these allocations are setup properly within the application so that we always produce accurate allocation results in the shortest amount of time necessary. This presentation will cover the different types of allocations that are often required and the best approach in handling each type within HFM. The session will introduce the Sub Allocate routine which is vital in producing correct allocation results between entities. The session will discuss the differences between when Sub Calculate should be used for allocations and when Sub Allocate should be used. The session will discuss the advantages and disadvantages of each and walk through an example of the end-user experience in updating and processing their allocations with HFM.

You've been working extremely hard on this kick-a** application. It's rich in features and allows the end-user to do everything they would ever need to do. You've business-analyzed every angle and left no stones unturned. It's now time to present it to the users and/or clients. Outcome: They're still not wowed?! More often than not, us techies are so bogged down with getting the features, functionalities, and corner cases covered that we neglect the ever so critical "First Impression"! In this talk, business executive and veteran UX designer, Cameron Mahbubian, will talk about how to boost your application's UX and give it the sleekness that WILL wow your audience on your next presentation.

Explore the wealth of custom graphing options available with three free/open source JavaScript libraries that can be integrated into Application Express and other web frameworks. The demo will include using APEX and D3.js to create two useful types of graphs that cannot be created with basic APEX graphing library: a connected node graph and an animated line graph that is dynamically updated with data from an Oracle DB in real time.

Get a sixty-minute cram session on using Calculation Manager with Essbase ASO. This session will navigate you through the key features within the Calculation Manager, specifically for Essbase ASO. The session will then guide you through the steps of creating calculation rules for ASO using the graphical interface and allocation and custom calculation components. Finally, the session will offer best practices and "insider" tips to shorten your learning curve and get you off to a turbo fast start!

Oracle Project Financial Planning is the newest packaged application to be rolled out with the Oracle Hyperion Enterprise Planning Suite (v.11.1.2.3). This pre-built solution ties project financial planning to corporate financial planning activities within a single application, as well as, supports financial planning throughout the complete project management lifecycle. Want to find out more?...a LOT MORE? This presentation will dive deep into the new Oracle Project Financial Planning solution. The following will be covered: 1) Highlights of key out-of-the-box features, functionality, and analytical tools 2) Integration with the Workforce and Capex Planning Modules, ERP, and Project Management systems 3) Implementation considerations for a successful deployment 4) Minimizing customizations...Are your company's business needs the right fit for the packaged solution? Maximize your success for integrating Oracle Project Financial Planning into your Enterprise Planning tool set.

What data is important to analyze in order to sign off on consolidated financial data or for accurately creating forecasts and budgets? How do users efficiently identify the key drivers and model possible financial outcomes based on uncertainty? This session will highlight the synergies between Enterprise Performance Management and Business Intelligence, and will showcase how the two together allows customers to propel their performance.

A complete case study of how a development team made the jump into Agile development. Learn from their experience including all about the hidden costs that weren't considered at the start.

Do you version control your database development? Do you use the file-based solution to work with the Database? This session will cover the benefits of implementing best practices that include working with Oracle SQL Developer and Version Control without using scripts. Learn how to generate the deploy scripts easily based on schema comparison, labels, and working by tasks.

Essbase Analytics Links (EAL) provides a great mechanism for extracting data from Hyperion Financial Management (HFM) into Essbase. In addition, it now has the ability to extract data directly to a relational database. This session will explore real world uses of the three extract methods using EAL. Whether you simply need to replicate HFM exactly in Essbase or have a more complex need like blending HFM and Hyperion Planning data together in one Essbase model, this session will cover it. Live demonstrations of all that EAL has to offer will be provided including some undocumented ways of automating processes.

Are you still using Essbase to do Planning? Allow me to introduce you to Hyperion Planning. For most Essbase developers, making that initial leap into Hyperion Planning is a bit scary. This presentation will walk users through the key steps to building a Hyperion Planning application. If you already know Essbase, you've already mastered the hardest part. From building the initial Planning model to producing web forms for the end-users, this presentation will provide a step-by-step guide to your first Planning application along with a live demo. You will come as an Essbase developer, but you will leave as a Planning developer.

OBIEE, OBIA, FR, Essbase, Smart View -- which tool should I use? Oracle provides a plethora of tools but which one is right for you? Flexera asked this same question. The session will review each Oracle reporting solution, list the tools' strengths and weaknesses, and provide use cases for reporting and analysis. Join this informative session which will share Flexera's decision-making process and the key factors to get to the right solution for you. You might be surprised to find the answer isn't just one tool.

Identity Management can be a complex business even in the simplest cases. When business rules get complicated though, things can get unwieldy quite quickly. This session shows how APEX was a great fit to manage a more complex scenario managing thousands of student accounts migrating to Google Mail while using LDAP for authentication. Now university administrators can manage all the user accounts, students can self-service them seamlessly from within APEX applications. Hear some of the hurdles overcome and lessons learned during this large implementation, and in cases such as Google Calendar, hear the directions in which this APEX-based identity management solution is heading.

A comprehensive review of Oracle Business Intelligence Enterprise Edition (OBIEE) and Oracle Hyperion Essbase integration and configuration.

Dynamic Actions in Oracle Application Express are a declarative interface to the JavaScript programming language available in web browsers. With Dynamic Actions it's really easy to do tasks that are very complex with native JavaScript, such as modal dialogs and Ajax... Well, it's easy once one learns how the Dynamic Action framework works. Although the learning curve for Dynamic Actions is much smaller than learning JavaScript, there is still a learning curve. This hands-on mini-class is designed to give students a jump start when beginning with the Dynamic Action framework. Students will start with the very basics and quickly move on to solving more complex tasks based on real business requirements. Along the way, related concepts such as selectors and event propagation will be explained to provide students with a background for the features within the framework.

Dynamic Actions in Oracle Application Express are a declarative interface to the JavaScript programming language available in web browsers. With Dynamic Actions it's really easy to do tasks that are very complex with native JavaScript, such as modal dialogs and Ajax... Well, it's easy once one learns how the Dynamic Action framework works. Although the learning curve for Dynamic Actions is much smaller than learning JavaScript, there is still a learning curve. This hands-on mini-class is designed to give students a jump start when beginning with the Dynamic Action framework. Students will start with the very basics and quickly move on to solving more complex tasks based on real business requirements. Along the way, related concepts such as selectors and event propagation will be explained to provide students with a background for the features within the framework.

Dynamic Actions in Oracle Application Express are a declarative interface to the JavaScript programming language available in web browsers. With Dynamic Actions it's really easy to do tasks that are very complex with native JavaScript, such as modal dialogs and Ajax... Well, it's easy once one learns how the Dynamic Action framework works. Although the learning curve for Dynamic Actions is much smaller than learning JavaScript, there is still a learning curve. This hands-on mini-class is designed to give students a jump start when beginning with the Dynamic Action framework. Students will start with the very basics and quickly move on to solving more complex tasks based on real business requirements. Along the way, related concepts such as selectors and event propagation will be explained to provide students with a background for the features within the framework.

Action framework is more than a rehashed version of guided navigation. It provides a mechanism to drive actionable intelligence outside the realm of your data warehouse environment. This session will explain its features, identify the tools you'll need, and demonstrate practical, real-life applications of the technology to enable the seamless integration of external data in your analytic reports.

Over the last several releases of OBIEE, Oracle has invested quite a bit of time in adding enhancements to the presentation services for end users. However, many companies are not aware these features exist nor understand how best to use them. This session will provide some tips and techniques for using a variety of new front-end features in OBIEE 11g.

This session will highlight new features available in Planning 11.1.2 including a number of enhancements like approvals, full Smart View functionality, adhoc analysis over the web in a data form, built-in data syncing to an ASO database, and Public Sector Planning. 11.1.2.3 goes even farther by introducing a new module to do project planning, integrating Crystal Ball for predictive planning, and impressively, adding charts and graphs to composite forms to make Planning into more of a dashboard experience.

Hyperion Planning 11.1.2.3 adds a new pre-built module to the existing suite of Workforce and Capital Expenditure planning. This new module, Project Planning, fills the gap of how to budget for projects both short- and long-term before they become capitalized assets. Whether you want to budget IT projects from initial proposal through implementation, capital projects to expand facilities, or development projects out in the field, the new Project Planning module can handle them all.

The BI Apps from Oracle present customers with a nice head start to getting their BI environment up and running. But for many customers, they are just too slow for their user community while running dashboards, reports, and ad-hoc queries. Learn about some of the key techniques you can use to take the BI Apps to performance levels you didn't think were possible.

Oracle truly has an advantage in the EPM/BI space with purpose-built solutions for very specific business cases ranging from operational budgeting to profitability analysis and long-range planning. However, organizations often struggle with the question of where certain functionality should reside within the suite. Learn how to fully leverage the power of the Hyperion platform through live discussion, real-life examples, and best practices. This roundtable will be moderated by Chad MacKendrick, VP of Business Development, along with the following speakers: Ryan Meester, Chris Barbieri, and Mike Killeen

Fast Connection Failover and TAF allow failing over connections and queries but do not guarantee transaction outcome, failover transactions, or mask outages. This session will cover these topics. This session covers upcoming Oracle database availability capabilities including: (i) Transaction Guard for checking and guaranteeing transaction outcome; (ii) Application Continuity for attempting to mask outages by failing over connections and replaying session contexts, queries, DML, and DDL. Other new HA features include recoverable errors, fast dead connection detection and adaptive connection retries. Application developers and DBAs will learn how to use these features for maximum application availability.

Stuck in the same old rut in how you create Essbase reports in Smart View? Did you know that there are six different Smart View tools for querying Essbase data? In one short session, learn how, when, and why to use each tool. Get out of the rut and expand your horizons with all of the Smart View query tools.

The past decade has seen an explosion in data from sources as varied as web server logs, social networks, sensors, and mobile devices. Organizations are now challenged with trying to capture and analyze it all. Combining elements of business intelligence, statistical analysis, computer science, and even art, the new discipline of data science has emerged in response to the big data problem. This presentation offers a basic introduction to data science with a focus on Oracle technologies, and will walk through the full data analysis lifecycle: from acquiring and organizing data, to analyzing and visualizing it. Demonstrations using Oracle R and Oracle Business Intelligence will include examples of data mining, natural language processing, social network analysis, data visualization, and statistical modeling techniques.

Interested in what to do with the vast, unstructured social data on sites like Twitter and Facebook? This presentation will help you discover how to combine social network data, advanced analytics, and visualization to find important patterns in the social web. Demonstrations will use Oracle R and Oracle Business Intelligence with real-world data sets to perform tasks including: acquiring social network data, identifying important members of a network, detecting communities, monitoring sentiment, and sharing your analysis through OBIEE dashboards.

Common questions on APEX often are about the infrastructure and on how complex it is to install, maintain, and upgrade. This session will demystify the APEX installation. Architectures, install, upgrade, tablespace management, schema management, installing APEX with EBS, and backups will be some of the subjects covered in this session.

This session will take you though the steps necessary for creating advanced input templates for distribution to end users. The templates will include data from multiple sources and the examples shown will leverage new features in Office 2010 and 2013 along with Excel features have been around for many versions. (charting, functions, sparkles, outline, and formatting) It will touch on the use of VBA to automate common tasks and we will go through some of the challenges of template distribution and maintenance.

In this session we will get you up to speed on all the new features available in the latest version of Smart View. We will discuss general client features like sheet level options, re-designed function builder, or platform support like Office 2013 as well as provider specific features like in-cell Point of View or improved Planning Smart Lists. This session will also contain details on, and show demos of new extensions; most notably the OBI (Oracle Business Intelligence) extension.

With APEX 4.x, we as APEX developers were given a GREAT gift in plug-ins. Then in APEX 4.1 we were given the ability to build an authentication plug-in to replace the old style function-driven coding for authentication schemes. This presentation will walk through taking an existing authentication scheme (custom, table driven) and show how to build a plug-in that can be dropped into your application(s) to allow custom table-driven authentication.

You might be tempted to view applications built with the Oracle Application Development Framework as being monolithic and inflexible, but how wrong you would be! In this advanced session Duncan will reveal some of the true underlying power of the framework, illustrating some core techniques that will lift your your ADF applications into the cloud and beyond. The paper will cover such techniques as adaptive bindings, design time at runtime and dynamic User Interfaces, all gleaned from Oracle's own internal use of ADF for building Enterprise applications.

We learn, it is said, through our mistakes, and this is never truer than in the world of software engineering. In this dynamic session, the speakers share some of the bad practices and downright errors they have seen again and again throughout the Oracle Application Development Framework (Oracle ADF) development community. Of course, it's not all doom and gloom; they'll actually also show you how to do it correctly and perhaps open your eyes to some cool new techniques along the way. This session is a must for any aspiring Oracle ADF developer looking for entertainment and education at the conference.

To many software developers, designers, and architects, "performance" is a side-effect...an afterthought of designing and building proper features like "book an order" or "look up a book by author." But great performance at scale doesn't happen by accident. The first step is to know what performance *is*: it is the answer to the question, "What have people been *experiencing*?" Knowing what people experience when they use your software is possible only if you treat performance as a proper feature, a feature you analyze, design, build, test, and maintain. This session explains the steps that will get you started.

In a cost-conscious economy, departments and lines of business keep close tabs on every penny that impacts their bottom line. Efficiencies can be gained by pooling common administrative functions into shared service centers, but who pays the bill? Find out how Oracle Hyperion Profitability and Cost Management is used to allocate costs to product lines, customer segments, locations, channels, and other lines of business and learn more about customer successes. Understand how Leggett & Platt has deployed HPCM to build a set of models to enhance allocation methodology to products and customers, provide transparency into costs, and to create customer and product profitability reporting for its manufacturing processes.

TBD

So you've learned the basics of MDX and you are ready to take the next step. What are the next challenges as you begin to put MDX to use in real projects? In this hands-on lab we will cover practical application of intermediate to advanced functions, calculation order and optimization using real world examples of some of the most frequently used calculations such as: * Intermediate to advanced ratio analysis * Rolling calculations * User defined members and sets * Complex period-to-period comparisons * Balance forward calculations * Analytical functions We will make use of member formulas and queries. We will also make use of Smart View's Smart Query feature to illustrate how MDX can be used in end user reporting applications. We will also address some tricky calculation order issues and demonstrate optimization techniques.

Achieving good SQL performance can often seem like a magic act where you never know if the trick is going to work or not. Sometimes it works (performance is good) and sometimes it doesn't (performance is bad). What can you do to eliminate the guesswork and create SQL that consistently performs as desired? It's not magic but simply a matter of understanding how to best write (or rewrite) your SQL to help the Optimizer produce the best executions possible. It's also a matter of supporting our SQL with an effective set of indexes. Part of the reason producing SQL that "just works" seems so hard is that we, as developers, often hold onto our coding styles long after they have become outdated or unwieldy. Particularly when maintaining SQL that was written by someone else, we often continue to use/reuse code that is no longer maintainable because it still works in some way and we are afraid to modify it. But is that really effective? Obviously, the answer is "no." What we need to do is to remove redundancy, eliminate unused functionality, and rejuvenate obsolete designs and constructs in our SQL through refactoring. Refactoring shouldn't happen just once but instead should happen every time the code is reviewed or modified in order to eliminate inefficiencies and increase quality. The original formulation can be a good guide post, but may now be obsolete or simply proven to be inefficient when measured against the requirements of your production environment. It may also be necessary to evaluate indexing strategy in order to achieve the best performance footprint. Just like your SQL, index effectiveness needs to be evaluated again and again over time. Indexes that worked well for one set of SQL may need to be adjusted to provide the best performance as SQL is modified and added. How do you know which indexes are "best"? How do you determine when to use single-column indexes or multi-column indexes? In this session you will learn: * Common ways to rewrite SQL that make it perform better and more consistently * How to make your SQL easy to identify and test * How and when to add or modify indexes * How to determine the best choice of columns to include in an index and what order to place them * How to determine the trade-offs of creating the "best" index

It's the Hunger Games and you've got a 1 in 24 chance to come out alive. What can you do to make sure the odds you survive are in your favor? Making sure your SQL performs well and remains stable over time may not be a life or death situation, but you can stack the odds in your favor by understanding how the optimizer utilizes statistics to formulate execution plans. The calculations the optimizer uses to make plan operation choices are rooted in some very simple statistical formulas. These formulas, if understood, can help you make better choices when writing SQL as well as improve how you performance test your code so that you are confident in how well it will perform over the long haul in production. In this session, you will learn: * Statistics fundamentals for computing cardinality/selectivity for single and multi-column predicates. * How statistics can help the optimizer understand data distribution patterns (skew). * Reasons why certain ways of writing SQL limit the optimizer's ability to determine the best plan and how the optimizer uses query transformations to improve the odds. * How to use extended statistics to help the optimizer create more accurate cardinality estimates. * How the optimizer learns and self-corrects plan choices using cardinality feedback as well as a look at Oracle 12c enhancements such as adaptive execution plans and enhanced statistics.

For many, the attraction of Oracle Fusion Applications and its underlying technology, Oracle Application Development Framework (Oracle ADF), may be a compelling reason to look at moving their existing applications to this new technology. But how can you do it? Many of you will have over twenty years' investment in hundreds of Oracle Forms applications. Do you rewrite? Can you perform automated migration? Should you redevelop from scratch? Can you salvage any of your existing code or skills? This presentation takes you through the decision process of looking at leaving a technology such as Oracle Forms and moving to Oracle ADF. It examines product roadmaps, design decisions, rearchitecture considerations, tools, and methodologies and shares real customer experiences.

Never tried Oracle ADF development before? Still think ADF is hard to develop with? Come and experience the Oracle ADF development on your own machine. See how far you can get building rich Web based applications with the latest version of Oracle ADF and without the need for low level coding. In the process you'll get familiar with the various layers and technologies used in Oracle ADF.

ADF is a first-class framework. Come to this session to learn how to create a first-class development team for building ADF applications. Whether you are a developer, team lead, or development manager, this session will help you understand how to set up your project for success. From training considerations for your developers to must-have resources, as well as key coding guidelines and reuse considerations, the essential elements of successful ADF application development are explained so that your team will be equipped to create compelling, usable, elegant applications that are performant and easy to maintain.

ADF is Oracle's next generation framework to build powerful enterprise applications. This session will teach you how to best leverage this rich framework in your BPM/SOA application. The session will rely on demonstrations to illustrate integration hook points so that you'll understand how to extend the usefulness of your organization's ADF applications, and how to customize BPM task forms to fit your organization's needs.

Smart View for Office provides a dynamic framework for customizing the functionality and capabilities to suit a client's deployment. This session provides practical, deployed examples of using customizing Smart View for both Planning and Essbase.

Join us for some Essbase Studio fun as we walk you through the basics and some intermediate concepts of the latest version of the Essbase Studio. Learn why Studio is the best way to create your Essbase applications and why its time to put EIS to bed. During the lab you will deploy an Essbase cube built from a relational source, learn how to update its properties and define drill-through reports to relational tables.

As analytic data sets grow, Essbase deployments are more and more focused on the ASO technology to take advantage of speed and scale. However, performing intricate calculations at run-time often leads to poor reporting performance. This session focuses on leveraging ASO procedural calculations and allocations to extend analysis and expedite reporting.

"508" refers to Section 508 of the Rehabilitation Act of 1973 that was later expanded by the Workforce Investment Act of 1998. The act requires that when Federal agencies develop, procure, maintain, or use electronic and information technology, they must ensure that it is accessible to people with disabilities. This presentation will present some of the challenges of developing 508 compliant APEX applications and will demonstrate techniques that can be used to overcome those challenges.

There are too many clouds! What's better? What's more secure? How much do I have to pay? Rather than listing all of them, this presentation will discuss two major players and literally slice and dice both offerings from the architecture, availability, security, manageability, and cost perspective - as we learned when serving universities from the cloud. It will highlight relevant benefits and limitations when moving your APEX solution to the cloud. This session will help you make the right choice!

SQL Developer has become an invaluable tool for developers for database development. It has, however, improved significantly in recent versions and is now as valuable to database administrators and developers alike. This session will look at some of the new features in SQL Developer 3 that can simplify some otherwise mundane tasks for database administrators - Data Pump Import/Export, RMAN Backup & Recovery, Scheduler, Real-Time SQL Monitoring and Reports. The session will also take a look at some Oracle Database 12c features supported in SQL Developer.

After years of success, including revenue growth of 50 percent in 2011, ENDO Pharmaceuticals realized it needed to support future growth strategies, including acquisitions. Attend this session to understand how ENDO selected Oracle Data Relationship Management(DRM) to complement their current investment and use of Hyperion applications, as well as manage master data across information silos that have resulted from previous growth.

Now that 4.2 has landed with built-in mobile support, how do we extend the capabilities with custom components like autocompletes, maps, charts, photo capture, etc.? You guessed it, by creating plug-ins. In this presentation I'll walk through the basics ingredients for developing plugins using jQuery Mobile, Sencha Touch, optionally with Apache Cordova(Phonegap). We'll then explore a number of demos from simple to advanced plugins and peek into their design. With one feature demo that is guaranteed to impress! Plugins provide the ability for you to take your development productivity through the clouds.

Developing a comprehensive Business Intelligence Roadmap may be a necessary step in implementing BI within your organization, but will this guarantee a beneficial outcome and a culture that embraces BI? BI promises many things to organizations, among them the ability to anticipate change, manage risk, improve efficiency, deliver a higher quality service to customers, generate higher revenue growth, and maximize profitability. This presentation will focus on methodologies and other dynamics important when bringing people, process, and tools into a strategy. These considerations will help produce the effective culture that benefits from the promises of BI. Topics will speak directly to business representatives, business sponsors, project managers, and technicians regarding distinct responsibilities.

Oracle has invested in user experience (UX) science for Fusion Applications. How can ADF developers benefit? This session explains the top functional UI design patterns and how using them with ADF brings a Forms-based CRUD UI to new levels of usability and user productivity.

Oracle Data Integrator (ODI) seems slow when it is installed out-of-the-box. Since it has to comply with different versions of the databases and operating systems, the default installation is not the optimal choice. ODI is a flexible product that can be customized for specific requirements and to implement new features of the database or operating systems. Attendees will learn how to easily create a customized ODI environment. This presentation will demonstrate the flexibility of the Knowledge Module, configuration best practices and the best query response time tips and techniques. It will include information about how to load an extensive number of files quickly with a special algorithm, as well as how to define new or customized data types and analytical functions.

End-users are increasingly demanding mobile access to corporate applications. New languages, development tools, skill sets, and determining platforms to support can make the entry into mobile application development difficult for organizations. A new technology makes decisions about mobile development much easier: JQuery Mobile. Oracle APEX integrates easily with JQuery Mobile. This combination can be used to create mobile applications that are supported on a wide range of mobile devices relatively simple. This presentation will walk attendees through the steps of building a mobile application using Oracle Application Express. Attendees are encouraged to bring an iPad (or other mobile device) to actively participate and see the final results of their work.

Triple Constraint, per wiki: "You are given the options of Fast, Good, and Cheap, and told to pick any two. Fast refers to the time required to deliver the product, Good is the quality of the final product, and Cheap refers to the total cost of designing and building the product. This triangle reflects the fact that the three properties of a project are inter-related, and it is not possible to optimize all three -- one will always suffer. In other words you have three options: * Design something quickly and to a high standard, but then it will not be cheap * Design something quickly and cheaply, but it will not be of high quality * Design something cheaply and with high quality, but it will take a long time All of the above statements have been proved otherwise; the District of Columbia Courts have designed and developed around fifteen division/departmental applications with a custom theme in under six months!

Oracle BI Applications have provided many organizations with a streamlined way to analyze data in Oracle ERP systems such as EBS, PeopleSoft, and JDE. But, what happens when you need to include data from companies or divisions within companies that are on other ERP/transaction systems? This session will focus on the techniques to leverage universal adapters to integrate that data into the BI application.

This session explores ways a DBA can keep up with faster development sprint cycles in the Agile development environment. A few automation techniques to find inter-dependencies of database objects for quicker impact analysis, automated QA of standards and conventions compliance of stored objects, automated identification and compilation of invalid objects, automatic identification of missing FK indexes, automated generation of test data, and automated performance analysis using AWR after a quick load testing of the application are covered. Agile developers with agile DBAs make a truly agile development team!

Learn for yourself just why Oracle Application Express is such a powerful, easy to use development tool. This session is designed to give you an overview of the tool complete with demonstrations on how you can maximize your Oracle Database investment. This session will also provide an insight into the major new capabilities being built into Application Express 5.0.

Rather than forcing you to choose just one lab session to attend, the Oracle Application Express Development Team is conducting an al la carte hands-on-lab session in which you get to choose the labs you're interested in. You have over two hours of sessions from which to choose a wide variety of different labs on Application Express.

Rather than forcing you to choose just one lab session to attend, the Oracle Application Express Development Team is conducting an al la carte hands-on-lab session in which you get to choose the labs you're interested in. You have over two hours of sessions from which to choose a wide variety of different labs on Application Express.

Come see how College of DuPage lessened the 'planning' burden on their operating staff by utilizing Hyperion Planning to automate all facets of their planning process including the target, the budget, the monthly forecast, and the five-year outlook. In addition, learn how DuPage utilized Hyperion Planning in a unique way by capturing new hires and terminations on a daily basis, allowing the finance team to track and manage vacant positions in relation to the annual budget. This session outlines the methods used to create this functionality and explores the associated application design and analytics of their enterprise solution.

When a company is deciding on which integration tool to use, the options can become daunting. Who is loading the data? Is the process controlled centrally? Are you sourcing from a ledger directly? What about metadata? The options include Financial Data Quality Management, ERP Integrator, and Oracle Data Integrator. This session will help outline where each product fits in real world type situations. These include the target system that you will be feeding as well as the questions asked above. The session will cover some standard and not so standard data loading processes and uncover the right fit of each of these products.

Attend this session to hear from INC Research, the 2012 Oracle Excellence and MiddleWare Fusion Award Winner. INC will showcase how they took a holistic approach and thought about every area of their business to develop a true competitive advantage and create new revenue channels. By extending their current process of collecting and distributing key financial, project, and clinical data to their customers and leveraging Oracle Business Intelligence, INC developed a next generation, self-service customer portal.

This session will review why Ensco chose to implement a custom CapEx solution in Hyperion Planning. The speaker will provide an introduction to the pre-built CapEx module and then walk you through the solution, sharing key decision factors along with CapEx application design that included smart lists, text measures, SQL integration processes, and more. You'll leave this session with information to apply in your CapEx implementation for both custom and pre-built solutions.

This session with share how Ensco has creatively used smart lists and text measures to reduce dimensionality and database size while enhancing the end user experience with more flexibility and information. Learn how they pushed metadata maintenance into the hands of users (instead of the Planning administrator) using smart dimension numbers and free form text measures. You don't want to miss this session where you can learn the tips and tricks to take your Planning application to the next level.

Your organization's decision to implement new Enterprise Performance Management (EPM) software is often a difficult one. Aside from selecting the software that will best suit the organization's needs, deciding how to move forward with the implementation is critical to its success. The EPM Strategic Roadmap is the foundation for guiding and measuring successful deployments. This session will discuss how a roadmap is key to achieving business transformation, improving productivity and profitability, and empowering decision-making through your new EPM deployment.

ASH and AWR performance data can be accessed in numerous ways. With the appropriate licensing, the DBA or developer has the opportunity to run various reports, both HTML and text, along with querying the data directly to gather important information about the database environment. This session will take the attendee through architecture, design, reports, and querying of the ASH and AWR data directly, that will provide invaluable data to troubleshoot issues and report on performance, ensuring a solid understanding of Oracle's Automatic Workload Repository.

This sesssion is a case study of a real-world system storing billions of images in a hybrid Oracle relational and NoSQL configuration. Images are stored in a highly available high-performance distributed database built with Enterprise Oracle NoSQL. Metadata for these images is stored in an Oracle relational database using Oracle Active Data Guard to provide high availability and read performance. This presentation will emphasize practical considerations and lessons learned when such a hybrid configuration is used to store high-value data, where data integrity is very important. Topics discussed will include performance, scalability, high availability, disaster recovery, security, and manageability of the system.

This session will be a panel discussion highlighting the results of our apples to apples test comparing an Exalytics-based solution to a comparable machine in the Amazon Cloud. These tests encompassed ASO and BSO; they covered data loads, BSO calculation, and ASO Aggregation; and finally multi-user performance tests of BSO Planning Rules and ASO Queries. Given the breadth of this testing some of the results are applicable to non-Exalytics solutions (assuming you have the "lots" of CPU and or Memory).

Why are some cubes fast and some are slow? When is it OK to use MDX and when should (or what types of) MDX be avoided? How do Solve Order, Dynamic, and Stored Hierarchies interact? By understanding how Essbase goes about resolving a query, many of these questions will answer themselves. Much of this understanding comes from the cryptic Bitmap Statistics dialog in Cube Properties. All of this is summarized in 12+1 rules. These 12+1 rules are discussed and used to illustrate how they should be used when designing your cubes. In particular, there are implications and options for the design of alternative hierarchies. These options will be discussed in terms of the trade-offs of cost (in storage size) vs. performance (in retrieval time). Concrete examples will be demonstrated.

Have you ever wondered why some loads are fast and others are slow? Why the same query performs differently at different times? Why your queries and loads are not as fast as they should be? Then this is the session for you. Starting with a discussion of how data file IO is handled in Windows and Unix, techniques to ensure apples-to-apples testing are presented. Then using the results of over three hundred load, and calculate/aggregate tests using very large BSO (9gB input level 175gB Calculated) and ASO cubes (1.4 billion cells 84GB aggregated). The testing spans Windows and UNIX; ASO and BSO; varying cache settings; sort order and file formats are presented. These variables are evaluated and ranked with several new and surprising conclusions. Conclusions, that in some cases, run contrary to existing best practices. Finally, expanding on the chapter "How ASO Works and How to Design for Performance" in Developing Essbase Applications, the speaker will discuss surrogate keys, MDX, multi-attribute queries. All of this will be discussed in light of real world experience where multiple cubes are running and data is prepared and hardware supplied by other parts of the organization with differing practices and priorities. In short: real techniques you can implement when you return from the conference.

You already know how to build beautiful APEX applications, but do you still struggle with the pre-historic APEX Application Builder? This session shows how you can make the Application Builder do what you want and how you can easily extend it.

Having beautifully designed and well-structured applications is one of the things easy to achieve in Oracle APEX. It gets more complicated when a user requests to run your application keyboard based only, without using a mouse or any other pointing device. How can you navigate through your application? What about Tabular Forms? Learn a quick and easy way to achieve full keyboard control in your APEX application.

Witness firsthand how your development projects can benefit from the speed and simplicity of the FOEX Plugin Framework. This session will show you how you can build functional pages using rich AJAX Components in record time with just a few mouse clicks, thanks to the UI richness of Sencha Ext JS and the RAD architecture of APEX. FOEX Plugins empower you to give your customers those complex and interactive screens they've always wanted, in record time, without the headaches.

Oracle Data Integrator and Oracle GoldenGate excel as standalone products, but paired together they are the perfect match for real-time data warehousing. Following Oracle's Next Generation Reference Data Warehouse Architecture, this discussion will provide best practices on how to configure, implement, and process data in real-time using ODI and GoldenGate. Attendees will see common real-time challenges solved, including parent-child relationships within micro-batch ETL.

Are you struggling with HFM application performance? Is your HFM application in line with your ever-changing reporting needs? Are you considering an upgrade but are left wondering if your current application is in alignment with best practices? If any of the above is true, it may be time for an application review to determine if your current HFM application can be optimized/enhanced to take advantage of the latest functionality and features available. George Batio, Director of IT at AON, and Anthony Reddin, Hyperion Practice Lead at CompIntelligence, Inc. will guide you through the challenges faced and lessons learned reviewing and optimizing Aon's current HFM application. The presentation will include successes gained around rule and process optimization, improved application performance and maintenance, and improved transparency of HFM's functionality to AON's user community.

Websheet Applications bring an interesting dynamic to Application Express in that they allow users to control not only content of what's in the application, but also to control to some degree just who gets access to the application. Come to this session to gain a better understanding of user access control in Websheet Applications.

You're creating APEX applications already, but you wish your screens would look better. Moving regions around, changing their size, width, placing items, and buttons; it's all frustrating and painful. In this session you'll learn how to position your elements and better implement the vision you have for your applications. The session will go into details of the attributes provided by APEX to make this happen. Learn some HTML and CSS that will allow you to personalize your applications.

This session sets out the unstructured and statistical analysis capabilities of the Exalytics platform to accompany the traditional OBIEE / structured data features. Using the Flight Delays dataset, the session will create an application that first uses Endeca for search/discovery, then creates in-memory BI dashboards using OBIEE, finally using ORE for deep analysis questions using the R statistical language.

This session describes new metadata modeling and storage options available with the latest release of OBIEE 11g, and talks about how repositories are deployed and moved through the development lifecycle, using these new features.

Responsive Web design is the approach that suggests that design and development should respond to the user's behavior and environment based on screen size, platform and orientation. The practice consists of a mix of flexible grids and layouts, images and an intelligent use of CSS media queries. What are CSS grids and media queries? How do they work and how can I integrate them in my APEX application design? These are the questions I will answer during my presentation as I build an example explication using Theme 25, the responsive theme provided in Oracle Application Express 4.2. This is the 2nd talk in a 4 part series on responsive design in APEX.

Oracle Application Express has a very flexible theming mechanism, allowing you to completely customize your applications interface. Unfortunately, you will only find little documentation on this subject. This presentation will introduce you to the basic concepts of APEX templates and themes and suggest a few different approaches to modifying existing themes or creating a new custom user interface in APEX.

If you've ever tried to find information on accessing Essbase from OBIEE, you'll be scouring badly written blogs for days, because there just isn't much published on this. This session will cover the seven poorly documented steps you must do to make sure your Essbase cube isn't flattened, it's in the correct outline order, aliases appear, and more. If you own Essbase & OBIEE and would like to integrate them, learn these seven steps and you too can start your own badly written blog (no offense).

OBIEE 11g (and in particular, version 11.1.1.6) is the most significant release of the Oracle BI products since Oracle first acquired the various products that make up the OBIEE suite. Do you want excellent ad-hoc analysis on Essbase? It's here now. Do you want integrated reports, analysis, and dashboards in a graphical, easy-to-use interface? Here too. If you want to hear about all the earth-shattering new features of OBIEE 11g, attend the session that shows how it has expanded the ability to report data, trends, KPIs, and far more than can possibly be listed in one abstract. The new features in 11.1.1.6 not only dramatically improve the Hyperion integration, they let you do analysis on an iPad. (Yes, the session will have an iPad passed around the room so you can experience it first-hand). If you've been looking to go mobile with Hyperion or OBIEE, this is the session that teaches you how to put Oracle on your iPhone.

Hourglass configurations, optimal block sizes, dense/sparse configurations, correct cache settings, FIX vs. IF, all those things you learned in Essbase Bootcamp, read in the Database Administrator's Guide, heard Edward Roske preach, or learned at conferences... were created years and years ago. They were designed for 32-bit hardware under old versions of Essbase and sadly, no one has ever gone back and corrected them UNTIL NOW. This session will retest every optimization tip you know as gospel, and show what they should be under modern versions of Essbase running on high-end hardware. If you want to learn the top ten things that will shock you that you're doing wrong, don't miss this session. It may blow your mind, but it will be the most valuable session you ever attend on Essbase BSO optimization as we debunk everything you thought you knew.

Over the last two years, Essbase footprint in the Oracle product portfolio had increase dramatically. In addition to being an application platform for many customer as well as Oracles own EPM applications, Essbase is a key part of Oracle BI Foundation, Exalytics and Fusion applications. These changes in the Essbase ecosystem along with other market trends such as cloud, require Essbase to adapt and evolve; But how do you prepare for the future while protecting your past? Join this session to learn about Oracles vision for Essbase and the product roadmap.

With the many options in Application Express authentication and authorization, it can be difficult to determine which method is right for you. This presentation will investigate these various methods and see how they work. The presentation will also take a look at session state protection to help you prevent URL tampering.

The Data Pump API is a set of functions and procedures in the dbms_datapump package, that can move data and metadata between Oracle databases. This presentation will take a detailed look at this package and its contents. There will be examples of how to use the various filtering options, how to stop, restart, and monitor running jobs. The audience will get an idea of how to use the Data Pump API in their own environments, and how to do more than just basic data exports and imports.

Oracle data dictionary views as DBA_IDENTIFIERS or DBA_DEPENDENCIES are in many cases sufficient to analyze static PL/SQL and SQL code within the Oracle database. But what if more detailed analysis are required, such as the use of tables or columns in PL/SQL package units, in SQL statements, or in SQL statement clauses? Wouldn't a DBA_OBJECT_USAGE view - showing DML and query operations on tables/views per database object -- be a helpful tool? This presentation shows how to extend the Oracle data dictionary views to support fine-grained PL/SQL and SQL analysis and demonstrates the capabilities using real-life examples.

Streamline your financial planning, budgeting and forecasting processes at cloud speed with the Oracle Planning and Budgeting Cloud Service. World-class planning and budgeting is now within easy reach of businesses of every size -- with no IT infrastructure investments and with minimal IT resources. Come learn how you can get off your spreadsheets and drive business agility, cross-functional alignment, and significantly better visibility and control -- all leading to predictable business performance -- with this new cloud service. It is the perfect solution for your planning and budgeting needs whether your ERP system is deployed in the cloud or on-premise.

Not the fish, anything but the fish! The FDM product is nearing the end of its life. This session will introduce you to FDM 2.0, aka ERP Integrator (ERPi). The session will begin with a technology overview of the new product - architecturally and functionally. The session will continue on to explore key features/changes from FDM. The session will explore strategies, techniques, and key watch-outs for migration from your existing FDM application. Finally the session will discuss best/leading practices for ERPi implementation and go-forward maintenance.

If you spend time writing Java code, and you're not using Groovy, you're spending too much time writing code. If you've ever pondered an Essbase automation problem and said, "I wish I knew how to write Java," and you haven't looked into Groovy, your answer is here. Groovy is an object-oriented dynamic language (also referred to as a scripting language) like Ruby or PHP. Like these languages, Groovy is much easier to use and has a simpler syntax than Java. However, what makes Groovy different than other scripting languages is that it compiles to Java bytecode. This means that Java programs can run Groovy, and Groovy programs can run Java. This seamless integration with Java and its concise syntax are why Groovy is the language of choice for scripting of ADF Business Components. This integration also means that writing in Groovy makes it easier to use existing Java libraries; including the Java libraries of the Essbase Java API. This session is an introduction to the Groovy programming language and how it can be used in conjunction with the Essbase JAPI to make advanced automation more accessible.

So what's so great about upgrading or installing 11.1.2.3 for HFM?...drumroll...extra custom dimensions. Check out this session to learn more.

Essbase Studio has been around since the beginning of version 11.1.X and there is still a lot of mystery around its usage. Come explore some of the more advanced features now that you have gotten your feet wet creating your first Studio model. This session will go over settings, optimizations, tips, and tricks that can make you more successful with Studio.

There are standard optimizations that developers do to improve performance, then there are those developers who think outside the box and create unique optimizations that can affect calculations, data loads, data transfers, etc. Come to this session to see some unique solutions and truly outrageous ways to improve performance.

This session will cover one of the nice new features in HTML5, namely WebSockets. Rather than using the traditional polling methods to determine when data has changed in your application, WebSockets allow the server to PUSH notifications to the browser, which has all kinds of implications for scalability and usability of applications. The presenter will show some different ways in which you can use WebSockets in any APEX application to really make your application stand out.

Internally at APEX Evangelists, they used to use Subversion for their source-control, but now they use Git. Why? Well attend this session to find out why they made the switch! This session will cover what Git is and how you can leverage it to provide a multi-developer environment effectively.

Although the Exalytics Engineered Machine is becoming a well-known addition to the Oracle enterprise hardware topology, the machine's adoption has not yet reached critical mass. Achieving redundancy, failover, and a high-availability environment for a mission-critical Business Intelligence system is a best practice, but is seldom implemented. This is usually due to cost, skill, preparation, or other prohibitive factors. This session underscores the importance for implementing an HA OBIEE 11g environment and how to execute this effectively in both Exalytics and non-Exalytics systems. By the end of the presentation the attendees should have an understanding of how proper planning can save a department time and money while adhering to best practices. They will also leave with the knowledge of what skills and resources are needed to build and maintain the prescribed Oracle BI 11g HA environments.

The Oracle BI Mobile iPad application is based on a public distribution system via the Apple App Store. Its ability to connect to an organization's non-externalized Oracle BI server typically requires a VPN connection to be opened on the tablet device before levering the OBIEE mobile application. There are tremendous security concerns surrounding opening VPN access to other applications downloaded to the device. This session covers the latest Mobile Security kit released by Oracle and provides a high to mid-level overview of how implementing containerization and an internal application deployment strategy can help achieve ubiquitous mobile deployment and any organization. By the end of this presentation attendees should understand a basic strategy for successfully deploying mobile Oracle BI while adhering to security standards.

Is predictive modeling a valuable tool for your organization? Yes! This presentation will lay out the business case of implementing predictive modeling techniques to your organization. The session will also discuss strategies to implement these techniques into your day- to-day reporting and analysis activities, including staffing, training, and selecting the right tools.

Version 11.1.2.3 of Hyperion Planning is including Crystal Ball's predictor feature. Predictor utilizes established time series procedures to help with forecasting upcoming time periods. This presentation will walk you through how to effectively use predictor as part of your budgeting and forecasting duties as well as an intuitive explanation of the concepts working behind the scenes.

Balance sheet design in HFM can be very complex, especially when dealing in a multi-tier translation environment. Learn how to automate this complex process.

Hyperion Financial Reporting (FR) has been around for a long time. In spite of rumors, FR has been a go-to reporting tool for Profit & Loss, Balance Sheet, Cash Flow, and various other financial reports. The simplicity of the tool, the user-friendly design, and easy training of the users have made FR a very popular reporting tool in the Enterprise Performance Management field.

Mobile and tablet devices have become an important part of today's business. With over 70% of organizations already using or planning to use custom mobile apps, companies can no longer afford to stand on the sidelines and need to adopt a mobile strategy now. Oracle Application Express provides customers with powerful tools to quickly and efficiently build mobile web apps and extend their existing Desktop apps for mobile use. Oracle Application Express 5.0 further expands the existing mobile development features by adopting the latest release of jQuery Mobile and introducing a user interface specifically designed for tablet use. This session provides an overview of the new mobile capabilities and includes a live demonstration of how to quickly build cross-platform, responsive apps for smartphones and tablets

Transaction processing systems are generally considered easier to scale than data warehouses. Relational databases were designed for this type of workload, and there are no esoteric hardware requirements. Mostly, it is just a matter of normalizing to the right degree and getting the indexes right. The major challenge in these systems is their extreme concurrency, which means that small temporary slowdowns can escalate to major issues very quickly. In this presentation Gwen Shapira will explain how application developers and DBAs can work together to build a scalable and stable OLTP system - using application queues, connection pools, and strategic use of caches in different layers of the system.

This beginner-level session introduces Oracle's offerings for .NET programmers, including Oracle Data Provider for .NET (ODP.NET), Oracle Developer Tools for Visual Studio, Oracle Providers for ASP.NET, and .NET stored procedures. Step-by step-demos illustrate how to get started with developing Oracle Database .NET applications by using each of these free products. New and upcoming .NET features, including fully managed ODP.NET, Microsoft Entity Framework features, Microsoft Visual Studio 2012 support, and schema compare tools are also described briefly in the session.

In this session, try the latest features of Oracle Data Provider for .NET (ODP.NET) and Oracle Database's tight integration with Visual Studio. Step-by-step labs include several topics: * LINQ, Entity Framework, WCF Data Services, and Open Data Protocol (OData) * Fully managed ODP.NET * The integrated PL/SQL debugger in Visual Studio * ASP.NET web application development * Using Oracle Performance Analyzer and Oracle Developer Tools for Visual Studio's SQL Tuning Advisor feature in Visual Studio * ODP.NET best practices for performance * Using ODP.NET with Oracle TimesTen In-Memory Database * Many others Pick whichever topic interests you---work at your own pace. Lessons cover all experience levels, for attendees new to .NET and Oracle, as well as experienced users.

This session discusses recent and upcoming .NET and Visual Studio features for Oracle Database. One of the major recent features is the 100% managed ODP.NET, which greatly eases data provider deployment and management. A second major feature is Oracle schema comparison tools within Visual Studio to simplify database schema evolution. These topics are discussed, as well as the following to provide an overview of the latest in Oracle and .NET development: Pluggable Databases, Entity Framework, .NET application high availability, and ease of development features, such as larger VARCHAR2, implicit REF Cursors, and ODP.NET Booleans.

.NET and Oracle programmers frequently work with PL/SQL, whether that means setting up a call to a stored procedure from a .NET program, executing a PL/SQL anonymous block, or writing and debugging the PL/SQL stored procedure code. In this session, we'll look at leveraging PL/SQL from the point of view of a .NET developer and will provide in-depth tips about how to configure and use the tightly integrated PL/SQL debugger in Visual Studio. We will also introduce the new Visual Studio Schema Compare tool and show how this new feature, along with automatic SQL script generation and source control integration assists in the Oracle database development lifecycle.

This session explores coding best practices and demonstrates how to use Visual Studio tuning tools for achieving faster data access performance with ODP.NET. It examines techniques for optimizing connection pooling, statement caching, data fetching and updating, statement batching, and Oracle datatype usage. Furthermore, it demonstrates tuning tools included with Oracle Developer Tools for Visual Studio, such as Oracle Performance Analyzer, which monitors the running application, highlights performance problems, and offers specific recommendations. Finally, the session discusses best practices for ODP.NET and Oracle client deployment to your mid-tier servers or clients.

The explosive growth in the amount of unstructured and semi-structured data created in the world continues to accelerate, and analyzing these large data sets will become a key basis for competitive advantage. Technologies like Hadoop have made it easier to acquire and organize data, but we still need to use Analytics tools to realize its full value. This session will cover a detailed approach for using Oracle Data Integrator adapters to integrate and transform data within Hadoop to build a simple analytic model that can be leveraged by OBIEE.

One of the key capabilities or Oracle ADF is the ability to change their look and feel. This session will introduce you to the art of skinning Oracle ADF Faces to achieve your desired look and feel. Learn how skins are defined, how to set up your project, and which tools are available for you to help in the development of your skins.

JDeveloper makes it very simple to create business services that interact with database tables using the ADF Business Components wizards. But what happens when the wizards are done? This session will teach some of the basic techniques and tips for getting even more functionality from your ADF Business Components.

Need to display data in meaningful ways? Looking to impress management with beautiful data visualizations? Come and learn how the Oracle ADF Data Visualization components can help you achieve an impressive web dashboard quickly. Create interactive charts, maps, gauges, and more.

Oracle JDeveloper 12c is the new major release of Oracle's flagship IDE and the embedded Oracle Application Development Framework (ADF). This session explores new features in Oracle JDeveloper and Oracle ADF, like the integration of Maven, JavaEE 6 support, REST integration, JavaServer Faces 2.0 support, improved skinning, the new XML-less JavaBean data control, ADF Business Components enhancements, Tablet support, new ADF Faces and DVT components, and many more. Developers who are not yet on Oracle JDeveloper 11g R2 will learn about technology changes and their path to upgrade to the Oracle ADF stack in Oracle JDeveloper 12c.

Perhaps you've wanted to have a portion of your calculation selectively run or not depending on other conditions? The combination of VAR and LOOP can be used to do exactly that. Come see how. In addition, learn how to use the ARRAY calc script function. ARRAY is one of the most underused and powerful tools in the Essbase developer's bag of tricks. The speed and power of ARRAY can be put to work in any situation where a one or two-dimensional set of factors is used to calculate values such as currency translation, location-specific taxes, allocation of fixed costs to products or profit centers, and many more. ARRAY reads a list of values into a rapid-access array; repetitive fetches from disk are eliminated. This presentation will teach by example and demonstrate factor-of-ten performance improvements.

Tired of reminding your users when data is due? Need to have a global real-time view of where you are in the close process? Want to ensure that the close is not interrupted when one critical user is sick during the close? See a real-world example of how FCM Financial Close Manager can help. Company Moog will show how they leveraged FCM with HFM, Planning, and all close-process related tasks. - Learn the concepts of FCM - See a live demo build of a simple close calendar from scratch to finish - Learn how to leverage FCM to handle task automation like Extended Analytics data extracts

While Essbase and the Oracle Business Intelligence server are powerful apart, they are even more powerful together. This session will cover the basics of OBIEE (Oracle Business Intelligence Enterprise Edition) including all the reasons that with OBIEE 11g, you can finally seamlessly pair Essbase and OBIEE (forget your OBIEE 10 nightmares). If you have Essbase, HFM, or OBIEE and you want to see the future of BI and analytics at Oracle, make sure you get a really good seat up front.

More than two and a half million people use Oracle SQL Developer, but how many of those are really getting the most of the tool? SQL Developer's primary purpose is to save the developer and DBA time and energy without getting in their way. See the most popular features and productivity tips the product manager accumulated in this interactive session. Each attendee is guaranteed to pick up two to three new techniques that will improve their Oracle database experience.

SQL Developer is used by millions of people and this lab will teach how to use some often missed features which help tune SQL statements. This includes using the SQL Tuning advisor, how to use various optimizer access path, and other features. Labs include: * Tune Your SQL with the SQL Tuning Advisor * Learn about Optimizer Access Paths Using Oracle SQL Developer * Working with Tuning Utilities in Oracle SQL Developer

I only use SQL*Plus. I say that graphical IDEs are the best. Who is right? How can an old-school database pro be convinced to use newer technology, and more importantly, why SHOULD they be convinced? Tools are designed to do one thing - increase productivity. If your tool is slowing you down, you're doing it wrong, or you're using the wrong tool. Watch Oracle's SQL Developer product manager debate himself on why SQL Developer can be good for both the new and advanced Oracle user.

Are you buried under a mound of financial reports and want to dig yourself out? This session will cover how to condense your hundreds of reports down to two or three using the dynamic power of Hyperion Financial Reporting. Laureate Education will describe their journey through reporting and the tips and tricks they came up with to make reports more dynamic and users more self-sufficient. Join Laureate as they help you free your reporting users from reporting torture.

Curious about SOA? Know what BPEL means? Dare to do battle with the schematron? Come to see how to build your first SOA project incorporating many of the 11g SOA suite features such as the mediator, BPEL projects, tech adapters, and schematron!

Businesses of any size can utilize commercially available cloud solutions to conduct pretty much any inward and outward facing transaction today. The challenge becomes obvious when multiple commercial solutions from multiple vendors need to be integrated. Rather than relying on commercial software and facing integration nightmares, an alternate approach would be to use Oracle APEX in the cloud. This session talks about how Enkitec as a company was able to consolidate almost all business transactions with a suite of Oracle APEX applications, eliminating a number of commercial subscriptions, including Salesforce.com. It will focus on some of the technical challenges that had to be overcome, such as SEO, user interfaces, security concerns and integration.

Oracle Application Express has proven itself as a powerful development platform for internal development needs in countless organizations worldwide. One of the new frontiers it is starting to conquer is building commercial applications. This session covers what it takes to use Oracle Application Express as a platform for building commercial applications. It looks at all facets of the software development lifecycle and discusses different infrastructures, deployments, processes, and tools used to make development with Oracle Application Express as streamlined and cost-effective as possible. Real-world examples are given throughout the session. Much of what is discussed in this session can also be applied to medium to large Oracle Application Express projects.

Service Oriented Infrastructures are becoming the norm in the enterprise. Our APEX apps need to fit into this architecture by being able to call and consume web services. See how to use the APEX_WEB_SERVICE API to extend your applications to fit into an SOA environment.

As your APEX footprint grows and becomes more critical to your organization, so do things such as security, manageability, and support. These concerns should be addressed before they become too large or unwieldy to deal with. Thus, Enkitec has developed a set of tools and services to augment the security, manageability, and support of any size organization that has invested in APEX. This session will highlight and demonstrate Enkitec's APEX tools and support offerings. eSERT is an APEX application that identifies security vulnerabilities in other APEX applications. eFramework is an enterprise-class management tool used to better manage and monitor a suite of APEX applications. And lastly, Enkitec Plugin Support provides a for-cost support service for a wide range of popular APEX plugins.

With all of the draws to get individual attention from users, how do you make e-mail communication effective? How many systems are built where the primary use is to generate SPAM mail? This presentation will show techniques for including complex reports, dynamic graphics, and charts within emails without writing code by hand. The session will also review the database technology required to enable the techniques shown and considerations for how it can be accomplished. Examples will include: Consuming APEX Page output to use as an HTML email source Creating dynamic graphs that are sourced from APEX Dynamic graphic content Effective email follow-up methods like approvals

APEX has the ability to leverage the database to store and manage files submitted by the user. This is valuable when building applications allowing the developer to create rich collaboration environments. This presentation will show how attachments work in APEX and show examples of how they can be used both in the user interface code as well as in code. The session will also be showing some of the considerations when creating tables that contain LOB content. Individuals will be given both a review of the APEX wizards and expand it with techniques for using the LOBS and information necessary to manage the database objects.

In this session, get to know Oracle Developer Cloud Services, a hosted environment for your application development infrastructure, including version management, build services, tasks, and defects tracking, wikis, document storage, and more.

Oracle ADF applications can be developed in Eclipse (through Oracle Enterprise Package for Eclipse) and - traditional - in Oracle JDeveloper. This session compares the ADF support in both IDEs in a entertaining and refreshing "can-you-do-that" battle-style. Besides learning about the capabilities of both IDEs you learn about the joint points that allow developers of both IDEs to work together on a shared ADF application project.

Learn how you can take full advantage of this new pluggable architecture with various deployment options for Application Express. This session will also cover new capabilities defined within Application Express to take advantage of other Oracle Database features.

The Kanban methodology was developed at Toyota in the 1940's as a production line scheduling tool for just-in-time building. It's been adapted to software development as a way to improve software delivery throughput, reliability, and customer satisfaction in an IT/programming environment, while having significantly lower overhead than most Agile implementations. This session will cover the basics of the Kanban methodology and how it applies in development environments, focusing on the improvements to team productivity and improved relationships with software consumers. It will also present a case study of Dartmouth College's IMS team implementation of Kanban during the past two years, including their implementation of Kanban, immediate productivity benefits, changes to long-term relationships with end-user departments, and the improvement in the team's reputation, morale, and productivity. An update will describe how and why IMS "upgraded" from Kanban to Scrum this past winter.

This session will be a short examination of Oracle's date/time datatypes and best practices for manipulating them in SQL and PL/SQL.

End-User and Business Unit Application Development are new paradigms in which end users produce their own software, freeing corporate IT developers to work on other business priorities. Is APEX a good fit for EUAD and BUAD? Can end users assisted by inexperienced IT interns develop high-quality software using APEX? This session will show you that the answer is yes to both questions. Based on a five-year program now involving 100 APEX developers, you'll learn how to make it happen based on four principles that guide all the technical and governance processes.

OBIEE Management pack and the Virtualization management pack in Enterprise Manager 12c provide some very interesting and important features for monitoring and management of the Oracle BI software stack. This session primarily dives into these two important areas offered by EM 12c in the context of OBIEE/Exalytics.

With the proliferation of OpenData and OpenGov movements, the amount of data in the public domain has increased by leaps and bounds. This session will have a look at how Endeca can be used for analyzing these huge data sets.

See how an Oracle ERP customer, Herbalife, and other Oracle Hyperion Planning and Essbase customers have implemented profitability, transfer pricing, and allocation models to improve efficiency and effectiveness and to provide transparency to users instead of the process being a "black box." Using a case study approach, see how you can use Oracle Hyperion Financial Reporting and Smart View to drill from the receiver to the sending entities/cost centers with the associated allocation methodology; build Excel templates with Essbase to dynamically build allocation methodologies; create journal entries; and use Planning forms to make adjustments.

Learn about Oracle Hyperion Workforce Planning -- what is "out-of-the-box" and perhaps more importantly, what is not. This session presents best practices including at what level to plan, budget, or forecast at: by employee, by position, or a "hybrid" approach. Assets and accelerators are shown including questionnaires used for requirements gathering and design documents. The "out-of-the-box" Workforce Planning module is demonstrated. Common configuration changes (and not so common ones) are shown using a case study approach from a number of client implementations. These configuration changes include: long-range planning at a higher level, multi-year forecasts, and additional dimensions/accounts.

Designing integrations for global organizations with complex entity structures, elimination entries, multiple currencies, and cash flow structure requirements can be complex. It is important to understand the similarities and differences between Planning/Essbase and HFM required and optional dimensions to order to effectively design integrations and avoid missteps and rework. Using a case study approach, best practices in designing dimensions and integrating metadata are presented.

Although the OlapUnderground Essbase Outline Extractor has been downloaded by over 10,000 unique users, the technology used is quickly becoming outdated. The new Dodeca Essbase Outline Extractor is a complete redesign and rewrite of the popular Essbase Outline Extractor technology and adds the ability to output in Hyperion Planning Outline Load Utility format and to relational databases. It also adds the ability to run on 32-bit and 64-bit operating systems including Windows, Unix, Linux, and even MacOS. Attend this session to learn how to leverage this free utility in your company.

With the emergence of Essbase as a key technology within the Oracle Fusion strategy, the Essbase Java API has become the lead API used by Oracle to develop robust applications. Attend this session to learn how to get started with Java and with the Essbase Java API. This session will cover the basics of creating an Essbase Java project, connecting to Essbase databases, and running simple tasks. The session will also review the types of functionality available within the Essbase Java API.

Essbase is a key component in the Oracle Fusion Applications strategy. As the Oracle Fusion Applications are written in Java, it is clear the Essbase Java API plays an important role in Oracle's future. Attend this session and learn Essbase Java API tips and tricks from one of the world's experts in the Essbase Java API. The session will cover some of the common issues developers encounter when writing Java API applications, as well as tips on how to build and maintain dependable software that utilizes Essbase.

Dodeca makes Essbase better. Attend this session to learn how Wells Fargo, Kroger, and other Dodeca customers achieved their goals (and beyond) by leveraging the power of Dodeca and Essbase together for small and large mission critical applications.

If you're building lifeless input forms that simply present data and allow inputs, you're doing it all wrong! There are a host of intermediate-to-advanced features in forms that are ready to impress your end-users. Have you ever used a right-click menu to pass context to another form? What about data validations that actually work in Smart View? Have you tried your luck with in-sheet calculations? What about user variables? If you've built basic Planning input forms, and you're ready to take your apps to the next level, this presentation is for you. You'll get a step-by-step guide, illustrated with a live demo and real-world examples.

One of the most exciting new enhancements to Planning 11.1.2.3 is its new Predictive Planning tool. This new feature allows users to plot their projections alongside those created by Predictive Planning, giving users another data set against which they can compare their results. This live demo will walk users through the process of setting up Predictive Planning and will provide several real-world examples. The session will cover: - When to use Predictive Planning and when to avoid it - Basic statistical concepts used by Predictive Planning - How to best configure input forms for Predictive Planning - A walk through of the Predictive Planning user interface - Running predictions. - Using Comparison Views to review the results of various scenarios - How to tweak your results with filters and reports Users will leave this session with the tools, knowledge, and confidence to implement Predictive Planning in their own environments.

This session reveals a creative solution to implementing public sector planning at a large public higher education institution. This solution includes simplifying the standard configuration to plan workforce related expenses by employee and position, application integration, and report design.

As any developer knows, beginning development with a new technology can be scary and frustrating. We can spend full days looking for how to do a basic task that we know how to do with our eyes closed in our current development technology. This session will dive into the major features needed to build enterprise applications and explain how to do them using Oracle's ADF technology. The session will begin with an overview of the essential ADF components and how they map to the comparable Oracle Forms application components. Next the session will review common development needs and how they are accomplished in ADF (including common triggers, list of values, validations, master-detail canvas design, and more). The session will answer all your burning questions like: How do we make a post_query trigger in ADF? What is the equivalent of a canvas, block, etc. in ADF? The session will also cover basic integration and how to run Oracle Forms business logic from ADF applications. And of course show lots of demos! Attend this session if you're a developer that has seen a few ADF sessions or done a hands-on, but have yet to get started.

Hearing conflicting reports about the future of Oracle Forms? Do you get the feeling you MUST re-develop / migrate your Forms applications ASAP? This session will help set the record straight. Oracle Forms applications contain hundreds of man-years of investment; this session will present your options going forward. And answer the burning question - Can you squeeze a few more years out of your systems or do you need to migrate to a new technology today? And if you must migrate then which next generation development technology should you choose? Come to this session to meet with some of the leading Oracle Forms experts for an open Q&A about if, when, why, and how you should migrate, including the options, costs, risks, and benefits of migration from Oracle Forms. The presenters will do their best to represent all major development technologies including Java, Oracle ADF, Oracle APEX,.NET, or new third-party development tools.

How can we preserve our Oracle Forms investment while still achieving modern applications? This question will be answered in this session. As Today's IT landscape is moving to new cloud and mobile environments, organizations are looking to create modern applications, using cutting-edge technologies. Companies with large Forms investments are facing difficulties moving their legacy systems into the next generation. This session will provide Oracle Forms developers/managers with the essential information on preserving their Forms investment going forward. The session will explore how to extend your existing systems by modernizing and integrating them with Oracle's next generation technologies. The session will start with a review of the future of Oracle Forms, then discuss what we can do now; including upgrading to Forms 11g - WebLogic, UI modernization, incorporating Java/JavaScript, and creating and building integrated systems of Forms and ADF. The session will then review what's next with future considerations and third-party solutions for running Oracle Forms on the cloud and on mobile devices.

This presentation will show how the power of Forms applications can be combined with the ease of use and smooth user interface of Application Express. The evolution of applications to new technology without loosing past investments is one reason to integrate Forms and APEX, picking the best of both breeds is another.

Driving maps are useful in showing us where we are or in providing directions to desired destination. When maps are coupled with Business Analytics and Dashboards they provide a more complete picture of the data. They allow us to quickly see patterns based on geographical relationships that is not easily identified with tabular data alone. This session will cover the integration of spatial data within OBIEE and the use of maps on Dashboards.

Oracle has identified BI Publisher (BIP) as their strategic production/pixel-perfect reporting tool. BIP is embedded into over forty Oracle products for report output. Many customers with legacy reporting tools (i.e. Hyperion SQR, Hyperion Interactive Reporting, Oracle Reports) are now looking at BIP as the new tool in which to convert their current report catalog. This session will review capabilities of BIP and the flexibility it brings to report development by breaking out the data model from the report design template. The session will discuss strategies for data model development and tips for template design.

Daunted by the task of pulling all those Metadata, Data, and Smartlist files from your ERP system and loading them into PSPB? Attend this session to learn a methodical approach that groups the files into Milestones that can be validated after each is loaded.

This presentation offers an overview of the "Allocate Compensation to General Ledger" process within a PSPB Planning application, including key design factors for success and troubleshooting techniques. Attendees will learn where and how PSPB stores the data and allocation drivers before the allocation, where the data and descriptors are stored after the allocation, the best way to map the results to a line item or reporting cube, and how to push the data to another cube. Several tips and tricks will be presented, especially concerning troubleshooting, "idiot proofing" the smartlists and metadata, and designing for a streamlined mapping.

This informative session will share a customer story of implementing OBIEE 11g with Hyperion. Learn how Weatherford implemented OBIEE 11g with its current Hyperion applications including Essbase, HFM, Financial Reporting, and DRM. They will share lessons learned in implementing OBIEE 11g with an Essbase source and rolling out interactive web dashboarding to executives and management.

Come and hear how a European investment bank handles complex consolidation in a dynamic business environment. This session will cover the implementation of HFM (both the process and the technical setup) and how it was adopted by the organization. Come and hear details of their Metadata structure, how they linked these to their business users, and how they managed to connect internal and external reporting in the same application.

EPMA, the key tool in building and managing EPM Planning, Essbase, HFM, and HPCM applications is similar to many software tools with its strengths and its opportunity for tips and tricks. This presentation will show new and experienced users methods and approaches that will help guide implementations to keep your development on track and your sanity in check. This presentation will be based on the 11.1.2.3 version. * Sourcing through the interface tables * Managing shared dimension libraries * Batch client automation * Attribute dimension management * Migrating shared dimensions * Application deployment The session will also present an introduction and general guidelines for the EPMA Calculation Manager. This application is the replacement for the Hyperion Planning's Business Rules, starting in version 11.1.2.2. If you are using Planning or HFM in version 11.1.2.2, you will need to know how to use this tool. * Calculation Manager -- getting started * Calculation Manager -- reusable modules

Accuracy and reliability are critical components of building an agile Enterprise Planning process. Initiatives and Projects in lines of businesses have an impact on the financial plans. This session explains how the recently launched Project Financial Planning Application from the Oracle Hyperion Planning team helps lines of business (LOBS) within enterprises drive a goal oriented project planning process through an effective enterprise wide project based financial planning process.

PBCS takes the best of breed Hyperion Planning solution to the Cloud with a compelling offering for companies looking to lower TCO by deploying their applications on the Cloud using the top Planning solution in the market. This session will introduce participants to the upcoming Planning Cloud offering from Oracle. Participants will hear the details of the offering and get a sneak preview of Oracle's Planning on the Cloud offering.

The latest Release 11.1.2.3 of Oracle Hyperion Planning takes Enterprise Planning to the next level by providing some valuable agile enablers within Planning. This session will discuss and showcase some of these key features in this release, and provide several good considerations for customers to help choose this release as the go-to release for deployment and upgrade.

There is no best way to build BI systems and significant trade-offs exist. The BI gurus at Vlamis will compare and contrast alternative strategies for integrating different data sources into OBI systems and use scenarios to outline best practices and to evaluate the costs and ROI. They will talk about BI Apps and Fusion Apps and analytics, OBIEE and Endeca, Essbase and OLAP, Oracle Data Mining and Oracle R Enterprise, and Exalytics, Exadata, and Exalogic, and contrast the Oracle Database Appliance with the Oracle Big Data Appliance.

This session will review the cutting edge of analytics and explain how and why business intelligence performance is exponentially faster when you crunch your numbers inside the Oracle database.

HFM and FDM don't handle two significant aspects of your close process. This session will explore the new Hyperion Financial Close Management to determine how it can make your close calendar more dynamic to reduce the days you spend on closing the books each month. The session will also discuss how the new account reconciliation features in Financial Close Management 11.1.2.3 will even further reduce your validation time between your sub-ledgers and your consolidation systems.

If you own HFM & want to get quickly started with OBIEE, Oracle Financial Management Analytics (OFMA) is the answer you've been seeking. If you want to quickly disseminate financial data to the masses, give people better visibility into the close process, or if your executives are just begging to walk around with HFM information on their iPads, the pre-built dashboards in OFMA will provide a quick jumpstart to sharing finance and accounting data across the enterprise.

The FDM EE 11.1.2.3 release combines the deep functional flows of classic FDM with the deeply integrated technical aspects of ERP Integrator. This new solution allows customers to build deep integrations directly against popular ERP's like E-Business Suite, Peoplesoft and SAP while taking advantage of the functional workflow required in any end user driven data quality process. This session will deep dive into the changes that were made, how they benefit new and existing customers, and typical use cases across the EPM product family.

Agile, real-time enterprises need the ability to capture business changes and apply them with consistency and accuracy across transactional and analytical system silos. Oracle Data Relationship Governance provides the change management and data quality remediation workflows essential for front-line business users, subject matter experts and signing authorities. It enables them to collaboratively create, correct and conform master reference entities, attributes, relationships and mappingsso that they are fit for many alternate business purposes yet bound together by referential integrity. This ensures data quality, policy compliance, repeatable business processes, cross-functional collaboration and change awareness throughout the enterprise.

Did you know that Oracle has developed packaged solutions based on Hyperion Financial Management and the Financial Close Suite for issues ranging from Sustainability Reporting to Solvency II Insurance requirements. Come see and learn how the Close Suite has been used to deliver packaged content around specific business issues.

Everyone realizes that Hyperion users should be utilizing the built-in reporting tools, but how does the rest of your organization get their reports? Not everyone in your organization has Hyperion access. Learn from a Hyperion certified consultant how to harness the built-in power of Smart View VBA Functions to generate reports. This session will focus on how to develop and deliver reporting to the non-Hyperion user community in your organization utilizing your existing tools. Live examples and code will be used to explore solutions to many of the common reporting scenarios. Specific examples will display the benefit of the Smart View 11.1.2.3 multiple grid reporting and butterfly reporting functionality. This session will help you shave hours off of your daily, monthly, and quarterly reporting tasks.

Workflow and the Rolling Forecast are two very useful toolsets that are included in Oracle Hyperion Planning 11.1.2.3; however, most companies are not leveraging everything this functionality has to offer. This session will demonstrate the power of the built-in Workflow and Rolling Forecast functionality to help maximize your EPM investment. Attendees will see a demonstration of the toolsets, learn about best practices, and be given a tutorial on how to setup and utilize the pre-built functionality.

Application Express 5.0 introduces new region and item types. Learn about how these new capabilities will make it easier and more productive to build APEX applications in Application Express 5.0.

Build out Workflow from scratch * Setting up Workflow. Hierarchies and assigning to planning units * Workflow from end user perspective * Setting up Workflow across multiple dimensions * Validation rules and workflow * Administration tips for Workflow Build out Workflow from scratch * Setting up Workflow. Hierarchies and assigning to planning units * Workflow from end user perspective * Setting up Workflow across multiple dimensions * Validation rules and Workflow * Administration tips for Workflow

Create forms exploring various Tips and Tricks * Substitution variables for making forms dynamic adjust months/years represented * Rolling forecasts * Dynamic variables * Business rules to spread inputs based on user selected options -- 445, even, historically based * Using validation rules and formulas * Composite forms