Problem Note 62982: SAS® Enterprise Guide® runs a default query before displaying the Options window when "Always open with options" is selected for SAS® OLAP cubes
When Always open with options is enabled for SAS OLAP cubes, SAS Enterprise Guide executes a default query on the SAS® OLAP Server before it opens the Options window. If the default query result set is very large, the Options window, shown in the following display, might take a long time to open.
Click the Hot Fix tab in this note to access the hot fix for this issue. After the hot fix is applied, you can set a configuration property so that SAS Enterprise Guide opens the MDX Editor window. No default query is submitted to the OLAP Server before the MDX Editor window is opened. To use the property, perform the following steps. (These steps are also in the post-installation instructions for the hot fix.)
- Navigate to the SAS Enterprise Guide installation directory. For example:
- If you are using SAS Enterprise Guide 32-bit, navigate to .\Program Files (x86)\SASHome\x86\SASEnterpriseGuide\7.1
- If you are using SAS Enterprise Guide 64-bit, navigate to .\Program Files\SASHome\SASEnterpriseGuide\7.1
- Create a copy of SEGuide.exe.config and rename the copy SEGuide.exe.config.ORIG.
- Open SEGuide.exe.config in a text editor.
- Add the following code to the end of the file, immediately before </configuration> :
<appSettings>
<add key="OLAPAnalyzerExecuteDefaultQuery" value="false" />
</appSettings>
- Save SEGuide.exe.config.
- Start a new session of SAS Enterprise Guide.
Operating System and Release Information
SAS System | SAS Enterprise Guide | z/OS | 7.15 | | 9.4 TS1M5 | |
Microsoft® Windows® for x64 | 7.15 | | 9.4 TS1M5 | |
Microsoft Windows 8 Enterprise 32-bit | 7.15 | | 9.4 TS1M5 | |
Microsoft Windows 8 Enterprise x64 | 7.15 | | 9.4 TS1M5 | |
Microsoft Windows 8 Pro 32-bit | 7.15 | | 9.4 TS1M5 | |
Microsoft Windows 8 Pro x64 | 7.15 | | 9.4 TS1M5 | |
Microsoft Windows 8.1 Enterprise 32-bit | 7.15 | | 9.4 TS1M5 | |
Microsoft Windows 8.1 Enterprise x64 | 7.15 | | 9.4 TS1M5 | |
Microsoft Windows 8.1 Pro 32-bit | 7.15 | | 9.4 TS1M5 | |
Microsoft Windows 8.1 Pro x64 | 7.15 | | 9.4 TS1M5 | |
Microsoft Windows 10 | 7.15 | | 9.4 TS1M5 | |
Microsoft Windows Server 2008 | 7.15 | | 9.4 TS1M5 | |
Microsoft Windows Server 2008 R2 | 7.15 | | 9.4 TS1M5 | |
Microsoft Windows Server 2008 for x64 | 7.15 | | 9.4 TS1M5 | |
Microsoft Windows Server 2012 Datacenter | 7.15 | | 9.4 TS1M5 | |
Microsoft Windows Server 2012 R2 Datacenter | 7.15 | | 9.4 TS1M5 | |
Microsoft Windows Server 2012 R2 Std | 7.15 | | 9.4 TS1M5 | |
Microsoft Windows Server 2012 Std | 7.15 | | 9.4 TS1M5 | |
Microsoft Windows Server 2016 | 7.15 | | 9.4 TS1M5 | |
Windows 7 Enterprise 32 bit | 7.15 | | 9.4 TS1M5 | |
Windows 7 Enterprise x64 | 7.15 | | 9.4 TS1M5 | |
Windows 7 Home Premium 32 bit | 7.15 | | 9.4 TS1M5 | |
Windows 7 Home Premium x64 | 7.15 | | 9.4 TS1M5 | |
Windows 7 Professional 32 bit | 7.15 | | 9.4 TS1M5 | |
Windows 7 Professional x64 | 7.15 | | 9.4 TS1M5 | |
Windows 7 Ultimate 32 bit | 7.15 | | 9.4 TS1M5 | |
Windows 7 Ultimate x64 | 7.15 | | 9.4 TS1M5 | |
64-bit Enabled AIX | 7.15 | | 9.4 TS1M5 | |
64-bit Enabled Solaris | 7.15 | | 9.4 TS1M5 | |
HP-UX IPF | 7.15 | | 9.4 TS1M5 | |
Linux for x64 | 7.15 | | 9.4 TS1M5 | |
Solaris for x64 | 7.15 | | 9.4 TS1M5 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2018-11-28 11:22:22 |
Date Created: | 2018-09-25 12:29:57 |