Various factors can influence overall CJA performance as well as the performance of a project within Analysis Workspace. In Workspace, you might get an error message that says
This query is too complex. Please review best practices for building Analysis Workspace queries.
These best practices discuss which factors might lead to this error and how to simplify the report/project.
These are the most common query factors that influence overall CJA performance:
|Number of Freeform rows and columns||The total number of Freeform table cells in the project, calculated by rows * columns across all tables. Excludes hidden data sources. The guideline is 4000.||Reduce the number of columns in your table to only the most relevant data points. Reduce the number of rows in your table by adjusting the number of rows shown, applying a table filter, or applying a filter.|
|Used components||The total number of components used in the project. The guideline is 100.||The number of used components is not a direct influencer of performance. However, the complexity of those components will contribute to performance of the project. See optimizations in the “Additional factors” section below.|
|Longest date range||This factor displays the longest date range used the project. The guideline is 1 year.||Where possible, don’t pull in more data than you need. Narrow the panel calendar to the relevant dates for your analysis or use date range components (purple components) in your freeform tables. Date ranges used in a table override the panel date range. For example, you can add last month, last week and yesterday to the table columns to request those specific ranges of data. For more information on working with date ranges in Analysis Workspace, watch this video.
Additionally, minimize the number of year-over-year comparisons used in the project. When a year-over-year comparison is calculated, it looks across the full 13 months of data between the months of interest. This has the same impact as changing the panel date range to last 13 months.
|Filter complexity||Intricate filters can have a significant impact on project performance.||Factors that add complexity to a filter (in descending order of impact) include:
||While some of the complexity factors cannot be prevented, look for opportunities to reduce the complexity of your filters. In general, the more specific you can be with your filter criteria, the better. For example:
|Visualization complexity (filters, metrics, filters)||The type of visualization (e.g. fallout vs a freeform table) added to a project by itself does not influence project performance very much. It is the complexity of the visualization that adds to processing time.||Factors that add complexity to a visualization include:
|Data center capacity||The amount of reporting capacity you and other customers share within an Adobe data center.||This is impacted by the number of concurrent queries made by your organization and other organizations within your data center.||Your organization is entitled to a set capacity and if the system is under a light load, Adobe will shift more capacity to you, above and beyond your entitled allowance.|
|Number of concurrent queries||The number of queries that are being requested by your organization at the same time. Each organization is entitled to a minimum of 5 concurrent queries. If a report is taking a long time, typically it is due to the fact that it is in a queue with other reports. This means your organization is trying to run many concurrent requests against a specific data view.||Queries can come from API requests, reporting UIs (Analysis Workspace, Report Builder, etc.), scheduled projects, scheduled alerts, and concurrent users making reporting requests.||Spread your requests and schedules for the data view more evenly throughout the day. Also, shift your requests to off-peak times when possible. Monday mornings, Tuesday mornings, and the first of each month are peak reporting times.|
|Connection size||The amount of data collected into your Connection.||Consult with your implementation team or CJA expert to determine if there are implementation improvements that can be made to improve overall experience in CJA.|
|Complexity of dimension settings||Highly complex dimensions can have a significant impact on project performance, specifically dimensions or metrics based on complex custom fields.||Reduce the number of custom fields or create separate dimensions.|
|Dimensions with a lot of unique values||Also known as high-cardinality dimensions, these dimensions may impact reporting performance.||See high-cardinality dimensions||See high-cardinality dimensions|
Various factors can influence the performance of a project within Analysis Workspace. It’s important to know what those contributors are before you start building a project so that you can plan and build the project in the most optimal way. This section includes a list of factors that impact performance and optimizations you can make to ensure peak performance in Analysis Workspace.
Under Analysis Workspace > Help > Performance, you can see factors that impact your project’s performance, including network, browser, and project factors. For the most accurate results, allow the project to fully load before opening the Performance page.
Additionally, you can Download as CSV the performance contents to easily share with Adobe Customer Care or your internal IT teams.
The information on the Performance page varies each time the modal is opened, as factors are subject to change. Additionally, Adobe will continue to refine the guidelines provided as more data becomes available.
Help > Performance network factors include:
|Connection to Adobe||Adobe sends in 10 test calls when the performance page is opened. This represents the percentage of those calls to Adobe that succeed.||Local network issues or Adobe issues will impact this factor.||Check status.adobe.com to verify if there are any known service issues. Then, validate your local network connection.|
|Internet bandwidth||Available for Google Chrome only. Your browser’s estimate of the bandwidth at your location. The guideline is 2.0MB/s.||Your local network connection will impact this factor.||Validate your local network connection.|
|Internet latency||Adobe sends in 10 test calls when the performance page is opened. This represents the amount of time it takes on average for each request to go to Adobe and be returned. Put more simply, it is a measure of how fast the internet is between your location and Adobe. The guideline is < 1 second.||Local network issues, many open browser tabs, or Adobe issues will impact this factor.||Check status.adobe.com to verify if there are any known service issues. Then, validate your local network connection and close unused browser tabs.|
Help > Performance browser factors include:
|Computation speed||How fast your computer performs a processing test. The guideline is < 750ms.||Your hardware as well as concurrent programs will impact this factor.||Open your computer’s Task Manager (PC) or Activity Monitor (Mac) to determine if any programs can be closed. Then, close unused browser tabs or other programs.
If those actions do not help, discuss hardware details with your IT team.
|Memory used||Available for Google Chrome only. Every Workspace tab in a Google Chrome browser shares 4GB of memory in total. This represents the percent of that memory allowance that is being consumed by the current project. The guideline is 3500 MB, which is the point at which Workspace will begin surfacing memory errors.||Working in multiple tabs or downloading 50000 rows of data will contribute to increased memory usage.||If you receive a memory error, close other Workspace tabs and/or run 50000 row downloads one-at-a-time.|
|Local storage used||Data stored locally to your computer for use in the browser. Each origin (e.g. experience.adobe.com) has an allowance of 10MB.||Analysis Workspace uses local storage for several functions, including to store auto-saved (existing) projects, user settings, and feature flags.||To ensure Analysis Workspace functions do not become disrupted, clear local storage for the experience.adobe.com domain.|
|Rendering speed||FPS stands for Frames per second, which is how many times per second the browser draws the page on your screen. 24 FPS is commonly what the human eye can observe; if FPS is lower than that, you will observe rendering issues in Workspace.||FPS is impacted by multitasking across many Workspace projects at once and size of the project being viewed. Other programs running on your computer may have an impact, such as streaming, background scanners, etc. Additionally, your hardware will impact this factor.||Open your computer’s Task Manager (PC) or Activity Monitor (Mac) to determine if any programs can be closed. Then, close unused browser tabs or other programs.
If those actions do not help, discuss hardware details with your IT team.
Help > Performance project factors include:
|Number of queries||The total number of queries (requests) made to Adobe to retrieve data that is displayed in the project. Queries include ranked requests for tables, anomaly detection, sparklines, components shown in the left rail, and more. Excludes collapsed panels and visualizations. The guideline is 100.||Simplify your project where possible by splitting out data into several projects that serve a specific purpose or group of stakeholders. Use tags to organize projects into themes, and use direct linking to create an internal table of contents so that stakeholders can more easily find what they need.|
|Expanded panels (out of total panels)||The number of expanded panels out of the total number of panels in the project. The guideline is 5.||After taking steps to simplify your project, collapse panels in your project that do not need to viewed on load. When the project is opened, only expanded panels will be processed. Collapsed panels will not be processed until the user expands them.|
|Expanded visualizations (out of total visualizations)||The number of expanded tables and visualizations out of the total in the project, including hidden data sources. The guideline is 15.||After taking steps to simplify your project, collapse visualizations in your project that do not need to be viewed on load. Prioritize the visuals that are most important to the consumer of the report and break out supporting visuals into a separate, more detailed panel or project if needed.|
|Number of freeform cells||See the “Query factors” table above.|
|Used components||See the “Query factors” table above.|
|Longest date range||See the “Query factors” table above.|