GL Wand for Oracle product news

GL Wand 4.15 released

noreply@blogger.com (Excel4apps) — Thu, 09 Dec 2010 01:10:00 +0000

An updated version of GL Wand is available. This version includes support for Excel 2010 64 bit as well as supporting the "&" character in a segment value which was previous not allowed. Also included is a new operator for Get Balance segment parameters which will return only the intersection of two sets of criteria. A number of smaller bug fixes are also included.

GL Wand performance optimisation update

noreply@blogger.com (Excel4apps) — Tue, 16 Nov 2010 23:00:00 +0000

Check out the latest tips and tricks for maximising GL Wand performance. Relevant for customers running on Oracle E-Business suite.

Download GL Wand performance optimisation PDF or
See all available GL Wand collateral

Reports Wand Seeded Reports Listing from 4.05 - requires seperate download

noreply@blogger.com (Excel4apps) — Fri, 20 Aug 2010 05:10:00 +0000

Listing of currently available seeded reports querying Oracle Projects, System Administration, Assets, Payables, Receivables, HR & Payroll. Reports Wand Seeded Reports Listing

New Reports Wand module for Oracle E-Business Suite wide reporting (Release 4.05)

noreply@blogger.com (Excel4apps) — Fri, 15 Jan 2010 07:32:00 +0000

Feature Description: Run Excel based reports based on your own custom SQL queries. This new module provides incredible flexibility in terms of filtering, sorting, formatting and refreshing real-time data from any area in Oracle in an Excel reporting environment. Link reports to each other for multi-level drill to detail, drill to anywhere type reporting. Please read the data sheet on our web site for the details or watch a demo on http://www.youtube.com/excel4apps

Feature Benefit: Flexible reporting from any area in Oracle e-Business Suite. Reports Wand is available as a cost plus option. Please contact your sales representative for details and for a free trial.

Calculated formulas on GL Wand drill down reports (Release 4.05)

noreply@blogger.com (Excel4apps) — Fri, 15 Jan 2010 07:21:00 +0000

Feature Description: You can now add calculated formulas to the GL Wand drill down reports as user defined columns. Please see the user guide for more details.

Feature Benefit: More flexibility added to the drill down report layouts. Also facilitates including a Run Report formula in an existing GL Wand drill down report which will allow you to drill to additional detail which is not provided in the standard drill down layouts. The Run Report functionality is part of the new Reports Wand Module available as a cost plus option.

Get Exchange Rate Function (Release 4.05)

noreply@blogger.com (Excel4apps) — Fri, 15 Jan 2010 07:17:00 +0000

Feature Description: Ability to fetch daily exchange rates out of Oracle using a GL Wand function.

Feature Benefit: Exchange rates can be fetched directly from Oracle using a function, therefore users don't have to manually fetch these out of Oracle for use in what-if analysis using GL Wand reports.

Get Balance and drill down by journal source and category (GL Wand 4.05)

noreply@blogger.com (Excel4apps) — Fri, 15 Jan 2010 07:15:00 +0000

Feature Description: A new parameter has been added to the Get Balance function which allows you to specify a journal source and category. The returned balance will then only include journal lines having that source and category. The drill down to detail will then also only return journals having that source and category.

Feature Benefit: Enables you to get balances on an account at a more detailed level than the overall account balance. The functionality can also be used to extract journals based on a particular source and category.

Drill down performance improvement in release 4.05

noreply@blogger.com (Excel4apps) — Fri, 15 Jan 2010 07:13:00 +0000

Feature Description: The drill down logic has been enhanced to improve performance. Where possible GL Wand will batch the drill down calls and fetch the results from Oracle in batches. The user also has the option to cancel the process.

This option will be enabled by default but can be disabled under the advanced GL Wand options. Feature Benefit: Faster drill downs, quicker population of the results into Excel and the ability to stop the process.

Reports Wand coming in version 4.0

noreply@blogger.com (Excel4apps) — Fri, 11 Dec 2009 05:39:00 +0000

Reports Wand for realtime reporting from any area in Oracle will be available as an add on from GL Wand 4.0. Download the Reports Wand datasheet or see the demo

Audit Get Balance feature helps identify glwNoAccess reasons in release 3.89.0

noreply@blogger.com (Excel4apps) — Thu, 29 Oct 2009 04:41:00 +0000

A new option on the tools menu - "Audit Get Balance" - can assist in determining why a Get Balance formula returns an error. It can specifically assist with providing information as to why a Get Balance formula returns glwNoAccess by identifying the segment and segment value which contains security rules.

Novell Groupwise email supported in release 3.89.0

noreply@blogger.com (Excel4apps) — Mon, 27 Jul 2009 02:41:00 +0000

Novell Groupwise email is now supported as an email client by the GL Wand Report Manager in addition to the previously supported Outlook and Lotus email clients. The Report Manager is used to mass produce and distribute GL Wand reports to users.

Drill down to OPM supported in release 3.89.0

noreply@blogger.com (Excel4apps) — Mon, 27 Jul 2009 02:32:00 +0000

GL Wand now supports drill down to Oracle Process Manufacturing in Oracle 11i.

Currencies list of values (Release 3.89.0)

noreply@blogger.com (Excel4apps) — Mon, 27 Jul 2009 02:21:00 +0000

The 'Create List of Values' functionality has been extended to include a list for Currencies. Organisations reporting across multiple currencies can easily create a dynamic Currencies List of Values that users can access by double clicking the cell containing the List of Values.

Sets of Books list of values (Release 3.89.0)

noreply@blogger.com (Excel4apps) — Mon, 27 Jul 2009 02:18:00 +0000

The 'Create List of Values' functionality as been extended to include a list of value listing all Sets of Books. Organisations reporting across sets of books can easily create a Set of Books List of Values that will be dynamic.

Convert FSG Reports to GL Wand (Release 3.89.0)

noreply@blogger.com (Excel4apps) — Mon, 27 Jul 2009 01:49:00 +0000

GL Wand now contains a feature which will extract an FSG report definition into an Excel worksheet and allow you to rapidly convert the FSG to a working GL Wand report.

Get Balance now supports converted amount (Release 3.85.0)

noreply@blogger.com (Excel4apps) — Tue, 02 Dec 2008 02:40:00 +0000

Feature Description: The Get Balance formula now contains a new option for the translated flag, namely "C" for converted. When using this option GL Wand will return the converted amount in functional currency for a particular entered currency. Feature Benefit: This amount type was previously not available in GL Wand.

New calculation option for Get Balance in Release 3.85.0

noreply@blogger.com (Excel4apps) — Tue, 02 Dec 2008 02:38:00 +0000

Feature Description: The GL Wand logon screen now has a new check box which allows you to select an alternative method for processing Get Balance formulas. You can select this option at each logon and vary it to suit which ever method provides you with the best performance for particular GL Wand reports. Feature Benefit: In certain situations this alternate Get Balance processing method can result in a significant performance improvement. When selecting this option, the initial GL Wand logon may be slower.

We recommend testing your slower GL Wand reports using the old and the new method to determine which method is better for your environment.

Change in the Get Balance all values parameter (Release 3.85.0)

noreply@blogger.com (Excel4apps) — Tue, 02 Dec 2008 02:36:00 +0000

Feature Description: Previously when leaving a particular Get Balance segment parameter empty, GL Wand would assume that you want all values for that segment. You had the option to either specify a "%" to denote all values or simply leave the segment parameter blank.

This functionality has however caused problems in certain situations. For example a user copies and pastes a Get Balance formula onto a new row. The Get Balance formula is linked in the segment 3 parameter to column A, however on this new row the value in column A is blank. If your GL Wand calculation is it set to "On" this calculation will start and may take a long time to complete as GL Wand is assuming you want all values for segment 3.

Feature Benefit: You must now specifically enter a "%"to denote all values. This gives GL Wand the ability to know whether you are specifically requesting all values or that you have simply not completed entering the formula yet.

This change also prevents GL Wand from duplicating the calculations which can result in certain cases when Excel does not initially get the calculation dependencies correct. This can happen when you derive the segment values using an Excel formula like Mid or the GL Wand Split_Text.

Explode using the parent hierarchy (Release 3.85.0)

noreply@blogger.com (Excel4apps) — Mon, 01 Dec 2008 07:13:00 +0000

Feature Description: You can now perform an explode using the Oracle defined parent hierarchy. Previously GL Wand would perform and explode on a summary report by splitting it down to the lowest level children only.

You can now explode a report down one level of the hierarchy or down the full hierarchy for all levels. Feature Benefit: More flexibility when exploding reports into their detail. You are now able to see the detail one level down the hierarchy (or for the full hierarchy) rather than only seeing the lowest level children.

Expand using the parent hierarchy (Release 3.85.0)

noreply@blogger.com (Excel4apps) — Mon, 01 Dec 2008 07:08:00 +0000

Feature Description: You can now perform an expand using the Oracle defined parent hierarchy per level of the hierachy. Previously GL Wand would perform and expand down to the lowest level children only.

You can expand down one level of the hierarchy or down the full hierarchy for all levels. Feature Benefit: More flexibility when expanding values into their detail. You are now able to see the detail one level down the hierarchy (or for the full hierarchy) rather than only seeing the lowest level children.

Discover parent hierarchy (Release 3.85.0)

noreply@blogger.com (Excel4apps) — Mon, 01 Dec 2008 07:05:00 +0000

Feature Description: You now have the option of extracting the hierarchy for a segment into an Excel sheet. Starting with a parent value GL Wand will extract the full hierarchy for that parent value and display it indented in an Excel sheet.

Feature Benefit: Previously GL Wand only extracted the segment values in alphabetical order, you now have the option to extract this information in the hierarchy sequence and view the full hierarchy.

Support for specifying segment criteria spanning account combinations in Release 3.80.0

noreply@blogger.com (Excel4apps) — Sat, 11 Oct 2008 23:19:00 +0000

Feature Description: In the past the Get Balance function only supported criteria independent to each segment e.g. seg 2 = 100 or 200 and seg 3 = 1000 or 2000. This would result in GL Wand returning all the possible combinations of those segment 2 and 3 criteria.

It is now possible to specify criteria spanning the account combination using the new Get Balance syntax. This means that you can create new complex criteria for your Get Balance formula e.g. (seg 2 = 100 and seg 3 = 1000) or (seg 2 = 200 and seg 3 = 2000). With this criteria GL Wand will no longer return all the possible combinations but rather only the combinations you specify.

Feature Benefit: Significantly enhanced reporting capability for customers requiring the ability to specify criteria for account combinations rather than individual segment values only. Previously this required using multiple Get Balance formulas to achieve the same result. Now you have the capability of specifying these complex criteria in a single Get Balance function.

Get Balance and drill down to balances based on DFF criteria (Release 3.80.0)

noreply@blogger.com (Excel4apps) — Thu, 02 Oct 2008 03:14:00 +0000

Feature Description: GL Wand now has the ability to extract balances and perform a drill down using information stored in the segment values descriptive flexfields. Feature Benefit: Report based on your descriptive flexfields information.

Expand feature extended to work across segments. (Release 3.80.0)

noreply@blogger.com (Excel4apps) — Thu, 02 Oct 2008 03:12:00 +0000

Feature Description: Previously the expand feature would allow you to extract all the child values that are included in your criteria for a single segment. You can now expand values using criteria spanning multiple segments. Feature Benefit: Expand complex segment combination criteria. Use this feature to extract account combinations that are in use.

New drill down sources will be supported in Release 3.80.0

noreply@blogger.com (Excel4apps) — Thu, 02 Oct 2008 01:04:00 +0000

Feature Description: GL Wand now supports drill down to the sub ledger for the following new journal sources - Marketing, PYA Transactions (Fed), Budgetary Transaction (Fed) and Payables for the Treasury Confirmation category.