SUPPORT / SAMPLES & SAS NOTES
 

Support

Usage Note 43113: Maximum length for member captions for a SAS OLAP cube

DetailsAboutRate It

The maximum length for member captions in a SAS OLAP cube is 256 bytes. For single-byte encodings, this means your captions can have up to 256 characters. When using a double-byte encoding or UTF-8, the maximum characters length depends on the number of bytes the individual characters of your string use.

For example, with UTF-8 encoding most Chinese characters use up to 3 bytes to store. If you have a member caption value that has 10 Chinese characters, it will take up to 30 bytes to store the value.

Therefore, with a 256 maximum length for a member caption, you might be able to store only 85 characters if all of the characters in the string use 3 bytes in UTF-8.

If you need to determine the length of your double-byte character values to see if they will fall within the allowed maximum length, you can verify the byte length using the LENGTH and KLENGTH functions to check the character length.

For example:



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS OLAP Serverz/OS9.1 TS1M3 SP4
Microsoft® Windows® for 64-Bit Itanium-based Systems9.1 TS1M3 SP4
Microsoft Windows Server 2003 Datacenter 64-bit Edition9.1 TS1M3 SP4
Microsoft Windows Server 2003 Enterprise 64-bit Edition9.1 TS1M3 SP4
Microsoft Windows XP 64-bit Edition9.1 TS1M3 SP4
Microsoft Windows 2000 Advanced Server9.1 TS1M3 SP4
Microsoft Windows 2000 Datacenter Server9.1 TS1M3 SP4
Microsoft Windows 2000 Server9.1 TS1M3 SP4
Microsoft Windows 2000 Professional9.1 TS1M3 SP4
Microsoft Windows NT Workstation9.1 TS1M3 SP4
Microsoft Windows Server 2003 Datacenter Edition9.1 TS1M3 SP4
Microsoft Windows Server 2003 Enterprise Edition9.1 TS1M3 SP4
Microsoft Windows Server 2003 Standard Edition9.1 TS1M3 SP4
Microsoft Windows XP Professional9.1 TS1M3 SP4
Windows Vista9.1 TS1M3 SP4
Windows Vista for x649.1 TS1M3 SP4
64-bit Enabled AIX9.1 TS1M3 SP4
64-bit Enabled HP-UX9.1 TS1M3 SP4
64-bit Enabled Solaris9.1 TS1M3 SP4
HP-UX IPF9.1 TS1M3 SP4
Linux9.1 TS1M3 SP4
Linux on Itanium9.1 TS1M3 SP4
OpenVMS Alpha9.1 TS1M3 SP4
Solaris for x649.1 TS1M3 SP4
Tru64 UNIX9.1 TS1M3 SP4
* 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.