Your Premier Source for Interprise Suite Plugins
Call Now!  (951) 928-1990
Toll Free  (800) 434-4514

The DS Data Explorer Plugin is an incredibly powerful data mining and analysis tool for Interprise Suite. 

Answer questions like "What's my total sales volume for each of my inventory categories for each of the last 12 months", maybe throw in subtotals by sales rep or customer or web store.  You can "slice and dice" your data to find the information you need that's buried deep in that database with a simple drag and drop interface.

You can print, export, and even email using various formats.  Do you need to export invoicing information for outsourced shipping?  Perhaps dump a filtered list of customers into Excel for a mail merge?  Or even drop analytical data into Excel for charting and graphing?  You can do it all with this simple tool.

Use any view, table, or even SQL statement to extract data from Interprise Suite, then use the powerful grid and built-in pivot table to filter, sort, group, and total the data however you need it.  DS Data Explorer supports the Interprise Suite Data Dictionary giving you hundreds of views and tables with field labels and descriptions to pull your data from. 

Set up your filters, sorts, groupings, pivot tables, etc., and then save the entire setup as a profile.  Then tomorrow, or next week, or next month when you need that margin analysis, sales report, or export again, a few mouse clicks brings it all back updated with the current data.

This is a well rounded tool - built out of necessity.  The longer you use Interprise Suite, the more history you build.  Use DS Data Explorer to leverage your investment and unlock the secrets hidden in your data.  This is the tool to help you better manage your business.

Need more information?  Download the complete Installation and User Guide here. 

DS Data Explorer requires Interprise Suite SP3 HF2 (2007.1.3.2) or higher.  Do not attempt to install on an older version.

DS Data Explorer for Interprise Suite Features:

• View and analyze data from any table or view in Interprise Suite with just a few mouse clicks.
• Data can source from a SQL statement.
• Data can source from a stored procedure.
• Interfaces with the Interprise Suite data dictionary to provide field label, field name, and bubble help information in grid header and tool tips.
• Provides a grid to view tabular data.
  • Grid can be sorted and grouped.
  • Data can be sorted by multiple columns (Sort first by customer, then by transaction date)
  • Data can be grouped by multiple columns (Group first by customer, then by item)
  • Simple "Excel-like" filters available in drop-downs to limit to individual values.
  • Simple drag-and-drop interface
  • Advanced multi-part filter editor to build complex filters.
  • Columns can be removed and added to the grid.
  • Columns can be rearranged and resized.
  • Simple "Best Fit" button to auto-size all columns or "Best Fit" a single column using the right click menu.
  • The entire grid layout including data source, filtering, sorting, grouping, column selections, sizes, and order can be saved in a profile and reused.  This is very useful for recurring exports or analysis.
  • Grid can be printed with features such as page scaling, headers and footers, background colors, etc.
  • Grid print preview can be searched for data.  This feature, in addition to the standard filters, is a great tool for finding that transaction amount you're looking for.
  • Grid can be exported to various formats including: PDF, HTML, MHT, RTF, Excel, CSV, and Text.
  • Grid can be exported to image formats including: BMP, EMF, WMF, GIF, JPEG, PNG, and TIFF.
  • Grid can be packaged in several formats and emailed through your default email client.
  • Grid data can easily be exported to Excel for analysis with pivot tables and charting.
• Provides a built in powerful pivot table for data analysis.
  • Data can be grouped and subtotaled in many different ways on both the horizontal and vertical axis.
  • "Slice and dice" your data to view totals of key factors across many different scenarios.
  • Data item area can hold multiple fields.
  • Excellent for analysis of data.  For example: View total sales, total cost, and total margin for all item sales, grouped by category, with totals for each month and year in a cross-tab type view.
  • A master filter field at the top of the pivot table allows additional cross sectioning of data (perhaps you want to see the above pivot table, for one, some, or all sales reps.)
  • Simple drop down filters allow selecting all or individual values to be included on both axis as well as the master filter.
  • Powerful pre-filter builder allows advanced multi-conditional filtering of data before it reaches the pivot table.
  • Simple drag-and-drop interface to move fields between axes or the available field list.
  • Rearrange grouping hierarchies to sub-total in different orders.  For example: Show total sales by customer, broken down by category with customer subtotals, or drag the column headers to show total sales by category broken down by customer with category subtotals.
  • Subtotals on both axes can be expanded and collapsed.
  • Special handling of dates to analyze by day, month, and year with the ability to collapse and expand to view the desired level of detail.
  • Simple "Best Fit" button to auto-size all columns for the best view.
  • Subtotals have a different background color to provide banding that makes large tables easy to read.
  • The entire pivot table including data source, filtering, sorting, axis layout, column sizing, and selection can be saved in a profile and reused.  This is useful for recurring analysis.  Simply build that sales analysis pivot table once, then reload it with fresh data any time you need it with just a few clicks.
  • Pivot table can be printed with features such as page scaling, headers and footers, background colors, etc.
  • Pivot table can be exported to various formats including: PDF, HTML, RTF, and Excel.
  • Pivot table can be exported to image formats including: BMP, EMF, WMF, GIF, JPEG, PNG, and TIFF.
  • Pivot table can be packaged in several formats and emailed through your default email client.
  • A pivot table is far more powerful than any report for data analysis.  You can drag and drop fields such as sales reps, item codes, customer names, transaction dates, zip codes, inventory categories, manufacturers, etc., to view totals across any combination of key factors. 
• Profiles containing the data source along with the grid and pivot table layouts can be saved and retrieved for reuse with fresh data at any time.
• A robust security model is included to control access to your data.
  • Using the standard role manager in Interprise Suite, you can choose which roles have access to the DS Data Explorer.
  • Each profile within DS Data Explorer can be assigned to a single role, or "All Roles".
  • The "Administrator" group is allowed access to all profiles.
  • Any other role is only allowed access to profiles assigned to their role or "All Roles".
  • The "Administrator" group can create, edit, and delete profiles as well as import and export Analysis Packages.
  • Any other role is limited to only running existing profiles.  They can use all of the features of the grid and pivot table but can not modify the data source or any other profile setting.  This allows the administrator to build a profile with access to a certain data source and assign it to a role and know that the users in that role can't use DS Data Explorer to browse other sensitive financial information or data.
  • The SQL command box is restricted to a special "super-user".  Only this special user can enter direct SQL commands to be used as the data source for a profile.  This protects your database.
  • Once the "super-user" builds a profile, even if driven from a SQL command, it can be assigned to other roles for use by the users belonging to that role.
• Analysis Packages provide a simple way to transport profiles between datasets or systems. 
  • An Analysis Package is an XML export of an entire profile.
  • Analysis Packages can be imported into the plugin and saved in your profile list.
  • You can export your own profiles as Analysis Packages to be shared or sold to other users of the plugin.
  • Analysis Packages provide a very cost effective way of designing and distributing data extraction and analysis solutions.  We can build an Analysis Package to your specification and deploy it to you in an email where you can import it and use it as a profile.  This can be done at a much lower cost than the development of a custom report or program.

Analysis Packages are a fast and simple way to add additional features to DS Data Explorer. 

Do you need Detailed Inventory Sales Analysis or maybe a table of G/L Activity by Account for Each Period and a Grid Configured for Drill-Downs for financial analysis? 

These Analysis Packages are available now and just a few mouse clicks away.  And best of all, they are free!

An Analysis Package is a complete profile stored in an XML file that you can download from our website and import into your copy of DS Data Explorer for your own use.  It will contain both the data source information as well as the Grid and Pivot table layout.

These Analysis Packages come "Ready to Use" but you are free to drag some different fields (maybe you want analysis by Territory and Sales Rep instead of just Inventory Category) onto the Grid or Pivot Table and save additional profiles in your DS Data Explorer so they're always available for reuse.

You can also export your own Profiles and create Analysis Packages to share.   We encourage you to email your Analysis Packs to us at webmaster@dimesoftinc.com and we'll include them in the listings so everyone can benefit. 

Check the download area in your My Account page for a current listing of Analysis Packages.  Download them all!

Version	Release Date	Notes	Manual	Upgrade Docs
2008.1.0.7	3/19/2008	Minor bug fix release: Fixed issue causing custom tables and views not to appear in the data source drop-down.  Hard coded profile property labels so systems not running US English as the default language will display prompts properly.	Manual	Upgrade
2008.1.0.6	3/5/2008	Initial Public Release (RTM)	Manual

Visit your My Account page to download the most recent version.