What Is SuiteAnalytics Workbook?
SuiteAnalytics Workbook is NetSuite's native analytics and visualization tool, introduced as part of the SuiteAnalytics platform. It allows you to build custom dashboards, create datasets from your NetSuite data, and design charts, tables, and KPIs without leaving the platform or exporting to external BI tools. Unlike saved searches or standard reports, Workbook provides drag-and-drop flexibility, interactive filters, and the ability to combine multiple data sources into a single view—making it ideal for ad-hoc analysis, executive dashboards, and recurring operational reports.
Workbook is available in NetSuite 2020.1 and later for accounts with SuiteAnalytics enabled. If you don't see it, check your account edition and feature enablement under Setup > Company > Enable Features.
When to Use Workbook vs. Saved Searches vs. Reports
Choosing the right tool depends on your use case. Use Workbook when you need interactive dashboards, multiple visualizations on one screen, drill-down capabilities, or combined datasets from different record types. Use Saved Searches when you need scheduled emails, workflow triggers, simple tabular exports, or lightweight lists. Use Standard Reports for formal financial statements and pre-built accounting reports. Many organizations use all three: saved searches feed workbooks, and workbooks complement standard reports for executive visibility.
| Tool | Best For | Limitations |
|---|---|---|
| Workbook | Interactive dashboards, multi-chart views, combined data | Performance limits on large datasets, requires SuiteAnalytics |
| Saved Search | Scheduled emails, workflows, exports | Tabular only, no charts |
| Standard Report | Formal financials, GAAP reports | Limited customization |
Step 1: Creating Your First Workbook
Navigate to Analytics > Workbook and click New Workbook. You'll start with a blank canvas. The interface has three main areas: the left panel shows your datasets; the center is the visualization area where you drag and drop; the right panel has chart and filter options. Add a dataset by clicking "Add Dataset" and selecting a saved search, report, or custom query.
For best performance, base datasets on saved searches that are already optimized—use indexed fields in criteria, limit result columns, and apply date or subsidiary filters at the search level. Avoid using raw reports with unbounded date ranges; instead, create a saved search with appropriate criteria and use that as the dataset source.
Step 2: Building Datasets
Your dataset defines the raw data for your workbook. You can combine multiple saved searches, join data from different sources, and add calculated columns. Use the Dataset Builder to add filters that apply at the data level—for example, restrict to the current subsidiary, last 12 months, or a specific department. These filters reduce the dataset size before visualization, improving load times.
Calculated columns let you add formulas (e.g., margin %, days outstanding, year-over-year change) without modifying the underlying saved search. Supported functions include basic math, CASE expressions, and date functions. Keep calculated columns simple; complex logic may slow rendering.
Step 3: Designing Visualizations
Drag fields from your dataset onto the canvas to create charts. Choose from bar, line, pie, pivot table, and KPI visualizations. Configure axes, colors, and labels in the right panel. Add filters so users can slice by date, subsidiary, or department without editing the workbook. Use the "Add Filter" option to make filters interactive—users change values from a dropdown or date picker.
Layout matters: place the most important metrics at the top or center. Use consistent color schemes across charts (e.g., green for positive, red for negative). For KPI portlets, show a single number with optional trend indicator. Pivot tables work well for detailed drill-down; limit columns to avoid overwhelming users.
Step 4: Sharing and Permissions
Workbooks can be private, shared with roles, or published to a tab. Use the Share option to grant access by role or individual user. Consider creating a "Finance Dashboard" workbook and publishing it to the Accounting role's home tab. Set up scheduled snapshots if you need to email static versions on a schedule—useful for weekly executive summaries.
Ensure users have access to the underlying data. If a saved search is restricted by role, users without access won't see data in the workbook. Test with a sample user in each target role before rollout.
Best Practices for Performance
- Limit dataset rows with filters (e.g., last 365 days, current subsidiary) to avoid timeouts
- Use indexed fields in underlying saved search criteria
- Avoid too many visualizations on one workbook—split into multiple workbooks if load time exceeds 10–15 seconds
- Test with realistic data volumes before rolling out to all users
- Prefer summary-level data over transaction-level when possible
Common Pitfalls and Troubleshooting
Workbook times out: Add more restrictive filters to the dataset, reduce the number of visualizations, or split into separate workbooks.
Empty charts: Verify the underlying saved search returns data when run standalone. Check filter values (e.g., date range) and permissions.
Incorrect totals: For summary charts, ensure you're grouping and aggregating correctly. Double-check the "Summarize by" and "Values" configuration.
Common Use Cases by Department
Finance: Revenue by month, AR aging, cash flow projection, budget vs. actual. Sales: Pipeline by stage, win rate, quota attainment, activity metrics. Operations: Inventory turns, order fulfillment cycle time, backlog, warehouse throughput. Executive: Consolidated KPIs across departments, trend charts, exception highlights. Each use case benefits from role-based workbooks that show only relevant data and dimensions.
Need help designing SuiteAnalytics workbooks for your organization? Contact YRK Consulting for process optimization and dashboard design.