Problem Note 38597: Multiple Language Support (MLS) OLAP cubes migrated from SAS® 9.1.3 might generate errors in Cube Designer in SAS® 9.2
 |  |  |  |
In SAS 9.2, if you attempt to edit a dimension for an OLAP cube using the Cube Designer wizard in SAS® OLAP Cube Studio, you might receive errors similar to the following when selecting to rebuild the cube on the Finish page of the wizard:
ERROR: The input column "Year" for level "Year" is missing from the input table. ERROR: Cube "MLScube" cannot be created.
This error appears even though the column YEAR does exist on the input table, and the column is registered in metadata.
This problem will most likely occur for Multiple Language Support (MLS) cubes that have been migrated from SAS 9.1.3. The problem is caused by a change in the case of the text stored internally for the language codes.
To circumvent this problem, you must rebuild the OLAP cube in SAS 9.2 after migration and before making any modifications via the Cube Designer in SAS OLAP Cube Studio.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS OLAP Cube Studio | Microsoft Windows XP Professional | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M2 |
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Windows Vista | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft® Windows® for x64 | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Type: | Problem Note |
| Priority: | high |
| Topic: | Query and Reporting ==> OLAP (Online Analytical Processing) |
| Date Modified: | 2010-02-05 14:15:52 |
| Date Created: | 2010-02-03 11:51:13 |