Ways you can optimize report builder delivery, and a list of error messages that could occur occasionally.
Adobe changed the separator between dimensions and classifications from an underscore character (_) to ||. This change has compatibility implications for a Report Builder 5.0 user who opens a Report Builder v5.1 workbook with classification requests. Each time a workbook from a version older than v5.1 is opened, all its serialized classifications requests will be converted to this format.
This introduces a forward compatibility problem: Once converted to v5.1, if a workbook is shared with a user on Report Builder v5.0, that user will not be able to recognize the classification request (indeed, it is looking for "" but v5.1 serialized "||_".
You will experience the following side effect when opening a ARB v5.1 workbook with classification request:
Report builder requires authentication to create data requests from your report suites. Sometimes there are issues logging in to report builder depending on your settings within Analytics or your network.
|Invalid Login Company||This error most commonly occurs when either the login company is improperly entered, or if there are network activity issues. Do the following:|
|Firewall||Report builder uses ports 80 and 443. Ensure that these ports are allowed through your organization's firewall. See also Adobe's Internal IP Addresses for additional firewall exclusions.|
The following factors can increase request complexity and result in slower processing:
|Factors that can slow down deliveries|
|Factors that can slow down workbook runtime|
|Causes that result in workbook delivery failure||Complex Excel formulas in a workbook, particularly ones that involve date and time.|
|Cells returning 0s (no values)||An apostrophe or single quote in the Excel sheet name will cause report builder to return no values. (This is a Microsoft Excel limitation.)|
Individual Request Performance
Processing speed can be affected by the following settings:
|Setting||Faster Performance||Slower Performance|
|Breakdowns and the breakdown order||Few||Many|
|Example: If you break down A by Z, the number of items for A should always be less than the number of items for Z. If it is the other way around, the request time can increase significantly.|
|Date range||Small range||Wide range|
|Filtering||Specific filtering||Most Popular filtering|
|Number of entries||Small data set||Large data set|
Stagger scheduling over 24-hour period (see table below). Existing bookmarks , dashboards, and report builder workbooks scheduled close together may cause delays.
Schedule larger, more complex requests in the early morning to allow for manual pulls and refreshing to occur during the business day.
|Scheduling Time||1 a.m. - 2 a.m.||2 a.m. - 7 a.m.||7 a.m. - 6 p.m.||6 p.m. - Midnight|
|Report builder usage||Quiet||Very busy|
Higher volumes of users refreshing locally and requesting to "Send immediately."
Additionally, verify whether the API queue is cleared when scheduled workbooks time out.
Any scheduled report times out after four hours. The system attempts scheduling three more times, potentially resulting in a failure. (Generally, the larger the data set the longer it takes to run.) These can be seen in Analytics repoirting and report builder:
A list of error messages that could occur occasionally while you are using report builder.
This feature can only be applied on an open workbook.
If no workbooks (spreadsheet documents) are open in Excel, and you click one of the icons in the report builder toolbar, this message is displayed. In addition, the toolbar becomes disabled until you open a spreadsheet. However, you can click the on-line help icon while the toolbar is still enabled without causing this error.
You first need to exit the Request Wizard before activating the Request Manager.
While the Request Manager and the Request Wizard are linked functionally, it is not possible to start working with the Request Managerbefore completing or cancelling actions taken in the Request Wizard.
There is no request associated with this range.
This error message occurs if you click on the From Sheet button in the Request Manager when a cell of the spreadsheet contains no requests.
To identify which cells in the spreadsheet contain requests, click individual requests listed in the table in the Request Manager. If a request is associated with cells, the cells will show up highlighted when the request is selected in the table.
The selected Range is not valid. Please select another Range.
If a cell of the spreadsheet is selected and already has a request mapped to it, this error occurs. Either delete the request mapped to the cells or choose another range of cells to map.
When you want to delete cells, it is important to locate cells containing requests and delete the request before deleting the cells (removing rows or columns).
Please Exit the Excel Cell with focus before using this feature.
If you are in edit mode in an Excel cell and click one of the report builder icons, this error message appears. Edit mode in an Excel cell means that the cell is selected and the cursor appears inside the cell. You are also in edit mode in an Excel cell when you type directly into theFormula bar or into the Name Box at the top of Excel.
The range selected intersects another request's range. Please change your selection.
If you have already mapped a set of cells to the spreadsheet, this error is displayed.
One way to determine which cells are mapped before adding new requests is to close the Request Wizard and open the Request Manager. Then, select items listed in the request summary table one by one. Whenever you select a request in the list, the corresponding cells containing request mappings in the spreadsheet are highlighted.
This is one reason you should consider marking cells with highlighting, row or column information, or a formatting style before mapping multiple cells to multiple areas.
Sign in to like this content
My Excel file crashed when I was creating a data request. When I opened the file again, I encountered this:
"You first need to exit the Request Wizard form before activating Run Requests for all Sheets."
However, I can't seem to find the Request Wizard pop-up anymore. How do I fix this?
Sign in to like this content