The Ask TOM team will be busy at Open World this month.

If you are at the conference, drop into the Groundbreaker area and say Hello.

My SQL for Excel is an Excel Add-In that is installed and accessed from within the MS Excel’s Data tab offering a wizard-like interface arranged in an elegant yet simple way to help users browse My SQL Schemas, Tables, Views and Procedures and perform data operations against them using MS Excel as the vehicle to drive the data in and out My SQL Databases.

My SQL for Excel has been designed to be a simple and friendly tool for data analysts who want to harness the power of MS Excel to play with My SQL data without worrying about the technical details involved to reach the data they want, boosting productivity so they can focus on the data analysis and manipulation.

Here I can introduce you a complex dynamic formula method. First, you need to create a defined name and a dynamic formula for each column.

Click Formulas Note: In the above formulas, the OFFSET function refers to the first data point, and the COUNTA refers to the entire column of data. After defining the names and formulas for each column data, then right click any column in your chart, and choose Select Data, see screenshot: 5.

Learn More » My SQL for Excel allows users to create a new My SQL table from selected Excel data; data types are automatically recognized and defaulted for the new table and column names can be created from the first row of data, speeding up the process and making it simple for non-technical users.

This article was co-authored by our trained team of editors and researchers who validated it for accuracy and comprehensiveness.

For classic application types, the admin extension has been available since planning release 11.1.2.3.

It bears repeating, however, that the extension is an essential part of your admin tool belt for a number of reasons: Download the extension directly from Oracle EPM Workspace: Open and manage classic application dimensions via Smart View’s Hyperion Planning connection.

It’s full function without limitation in 60 days,please download and have a free trial now.