Problem Note 35144: Cube Designer wizard ignores custom captions for the All member for dimensions that have only one hierarchy
The Dimension Designer - Define a Hierarchy window within the Cube Designer wizard in SAS® OLAP Cube Studio enables you to specify a custom value for the All member in a dimension. However, in SAS® 9.2, if your dimension has only one hierarchy defined, then the custom value will be reset back to the default when you exit that wizard window.
To circumvent this issue, you can save out the long form of the PROC OLAP code by using the Export Code button on the final window of the Cube Designer wizard, or by selecting Export Cube from the pop-up menu for the cube under the Cube folder of the Inventory tab. You can then edit the PROC OLAP code and specify the desired text for the All member, and then submit the PROC OLAP code through SAS® Enterprise Guide® or a batch SAS session.
Operating System and Release Information
| SAS System | SAS OLAP Cube Studio | Microsoft® Windows® for x64 | 4.2 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows XP Professional | 4.2 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Windows Vista | 4.2 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 |
*
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 |
| Topic: | Query and Reporting ==> OLAP (Online Analytical Processing)
|
| Date Modified: | 2012-04-19 16:27:19 |
| Date Created: | 2009-03-16 14:28:57 |
