SUPPORT / SAMPLES & SAS NOTES
 

Support

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

DetailsHotfixAboutRate It

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.)

  1. 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
  1. Create a copy of SEGuide.exe.config and rename the copy SEGuide.exe.config.ORIG.
  2. Open SEGuide.exe.config in a text editor.
  3. Add the following code to the end of the file, immediately before </configuration> :

<appSettings>

<add key="OLAPAnalyzerExecuteDefaultQuery" value="false" />

</appSettings>

  1. Save SEGuide.exe.config.
  2. Start a new session of SAS Enterprise Guide.


Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Enterprise Guidez/OS7.159.4 TS1M5
Microsoft® Windows® for x647.159.4 TS1M5
Microsoft Windows 8 Enterprise 32-bit7.159.4 TS1M5
Microsoft Windows 8 Enterprise x647.159.4 TS1M5
Microsoft Windows 8 Pro 32-bit7.159.4 TS1M5
Microsoft Windows 8 Pro x647.159.4 TS1M5
Microsoft Windows 8.1 Enterprise 32-bit7.159.4 TS1M5
Microsoft Windows 8.1 Enterprise x647.159.4 TS1M5
Microsoft Windows 8.1 Pro 32-bit7.159.4 TS1M5
Microsoft Windows 8.1 Pro x647.159.4 TS1M5
Microsoft Windows 107.159.4 TS1M5
Microsoft Windows Server 20087.159.4 TS1M5
Microsoft Windows Server 2008 R27.159.4 TS1M5
Microsoft Windows Server 2008 for x647.159.4 TS1M5
Microsoft Windows Server 2012 Datacenter7.159.4 TS1M5
Microsoft Windows Server 2012 R2 Datacenter7.159.4 TS1M5
Microsoft Windows Server 2012 R2 Std7.159.4 TS1M5
Microsoft Windows Server 2012 Std7.159.4 TS1M5
Microsoft Windows Server 20167.159.4 TS1M5
Windows 7 Enterprise 32 bit7.159.4 TS1M5
Windows 7 Enterprise x647.159.4 TS1M5
Windows 7 Home Premium 32 bit7.159.4 TS1M5
Windows 7 Home Premium x647.159.4 TS1M5
Windows 7 Professional 32 bit7.159.4 TS1M5
Windows 7 Professional x647.159.4 TS1M5
Windows 7 Ultimate 32 bit7.159.4 TS1M5
Windows 7 Ultimate x647.159.4 TS1M5
64-bit Enabled AIX7.159.4 TS1M5
64-bit Enabled Solaris7.159.4 TS1M5
HP-UX IPF7.159.4 TS1M5
Linux for x647.159.4 TS1M5
Solaris for x647.159.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.