<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Troubleshooting &amp; Best Practices for Report Builder in Adobe Analytics Discussions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/troubleshooting-best-practices-for-report-builder/m-p/176677#M102</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;H1 class="title topictitle1" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-family: AdobeCleanLight; font-size: 1.675rem; margin: 0px; padding: 0px 0px 10px; color: rgb(75, 75, 75); line-height: normal;"&gt;Troubleshooting and Best Practices for Report Builder&lt;/H1&gt;&lt;DIV class="body conbody" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); color: rgb(75, 75, 75); font-family: AdobeClean; font-size: 16px; line-height: normal;"&gt;&lt;P class="shortdesc" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;Ways you can optimize report builder delivery, and a list of error messages that could occur occasionally.&lt;/P&gt;&lt;DIV class="section" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;H2 class="title sectiontitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-family: AdobeCleanLight; font-size: 1.5rem; margin: 24px 0px 0px; padding: 15px 0px 5px;"&gt;Report Builder 5.0 Users and Opening 5.1 Workbooks&lt;/H2&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;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.&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;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 "||_".&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;You will experience the following side effect when opening a ARB v5.1 workbook with classification request:&lt;/P&gt;&lt;UL class="ul" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding-right: 0px; padding-left: 0px; margin: 8px 20px 20px;"&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding-bottom: 0px; margin: 8px 0px 0px;"&gt;When opening the workbook, you will get the following warning: “This workbook was last saved using Report Builder v5.1. This version has introduced some features that are incompatible with the Report Builder version installed on this computer. It is highly recommended that you upgrade to the latest Report Builder version before updating this workbook.”&lt;/LI&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 8px 0px 0px; padding-bottom: 0px;"&gt;If you right-click an ARB request with classification, the Report Builder context menus (edit request, add dependent request...) will not show up.&lt;/LI&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 8px 0px 0px; padding-bottom: 0px;"&gt;If you perform a Refresh All, by clicking the third button, or by refreshing a set of requests from the Request Manager form, the classification request will execute without error. However, the classifications values will not be written out.&lt;/LI&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 8px 0px 0px; padding-bottom: 0px;"&gt;You can still edit the request by opening the Request Manager, then going from row to row, until it reaches the right request.&lt;/LI&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 8px 0px 0px; padding-bottom: 0px;"&gt;If you edit the request and leave all parameters the same and then click Finish, the response will be properly written out. Indeed, editing the request resolves the problem as the Response Layout parameters are re-serialized. So there is a workaround, although it is time consuming.&lt;/LI&gt;&lt;/UL&gt;&lt;/DIV&gt;&lt;DIV class="section" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;H2 class="title sectiontitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-family: AdobeCleanLight; font-size: 1.5rem; margin: 24px 0px 0px; padding: 15px 0px 5px;"&gt;Authentication Issues in Report Builder&lt;/H2&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;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&amp;nbsp;&lt;SPAN class="keyword" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Analytics&lt;/SPAN&gt;&amp;nbsp;or your network.&lt;/P&gt;&lt;DIV class="tablenoborder" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); border: 0px;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;TABLE border="1" cellpadding="4" cellspacing="0" class="table" frame="border" rules="all" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 12px; table-layout: fixed; width: 929px;" summary=""&gt;&lt;THEAD align="left" class="thead" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TH class="entry" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); color: rgb(255, 255, 255); padding: 8px; word-wrap: break-word; background-color: rgb(58, 62, 62);" valign="top" width="28.169014084507044%"&gt;Item&lt;/TH&gt;&lt;TH class="entry" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); color: rgb(255, 255, 255); padding: 8px; word-wrap: break-word; background-color: rgb(58, 62, 62);" valign="top" width="71.83098591549295%"&gt;Description&lt;/TH&gt;&lt;/TR&gt;&lt;/THEAD&gt;&lt;TBODY class="tbody" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TD class="entry" headers="d22813e111 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="28.169014084507044%"&gt;Invalid Login Company&lt;/TD&gt;&lt;TD class="entry" headers="d22813e114 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="71.83098591549295%"&gt;This error most commonly occurs when either the login company is improperly entered, or if there are network activity issues. Do the following:&lt;UL class="ul" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding-right: 0px; padding-left: 0px; margin: 8px 20px 20px;"&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding-bottom: 0px; margin: 8px 0px 0px;"&gt;Check the login company spelling to ensure that there is not a typo or an errant space.&lt;/LI&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 8px 0px 0px; padding-bottom: 0px;"&gt;Log in to&amp;nbsp;&lt;SPAN class="keyword" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Analytics&lt;/SPAN&gt;&amp;nbsp;with the same login company to ensure that it is correct. If you are not able to log in with those credentials, contact one of your organization's administrators to obtain the correct login company.&lt;/LI&gt;&lt;/UL&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TD class="entry" headers="d22813e111 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="28.169014084507044%"&gt;Firewall&lt;/TD&gt;&lt;TD class="entry" headers="d22813e114 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="71.83098591549295%"&gt;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.&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;DIV class="section" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;H2 class="title sectiontitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-family: AdobeCleanLight; font-size: 1.5rem; margin: 24px 0px 0px; padding: 15px 0px 5px;"&gt;Recommendations for Optimizing Requests&lt;/H2&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;The following factors can increase request complexity and result in slower processing:&lt;/P&gt;&lt;DIV class="tablenoborder" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); border: 0px;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;TABLE border="1" cellpadding="4" cellspacing="0" class="table" frame="border" rules="all" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 12px; table-layout: fixed; width: 929px;" summary=""&gt;&lt;THEAD align="left" class="thead" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TH class="entry" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); color: rgb(255, 255, 255); padding: 8px; word-wrap: break-word; background-color: rgb(58, 62, 62);" valign="top" width="28.24858757062147%"&gt;Item&lt;/TH&gt;&lt;TH class="entry" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); color: rgb(255, 255, 255); padding: 8px; word-wrap: break-word; background-color: rgb(58, 62, 62);" valign="top" width="71.75141242937853%"&gt;Description&lt;/TH&gt;&lt;/TR&gt;&lt;/THEAD&gt;&lt;TBODY class="tbody" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TD class="entry" headers="d22813e175 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="28.24858757062147%"&gt;Factors that can slow down deliveries&lt;/TD&gt;&lt;TD class="entry" headers="d22813e178 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="71.75141242937853%"&gt;&lt;UL class="ul" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding-right: 0px; padding-left: 0px; margin: 8px 20px 20px;"&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding-bottom: 0px; margin: 8px 0px 0px;"&gt;Too many bookmarks, dashboards,&amp;nbsp;&lt;SPAN class="keyword" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;ExcelClient&lt;/SPAN&gt;&amp;nbsp;workbooks and report builder workbooks were scheduled within a few hours&lt;/LI&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 8px 0px 0px; padding-bottom: 0px;"&gt;Too many report builder workbooks were scheduled at around the same time. When this occurs, the report API queue becomes backlogged.&lt;/LI&gt;&lt;/UL&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TD class="entry" headers="d22813e175 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="28.24858757062147%"&gt;Factors that can slow down workbook runtime&lt;/TD&gt;&lt;TD class="entry" headers="d22813e178 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="71.75141242937853%"&gt;&lt;UL class="ul" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding-right: 0px; padding-left: 0px; margin: 8px 20px 20px;"&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding-bottom: 0px; margin: 8px 0px 0px;"&gt;Significant increase in classifications.&lt;/LI&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 8px 0px 0px; padding-bottom: 0px;"&gt;Increasing the request date range over time.&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px 0px 8px; margin: 0px;"&gt;&lt;STRONG class="ph b" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Example&lt;/STRONG&gt;: Suppose you create a trended request using the&amp;nbsp;&lt;SPAN class="keyword wintitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Current Year&lt;/SPAN&gt;&amp;nbsp;setting, broken down by&amp;nbsp;&lt;SPAN class="keyword wintitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Day&lt;/SPAN&gt;&amp;nbsp;granularity. At the end of the year, the request will return more periods than the one created at the beginning of the year.&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px 0px 8px; margin: 0px;"&gt;(January 1 - January 30 versus January 1 - December 31.)&lt;/P&gt;&lt;/LI&gt;&lt;/UL&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TD class="entry" headers="d22813e175 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="28.24858757062147%"&gt;Causes that result in workbook delivery failure&lt;/TD&gt;&lt;TD class="entry" headers="d22813e178 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="71.75141242937853%"&gt;Complex Excel formulas in a workbook, particularly ones that involve date and time.&lt;/TD&gt;&lt;/TR&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TD class="entry" headers="d22813e175 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="28.24858757062147%"&gt;Cells returning 0s (no values)&lt;/TD&gt;&lt;TD class="entry" headers="d22813e178 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="71.75141242937853%"&gt;An apostrophe or single quote in the Excel sheet name will cause report builder to return no values. (This is a Microsoft Excel limitation.)&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;/DIV&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;&lt;STRONG class="ph b" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Individual Request Performance&lt;/STRONG&gt;&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;Processing speed can be affected by the following settings:&lt;/P&gt;&lt;DIV class="tablenoborder" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); border: 0px;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;TABLE border="1" cellpadding="4" cellspacing="0" class="table" frame="border" rules="all" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 12px; table-layout: fixed; width: 929px;" summary=""&gt;&lt;THEAD align="left" class="thead" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TH class="entry" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); color: rgb(255, 255, 255); padding: 8px; word-wrap: break-word; background-color: rgb(58, 62, 62);" valign="top" width="23.696682464454977%"&gt;Setting&lt;/TH&gt;&lt;TH class="entry" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); color: rgb(255, 255, 255); padding: 8px; word-wrap: break-word; background-color: rgb(58, 62, 62);" valign="top" width="25.82938388625593%"&gt;Faster Performance&lt;/TH&gt;&lt;TH class="entry" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); color: rgb(255, 255, 255); padding: 8px; word-wrap: break-word; background-color: rgb(58, 62, 62);" valign="top" width="50.4739336492891%"&gt;Slower Performance&lt;/TH&gt;&lt;/TR&gt;&lt;/THEAD&gt;&lt;TBODY class="tbody" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TD class="entry" headers="d22813e283 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="23.696682464454977%"&gt;Breakdowns and the breakdown order&lt;/TD&gt;&lt;TD class="entry" headers="d22813e286 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="25.82938388625593%"&gt;Few&lt;/TD&gt;&lt;TD class="entry" headers="d22813e289 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="50.4739336492891%"&gt;Many&lt;/TD&gt;&lt;/TR&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TD class="entry" headers="d22813e283 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="23.696682464454977%"&gt;&amp;nbsp;&lt;/TD&gt;&lt;TD class="entry" colspan="2" headers="d22813e286 d22813e289 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top"&gt;&lt;STRONG class="ph b" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Example&lt;/STRONG&gt;: 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.&lt;/TD&gt;&lt;/TR&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TD class="entry" headers="d22813e283 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="23.696682464454977%"&gt;Date range&lt;/TD&gt;&lt;TD class="entry" headers="d22813e286 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="25.82938388625593%"&gt;Small range&lt;/TD&gt;&lt;TD class="entry" headers="d22813e289 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="50.4739336492891%"&gt;Wide range&lt;/TD&gt;&lt;/TR&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TD class="entry" headers="d22813e283 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="23.696682464454977%"&gt;Filtering&lt;/TD&gt;&lt;TD class="entry" headers="d22813e286 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="25.82938388625593%"&gt;Specific filtering&lt;/TD&gt;&lt;TD class="entry" headers="d22813e289 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="50.4739336492891%"&gt;Most Popular filtering&lt;/TD&gt;&lt;/TR&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TD class="entry" headers="d22813e283 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="23.696682464454977%"&gt;Granularity&lt;/TD&gt;&lt;TD class="entry" headers="d22813e286 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="25.82938388625593%"&gt;Aggregated&lt;/TD&gt;&lt;TD class="entry" headers="d22813e289 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="50.4739336492891%"&gt;&lt;UL class="ul" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding-right: 0px; padding-left: 0px; margin: 8px 20px 20px;"&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding-bottom: 0px; margin: 8px 0px 0px;"&gt;Hourly&lt;/LI&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 8px 0px 0px; padding-bottom: 0px;"&gt;Daily&lt;/LI&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 8px 0px 0px; padding-bottom: 0px;"&gt;Weekly&lt;/LI&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 8px 0px 0px; padding-bottom: 0px;"&gt;Monthly&lt;/LI&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 8px 0px 0px; padding-bottom: 0px;"&gt;Quarterly&lt;/LI&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 8px 0px 0px; padding-bottom: 0px;"&gt;Yearly&lt;/LI&gt;&lt;/UL&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TD class="entry" headers="d22813e283 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="23.696682464454977%"&gt;Number of entries&lt;/TD&gt;&lt;TD class="entry" headers="d22813e286 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="25.82938388625593%"&gt;Small data set&lt;/TD&gt;&lt;TD class="entry" headers="d22813e289 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="50.4739336492891%"&gt;Large data set&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;/DIV&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;&lt;STRONG class="ph b" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Scheduling Time&lt;/STRONG&gt;&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;Stagger scheduling over 24-hour period (see table below). Existing bookmarks , dashboards, and report builder workbooks scheduled close together may cause delays.&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;Schedule larger, more complex requests in the early morning to allow for manual pulls and refreshing to occur during the business day.&lt;/P&gt;&lt;DIV class="tablenoborder" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); border: 0px;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;TABLE border="1" cellpadding="4" cellspacing="0" class="table" frame="border" rules="all" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 12px; table-layout: fixed; width: 929px;" summary=""&gt;&lt;THEAD align="left" class="thead" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TH class="entry" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); color: rgb(255, 255, 255); padding: 8px; word-wrap: break-word; background-color: rgb(58, 62, 62);" valign="top" width="17.636684303350968%"&gt;Scheduling Time&lt;/TH&gt;&lt;TH class="entry" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); color: rgb(255, 255, 255); padding: 8px; word-wrap: break-word; background-color: rgb(58, 62, 62);" valign="top" width="17.636684303350968%"&gt;1 a.m. - 2 a.m.&lt;/TH&gt;&lt;TH class="entry" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); color: rgb(255, 255, 255); padding: 8px; word-wrap: break-word; background-color: rgb(58, 62, 62);" valign="top" width="17.636684303350968%"&gt;2 a.m. - 7 a.m.&lt;/TH&gt;&lt;TH class="entry" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); color: rgb(255, 255, 255); padding: 8px; word-wrap: break-word; background-color: rgb(58, 62, 62);" valign="top" width="20.458553791887123%"&gt;7 a.m. - 6 p.m.&lt;/TH&gt;&lt;TH class="entry" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); color: rgb(255, 255, 255); padding: 8px; word-wrap: break-word; background-color: rgb(58, 62, 62);" valign="top" width="26.63139329805996%"&gt;6 p.m. - Midnight&lt;/TH&gt;&lt;/TR&gt;&lt;/THEAD&gt;&lt;TBODY class="tbody" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TD class="entry" headers="d22813e425 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="17.636684303350968%"&gt;Report builder usage&lt;/TD&gt;&lt;TD class="entry" headers="d22813e428 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="17.636684303350968%"&gt;Quiet&lt;/TD&gt;&lt;TD class="entry" headers="d22813e431 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="17.636684303350968%"&gt;Very busy&lt;/TD&gt;&lt;TD class="entry" headers="d22813e434 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="20.458553791887123%"&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px 0px 8px; margin: 0px;"&gt;Client-side usage.&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px 0px 8px; margin: 0px;"&gt;Higher volumes of users refreshing locally and requesting to "Send immediately."&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px 0px 8px; margin: 0px;"&gt;Additionally, verify whether the API queue is cleared when scheduled workbooks time out.&lt;/P&gt;&lt;/TD&gt;&lt;TD class="entry" headers="d22813e437 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="26.63139329805996%"&gt;Not busy&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;/DIV&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;&lt;STRONG class="ph b" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Timeouts&lt;/STRONG&gt;&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;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&amp;nbsp;&lt;SPAN class="keyword" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Analytics&lt;/SPAN&gt;&amp;nbsp;repoirting and report builder:&lt;/P&gt;&lt;UL class="ul" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding-right: 0px; padding-left: 0px; margin: 8px 20px 20px;"&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding-bottom: 0px; margin: 8px 0px 0px;"&gt;&lt;SPAN class="keyword" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Analytics&lt;/SPAN&gt;:&amp;nbsp;&lt;SPAN class="ph uicontrol" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-weight: bold;"&gt;Favorites&lt;/SPAN&gt;&amp;nbsp;&amp;gt;&amp;nbsp;&lt;SPAN class="ph uicontrol" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-weight: bold;"&gt;Scheduled Reports&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 8px 0px 0px; padding-bottom: 0px;"&gt;Report builder: Click&amp;nbsp;&lt;SPAN class="ph uicontrol" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-weight: bold;"&gt;Management&lt;/SPAN&gt;&amp;nbsp;in the&amp;nbsp;&lt;SPAN class="keyword wintitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Add-ins&lt;/SPAN&gt;&amp;nbsp;tab in Excel.&lt;/LI&gt;&lt;/UL&gt;&lt;/DIV&gt;&lt;DIV class="section" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;H2 class="title sectiontitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-family: AdobeCleanLight; font-size: 1.5rem; margin: 24px 0px 0px; padding: 15px 0px 5px;"&gt;Error Message Descriptions&lt;/H2&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;A list of error messages that could occur occasionally while you are using report builder.&lt;/P&gt;&lt;DIV class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;DIV class="note" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0.5em; margin-bottom: 0.5em; margin-left: 1em; padding: 5px; border-top-width: 1px; border-top-style: solid; border-top-color: rgb(238, 238, 244); border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(238, 238, 244);"&gt;&lt;SPAN class="notetitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-weight: bold; color: rgb(15, 85, 130);"&gt;Note:&lt;/SPAN&gt;&amp;nbsp;This is only a selection of error messages, and not an exhaustive list. For more information about resolving errors, contact your administrator.&lt;/DIV&gt;&lt;/DIV&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;&lt;STRONG class="ph b" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;EM class="ph i" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;This feature can only be applied on an open workbook.&lt;/EM&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;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.&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;&lt;STRONG class="ph b" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;EM class="ph i" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;You first need to exit the&amp;nbsp;&lt;SPAN class="keyword wintitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Request Wizard&amp;nbsp;&lt;/SPAN&gt;before activating the&amp;nbsp;&lt;SPAN class="keyword wintitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Request Manager&lt;/SPAN&gt;.&lt;/EM&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;While the&amp;nbsp;&lt;SPAN class="keyword wintitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Request Manager&lt;/SPAN&gt;&amp;nbsp;and the&amp;nbsp;&lt;SPAN class="keyword wintitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Request Wizard&lt;/SPAN&gt;&amp;nbsp;are linked functionally, it is not possible to start working with the&amp;nbsp;&lt;SPAN class="keyword wintitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Request Manager&lt;/SPAN&gt;before completing or cancelling actions taken in the&amp;nbsp;&lt;SPAN class="keyword wintitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Request Wizard&lt;/SPAN&gt;.&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;&lt;STRONG class="ph b" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;EM class="ph i" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;There is no request associated with this range.&lt;/EM&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;This error message occurs if you click on the&amp;nbsp;&lt;SPAN class="keyword wintitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;From Sheet&lt;/SPAN&gt;&amp;nbsp;button in the&amp;nbsp;&lt;SPAN class="keyword wintitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Request Manager&lt;/SPAN&gt;&amp;nbsp;when a cell of the spreadsheet contains no requests.&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;To identify which cells in the spreadsheet contain requests, click individual requests listed in the table in the&amp;nbsp;&lt;SPAN class="keyword wintitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Request Manager&lt;/SPAN&gt;. If a request is associated with cells, the cells will show up highlighted when the request is selected in the table.&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;&lt;STRONG class="ph b" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;EM class="ph i" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;The selected Range is not valid. Please select another Range.&lt;/EM&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;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.&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;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).&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;&lt;STRONG class="ph b" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;EM class="ph i" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Please Exit the Excel Cell with focus before using this feature.&lt;/EM&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;If you are in&amp;nbsp;&lt;EM class="ph i" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;edit mode&lt;/EM&gt;&amp;nbsp;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 the&lt;SPAN class="keyword wintitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Formula&lt;/SPAN&gt;&amp;nbsp;bar or into the&amp;nbsp;&lt;SPAN class="keyword wintitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Name Box&lt;/SPAN&gt;&amp;nbsp;at the top of Excel.&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;&lt;STRONG class="ph b" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;EM class="ph i" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;The range selected intersects another request's range. Please change your selection.&lt;/EM&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;If you have already mapped a set of cells to the spreadsheet, this error is displayed.&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;One way to determine which cells are mapped before adding new requests is to close the&amp;nbsp;&lt;SPAN class="keyword wintitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Request Wizard&lt;/SPAN&gt;&amp;nbsp;and open the&amp;nbsp;&lt;SPAN class="keyword wintitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Request Manager&lt;/SPAN&gt;. 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.&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;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.&lt;/P&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Mon, 30 Nov 2015 07:37:30 GMT</pubDate>
    <dc:creator>TanmayMathur</dc:creator>
    <dc:date>2015-11-30T07:37:30Z</dc:date>
    <item>
      <title>Troubleshooting &amp; Best Practices for Report Builder</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/troubleshooting-best-practices-for-report-builder/m-p/176677#M102</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;H1 class="title topictitle1" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-family: AdobeCleanLight; font-size: 1.675rem; margin: 0px; padding: 0px 0px 10px; color: rgb(75, 75, 75); line-height: normal;"&gt;Troubleshooting and Best Practices for Report Builder&lt;/H1&gt;&lt;DIV class="body conbody" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); color: rgb(75, 75, 75); font-family: AdobeClean; font-size: 16px; line-height: normal;"&gt;&lt;P class="shortdesc" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;Ways you can optimize report builder delivery, and a list of error messages that could occur occasionally.&lt;/P&gt;&lt;DIV class="section" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;H2 class="title sectiontitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-family: AdobeCleanLight; font-size: 1.5rem; margin: 24px 0px 0px; padding: 15px 0px 5px;"&gt;Report Builder 5.0 Users and Opening 5.1 Workbooks&lt;/H2&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;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.&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;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 "||_".&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;You will experience the following side effect when opening a ARB v5.1 workbook with classification request:&lt;/P&gt;&lt;UL class="ul" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding-right: 0px; padding-left: 0px; margin: 8px 20px 20px;"&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding-bottom: 0px; margin: 8px 0px 0px;"&gt;When opening the workbook, you will get the following warning: “This workbook was last saved using Report Builder v5.1. This version has introduced some features that are incompatible with the Report Builder version installed on this computer. It is highly recommended that you upgrade to the latest Report Builder version before updating this workbook.”&lt;/LI&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 8px 0px 0px; padding-bottom: 0px;"&gt;If you right-click an ARB request with classification, the Report Builder context menus (edit request, add dependent request...) will not show up.&lt;/LI&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 8px 0px 0px; padding-bottom: 0px;"&gt;If you perform a Refresh All, by clicking the third button, or by refreshing a set of requests from the Request Manager form, the classification request will execute without error. However, the classifications values will not be written out.&lt;/LI&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 8px 0px 0px; padding-bottom: 0px;"&gt;You can still edit the request by opening the Request Manager, then going from row to row, until it reaches the right request.&lt;/LI&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 8px 0px 0px; padding-bottom: 0px;"&gt;If you edit the request and leave all parameters the same and then click Finish, the response will be properly written out. Indeed, editing the request resolves the problem as the Response Layout parameters are re-serialized. So there is a workaround, although it is time consuming.&lt;/LI&gt;&lt;/UL&gt;&lt;/DIV&gt;&lt;DIV class="section" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;H2 class="title sectiontitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-family: AdobeCleanLight; font-size: 1.5rem; margin: 24px 0px 0px; padding: 15px 0px 5px;"&gt;Authentication Issues in Report Builder&lt;/H2&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;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&amp;nbsp;&lt;SPAN class="keyword" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Analytics&lt;/SPAN&gt;&amp;nbsp;or your network.&lt;/P&gt;&lt;DIV class="tablenoborder" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); border: 0px;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;TABLE border="1" cellpadding="4" cellspacing="0" class="table" frame="border" rules="all" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 12px; table-layout: fixed; width: 929px;" summary=""&gt;&lt;THEAD align="left" class="thead" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TH class="entry" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); color: rgb(255, 255, 255); padding: 8px; word-wrap: break-word; background-color: rgb(58, 62, 62);" valign="top" width="28.169014084507044%"&gt;Item&lt;/TH&gt;&lt;TH class="entry" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); color: rgb(255, 255, 255); padding: 8px; word-wrap: break-word; background-color: rgb(58, 62, 62);" valign="top" width="71.83098591549295%"&gt;Description&lt;/TH&gt;&lt;/TR&gt;&lt;/THEAD&gt;&lt;TBODY class="tbody" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TD class="entry" headers="d22813e111 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="28.169014084507044%"&gt;Invalid Login Company&lt;/TD&gt;&lt;TD class="entry" headers="d22813e114 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="71.83098591549295%"&gt;This error most commonly occurs when either the login company is improperly entered, or if there are network activity issues. Do the following:&lt;UL class="ul" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding-right: 0px; padding-left: 0px; margin: 8px 20px 20px;"&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding-bottom: 0px; margin: 8px 0px 0px;"&gt;Check the login company spelling to ensure that there is not a typo or an errant space.&lt;/LI&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 8px 0px 0px; padding-bottom: 0px;"&gt;Log in to&amp;nbsp;&lt;SPAN class="keyword" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Analytics&lt;/SPAN&gt;&amp;nbsp;with the same login company to ensure that it is correct. If you are not able to log in with those credentials, contact one of your organization's administrators to obtain the correct login company.&lt;/LI&gt;&lt;/UL&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TD class="entry" headers="d22813e111 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="28.169014084507044%"&gt;Firewall&lt;/TD&gt;&lt;TD class="entry" headers="d22813e114 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="71.83098591549295%"&gt;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.&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;DIV class="section" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;H2 class="title sectiontitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-family: AdobeCleanLight; font-size: 1.5rem; margin: 24px 0px 0px; padding: 15px 0px 5px;"&gt;Recommendations for Optimizing Requests&lt;/H2&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;The following factors can increase request complexity and result in slower processing:&lt;/P&gt;&lt;DIV class="tablenoborder" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); border: 0px;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;TABLE border="1" cellpadding="4" cellspacing="0" class="table" frame="border" rules="all" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 12px; table-layout: fixed; width: 929px;" summary=""&gt;&lt;THEAD align="left" class="thead" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TH class="entry" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); color: rgb(255, 255, 255); padding: 8px; word-wrap: break-word; background-color: rgb(58, 62, 62);" valign="top" width="28.24858757062147%"&gt;Item&lt;/TH&gt;&lt;TH class="entry" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); color: rgb(255, 255, 255); padding: 8px; word-wrap: break-word; background-color: rgb(58, 62, 62);" valign="top" width="71.75141242937853%"&gt;Description&lt;/TH&gt;&lt;/TR&gt;&lt;/THEAD&gt;&lt;TBODY class="tbody" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TD class="entry" headers="d22813e175 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="28.24858757062147%"&gt;Factors that can slow down deliveries&lt;/TD&gt;&lt;TD class="entry" headers="d22813e178 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="71.75141242937853%"&gt;&lt;UL class="ul" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding-right: 0px; padding-left: 0px; margin: 8px 20px 20px;"&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding-bottom: 0px; margin: 8px 0px 0px;"&gt;Too many bookmarks, dashboards,&amp;nbsp;&lt;SPAN class="keyword" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;ExcelClient&lt;/SPAN&gt;&amp;nbsp;workbooks and report builder workbooks were scheduled within a few hours&lt;/LI&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 8px 0px 0px; padding-bottom: 0px;"&gt;Too many report builder workbooks were scheduled at around the same time. When this occurs, the report API queue becomes backlogged.&lt;/LI&gt;&lt;/UL&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TD class="entry" headers="d22813e175 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="28.24858757062147%"&gt;Factors that can slow down workbook runtime&lt;/TD&gt;&lt;TD class="entry" headers="d22813e178 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="71.75141242937853%"&gt;&lt;UL class="ul" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding-right: 0px; padding-left: 0px; margin: 8px 20px 20px;"&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding-bottom: 0px; margin: 8px 0px 0px;"&gt;Significant increase in classifications.&lt;/LI&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 8px 0px 0px; padding-bottom: 0px;"&gt;Increasing the request date range over time.&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px 0px 8px; margin: 0px;"&gt;&lt;STRONG class="ph b" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Example&lt;/STRONG&gt;: Suppose you create a trended request using the&amp;nbsp;&lt;SPAN class="keyword wintitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Current Year&lt;/SPAN&gt;&amp;nbsp;setting, broken down by&amp;nbsp;&lt;SPAN class="keyword wintitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Day&lt;/SPAN&gt;&amp;nbsp;granularity. At the end of the year, the request will return more periods than the one created at the beginning of the year.&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px 0px 8px; margin: 0px;"&gt;(January 1 - January 30 versus January 1 - December 31.)&lt;/P&gt;&lt;/LI&gt;&lt;/UL&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TD class="entry" headers="d22813e175 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="28.24858757062147%"&gt;Causes that result in workbook delivery failure&lt;/TD&gt;&lt;TD class="entry" headers="d22813e178 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="71.75141242937853%"&gt;Complex Excel formulas in a workbook, particularly ones that involve date and time.&lt;/TD&gt;&lt;/TR&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TD class="entry" headers="d22813e175 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="28.24858757062147%"&gt;Cells returning 0s (no values)&lt;/TD&gt;&lt;TD class="entry" headers="d22813e178 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="71.75141242937853%"&gt;An apostrophe or single quote in the Excel sheet name will cause report builder to return no values. (This is a Microsoft Excel limitation.)&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;/DIV&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;&lt;STRONG class="ph b" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Individual Request Performance&lt;/STRONG&gt;&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;Processing speed can be affected by the following settings:&lt;/P&gt;&lt;DIV class="tablenoborder" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); border: 0px;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;TABLE border="1" cellpadding="4" cellspacing="0" class="table" frame="border" rules="all" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 12px; table-layout: fixed; width: 929px;" summary=""&gt;&lt;THEAD align="left" class="thead" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TH class="entry" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); color: rgb(255, 255, 255); padding: 8px; word-wrap: break-word; background-color: rgb(58, 62, 62);" valign="top" width="23.696682464454977%"&gt;Setting&lt;/TH&gt;&lt;TH class="entry" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); color: rgb(255, 255, 255); padding: 8px; word-wrap: break-word; background-color: rgb(58, 62, 62);" valign="top" width="25.82938388625593%"&gt;Faster Performance&lt;/TH&gt;&lt;TH class="entry" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); color: rgb(255, 255, 255); padding: 8px; word-wrap: break-word; background-color: rgb(58, 62, 62);" valign="top" width="50.4739336492891%"&gt;Slower Performance&lt;/TH&gt;&lt;/TR&gt;&lt;/THEAD&gt;&lt;TBODY class="tbody" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TD class="entry" headers="d22813e283 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="23.696682464454977%"&gt;Breakdowns and the breakdown order&lt;/TD&gt;&lt;TD class="entry" headers="d22813e286 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="25.82938388625593%"&gt;Few&lt;/TD&gt;&lt;TD class="entry" headers="d22813e289 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="50.4739336492891%"&gt;Many&lt;/TD&gt;&lt;/TR&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TD class="entry" headers="d22813e283 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="23.696682464454977%"&gt;&amp;nbsp;&lt;/TD&gt;&lt;TD class="entry" colspan="2" headers="d22813e286 d22813e289 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top"&gt;&lt;STRONG class="ph b" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Example&lt;/STRONG&gt;: 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.&lt;/TD&gt;&lt;/TR&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TD class="entry" headers="d22813e283 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="23.696682464454977%"&gt;Date range&lt;/TD&gt;&lt;TD class="entry" headers="d22813e286 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="25.82938388625593%"&gt;Small range&lt;/TD&gt;&lt;TD class="entry" headers="d22813e289 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="50.4739336492891%"&gt;Wide range&lt;/TD&gt;&lt;/TR&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TD class="entry" headers="d22813e283 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="23.696682464454977%"&gt;Filtering&lt;/TD&gt;&lt;TD class="entry" headers="d22813e286 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="25.82938388625593%"&gt;Specific filtering&lt;/TD&gt;&lt;TD class="entry" headers="d22813e289 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="50.4739336492891%"&gt;Most Popular filtering&lt;/TD&gt;&lt;/TR&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TD class="entry" headers="d22813e283 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="23.696682464454977%"&gt;Granularity&lt;/TD&gt;&lt;TD class="entry" headers="d22813e286 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="25.82938388625593%"&gt;Aggregated&lt;/TD&gt;&lt;TD class="entry" headers="d22813e289 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="50.4739336492891%"&gt;&lt;UL class="ul" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding-right: 0px; padding-left: 0px; margin: 8px 20px 20px;"&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding-bottom: 0px; margin: 8px 0px 0px;"&gt;Hourly&lt;/LI&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 8px 0px 0px; padding-bottom: 0px;"&gt;Daily&lt;/LI&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 8px 0px 0px; padding-bottom: 0px;"&gt;Weekly&lt;/LI&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 8px 0px 0px; padding-bottom: 0px;"&gt;Monthly&lt;/LI&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 8px 0px 0px; padding-bottom: 0px;"&gt;Quarterly&lt;/LI&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 8px 0px 0px; padding-bottom: 0px;"&gt;Yearly&lt;/LI&gt;&lt;/UL&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TD class="entry" headers="d22813e283 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="23.696682464454977%"&gt;Number of entries&lt;/TD&gt;&lt;TD class="entry" headers="d22813e286 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="25.82938388625593%"&gt;Small data set&lt;/TD&gt;&lt;TD class="entry" headers="d22813e289 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="50.4739336492891%"&gt;Large data set&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;/DIV&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;&lt;STRONG class="ph b" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Scheduling Time&lt;/STRONG&gt;&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;Stagger scheduling over 24-hour period (see table below). Existing bookmarks , dashboards, and report builder workbooks scheduled close together may cause delays.&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;Schedule larger, more complex requests in the early morning to allow for manual pulls and refreshing to occur during the business day.&lt;/P&gt;&lt;DIV class="tablenoborder" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); border: 0px;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;TABLE border="1" cellpadding="4" cellspacing="0" class="table" frame="border" rules="all" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 12px; table-layout: fixed; width: 929px;" summary=""&gt;&lt;THEAD align="left" class="thead" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TH class="entry" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); color: rgb(255, 255, 255); padding: 8px; word-wrap: break-word; background-color: rgb(58, 62, 62);" valign="top" width="17.636684303350968%"&gt;Scheduling Time&lt;/TH&gt;&lt;TH class="entry" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); color: rgb(255, 255, 255); padding: 8px; word-wrap: break-word; background-color: rgb(58, 62, 62);" valign="top" width="17.636684303350968%"&gt;1 a.m. - 2 a.m.&lt;/TH&gt;&lt;TH class="entry" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); color: rgb(255, 255, 255); padding: 8px; word-wrap: break-word; background-color: rgb(58, 62, 62);" valign="top" width="17.636684303350968%"&gt;2 a.m. - 7 a.m.&lt;/TH&gt;&lt;TH class="entry" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); color: rgb(255, 255, 255); padding: 8px; word-wrap: break-word; background-color: rgb(58, 62, 62);" valign="top" width="20.458553791887123%"&gt;7 a.m. - 6 p.m.&lt;/TH&gt;&lt;TH class="entry" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); color: rgb(255, 255, 255); padding: 8px; word-wrap: break-word; background-color: rgb(58, 62, 62);" valign="top" width="26.63139329805996%"&gt;6 p.m. - Midnight&lt;/TH&gt;&lt;/TR&gt;&lt;/THEAD&gt;&lt;TBODY class="tbody" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TR class="row" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;TD class="entry" headers="d22813e425 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="17.636684303350968%"&gt;Report builder usage&lt;/TD&gt;&lt;TD class="entry" headers="d22813e428 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="17.636684303350968%"&gt;Quiet&lt;/TD&gt;&lt;TD class="entry" headers="d22813e431 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="17.636684303350968%"&gt;Very busy&lt;/TD&gt;&lt;TD class="entry" headers="d22813e434 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="20.458553791887123%"&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px 0px 8px; margin: 0px;"&gt;Client-side usage.&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px 0px 8px; margin: 0px;"&gt;Higher volumes of users refreshing locally and requesting to "Send immediately."&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px 0px 8px; margin: 0px;"&gt;Additionally, verify whether the API queue is cleared when scheduled workbooks time out.&lt;/P&gt;&lt;/TD&gt;&lt;TD class="entry" headers="d22813e437 " style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); vertical-align: top; border: 1px solid rgb(0, 0, 0); padding: 10px 8px; word-wrap: break-word;" valign="top" width="26.63139329805996%"&gt;Not busy&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;/DIV&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;&lt;STRONG class="ph b" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Timeouts&lt;/STRONG&gt;&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;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&amp;nbsp;&lt;SPAN class="keyword" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Analytics&lt;/SPAN&gt;&amp;nbsp;repoirting and report builder:&lt;/P&gt;&lt;UL class="ul" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding-right: 0px; padding-left: 0px; margin: 8px 20px 20px;"&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding-bottom: 0px; margin: 8px 0px 0px;"&gt;&lt;SPAN class="keyword" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Analytics&lt;/SPAN&gt;:&amp;nbsp;&lt;SPAN class="ph uicontrol" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-weight: bold;"&gt;Favorites&lt;/SPAN&gt;&amp;nbsp;&amp;gt;&amp;nbsp;&lt;SPAN class="ph uicontrol" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-weight: bold;"&gt;Scheduled Reports&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI class="li" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 8px 0px 0px; padding-bottom: 0px;"&gt;Report builder: Click&amp;nbsp;&lt;SPAN class="ph uicontrol" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-weight: bold;"&gt;Management&lt;/SPAN&gt;&amp;nbsp;in the&amp;nbsp;&lt;SPAN class="keyword wintitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Add-ins&lt;/SPAN&gt;&amp;nbsp;tab in Excel.&lt;/LI&gt;&lt;/UL&gt;&lt;/DIV&gt;&lt;DIV class="section" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;H2 class="title sectiontitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-family: AdobeCleanLight; font-size: 1.5rem; margin: 24px 0px 0px; padding: 15px 0px 5px;"&gt;Error Message Descriptions&lt;/H2&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;A list of error messages that could occur occasionally while you are using report builder.&lt;/P&gt;&lt;DIV class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;DIV class="note" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0.5em; margin-bottom: 0.5em; margin-left: 1em; padding: 5px; border-top-width: 1px; border-top-style: solid; border-top-color: rgb(238, 238, 244); border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(238, 238, 244);"&gt;&lt;SPAN class="notetitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-weight: bold; color: rgb(15, 85, 130);"&gt;Note:&lt;/SPAN&gt;&amp;nbsp;This is only a selection of error messages, and not an exhaustive list. For more information about resolving errors, contact your administrator.&lt;/DIV&gt;&lt;/DIV&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;&lt;STRONG class="ph b" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;EM class="ph i" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;This feature can only be applied on an open workbook.&lt;/EM&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;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.&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;&lt;STRONG class="ph b" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;EM class="ph i" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;You first need to exit the&amp;nbsp;&lt;SPAN class="keyword wintitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Request Wizard&amp;nbsp;&lt;/SPAN&gt;before activating the&amp;nbsp;&lt;SPAN class="keyword wintitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Request Manager&lt;/SPAN&gt;.&lt;/EM&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;While the&amp;nbsp;&lt;SPAN class="keyword wintitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Request Manager&lt;/SPAN&gt;&amp;nbsp;and the&amp;nbsp;&lt;SPAN class="keyword wintitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Request Wizard&lt;/SPAN&gt;&amp;nbsp;are linked functionally, it is not possible to start working with the&amp;nbsp;&lt;SPAN class="keyword wintitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Request Manager&lt;/SPAN&gt;before completing or cancelling actions taken in the&amp;nbsp;&lt;SPAN class="keyword wintitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Request Wizard&lt;/SPAN&gt;.&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;&lt;STRONG class="ph b" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;EM class="ph i" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;There is no request associated with this range.&lt;/EM&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;This error message occurs if you click on the&amp;nbsp;&lt;SPAN class="keyword wintitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;From Sheet&lt;/SPAN&gt;&amp;nbsp;button in the&amp;nbsp;&lt;SPAN class="keyword wintitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Request Manager&lt;/SPAN&gt;&amp;nbsp;when a cell of the spreadsheet contains no requests.&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;To identify which cells in the spreadsheet contain requests, click individual requests listed in the table in the&amp;nbsp;&lt;SPAN class="keyword wintitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Request Manager&lt;/SPAN&gt;. If a request is associated with cells, the cells will show up highlighted when the request is selected in the table.&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;&lt;STRONG class="ph b" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;EM class="ph i" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;The selected Range is not valid. Please select another Range.&lt;/EM&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;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.&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;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).&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;&lt;STRONG class="ph b" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;EM class="ph i" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Please Exit the Excel Cell with focus before using this feature.&lt;/EM&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;If you are in&amp;nbsp;&lt;EM class="ph i" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;edit mode&lt;/EM&gt;&amp;nbsp;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 the&lt;SPAN class="keyword wintitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Formula&lt;/SPAN&gt;&amp;nbsp;bar or into the&amp;nbsp;&lt;SPAN class="keyword wintitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Name Box&lt;/SPAN&gt;&amp;nbsp;at the top of Excel.&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;&lt;STRONG class="ph b" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;&lt;EM class="ph i" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;The range selected intersects another request's range. Please change your selection.&lt;/EM&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;If you have already mapped a set of cells to the spreadsheet, this error is displayed.&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;One way to determine which cells are mapped before adding new requests is to close the&amp;nbsp;&lt;SPAN class="keyword wintitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Request Wizard&lt;/SPAN&gt;&amp;nbsp;and open the&amp;nbsp;&lt;SPAN class="keyword wintitle" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"&gt;Request Manager&lt;/SPAN&gt;. 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.&lt;/P&gt;&lt;P class="p" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding: 0px;"&gt;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.&lt;/P&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 30 Nov 2015 07:37:30 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/troubleshooting-best-practices-for-report-builder/m-p/176677#M102</guid>
      <dc:creator>TanmayMathur</dc:creator>
      <dc:date>2015-11-30T07:37:30Z</dc:date>
    </item>
    <item>
      <title>Re: Troubleshooting &amp; Best Practices for Report Builder</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/troubleshooting-best-practices-for-report-builder/m-p/453264#M2955</link>
      <description>&lt;P&gt;Hi Tanmay,&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;My Excel file crashed when I was creating a data request. When I opened the file again, I encountered this:&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;"You first need to exit the Request Wizard form before activating Run Requests for all Sheets."&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;However, I can't seem to find the Request Wizard pop-up anymore. How do I fix this?&lt;/P&gt;</description>
      <pubDate>Wed, 25 May 2022 03:58:07 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/troubleshooting-best-practices-for-report-builder/m-p/453264#M2955</guid>
      <dc:creator>ain_nazira</dc:creator>
      <dc:date>2022-05-25T03:58:07Z</dc:date>
    </item>
  </channel>
</rss>

