viagra canada

Want to get the best out of your tools and technologies? Learn how to leverage ODIEE and get under the hood to get the job done in the best manner - how to push the envelope and embrace best practices. In this session, you will learn how to use ODIEE to load your data warehouse. Learn how to utilize common principles like partitioned loads, rationalize designs using inline SQL, and perform efficient complex transformations.

Service-oriented Architecture (SOA) provides great benefits by de-coupling applications; however, the challenge is to then have the ability to tune, perform, and scale. The success of SOA has led to diverse usage patterns which include mission critical applications for the enterprise. In this session, you will learn details on deploying the right products, Patterns, and Performance tuning best practices for Oracle SOA Suite.

viagra canada

In this presentation, Mike Ault, Oracle tuning expert, provides a guide to tools and good practices for SQL statement development. Using examples, the presentation will show the use of Oracle provided tools to help tune statements. Explain plan, tkprof, events, statspack, AWR, as well as other utilities will be discussed.

Automating Essbase tasks is a job every company wrestles with. It is often accomplished with shell scripts (or Perl scripts) and MaxL. But there is a better way. With Groovy (an extension of Java) the full power of the Essbase Java API can be accessed from a scripting environment. Even better, Groovy's features and dynamic typing make working with Java libraries simpler and easier. This session introduces Groovy and the JAPI, then uses them to perform common Essbase automations. Essbase administrators with automation needs and Java developers with Essbase interest will benefit from this session. You will see how Groovy tames the JAPI and delivers its power in an exciting, usable way.

viagra canada

DBMS_JOB was made available with Oracle 7.2 and has been superseded in 10g by the Oracle Scheduler. Oracle recommends that you switch from DBMS_JOB to Oracle Scheduler. This session will explore five Scheduler features that make the Oracle RDBMS the most powerful scheduling tool that has ever existed.

Calix, an industry leader in providing cutting-edge telecommunications equipment and management software, wanted to expand their leadership in the supply chain by more effectively managing both strategic and day-to-day aspects of manufacturing operations. Attend this session and learn how the company moved from a spreadsheet-based, labor-intensive system to a new, state-of-the-art performance management and cost modeling system that combines a number of technologies including an Oracle database, Oracle Data Integrator (ODI), Oracle Essbase, Dodeca, and OBIEE. Also learn how the new system gives Calix the information necessary to make informed decisions quickly and prioritize actions based on business impact, and thus, gives the company a competitive advantage by improving margins in their highly competitive industry.

viagra canada

viagra canada

Chris Barbieri, Oracle ACE for HFM presents an introduction to Calc Manager including HFM basic rules concepts. This session focuses on setting up Calc Manager and introduces users to the various features within Calc Manager through real examples of Sub Calculate. Join Chris for a second session where he covers advanced concepts including Sub Translate, NoInput, Dynamic, and Sub Consolidate rules.

viagra canada

Chris Barbieri, Oracle ACE for HFM presents advanced topics in HFM rules using Calc Manager. This session progresses from the Calc Manager introduction by adding Sub Translate, Dynamic, NoInput, and Consolidate rules, as well as troubleshooting techniques. The session also focuses on writing rules that optimize performance and reduce maintenance.

viagra canada

An often overlooked aspect of HFM implementations, Chris Barbieri provides attendees with a detailed discussion of how to implement security for any size organization. The discussion covers roles, classes, auditing configuration, and a review of the various reporting mechanisms.

“If you can do it in SQL, use SQL.” But sometimes even the very powerful version of SQL that Oracle provides is not enough and you need more, like loops, conditions, etc. If you can make the output of a function like it's a table, then you can use it in SQL and have access to all the power PL/SQL provides. After this session, you will know how to create functions that can be used as tables in SQL.

viagra canada

viagra canada

This session will include a survey of techniques to transfer data from Financial Management to Planning and/or Essbase. This will cover base data, eliminations, and journals. The following methods will be covered in detail: Traditional, Direct SQL in conjunction with Financial Data Quality Management, Performance Management Architect, and Essbase Analytics Link.

Most ADF applications interact with an (Oracle) RDBMS. It has been proven many times over that it really pays off to strike a good balance between ADF and Database - exploring which tool is best suited for which job and how the two can optimally leverage each other. This session discusses the various points of interaction between database and ADF and when to use which - for example Cursors, Types and Collections, XML as well as interaction via HTTP. The session will focus on ADF BC but will mention JPA and plain JDBC as well. It also highlights some special database features - hierarchical query, flashback, result cache, View with Instead Of Trigger, Analytical Functions - that ADF applications can leverage or should employ - security, database tracing, cache refresh through DB Query ResultSet Change Notification, constraints, and exception handling. Attendees learn what the database can do for their ADF application. They will be able to make better design decisions about how to implement functionality, which tier(s) to use, and how they can best work together.

viagra canada

This session is A Forms Modernization Story Featuring JHeadstart Forms2ADF. It talks about considerations to make when you are about to decide whether or not to leave Forms and go for ADF. You will see the process of conversion step by step starting with the business case and ending at the new ADF application. You will hear about issues you run into when using Forms2ADF for automated conversion and you will get hints on how to use Forms2ADF.

People these days are used to graphical and interactive user interfaces. They really want (and need) their data to be displayed in fancy dashboards so they have instant insight in their business. This session is all about clarifying data by means of ADF Data Visualization Components. Based on a fictional dot com company, you will learn how to present your data in a different way and recognize when and how to use DVT components for data analysis. From pretty straightforward usage of gauges, graphs, and maps, to more sophisticated features like time selectors, drill down functionality, data manipulation in DVT, and real time update via server push. And finally, this will all come together in a fancy interactive dashboard.

viagra canada

This presentation will look at a variety of different features from APEX 4. Paul will show some tips and tricks that have helped him. He will go through some mistakes he made and how he rectified them. Paul hopes to teach people additional skills and pass on some useful information that they can include in future applications they build.

This presentation is going back to the basics to outline various parts of an APEX page. It looks at sequences, branches, and navigating between pages. It will show how having items organized in the wrong sequence can affect how a page works.

Agile project management methodologies are driven by user stories, which describe verifiable end-user functionality that can be delivered in a short amount of time. But traditional data warehousing projects struggle to deliver completed user stories because of all the moving parts: data modeling, ETL, and front-end development. Implementing the logical modeling capabilities of OBIEE 11viagra canada on top of the Oracle Exadata Database Machine provides a combination of flexibility and performance that can drive the completion of user stories in the timeframes required in Agile projects.

Learn how OBIEE11g Answers is replacing Hyperion Web Analysis.

viagra canada

Tight tabular forms don't just happen, you have to work for them. Tabular forms are ideal for entering and editing many rows of data quickly, but adding validations to those forms to enforce real-life business rules is not always as simple as it should be. This presentation covers how to tighten down your APEX tabular forms with item, row, and form-level validations that are not disruptive to a user's data entry flow. The presentation will cover the new tabular form features in APEX 4.0, how they help, where they fall short, and demonstrate how to supplement what APEX 4.0 provides to meet your more complex requirements.

APEX 4.0 introduces maps, Gantt charts, and improved charting capabilities. Great, but how do I make meaningful use of these new features in my applications? This session is a deep dive into practical adoption of maps, Gantts, and charts in your current and future applications, touching on additional APEX 4.0 new features along the way. Learn to readily incorporate maps, Gantts, and charts in your applications - to knock their sox off.

We spend a great deal of time creating intelligence around the data generated by our enterprises, but neglecting the data being generated by the systems in which we manage. Utilizing usage tracking, we can gain insight into the Who, What, Where, When, and Why in regards to reporting and analysis. Usage tracking provides system administrators the ability to track application performance and provide a view of the information end users are consuming. This presentation will cover implementing usage tracking and provide multiple concrete ways in which companies can use this information to drive improvement in the reporting environment.

Team Development was added to Oracle Application Express (APEX) in Version 4.0. Team Development captures Features, To Dos, Milestones, and Bugs. Feedback from all hands-on stakeholders (including end users) is captured by the Feedback feature that can be installed declaratively in one or two minutes. This presentation describes Team Development, shows how it can be configured to work successfully with an Agile Software Development methodology, and compares Team Development with conventional Project Management tools. The presentation's goals are to help the audience decide whether or not to use Team Development and, if they decide to use it, give insights as to how it can be integrated into their Project Management culture.

This session shows the process of identifying and resolving the most common SQL execution performance problems including, poor cardinality estimations, wrong access method being used, and much more. With clear how-to examples, you will learn how the Optimizer determines an execution plan, from the types of statistics it looks at, to the formulas it uses to calculate the cardinality estimates for each operation in the plan. By understanding how the Optimizer thinks, you will be able to determine if the execution plan you are looking at is the best plan you could get and, if not, why the Optimizer got it wrong. By applying some of the simple procedures explained in this session, you will be able to quickly resolve these issues without the necessity of Optimizer hints or messing with initialization parameters.

The execution plan for a SQL statement can often seem complicated and hard to understand. Determining if the execution plan you are looking at is the best plan you could get, or attempting to improve a poorly performing execution plan, can be a daunting task even for the most experience DBA or developer. This session examines the different aspects of an execution plan, from selectivity to parallel execution and explains what information you should be gleaming from the plan and how it affects the execution. It offers insight into what caused the Optimizer to make the decision it did as well as a set of corrective measures that can be used to improve each aspect of the plan.

Within the past year, there has been an increase in clients asking about migrating to SmartView from Essbase Excel Add-In in regards to usage and VBA code migration. When describing the process to them, I tell them that it is similar to Basic Training: The process is hard and difficult at first, but the growing pains will pay off in the end. There will be new features to learn, old features to let die and some powerful new options and tools that could revolutionize your company's reporting capabilities.

viagra canada

In the debates between traditional SDLC (waterfall) proponents and their Agile counterparts, probably the biggest hinge point is the question of database design. Agile practitioners value working software over comprehensive documentation and responding to change over following a plan. Is Agile, then, the enemy of proper design? What does honoring these values mean to the data design process? This session considers questions like: What is a data design? Do you really need one? Why? Who creates it? When? What's the best format for it? What tools are good for managing it? Can the data design be changed? How? How often? By whom? How do you keep a data design document in sync with your implementation?

The presentation shows how spatial data can be used in APEX applications using Oracle Spatial and Oracle MAPS technology.

viagra canadaviagra canada

This presentation will demonstrate how to leverage the APEX dictionary, along with existing plug-ins, to enhance your APEX applications. It will include how to automate monitoring of your application, improve testing capabilities, improve development time, and provide some tweaks to enhance end-user experience.

viagra canada

HTML 5 consists of many new features which will make developers’ jobs a lot easier and improve end-user experience. HTML 5 is currently under development but many browsers already support some of its features. APEX developers should be aware of these enhancements. This presentation will highlight some of the HTML 5 features and how to integrate them with your APEX application to produce stunning results.

If well-designed, ADF Task Flows are self-contained reusable UI services, with a clearly defined contract. In this presentation, Steven will explain step-by-step how you can create highly reusable and configurable ADF Task flows. He will explain and demonstrate how to build one taskflow that is used for data entry, for lookup in a popup window, for deeplinking from other taskflows or external sources like e-mail, as a master taskflow as well as a detail taskflow. After this session you will understand how you can dramatically reduce the number of pages and taskflows you need to build in your application.

Come and learn how Oracle JHeadstart R11 can help you in building enterprise-class ADF Web applications that leverage powerful ADF 11 features like page templates, dynamic tabs, page fragments, (un)bounded taskflows, XML-driven menus, model-based List of Values, and all the new rich user interface elements. You will learn how JHeadstart can save you months of development time by providing a set of sophisticated reusable components and by automating ADF development tasks through powerful utilities and generators. During the presentation, many best practices are discussed, and Steven will demonstrate how these best practices are auto-implemented for you when using JHeadstart.

In this hands-on session you will built a best-practice ADF web application based on 6 tables of the Oracle HR schema, that includes rich functionality like quick and advanced search, a wizard, a shuttle picker, a tree control, validation using list of values, conditionally dependent items, a graph, deeplinking and more.
You don't need to have any prior knowledge of Oracle ADF. Only prerequisite is that you bring your own laptop with a database installed, either Oracle XE, or enterpise edition.
We will be using JDeveloper 11.1.1.4, which we will install during the hands-on if you don't have it installed yet. The JHeadstart software will also be provided.

In this hands-on session you will built a best-practice ADF web application based on 6 tables of the Oracle HR schema, that includes rich functionality like quick and advanced search, a wizard, a shuttle picker, a tree control, validation using list of values, conditionally dependent items, a graph, deeplinking and more.
You don't need to have any prior knowledge of Oracle ADF. Only prerequisite is that you bring your own laptop with a database installed, either Oracle XE, or enterpise edition.
We will be using JDeveloper 11.1.1.4, which we will install during the hands-on if you don't have it installed yet. The JHeadstart software will also be provided.

They all were built with APEX and they all are used in businesses around the globe: MT AG’s four professional open source solutions based on APEX, downloadable from www.apexsolutions.info. In this session, their open source applications, Time Management System, Questionnaire, Database Control, and Translation Management System will be explained, both from a business perspective as well as from a technical perspective.

Within four months, the APEX team @ MT AG has migrated 160 dialogs from both MS Access as well as Oracle Forms to APEX. Learn in this session why their customers chose APEX, how they realized it and what experiences they had. Does APEX really have what it takes to handle such migrations?

This presentation starts by demonstrating an employee portal based on WebCenter Spaces that provides relevant company information stored in SAP, Microsoft, and Oracle. Next, we take a look into the various implementation techniques used to get the information displayed in the portal. For instance, see how you can integrate Microsoft Sharepoint in WebCenter Spaces, utilize the Portlet technology to get non-ADF-based programs integrated, and how to integrate an ADF Task Flow exposed as a Portlet using the ADF Portlet Bridge. Our next topic focuses on the wiring of information pieces within the portal. Learn how you can achieve inter-component communication by utilizing features of the WSRP 2.0 specification or by using contextual events to make the portal context-aware and more productive for the end user.

This presentation will show you how good data models are made and how SQL Developer Data Modeler 3.0 can help you succeed even large data modeling tasks with hundreds of business terms that need to be defined and structured. The presentation will include data modeling theory as well as specific tool features such as diagram features, model metadata, the glossary editor, and the reporting schema export tool.

This presentation will show you how the presenter has used the Reporting Schema for much more than simple reporting. By applying a little bit of intelligent PL/SQL, you can turn your data models into natural language descriptions of your business architecture, business terminology definitions, and even integrate your model descriptions and definitions into the online help of your APEX 4.0 applications.
After seeing this you will know that data modeling (using SQL Developer Data Modeler 3.0) is certainly worth every minute you invest in it!

Experts in BI and EPM answer your questions and discuss important BI issues.

What is this thing called MaxL (and why the funny capitalization)? All will be revealed through practical code samples and interactive examples that show why MaxL is an essential Essbase tool. You will see: the many ways to invoke MaxL, driving MaxL scripts via the OS shell, Essbase database manipulation with error checking, encryption, script nesting, and logging.

How do you shorten and enhance the performance feedback loop from DBAs to developers and back? How can you achieve this enhancement without sacrificing quality? This presentation will show you how to adapt your development processes and database development tools in ways that truly make your performance feedback loop a racetrack. Examples using TOAD, SQL Developer, SQL*Plus, and SCM tools like Subversion will be discussed along with common development and DBA roles on development projects.

The data warehouse space is always evolving. This session will explore the usage of in-memory technologies to speed up the data warehouse. As of Oracle Database 11g Release 2, Oracle provides transparent technology to leverage the aggregate memory in a clustered system. You will learn a number of things by attending this session. First you will get a general idea of the benefits or in-memory processing and then dive into how to leverage the in-memory parallel processing capabilities of the Oracle Database. The session will look under the hood and explain how and when we use in-memory parallel execution and what the benefits for your system can be.

In today's world, you as a DBA will need to understand how to run your statements in parallel to achieve acceptable performance for all users. On top of that, you will deal with more and more users wanting faster execution times on larger data sets. This session will address these hot topics by discussing how you manage an Oracle system to achieve optimal parallelism, good workload management, and drive excellent query performance of your systems, without excessive tuning. This session will cover some of the latest features in Oracle Database 11g Release 2, like Automatic Degree of Parallelism, resource manager statement queuing, and in-memory parallel execution and how to use them.

viagra canada

Abstract coming soon.

viagra canada

viagra canada

SOA developers typically need to deploy their applications to multiple environments during different development cycles. The most common environments are development, test (sometimes QA), and production. Oracle 10g suite does not have a coherent support for platform migration. 11g recommended practice is to use composite deployment configuration plans to migrate from platform to platform. The presenter has used several different approaches in his practice. He has categorized these approaches into three categories: deployment plan file (11g), DNS manipulation, and ad hoc solution. This presentation will explore these approaches and provide some comparisons and recommendations.

This session will explain how to make SOA components unbreakable. The presenter will explain different transaction scenarios and use of exceptions and exception policy framework in 11g SOA components.

A user's view of an application is formed largely on their experience using that application and the performance of an application makes up a large part of that experience. Performance testing is an important part of any Oracle EPM deployment which is often either neglected or not executed properly. In order for performance testing to be effective it is critical that it be done properly. This means following some key concepts as it relates to performance testing and modeling the correct mix of transactions in different scenarios. This presentation will cover the key concepts of performance testing & discuss utilizing these concepts as it relates to an Oracle EPM implementation.

The process of troubleshooting Oracle EPM 11 has changed how administrators manage and support their environment. The introduction of common logging frameworks and Oracle Diagnostics give administrators powerful tools and information to deal with issues. The details on the where and what of Oracle EPM logging and troubleshooting will be reviewed. In addition, information will be given on how to utilize online resources such as Oracle’s knowledge base will be discussed. Finally, information on the Oracle Diagnostics tools will be reviewed with how to implement them in an Oracle EPM 11 environment.

Oracle Business Intelligence Publisher (formerly Oracle XML Publisher) is Oracle's strategic enterprise reporting solution for authoring, managing, and delivering all types of highly formatted documents for over thirty Oracle Applications and Products. This session covers best practices for BI Publisher including system configuration settings, optimizing data model design, tips, and tricks of building layouts, and bursting. Learn how you can optimize your investment to create a high performance reporting environment.

viagra canada

viagra canada

You've all heard the Essbase v9.x ASO Planning and Forecasting solution before: do your planning and forecasting in a BSO cube, and import or partition to your ASO cube. Well what happens if you have too much data for Planning and Forecasting to function in a v9.x BSO cube? Are you just out of luck? The answer is NO!
Come hear how the world's largest retailer and the world's best Oracle consulting company were able to use MDX outline formulas and Report Script data exports and imports to build a 20Gb+, ASO planning and forecasting cube. In just FOUR WEEKS! It wasn't easy. But it CAN be done!

Oracle Business Intelligence introduced a new API for enabling systems management with programmatic and scripting capabilities in conjunction with JMX and the WebLogic Server scripting tool. This session will provide a detailed introduction to the available functionality and benefits of creating scripts for these tasks. There will be detailed demonstrations and examples of Python scripts to monitor key metrics in an Oracle BI system in addition to hints and tips for using WebLogic console.

If your company has a data warehouse or is thinking of building one, come to this presentation to learn how Oracle EPM System, Fusion Edition (including the products formerly known as Hyperion) helps drive value from your warehouse solution.  Understand the benefit of Essbase and OBIEE+ and how they fit into your overall information delivery platform. Learn about how Essbase and the Oracle technologies combine to provide seamless integration between your applications, relational databases, and multi-dimensional databases. This session will show how the OBIEE+ Reporting and Analysis components provide a single interface into any type of data source, combining data from your data warehouse and data marts into nicely formatted reports, user friendly dashboards, and easy-to-use analytic screens. Join us for this informative session to learn the best way to build a warehouse for integration with Oracle EPM System, and how to get information out of your warehouse if you've already built one.

This presentation will provide tips and tricks on how to do things in Answers that it doesn't do well or not at all. Also, it will highlight a few things a user can do when creating a report that they don't know about but might help them in their development. This presentation will be beneficial for users who are just learning to use Answers or have limited experience with it. Scott has been using it for four years and has picked up many things along the way that have helped him to build reports faster and more efficiently.

All too often, SOA Suite and databases are perceived as two different worlds. There’s the realm of the Oracle SOA Suite, where everything revolves around technologies like Web Services, XML, and BPEL. And there’s your databases, containing your company’s data and business logic in tables, views, and PL/SQL logic. Luckily, the Oracle SOA Suite ships with a powerful set of “Technology Adapters,” as well as various other technologies that successfully bridge the gap between SOA Suite components such as BPEL, Mediator and the Oracle Service Bus, and your databases – allowing you to reuse your existing database logic when moving to a Service Oriented Architecture. From the Database Adapter to SDO, and from AQ to Native Database Webservices, this presentation will provide a thorough overview of the techniques and technologies that deliver the data and logic in your database straight into the SOA Suite.

Service Oriented Architecture is no longer a hype or something that will “blow over.” In an ever increasing pace, it is shaping the way companies and governments are collaborating, by exchanging data and invoking and exposing business services. One of the most important reasons for the success of SOA is the fact that it is based on open standards, allowing heterogeneous systems to communicate regardless of operating systems and programming languages. However, these standards come with their fair share of acronyms, buzzwords, and concepts, that can be quite daunting if this is not your everyday cup of tea. This session will brush up your knowledge about important SOA standards such as WSDL, BPEL, XSD, and many more. With comprehensive examples and demos using the Oracle SOA Suite, the proper application and usefulness of these standards will be demonstrated, and their underlying concepts explained. Don’t miss this chance to get up-to-speed!

viagra canada

viagra canada

viagra canada

The presentation analyzes the EPM solution for a mid-sized global high tech manufacturing company which features the integration of Essbase Studio, EPMA –deployed planning application with integration with relational data sources, and ODI. First, the session will start off with an overview of the client’s requirements and pre-implementation IT architecture. Then, the session will reveal the architecture for the reporting and planning solution, including Oracle EPM technologies incorporated, data sources, and data integrations. The session will discuss overcoming design and implementation challenges, including producing an automated solution for hierarchy and dimension maintenance from a data source where parent-child relationships are virtually none existent. The session will deconstruct the Essbase Studio configuration and provide helpful tips and tricks to use in your Essbase Studio deployments.

viagra canada

viagra canada

viagra canada

Customers require Java EE applications to be adaptable to changing business needs, using customizations that can be maintained easily. Whether your business users need to change the layout of your pages, populate your pages with content, portlets, and task flows, or setup inter-portlet communication, Oracle Composer is the tool for them.
This session will discuss how developers can build highly customizable applications, as well as how Oracle Fusion Applications are integrated with Oracle WebCenter Composer, Oracle WebCenter Composer extensions, and Oracle Metadata Services to provide the adaptability customers need.

viagra canada

viagra canada

This is a presentation about legacy Oracle Forms applications and a seemingly impossible way to modern technologies. Sure you can throw your application away, spend a lot of money, and repeat the same mistakes again. If you are inexperienced in the chosen technology, you end up with endless iteration until the new application meets the same business requirements as your old application did.  But is there a way without throwing away all the assets and business logic you have developed? Like taking a step by step "phased" approach to evolve your current application in a modern, open architecture with a state-of-the-art user interface like a caterpillar to a butterfly. Join this session to learn how a step by step approach could change the old legacy application to a new modern cloud technology based application - from legacy to cloud.

In 2010, Hypertherm began the process of migrating its internal tools from Excel, Access, Portal, and htp.print() to APEX, integrating it with the existing E-Business Suite installation, as well as the data warehouse and CRM databases. This presentation will cover the successes, rough spots, and lessons learned throughout the migration process.

With 4.0, the APEX APIs have been extended quite significantly. Consider this presentation your guided tour through the APIs with a flavor of where they might be used. This session will even try to cover some of the lesser known and under-documented Public APIs.

This presentation introduces the attendee to the new features of debug in APEX 4.0 and guides them through how to use the information to identify programmatic and performance problems. It also introduces the attendee to the underlying data and the APIs that APEX makes available.

Many times while developing APEX applications, you find yourself solving a problem and implementing the solution over and over. The APEX 4 plugin architecture gives you the tools to encapsulate the solution and reuse it. This presentation takes the requirement of presenting multiple SparkLine charts on a page and walks the attendee through the steps of implementing a plugin to encapsulate all the logic so that it can be reused with very little effort. Attendees will walk away with a better understanding of the process of creating a plugin from scratch.

This presentation will show you how you can build amazing Web applications. First the session will raise the bar high for what constitutes an amazing application and then the session will rise over it with PL/SQL and JavaScript. The presentation will argue that any further Web development must be done using AJAX only. The session will discuss the challenges to achieve 100 percent AJAX applications and provide solutions to them. The participants will learn how they can take advantage of the many freely available JavaScript libraries such as Dojo and YUI, and control them from PL/SQL to build 100 percent AJAX-based Web applications.

Almost all ASO databases will require some degree of aggregation to achieve acceptable query performance, but - just as with BSO - there is a trade-off between 'calculation' and retrieval times. Selecting the right set of aggregate views within processing window constraints is therefore critical to the end-user experience. This session will begin with a review of the fundamentals of ASO aggregation, then cover the features available to make the view selection process more intelligent. Some more advanced and non-obvious techniques to maximize control over which aggregate views are selected will be described in detail, along with a number of ASO aggregation 'tips and tricks' not covered by the Administrator's Guide. Finally, a real world approach to tackling any given ASO aggregation design problem will be presented.

Anyone who has spent time working with Essbase will have experienced the frustration of a calculation script that 'looks just fine', but refuses to produce the correct results. This presentation will address some of the more subtle but perennial problems that catch even experienced developers out. Beginning with a review of the fundamentals of the Essbase calculation process, parallel calculation, various 'mode' options, configuration settings and calculation commands will be discussed in detail. Problems of block creation and calculation order will be addressed, and the pros and cons of various potential solutions evaluated. Attention will be paid throughout to getting code working without sacrificing performance.

The objective of the session is for Essbase developers to gain a more thorough understanding of the calculation engine in order to avoid 'classic' real-world pitfalls.

viagra canada

viagra canada

viagra canada

Oracle's Public Sector Planning module represents a new direction for Oracle Planning applications. It is intended as a complete out-of-the-box solution requiring little or no customization from consultants or administrators. This presentation details how expectations by the customer, the Planning consultants and even Oracle evolved over time as we all got acquainted with the 1.0 release of a product.

viagra canada

You keep hearing about Application Express as the popularity of this tool continues to grow. 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 is based on APEX 4.0 and all of the brilliant new features that make development even easier and more productive.

SQL Developer provides database developers with a powerful tool for database tasks. This session is an overview of all Oracle SQL Developer offers focusing on the latest features. Without drilling to every feature, the session focuses on new features such as the new visual query builder and support for DBMS Scheduler. The session will look at the introduction of DBA-related functionality, such as DB Controls, and the addition of support for roles and tablespaces. The session also reviews other features including the updated SQL Worksheet, enhanced Data Grid support, and ongoing additions and updates to existing functionality.

Oracle SQL Developer Data Modeler is a feature-rich product supporting logical, relational, physical, multi-dimensional, data type, and data flow models. The latest release is tightly integrated with the open source, source code control software, Subversion, allowing users to track changes to models and objects. The session demonstrates the support for collaborative development through this Subversion integration. SQL Developer Data Modeler 3.0 includes a number of other new features including the ability to create user defined design rules and transformation scripts. These and other new features will be demonstrated in this session.

Oracle SQL Developer Data Modeler is a feature-rich product supporting logical, relational, physical, multi-dimensional, data type, and data flow models. Database design and generation can start with a blank page and users start by building a new ERD. In today’s development environments, much development starts with an existing data model. This session reverse engineers an existing data model, makes changes to the model, compares and merges changes, and updates the database with those changes. In the process, it also looks at the utilities offered by the Data Modeler for verifying the design through design rules and by applying transformation scripts.

viagra canada

viagra canada

viagra canada

Mission Critical implementations of the Hyperion Enterprise Performance Suite are becoming more commonplace. As corporations are turning to global integration and follow-the-sun real time analytics, Hyperion applications must accommodate thousands of users 24x7. Join Oracle ACE Director Eric Helmer as he dissects larger Hyperion implementations and strategies to achieving a global, highly available enterprise. Learn how many Fortune 500 companies achieve world class availability through clustering and failover techniques, disaster recovery procedures, load balancing, and virtual machines.

Hyperion Planning is great for financial plans. However, it lacks many features necessary for operational planners. A large consumer goods company has implemented a solution combining Oracle Hyperion Planning with Oracle Integrated Operational Planning. This session will discuss this solution and how the two systems interact. The solution provides the ability to create customer, product, and plant profit and loss statements with the ability to drill to a full level of detail behind the cost of goods sold. The solution also provides operational planners the ability to do what-if analysis on commodities, and plan plant labor and loading. The solution manages over 15,000 products and an equal number of customers. It has allowed the company to create more detailed forecasts for products, customers, and plants and provides a platform for more detailed analysis profitability for each of those segments with dramatically less effort than was required previously. Technical solutions will be discussed regarding reporting, metadata management, data movement between the tools, and the overall forecasting process.

The creation of summary charts and graphs consumes great quantities of time for financial analysts working with EPM systems. Smart View provides the capability to create these presentations in PowerPoint and allows an analyst to update them with the latest data from the source system with no need to recreate the charts and graphs. This reduces the cycle time from days to minutes and frees up time for analysts to do higher value work. The creation of these books is not a well-documented process and unfortunately many companies are not utilizing this capability. This presentation is intended to demystify the process of creating and managing these presentations. System roles necessary for the creation, management, and usage of these presentations will be discussed. The usage of Hyperion Financial Reporting objects will be demonstrated from creation through publication. The usage of Smartslices in such presentations will also be discussed. Pulling data from multiple EPM systems (Planning, Essbase, and HFM) will be discussed and demonstrated.

Essbase Studio was introduced in EPM Fusion Edition 11 as a replacement for Essbase integration Services(EIS). Learn what it is and how it works to create Essbase databases from multiple data sources. This session takes you through the creation of an Essbase cube from source to deployment. The session also covers the differences between various products used to build and load Essbase cubes. Throughout the presentation, tips and tricks will be presented.

viagra canada

This talk is an introduction to the MySQL database, particularly for Oracle professionals. Patrick will give an overview of its architecture and concepts. He will describe and demonstrate many MySQL administrative tasks, including installation, database creation, backup, and recovery. Patrick will finish by showing how relatively easy it is to set up replication between two MySQL databases.

This session covers and demonstrates MapViewer and OBIEE 11g Integration, the enhancements over OBIEE 10g Integration – capability to import themes, tile layers, styles into OBIEE catalog via presentation services admin tool, ability to provide mapping between BI metadata and Mapviewer metadata, and ability to provide layer ordering and zoom levels on maps. This session will also cover a real life use-case from a client site implementation of Mapviewer and OBIEE 10g integration and pros and cons (for this particular use case) of OBIEE 11g style integration.

See how General Dynamics benefits with their new profitability product – HPCM. Understanding profitability and cost in your business is fundamental to improving performance. Observe how General Dynamics faced many challenges of large allocations, identification of stages of allocations, and creation of allocations. Hear best practices on how they were successful, and learn some key lessons on their implementation success with a demonstration of how they are using the product in their environment.

viagra canada

viagra canada

viagra canada

This presentation is a case-study in the design, development, and deployment of an OBIEE Business Intelligence solution across Multi-Network Domains for the U.S. Army. The Business Intelligence application provides current and predictive analysis on multiple military units which have significant organizational dependencies. Challenges dealing with Common Interface Schema, Authoritative Data Sources, data cleansing and load using the OWB ETL tool, Inter-network data calls, and selection of appropriate Oracle software tools are covered. Development of a Common Semantic Layer and unification of data schemas will be addressed in the context of development using the OBIEE Business Intelligence tool.

This presentation will cover how to address complex ownership structure, equity pickup, non-controlling interest, and organization structure changes using Oracle Hyperion Financial Management.

viagra canada

viagra canada

Financial Close Management is an end user focused application built on Oracle's SOA Suite. While Oracle provides out-of-the-box integrations for several of our financial EPM modules, developers can create custom integrations of their own. In this session, the presenter will walk through the construction of a custom integration.

PL/SQL is Oracle’s procedural extension to SQL, and it is a true 3GL programming language. It was first introduced way back in version 6 of the database, giving us the ability to code “anonymous blocks” in our client applications and submit them for processing on the database. In Oracle 6, there were no stored procedures, no packages, and no triggers. The ability to store PL/SQL in the database came with version 7 in 1992.

Today, PL/SQL is competent, mature, and full-featured, offering everything you expect to find in a 3GL programming language. This session will look at why you should be using PL/SQL in your applications and cover the most important programming techniques that provide efficient, high-performance PL/SQL code.

This session will briefly overview why binding is extremely important with regards to performance, scalability, and even security, but quickly move into topics such as: Do I always want to bind? (Surprisingly, the answer is no.) What is bind variable peeking? Is it good or evil in disguise or a bit of both? And how does this adaptive cursor sharing thing work?

Oracle Tech Support will be on hand to answer your burning EPM questions.

viagra canada

A panel discussion with Oracle leaders in the EPM/BI development, Product Management and Strategy.  Attendees will be able to ask questions of the panel across a wide range of topics.

Essbase (ASO) Aggregate Storage Option cubes are changing the Analytical landscape. Oracle now recommends ASO as the primary cube technology for both new, replacement, and enhanced hybrid analytical application designs. Many ASO solutions are simply migrated designs of BSO applications. And many developers are not exploring the full capabilities of ASO, including read/write. Learn advanced techniques in Essbase ASO through the use of MDX, MaxL and creative Outline design. Use MDX to create complex calculations for near-real time performance. Learn how to use MaxL to perform a variety of critical production tasks like clearing data, building aggregations, and storing calculations rather than depending on queries alone. Take advantage of the power of an ASO outline for improving performance and for complex calculations.

Abstract coming soon.

Inflexible users? Ever heard, “but we did that in Forms?” One of the frequently requested Forms features is the multi-return List of Values. You know, the one with multiple columns in the select list that returns values not only to the select item but to several other page items? APEX’s new plug-ins allow you to add, as native functionality, features that normally are not available. Once created, plug-ins can be used in any application and are added to pages through the normal wizard process. This presentation will take an in-depth look at all the pieces needed to implement this Forms functionality in an APEX item plug-in. This will include all the PL/SQL API packages, the integration of JavaScript files, using standard and custom attributes, and much more. At the conclusion, you will have everything you need to implement this plug-in and enough knowledge to start creating your own plug-ins.

Companies running Oracle Financials have the same reporting challenges. They need to develop a method to reference account and cost center structure into ‘cost type’ accounts, which is used to prepare their financial statements. Additional complexity is added when these financial statements are required to be prepared in various ‘views’, i.e. Internal, Tax, and Audit. As an Essbase solution, the above can be met by embedding mapping logic into calculation scripts though it’s difficult to maintain by business users. This presentation introduces a framework based on Oracle/Hyperion technology that’ll not only address Oracle Financials’ reporting challenges, but also provide business users direct/easy access to maintain ‘cost type’ references. It further expands Essbase’s analytic capability by supporting drill-through to all ‘cost type’ accounts and views.

Oracle Corporation's bug database is mission-critical. Its own engineers, support staff, and managers, and also its customers, depend on its 24/7 availability. Our BugDB has tables, views, synonyms, PL/SQL units of all kinds, and objects of other types. There is always pressure to change these to correct minor problems and to bring new functionality. Historically, such changes have been bundled into planned quarterly outages. Edition-based redefinition (a.k.a. EBR), new in Oracle Database 11g Release 2, has changed the game. BugDB is now live on 11.2 and EBR has been used to make several incremental functionality enhancements, as soon as each is ready, without interrupting availability. This session describes how this was done.

viagra canada

The increasing integration of performance management technologies (PMT) applications into ERP platforms is providing organizations and their tax departments new ways to monitor, measure, and manage business performance. PMT applications such as Oracle's Hyperion Financial Management (HFM), Oracle Hyperion Financial Close Management, Oracle Hyperion Disclosure Management, and various tax tools have provided tax departments new opportunities to enhance the quality of data tax departments now receive. These enhancements can be accomplished without a complete re-implementation or upgrade of an ERP system, leaving the systems required for management reporting intact.

So you decided to make the move…upgrade your Planning application to EPMA. Or you’re a diehard Planning Classic implementer about to embark into the unchartered EPMA frontier. The presenter will take the guess work away from you and save you hours of rework and navigating aimlessly in the EPMA black hole. In sixty minutes, you’ll be armed with all of the ins and outs of deploying an EPMA Planning application, including navigating through “oh those quirky features.” This session will demystify all those Planning features that escaped the Classic Administration Menu, and found its new home in the EPMA Dimension library. Further enhance your deployment using interface tables and the EPMA batch client. Dodge the trials and pains of the transition and accelerate your deployment.

This presentation demonstrates how to consume a Java embedded BPEL API process using Oracle APEX. The demonstration includes creating a BPEL administration process with a Java embedded activity, calling a BPEL Java API, and creating an Oracle APEX region based on the BPEL utility process wsdl.

This will be a discussion about techniques for translating business requirements into APEX Applications based on case studies. As an APEX Developer, it is useful to have skills that will help you conceptualize APEX applications from business requirements or current processes. For example, learn how in some cases, reducing multiple instances of spreadsheets and databases into one APEX application helps to increase productivity and efficiency. This and many other techniques will be openly discussed. After this session, you will be armed and dangerous to tackle real world Enterprise level development with APEX.

Have you always wanted/needed to know what was going on behind the scenes in Planning but were afraid to dive into the SQL tables? Do you wish Planning made information more readily available then navigating through the web interface? Master Plan is your ticket to that information, no digging required. This presentation will show you how to use packaged reports to get the Planning information you always wanted but couldn’t get such as metadata extracts, users, security, and individual planning objects.

Learn about the new method of loading data and dimensions: ODI (Oracle Data Integrator).

The Metadata Load Utility is a configurable tool used to load dimensions and exchange rate data into Planning. The tool is a viable alternative to using ODI as it can be configured to run by scheduled batch, and can be encrypted. By the end of the presentation, the user will have ready to use scripts that can be used and easily configured to load metadata into any System 11 Classic Planning Application. Since HAL (Hyperion Application Link) has been discontinued, there have not been many options for loading of metadata. ODI is one option, but for just about all applications, metadata can more easily be uploaded using this utility. For EPMA applications, the ADS file process will be shown, and the process for integrating with Interface tables will be explained.

viagra canada

viagra canada

This session aims to introduce the concept of collections and walk through some of the most helpful use cases for using them. Using the APEX-specific examples of a shopping cart, interactive reports with dynamic SQL, and running saved queries, the audience should leave the session feeling comfortable using collections in various scenarios.  Although this session will contain demonstrations, the more important goal is to expose the audience to the potential uses of collections even beyond the proverbial shopping cart. The examples of running saved queries and interactive reports are two such uses of collections, and time-allowing, the session will explain the use of collections to perform complex tabular form validations.

viagra canada

This presentation will discuss the hands-on challenges faced and the experience gained during the process of migrating several of an international organization's large, core systems to a single Oracle application using Application Express.

viagra canada

Manual tabular forms in APEX are often considered difficult to create, but with a solid methodology, they can be much easier than one thinks.

viagra canada

viagra canada

With the advancements in cell phones and mobile computing, information originating from the internet is now available to people anytime, anywhere. Companies are now exploring ways in which they can make their internal business information available to their employees at locations other than a desktop computer in a cubicle or office. This presentation will cover multiple concrete ways in which companies can combine Oracle Business Intelligence Enterprise Edition (OBIEE) with mobile computing solutions like the iPad and iPhone to deliver insightful information to users anytime, anywhere.

viagra canada

viagra canada

Nervous about changing the underlying relational tables? Updating the validatedata.jsp page? Never fear! This session will come to your rescue. This session will show you the supported ways to meet some of your requirements that don't require Web developing or DBA skill sets. While this may be the anti-Kscope presentation,  these topics will help you deliver the best possible Planning solution to your organization with the minimal amount of maintenance as you upgrade to newer versions. Consider this to be your "before I can go outside the box, I better learn where the edges of the box are first" session of Kscope11.

viagra canada

This presentation is focused on organizations that are concerned with the 4.0 upgrade and is intended to de-mystify and add some structure on how to approach the upgrade. The presentation will discuss: Communication – how an approach was made not only to communicate with developers, but also with super users and users that would be impacted by the change. Training – How new features training was key to leverage the upgrade process. Testing – Method for testing applications most critically impacted by the change accomplished by reviewing usage logs and critical process maps. Issues – Outline issues found such as grants, theme availability changes, and new feature control. The intention is to share findings, issues, and methods with peers in order to benefit the APEX community.

This session will discuss real-world case studies, leading best practices and key functionality with a focus on the recently released game-changing applications — Hyperion Financial Close Management and Hyperion Disclosure Management.

This session discusses ways to troubleshoot and debug ADF applications. Topics covered include finding problems using diagnostics and logging; using test clients to troubleshoot and debug problems in your business services; features of the JDeveloper debugger; and how to use the ADF declarative debugger to diagnose problems in metadata.

viagra canada

viagra canada viagra canadaCary Millsap leads an hour-long question and answer session about the principles described in the ODTUG 2010 Editor's Choice Award winning paper, "Thinking Clearly About Performance" (available at ). Topics include: an axiomatic approach, what is performance, response time vs. throughput, percentile specifications, problem diagnosis, the sequence diagram, the profile, Amdahl's Law, skew, minimizing risk, efficiency, load, queueing delay, the knee, relevance of the knee, capacity planning, random arrivals, coherency delay, performance testing, measuring, and performance is a feature.

Profitability analysis is one of the most common Essbase applications for a reason. It’s one of the most important things you can do to improve business performance. Profitability analysis doesn’t stop at direct costs. You have to allocate indirect costs to calculate fully loaded profit. Allocations are fundamentally multidimensional so Essbase is an ideal place to do allocations and profitability analysis. This session will discuss the objectives of profitability analysis and identify the advantages of using Essbase. The session will describe simple allocations, waterfalls, and reciprocal allocations and present several alternative design structures. The session will also present some calculation examples.

This will be a practical overview of some of the most important new features in V11 up thru V11.1.2. Depending on new releases between now and K-scope, the session will try to include the most recent releases. The focus will be on pointing out how to use the new features to make real improvements e.g. how does db archiving and transaction playback compare to the traditional approach in terms of performance and convenience or, how would the presenter actually use @XWRITE or varying attributes. In addition, the objective is to leave attendees with a clear set of steps to implement the features documented in the PPT and the accompanying paper.

The objective of the Killer Apps Survey and panel discussion is to survey a broad spectrum of the Oracle EPM community to: identify the most valuable existing applications; determine how pervasive the most valuable apps are, assess the “next wave” of EPM initiatives, determine how effective organizations set EPM objectives, and establish best practices designed to realize the business benefit of Oracle EPM.

viagra canada

This presentation will cover how the Idaho National Laboratory Idaho Cleanup Project (INL ICP) has modified their software development practices to better implement new Department of Energy Cyber Security rules.

viagra canada

Oracle Application Express is a great tool for building applications, but it is even a greater tool in the hands of researchers. Research is by definition, data driven. That process includes developing the mechanism for capturing data, cleaning and combining data, and collaborating and communicating research results. The audience will see how Rich used APEX to not only develop the data capture tool, but also to quickly uncover patterns and visualize the data in support of our research programs.

In this session, participants will learn how to develop comprehensive training programs using Oracle's UPK (User Productivity Kit). Mary Myers, ISA Consulting, will demonstrate UPK's native capabilities and how to develop custom content using your organization's Oracle Hyperion data and metadata to meet the specific training needs of your EPM end-users.

Ever since Arbor Software first started shipping Essbase, the march towards a truly enterprise-focused product architecture has moved slower than most IT shops would like. With the advent of System 9, a fundamental shift towards architecting common product services throughout the Hyperion product ecosystem can be seen. Centralized security administration (Shared Services), centralized logging, HTTP Proxy for (most) Web applications, and more demonstrated than Hyperion, and now Oracle, were taking the needs of IT and the need to reduce the total cost of ownership (TCO) more seriously. With the release of Oracle’s EPM Fusion Edition, we are witnessing significant milestones in the evolution of systems architecture and administration; a Configuration Management Database (CMDB), true 64-bit architecture, and elimination of most points of failure across the Hyperion architecture.

This presentation will offer an overview of Disaster Recovery principles as they relate to Hyperion, both past, and present. A comparative analysis will be presented showing examples of Disaster Recovery solutions for both pre-System 9 and 11.1.2.0 Hyperion Planning and Hyperion Financial Management environments.

The session will provide an overview and help develop understanding of the various Oracle Business Intelligence and Reporting tools such as OBIEE/BI Applications, BI Publisher, Discoverer, Financial Reporting, IR, Web Analysis etc. as well as non-Oracle offerings for Oracle Database and ERP users such as Cognos/Adaptive Analytics Framework and Business Objects. After attending this session, attendees will be able to understand various reporting and analytics options available to them.

Join us for this informative session where we go beyond the basics of Calculation Manager and show you the tips and tricks for using Calculation Manager against Planning and Essbase. We’ve been working with Calc Manager for over a year now at American Family, using Calculation Manager to write complicated allocation scripts and more. Don’t miss this chance to hear our lessons learned that can be applied in your environment.

viagra canada

Turkcell is a telecommunication operator which is the leader of Turkey and third in Europe. Project NODI is a data warehouse approach especially built for Network Operations Division in Turkcell developed in Turkcell Technology. NODI has a variety of source systems including files, Sybase IQ, Sybase ASE, MSSQL and Oracle and about 25TB of disk space. To give the vision of Turkcell's Network Architecture, Turkcell managed to reach 300M text messages and 16k text messages per second in the first day of Ramadan feast. Sybase Power Designer is used to model complete physical and logical architecture.

An exploration of challenges and resolutions in converting an existing block storage application to aggregate storage

HPCM is one of Hyperion's newest and fastest growing applications. This session will combine an overview of HPCM and best practices in implementing the solution.

Oracle Application Express (APEX) is a very popular tool for building rapid database-centric Web applications. It is also one of the primary choices for extending E-Business Suite. This session will introduce you to Application Express and demonstrate how to integrate APEX into your E-Business Suite environment in a fully certified and supported manner.

The principles of enterprise dimension management can ensure that the dimensions used to drive EPM and BI across the enterprise are aligned and consistent. Just as important is the ability to establish change  management processes that can be leveraged across large EPM & BI deployments. This presentation will review the value of implementing effective enterprise dimension management processes and will define a best-practice approach for planning an effective deployment of Hyperion Data Relationship Management (DRM)

Oracle Application Express 4.0 is a rapid application development tool, which offers developers the power of the Oracle database APIs, a wide arrangement of customization options, and an increased level of data interactivity with websheets, dynamic actions, and enhanced interactive reports. This powerful blend of features in APEX is extremely valuable in facilitating data integration and validation and in allowing end users with minimal training to import data from XML sources, to convert these data into a relational format, and to further curate and manipulate them.

Building a Cash Flow statement in HFM can be very difficult. Typically, a CashFlow account hierarchy is built in HFM and rules are written to pull Balance Sheet and Income Statement data into the Cash Flow accounts. This can lead to a lot of rules maintenance and rapidly grow your rule file and make it very difficult to read and maintain. How about you build the Cash Flow rules into your account maintenance routine and throw all that scripting out the window! In addition, you can build your Cash Flow accounts at such a low level, that financial analysis becomes very simple. Your users can free up their time identifying issues instead of working through the mechanics.

Why do companies make bad decisions in their Planning design, and how can you avoid them? Would you like to allow end users to input their plan and immediately see the impact at a consolidated level without switching forms? How can you increase data form performance dramatically? We’ll answer these questions and more through common and not-so-common tuning and optimization tips. This session will include ideas for Planning design, tuning of the underlying Essbase cubes and other aspects of optimization critical to your application. And when tweaking is not enough we will offer some useful redesign ideas. If you have an older Planning application that has been running along for several years, you can breathe some new life into it with a little tune-up or maybe some redesign. It will be singing again in no time.

viagra canada

Developing functional, easy-to-use, secure, and fast Web applications requires many different skills. Tasks like creating a well designed database model, building the application logic, and designing a modern, crisp, and pleasing user interface are ideally done by experts in their respective areas. Yet often the developers in charge of building an application's back-end might also be tasked with building the user interface. And while these developers may be well versed in the latest Web 2.0 techniques, Ajax, and JavaScript, using Photoshop or CSS may not be their area of expertise. For this reason, Oracle Application Express provides a rich user interface theme framework and ships with twenty-two built-in themes, allowing developers to focus on what they do best, and have graphic artists provide the user interface design. In this session, you will learn about the basic architecture behind themes and the composition of a template. Using the APEX-based Oracle Online Store as an example, this session will discuss the different approaches to building a custom theme using simple, easy to follow Photoshop-techniques and show how Oracle overhauled many of the built-in themes in APEX 4.0, transitioning from a more traditional, table-based page structure, to a modern DIV and CSS-based structure. You will see how you can go about testing your theme, to ensure that you have covered all the bases, and how to package and deploy your application with all images and CSS files included.

Strategic and Operational Dashboards are tools that more managers are turning to in order to plot their course through these turbulent times. Designing and implementing dashboards involves both art and technology. This presentation will provide a proven methodology that can be used by developer and the BI community to measure and continuously improve their BI delivery to consumers.

This session is a deep dive into platform architecture, configuration management, instance tracking, fault recovery, troubleshooting, and performance tuning for Oracle SOA Suite 11g. The presentation will cover the above topics from both administration and architecture perspectives.

viagra canada

Oracle SQL Developer provides access to the database for a wide spectrum of users, initially focusing on database developers. Each release has introduced more and more functionality for DBAs. For all users, tuning SQL queries and understanding how queries can impact performance is very important. SQL Developer now accesses a number of the Oracle Enterprise Manager 11g Database Management Packs. In this session, you learn more about these Database Management Packs and through a series of demonstrations, you see how to use Oracle SQL Developer and the Oracle Enterprise Manager 11g Database Management Packs to increase your productivity and improve the quality of your database applications.

Oracle SQL Developer supports the development of SQL and PL/SQL code. You can create, edit, compile, and run your code using the editors provided. Once compiled, building tests to ensure the code is accurate is essential. This session will show you how to create unit tests, build implementations, save tests to a library, and run the tests individually or as a suite. SQL Developer 3.0 introduces a number of additional features that support tuning SQL code. This session demonstrates the new tuning capabilities and PL/SQL unit testing support.

This presentation will introduce the attendee to Calculation Manager. Calculation Manager, a component of Hyperion Enterprise Performance Management Architect, is the new tool to create business rules and business rule sets to run against Hyperion Planning and Oracle Essbase. By attending the presentation, the attendee will learn about differences between Calculation Manager and Hyperion Business Rules, as well as see a live demo of the tool to develop and deploy business rules to a Hyperion Planning application.

United Space Alliance delivered a highly configurable application that met the demands of the rigid Human Spaceflight environment. Utilizing the power of the Oracle database and APEX toolsets, the team designed a robust and dynamic data model that can be transferred across multiple business organizations.

viagra canada

viagra canada

LROs, Cell Text, Related Content? Essbase provides many options for adding commentary to your reporting and analysis solutions. Join ConocoPhillips as they share how they provided an automated system for capturing and reporting variance commentary. We will discuss our current solution as well as possible future changes based on Oracle's direction for Essbase commentary. Don't miss this chance to learn more about ways to capture critical text information about your Essbase numbers!

Make your ADF Application go social for the enterprise! This session will discuss WebCenter Suite and how to select which component to use from its comprehensive set of Enterprise 2.0 features. It will also include WebCenter Spaces, Portal Framework, and Services in real world scenarios.

Oracle WebCenter Spaces is a ready-to-use application that pulls together the capabilities of all the WebCenter Services to empower teams to quickly and efficiently manage their information, applications, projects, and people without requiring IT assistance. This session will talk about the challenges of going social on the Enterprise and how WebCenter Spaces can help and adapt for your needs.

This presentation is a practical guide to the concept of APEX themes and templates. It outlines skills, tooling, and steps necessary to create a professional looking, custom APEX GUI.

Every long-term IT project reaches a point when one or more fundamental concepts that define the whole system are no longer true. If the business is lucky, this may lead to a brand new development project. If not, the current system must be altered to support requirements for which it was never designed. This presentation discusses how to mitigate possible design-time risks using available technologies and concepts from a database perspective. The presentation will also cover real-life examples of best practices for handling unexpected architectural shifts.

One of the most critical aspects of building an effective database system is successful management of unstructured information. Developers and designers must know how to work with Large Object datatypes (LOBS) including CLOB, BLOB, and BFILE. This presentation covers the core LOB concepts (multi-segment storage, I/O mechanism, copy semantics/pointer semantics, etc.) applicable to all Oracle versions starting with 9i. It also introduces SecureFiles, an 11g implementation of LOBs targeted to solve a number of functional pitfalls, and introduces several advanced features (de-duplication, compression, encryption, etc). Real-life examples will be included to pinpoint key ideas and solutions.

viagra canada

viagra canada

viagra canada

viagra canada

Essbase Analytics Link provides a way to use Essbase as a "live" reporting cube on HFM. But did you know you can combine dimensions, add new dimensions, and add additional data. This session will demonstrate how to use EAL to create applications that combine additional data for a robust reporting environment.

This session will demonstrate a client solution which utilizes Financial Data Quality Management, ERP Integrator, and Enterprise Performance Management Architect to automate data and metadata flows into Hyperion Financial Management. The overall solution utilizes several key components of Oracle’s EPM Suite including FDM, ERP Integrator, EPMA, Calc Manager, and Life Cycle Management. This session will focus on the metadata and data automation. The process was designed to enable full lights-out automation for data as well as metadata loading.

For so many, FDM is viewed simply as the 4 fish.  But FDM is an extraordinarily powerful tool that is capable of much, much more.  This session will explore some of the most common client data quality & automation needs that can be addressed through FDM scripting.  Over the course of the session, we will explore various script types (Event, Custom & Import) as well as their intended usage and best practices.  At the end of this session, a batch automation script will be created to illustrate the use of FDM's scripting tools.  This script can be used to automate the entire data load process, virtually eliminate the need for end users to perform the data load process.  This automation generally results in a close process that is more timely as well as accurate.

Out of the box, FDM provides a very efficient & end user friendly interface to load and validate data to various Oracle EPM application - HFM, Essbase, HSF as well as Enterprise.  The 4 fish have become a very recognizable icon and many organizations will refer to their close process status by the number of gold fish a location has attained.

One of the most common FDM questions is, can FDM do X?  As with all technology investments, the more an organization can accomplish with their given toolset, the better the ROI.  FDM has an extremely powerful and flexible scripting engine that allows an application to seamlessly perform a number of tasks that previously required interaction with multiple systems and/or process.

Smart Replace - an example of a common customization - will be explored in greater detail.  This deep dive will highlight how the combination of FDM's scripting engine, SQL and a little imagination overcome a common data quality challenge.

This session will explore the capabilities of FDM, and now ERPi, to integrate with other target EPM applications such Essbase (BSO & ASO) and Strategic Finance. Out of the box features such as the ability to execute calc scripts before and after a load as well as leveraging load rules will be showcased. The session will highlight how the introduction of ERPi further expanded the already world class analysis & reporting capabilities of Essbase by adding drill through to transactional detail. This session will conclude with an overview of automation capabilities of FDM, discussion of use cases, and thorough Q&A.

viagra canada

You have a lot of existing Java EE applications. Part of these applications and their logic have a potential to be reused in an SOA. But what is the best practice for reusing such Java EE applications? This session will show different approaches available with SOA Suite 11g in the SCA assembly model as well as with the Oracle Service Bus to reuse existing Java EE artifacts.

viagra canada

In Web 2.0, MySQL is very important and any DBA should know what level of availability they need to fulfill their service level agreements both internally and externally. This presentation is an informative synopsis about different levels of availability within the MySQL server architecture.  The audience will learn about terms and concepts, what it means to scale MySQL, different replication methodologies, DBBD, and MySQL Cluster.  The presentation will also dive a bit further with specific visual examples pertaining to the different levels of availability and what you need to do to achieve higher levels of availability.

viagra canada

viagra canadaviagra canadaFix on sparse, if on dense; hourglass vs. hourglass on a stick. Just when you thought you had all of the Essbase design best practices down, here comes Glenn Schwartzberg, Oracle ACE, with some exceptions to the general Essbase rules. Join us for this unique twist on an Essbase tips and tricks presentation where Glenn will share some of the “exceptions” to consider when designing and implementing Essbase. Test your Essbase knowledge and make sure you know all of the considerations when applying design and tuning principles.

viagra canada

viagra canada

viagra canada

The power of APEX is due in part to the immense scope of capabilities present in the Oracle Database. This presentation will cover a variety of Oracle Database capabilities, from helpful to esoteric, and how they can be integrated into an APEX application. Topics include Oracle Text, SQL Analytics, Oracle Multimedia, a variety of database util packages, external table, Virtual Private Database, and others. The goal of this presentation is to introduce developers to a few database features and inspire them to seek out others.

APEX Interactive Reports are incredibly powerful, but lack in formatting and the ability to do master detail reporting.  APEX standard pages allow for master detail, but more than one level of detail is very difficult without drilling into a second page.  This presentation will demonstrate how to develop multiple pages, a master and multiple details, and then stitch them together into a single page report using AJAX callAPEX Interactive Reports are incredibly powerful, but lack in formatting and the ability to do master detail reporting. APEX standard pages allow for master detail, but more than one level of detail is very difficult without drilling into a second page. This presentation will demonstrate how to develop multiple pages, a master and multiple details, and then stitch them together into a single page report using AJAX calls. s.

This beginner-level session introduces Oracle's offerings for .NET programmers, including Oracle Data Provider for .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 developing Oracle Database .NET applications using each of these free products. New features for Oracle .NET developers are highlighted in this session.

This session presents the newest and upcoming features for Oracle Database .NET development. We will discuss support for Microsoft Visual Studio 2010, Entity Framework, LINQ, OData, fully-managed ODP.NET, and database .NET application performance tuning.

Trying to achieve a specific look for your ADF Faces application? This session will focus on the features that Oracle ADF Faces offers to help you achieve the exact look and feel you are after. It will cover the basic concepts involved in developing skins for Oracle ADF applications, using the new ADF Faces Skin Editor, and tips to help you debug your skin.

Java Persistence API (JPA) provides a standard O/R mapping and persistence layer for the Java EE stack and provides the interface between Java EE applications and relational databases. This session will introduce you to the key concepts of JPA and explain how it works. It will show you how you can leverage JPA as the database access layer in an Oracle ADF application, and what special features you get from this integration.

Dynamic Actions can empower the APEX developer to build complex events and UI elements with a three-step wizard that would have taken many, many lines of hand coding before. In this presentation, learn the basics of dynamic actions and how you can incorporate them into your applications.

User experience is becoming more and more important as the social Web spills over into the enterprise. Users expect rich interactive experiences with no waiting. In this presentation, learn how to incorporate the latest UX trends in your applications. Attendees will learn how to create custom page, report, and region templates. Using a stock theme? No problem. See how to extend the stock themes with social Web goodies. Dynamic actions also will be used to help with the user experience.

viagra canada

APEX is entering its adolescence phase of development. Adolescence is a critical phase in both childhood and software development, as there are a number of decisions that need to be made - all of which will be hard to undo.

As "parents" of APEX, it's our responsibility to guide APEX through this critical yet typically awkward phase, instilling our knowledge and wisdom every step of the way. This presentation outlines some of those decision points, and things that we can do to ensure that APEX becomes a productive "adult."

viagra canada

viagra canada

Business Rules can be used in a wide variety of applications. This session will look at specific examples of using Oracle Business Rules to make work assignment and routing more flexible when using Oracle Human Workflow services.

With the release of the Java-based APEX Listener, there is an even easier way to implement your APEX applications. The J2EE implementation offers functionality including a Web-based configuration, enhanced security, and file caching. This session will show how to deploy and configure the APEX Listener, how to test for common installation issues, and how to secure your implementation. During the session, Timothy will go through a full installation showing how easy configuration is and demonstrating the debugging methods discussed.

After learning the basic functionality of Oracle Application Express, developers are often asked to implement more advanced interfaces that require knowledge of AJAX and JavaScript functionality. Without any additional libraries, APEX contains the functionality and capability to add features to any APEX application. With the release of APEX 4.0, the dynamic capabilities of APEX have become more declarative. Although the same concepts apply in 3.2, the approach has dramatically changed with the declarative framework. Both 3.2 and 4.0 methods for accomplishing the same functionality will be compared. The focus audience is intermediate individuals who have learned the basics of Application Express and are interested in starting to utilize the JavaScript, AJAX, and on-demand processing capabilities built into the APEX tool set to advance their knowledge and productivity in APEX.

Learn the difference between Oracle's many ETL tools for loading into Hyperion and EPM.

This presentation will explore SQL Developer Data Modeler's support for developers, repository managers and data architects who may be concerned with issues such as collaborative development, model re-use, master data management and metadata integration. Data Modeler is presented from the perspective of tool adoption, focusing on what you need to know to get started. The presentation will provide a valuable foundation for any organization considering using Data Modeler as their next modeling tool.

Using RESTful Web services has become the new cool way to integrate services into your applications. The RESTful Web service design is a much simpler architecture than big Web services such as SOAP. Application Express 4.0 introduced support for consuming RESTful Web services. This session will demonstrate how you can integrate RESTful Web services into your Application Express applications from many of the major players such as Amazon, Yahoo, Google, and Netflix.

Learn how Harvard University and Performance Architects established a robust staging area for the largest Hyperion Planning installation in the world, permitting decentralized and unique planning approaches for a diverse organization with distinct planning approaches – and how you can apply this type of approach to your Planning environment and efforts.

viagra canada

viagra canada

Microsoft has invested heavily in Office features for enabling BI on the desktop, and many enterprises have embraced Excel for BI. This session provides an overview of new and popular functionality built into Excel 2010. You’ll see how to create a PivotTable with a live connection to Oracle Database OLAP Option. This session will then demonstrate how to use Excel to drill down into a dimension, then filter and analyze data with trend icon sets, conditional formatting, and Excel 2010 slicers and Sparklines. You can even drill ‘through’ to the underlying relational data from the fact table, or create fabulous PivotCharts hot connected to Oracle OLAP.

Prior to Version 11.1.2, Hyperion Planning’s process management capabilities were limited. Users had excessive flexibility in terms of who they could promote data to. On the other hand, they had limited flexibility in terms of the “chunks” of data being promoted. Version 11.1.2 addressed many of these limitations by adding two new process management templates and a host of new features. This presentation will walk users through a quick demonstration of the “old” process management followed by a detailed demo of the new templates and features.

A Service Bus offers capabilities to transform, route, and queue messages. This session will show you how to implement a Service Bus based on good practices and patterns. Expect far more than just theory, since the examples are based on real life cases. Each of them is based on an implementation of the Oracle Service Bus or Mediator from the SOA Suite. This session will give you answers on how to create composite services using the OSB, how to transform messages from over a hundred types of messages containing basically the same data to a single common schema, or create and maintain a common schema. Of course questions like what is the best of those tools for a specific job will be answered. The session will also share thoughts and experiences on using the combination with WSM, and using the Oracle Enterprise Repository to leverage governance efforts.

viagra canada

viagra canada

It is one thing to design and code the “happy flow” of your automated business processes and services. It is another thing to deal with situations you do not want [or expect] to occur in your processes and services. This session will dive into fault handling in Oracle SOA Suite 11g using a case study based on automated invoice handling. First the session investigates what can go wrong in automated processes and services. Then it categorizes these situations and dives into the mechanisms Oracle SOA Suite 11g offers to handle these different scenarios. These mechanisms include BPEL activities such as Throw and Catch activities, the SOA Suite Enterprise Manager, and SOA Suite’s fault handling framework. The session will wrap up by introducing a generic fault handling framework for technical faults used in a real-life project that is realized using a Java fault handler and SOA Suite’s fault handling framework.

viagra canada

viagra canada

viagra canada

ADF controls for accessing Essbase will be released along with the Fusion applications. This session will highlight what controls will be available, and walk through different samples on their usage in a Web page.

Learn how you can easily extend the Essbase calculator with functions built in Java. You will learn how to create, deploy, register, and debug Custom Defined Functions. Several Custom Defined Functions will be demonstrated such as: a Custom Calendar to calculate the number of business days in a month, statistical functions, string and date manipulation functions, data import/export functions, XREF on steroids, calc scripts debugging functions, etc.

This talk will be a quick but thorough introduction to the jQuery JavaScript Library. If you have zero experience with jQuery, this is the talk to start with. The session will cover jQuery and its history. The session will start by introducing basic jQuery concepts and principles, and conclude by building a basic jQuery plug-in.

Attend this informative session where the presenter will share Sally Beauty's success story of using Essbase for analysis. While everyone knows that Essbase is the number one financial reporting solution in retail, not everyone knows some of the other analysis for which Essbase is perfect. Whether it’s flash sales by store and SKU, product profitability, customer segmentation, SKU analysis, store sales (comp and non comp), weeks of supply, pricing models, or more, retail companies around the world are using Essbase to meet all of their needs. In this one hour presentation, you will see Sally's real-world examples of reporting, analysis, modeling, and planning that you can do with Essbase, God’s gift to retail companies everywhere.

Join Sally Beauty as they share their success story in implementing Hyperion Planning. Learn how their entire budget and forecast cycles went from over three weeks to complete with suspect information to more accurate plans in two to three days with reporting available in seconds. This session will share the secrets to good application design and lessons learned that can help you improve your Planning solution.

viagra canada

Plug-ins to extend the feature set of Oracle APEX were introduced in APEX 4.0 over a year ago. Since then, countless plug-ins have been created by the community and the Oracle development team themselves. Get to know the lessons learned and the best practices of plug-in development from one of the most active plug-in developers. You will also learn all about the new features and enhancements which are being added in APEX 4.1 to make it even easier for plug-in developers. Don't miss the opportunity to get an in-depth first hand experience from the developer of this feature in Oracle Application Express.

This session is perfect for new developers trying to get familiar with ASO. Whether you have experience with Block Storage or not, this session is designed to go over the fundamentals of design and architecture of Aggregate Storage type databases, including: • ASO architecture • Best fits for ASO vs. BSO currently • Restrictions in ASO • Basics of Outline modeling in ASO • Aggregations and retrievals in ASO • Basics of MDX.

We smell the end of the Block Storage. Although still some years away, simple strategies can be implored to build out cubes predominately in ASO. Even for Planning systems or calculation intensive applications, there are ways to design ASO cubes to address these requirements and in some cases work alongside of Block Storage applications. By going through the major sections of ASO, the presentation will cover advanced topics such as: • Where we are at in the cross-roads between BSO and ASO. • Modeling choices and structural architecture. • MDX capabilities through visual examples • Aggregations and optimization • ASO allocations • Integrating BSO and ASO.