NetSuite SuiteAnalytics Customization: A Complete Guide to Reports, Workbooks, Dashboards, and Beyond

Many NetSuite users still export data to spreadsheets for reporting and analysis. The process takes time and often creates multiple versions of the same information.

SuiteAnalytics gives you a set of tools for reporting, analysis, and data exploration inside NetSuite. These tools include Saved Searches, Reports, Workbooks, Dashboards, and SuiteAnalytics Connect.

Each tool serves a different purpose. A Saved Search helps you track operational data. A Workbook helps you analyze information across multiple records and datasets. Dashboards bring key metrics into a single view. SuiteAnalytics Connect extends NetSuite data to external reporting platforms.

Customization affects how well these tools support your reporting requirements. The right configuration helps users find answers faster, reduce manual reporting effort, and work with more relevant information.

This guide is intended for NetSuite administrators, business analysts, finance teams, reporting users, and decision-makers who want to improve reporting, gain better visibility into business data, and make more effective use of SuiteAnalytics.

Understanding the SuiteAnalytics Components

SuiteAnalytics consists of several reporting and analytics components. Each one serves a different purpose and supports a different level of customization. Understanding these differences helps you choose the right tool for each reporting requirement.

Saved Search Customization

Saved Searches are one of the most commonly used reporting tools in NetSuite. They give you access to real-time business data and support a wide range of reporting requirements.

Custom Fields and Formula Columns

You can add custom fields and formula columns to a Saved Search. Formula fields help you calculate values, combine data from multiple fields, and create custom reporting metrics.

Summary Types: GROUP, SUM, COUNT, and AVG

Summary types help you aggregate data within a Saved Search. For example, you can group transactions by customer, sales representative, or department and calculate totals, averages, or record counts.

These options help you turn large volumes of transactional data into meaningful summaries.

Dashboard Portlet Deployment and Automated Email Scheduling

Saved Searches work directly with NetSuite dashboards. You can add search results to a dashboard through a Saved Search portlet and monitor important information from a single screen.

You can also schedule Saved Searches and send results automatically by email. This reduces the need to run the same reports repeatedly.

When a Saved Search Reaches Its Limits

Saved Searches work well for operational reporting. They become less effective when you need advanced pivots, complex multi-record relationships, or deeper analytical reporting.

In these situations, SuiteAnalytics Workbooks are often a better fit.

SuiteAnalytics Workbook Customization

SuiteAnalytics Workbooks support deeper analysis than Saved Searches. They allow you to work with multiple datasets, create visualizations, and analyze information across different parts of the business from a single workspace.

Datasets

Datasets form the foundation of a Workbook. They determine which records and fields are available for analysis.

A Workbook can contain multiple datasets, allowing users to work with information from different sources. Datasets also support joins between related records and custom records, making more advanced reporting possible.

Pivot Tables

Pivot tables help users summarize and analyze large volumes of data. You can group records, apply filters, and calculate totals without building complex reports.

Workbooks also support custom formula measures, giving users greater flexibility when analyzing business data.

Charts

Workbooks include several chart types for visual analysis. Users can configure chart settings, adjust axes, apply filters, and present information in different formats.

Workbook charts can also be published to dashboards through Analytics Portlets.

Dataset Linking

Dataset linking allows users to compare metrics from multiple datasets within the same Workbook visualization. This allows users to compare information from different business areas within the same Workbook.

SuiteQL in Workbooks

SuiteAnalytics Workbooks use a visual interface for building datasets and reports. For many reporting requirements, users can create joins, filters, and calculations without writing code.

Some reporting scenarios involve complex joins, subqueries, or specialized query logic. In these situations, developers often use SuiteQL to retrieve and structure data more precisely.

The choice depends on the reporting requirement. Workbooks support visual analysis, while SuiteQL provides greater control over query design.

Performance Considerations

Workbook performance depends heavily on dataset design. Large datasets with broad criteria often increase loading times and make analysis slower.

Applying filters early and limiting unnecessary data helps improve Workbook performance.

How Dashboard Customization Works in SuiteAnalytics?

Dashboards help users access reports, KPIs, and analytics from a single screen. NetSuite allows administrators to customize dashboard layouts, publish standard dashboard configurations, and control what users see based on their roles.
 

Role-Based Layouts

Different teams require different information. Finance users often focus on financial performance and cash flow. Sales teams monitor opportunities and forecasts. Operations teams track orders, inventory, and fulfillment activity. Executives typically review high-level business metrics.

Role-based layouts help ensure users see information relevant to their responsibilities.

Portlet Types

NetSuite dashboards support several portlet types, including KPI Scorecards, Trend Graphs, Report Snapshots, Saved Search portlets, Analytics portlets, and Custom portlets.

Analytics portlets display Workbook visualizations directly on the dashboard, while Custom portlets allow developers to add specialized functionality through Suitelets and other custom solutions.

Publishing and Locking Dashboards

Administrators can publish dashboards to multiple users and roles. This helps maintain consistency across teams and reduces manual setup.

Dashboard locking provides additional control by preventing users from modifying specific dashboard components while leaving other areas available for personalization.

Role-Based Permissions

Dashboard visibility follows NetSuite's role-based security model. Users only see information they have permission to access.

This helps protect sensitive data while ensuring each role receives access to relevant reports, KPIs, and analytics.

Automatic Reminders Portlet Refresh

NetSuite 2026.1 introduced automatic refresh functionality for the Reminders portlet. The portlet now refreshes every 30 minutes and displays the last refresh time.

This reduces the need for manual refreshes and helps users view more current reminder information throughout the day.

Using SuiteAnalytics Connect for External Reporting

SuiteAnalytics Connect provides direct access to NetSuite data through ODBC, JDBC, and ADO.NET connections. It is designed for organizations that need to use NetSuite data in external reporting, analytics, and business intelligence platforms.

Unlike Workbooks and Dashboards, which operate inside NetSuite, Connect allows external tools to query NetSuite data directly.

What It Does: ODBC, JDBC, and ADO.NET Access

SuiteAnalytics Connect gives external applications access to NetSuite data through standard database connectivity technologies such as ODBC, JDBC, and ADO.NET.

Organizations often use Connect with reporting and analytics platforms such as Power BI, Tableau, and other business intelligence tools.

Critical 2026.1 Update

NetSuite 2026.1 removed support for the legacy NetSuite.com data source in SuiteAnalytics Connect. NetSuite2.com is now the only supported data source.

Organizations using SuiteAnalytics Connect should review existing integrations and reporting pipelines to ensure they use NetSuite2.com. Oracle also recommends upgrading the JDBC driver to version 8.10.184.0.

NetSuite2.com Benefits

NetSuite2.com supports OAuth 2.0 authentication, SuiteQL queries, and role-based access controls. These capabilities improve authentication, query flexibility, and access control for external reporting environments.

When to Use Connect vs Workbook

Workbooks are generally the better choice for reporting and analysis inside NetSuite. SuiteAnalytics Connect becomes more useful when data needs to move into external reporting and business intelligence platforms.

Saved Search vs Workbook vs Report: Choosing the Right Tool

SuiteAnalytics includes multiple reporting tools, and each one serves a different purpose. Choosing the right tool helps you avoid unnecessary complexity and build reports that are easier to maintain.
 

Saved Searches work well for operational reporting and alerts. Workbooks support deeper analysis and data visualization. Standard Reports remain the preferred option for financial statements and predefined reporting formats. SuiteAnalytics Connect is best suited for external reporting and business intelligence platforms.

AI-Powered SuiteAnalytics: New Capabilities in 2025 and 2026

Recent NetSuite updates introduce AI features across reporting and analytics workflows. These features help users summarize data, retrieve information, and interact with NetSuite through natural language and external AI platforms.

Narrative Insights

Narrative Insights generates written summaries for supported reports and analytics views. Users can select Generate Insight to receive a summary of trends, changes, and key metrics within the report.

Because the feature uses generative AI, the output may differ between requests.

NetSuite AI Assistant

NetSuite AI Assistant allows users to interact with NetSuite using natural language prompts. Users can ask questions, retrieve information, and perform tasks through a conversational interface instead of navigating menus or building reports manually.

Within analytics and reporting workflows, this helps users access information more quickly and reduces reliance on technical teams for routine reporting requests.

NetSuite AI Connector Service

NetSuite AI Connector Service uses Model Context Protocol (MCP) to connect external AI platforms with NetSuite. Access follows NetSuite's role-based security model

Oracle documentation references platforms such as ChatGPT and Claude as examples of external AI clients that can connect through this service.

Common Challenges in SuiteAnalytics Customization

SuiteAnalytics provides extensive reporting and analytics capabilities, but customization projects often face technical and administrative challenges. Understanding these limitations helps improve reporting performance and reduce maintenance issues.

Dataset Performance

Overly broad datasets often increase Workbook loading times and affect reporting performance. Large volumes of unnecessary data place additional processing demands on Workbooks and dashboards.

Applying filters early, limiting unnecessary records, and reducing dataset complexity helps improve responsiveness and makes analysis more efficient.

Permissions and Dataset Access

Dataset access follows NetSuite's permission model. Users may not have access to every dataset, Workbook, or analytics view by default.

Role permissions should be planned carefully to ensure users can access the reports and analytics they need.

Formula Differences

SuiteAnalytics formulas and Saved Search formulas do not always work the same way. Calculations that work in a Saved Search may require different syntax or logic when recreated in a Workbook or dataset.

This can create unexpected results when reports are moved between reporting tools.

Dashboard Overload

Dashboards often become less effective when too many portlets, reports, and visualizations are added to a single screen.

Each dashboard should focus on a defined set of business questions and reporting requirements.

Connect Migration

Organizations using SuiteAnalytics Connect should identify integrations that still rely on the legacy NetSuite.com data source. Oracle removed support for NetSuite.com in NetSuite 2026.1, making NetSuite2.com the supported data source.

Power BI, Tableau, and other external reporting integrations that have not been migrated may stop working after the upgrade.

Workbook Deployment Considerations

Organizations that use SuiteBundler should review Workbook deployment requirements before moving analytics assets between NetSuite environments. Reporting components do not always follow the same deployment process as traditional NetSuite customizations.

Deployment planning becomes especially important when Workbooks, datasets, and related analytics objects need to be maintained across multiple accounts or environments.

Best Practices for SuiteAnalytics Customization

SuiteAnalytics provides several options for reporting, analytics, and dashboard customization. Following a few practical guidelines helps improve performance, simplify maintenance, and create a more consistent reporting experience.

Design Datasets for Reuse

Datasets often support multiple Workbooks, dashboards, and reporting requirements. Creating reusable datasets reduces duplication and makes future reporting changes easier to manage.

Publish Standardized Role-Based Dashboards

Publishing standardized dashboards helps maintain consistency across teams. Users receive access to relevant reports, KPIs, and analytics without building dashboards from scratch.

Role-based dashboards also simplify administration and reporting governance.

Establish Naming Conventions

Clear naming conventions make reporting assets easier to find and maintain. Consistent names for Saved Searches, Datasets, Workbooks, and Dashboards reduce confusion as reporting environments grow.

Document Custom Formula Fields

Custom formulas often become difficult to interpret over time, especially when the original developer is no longer involved.

Documenting formulas helps future administrators understand reporting logic and simplifies maintenance.

Test Before Large-Scale Deployment

Reports and Workbooks should be tested with realistic data volumes before being deployed to larger user groups. Early testing helps identify performance issues, access restrictions, and reporting errors.

Keep SuiteAnalytics Connect Up to Date

Organizations using SuiteAnalytics Connect should review driver versions regularly. Oracle recommends upgrading to JDBC driver version 8.10.184.0 following the NetSuite 2026.1 changes to SuiteAnalytics Connect.

Conclusion

SuiteAnalytics includes several tools for reporting and analysis. Saved Searches support operational reporting. Workbooks support deeper analysis and visualizations. Dashboards bring key metrics into a single view. SuiteAnalytics Connect extends NetSuite data to external reporting platforms.

The most effective reporting setup depends on your reporting requirements, data sources, and users. A well-structured reporting environment makes information easier to find, reduces manual reporting effort, and supports better decision-making.

As an Oracle NetSuite Solution Provider, Jobin & Jismi helps organizations build reports, develop Workbooks, customize dashboards, and implement SuiteAnalytics Connect. Our team works with businesses to improve reporting processes and get more value from their NetSuite investment.

If you are planning a SuiteAnalytics project or looking to improve an existing reporting setup, contact us to discuss your goals.

Frequently Asked Questions

What is the difference between a Saved Search and a Workbook?

Saved Searches are best suited for operational reporting, lists, alerts, and day-to-day monitoring. Workbooks support more advanced analysis, including pivot tables, charts, linked datasets, and data visualizations. If you need deeper analysis across multiple data sources, a Workbook is usually the better choice.

Can Workbooks use data from custom records?

Yes. SuiteAnalytics Workbooks support custom records and multilevel joins. This allows businesses to include custom NetSuite data in reports, datasets, and visualizations.

What is SuiteQL, and when should I use it?

SuiteQL is NetSuite's SQL-based query language. It is typically used when reporting requirements involve complex joins, subqueries, or data relationships that are difficult to build through standard reporting tools. Developers often use SuiteQL for advanced reporting and analytics requirements.

Is the NetSuite.com data source still supported in SuiteAnalytics Connect?

No. Oracle removed support for the NetSuite.com data source in NetSuite 2026.1. Organizations using SuiteAnalytics Connect should migrate to NetSuite2.com and review existing integrations to ensure continued access to reporting data.

Can administrators publish dashboards to all users?

Administrators can publish dashboards to roles and groups of users. This helps maintain consistent reporting layouts while still allowing users to personalize approved areas of the dashboard where appropriate.

Does SuiteAnalytics include AI-generated report summaries?

Yes. Narrative Insights uses generative AI to create written summaries for supported reports and analytics views. Users can generate summaries that highlight trends, changes, and key metrics within the data.