Analytics > Designing an Analysis > Getting Started with Analytics > Language Support for Picklists in Analytics
Language Support for Picklists in Analytics
Analytics supports the display of picklist values in your user language in addition to the company’s default language. The following table lists the record types that support these picklists and the name of the picklist subfolders. Each subfolder contains a set of picklist fields that you can use to display the picklist values in your user language.
Record Type
|
Historical or Real-Time
|
Subfolder Name
|
Account
|
Historical and Real-Time
|
Account Picklist Fields (User Language)
|
Account Relationship
|
Historical and Real-Time
|
Account Relationship Picklist Fields (User Language)
|
Activity
|
Historical and Real-Time
|
Activity Picklist Fields (User Language)
|
Assessment
|
Real-Time
|
Assessment Picklist Fields (User Language)
|
Asset
|
Historical and Real-Time
|
Asset Picklist Fields (User Language)
|
Business Plan
|
Real-Time
|
Business Plan Picklist Fields (User Language)
|
Campaign
|
Historical and Real-Time
|
Campaign Picklist Fields (User Language)
|
Contact
|
Historical and Real-Time
|
Contact Picklist Fields (User Language)
|
Custom Object 01 - 05
|
Historical and Real-Time
|
Custom Object nn Picklist Fields (User Language)
|
Custom Object 06 - 40
|
Real-Time
|
Custom Object nn Picklist Fields (User Language)
|
Event
|
Historical
|
Event Picklist Fields (User Language)
|
Financial Plan
|
Real-Time
|
Financial Plan Picklist Fields (User Language)
|
Household
|
Historical and Real-Time
|
Household Picklist Fields (User Language)
|
Lead
|
Historical and Real-Time
|
Lead Picklist Fields (User Language)
|
Message Response
|
Historical and Real-Time
|
Message Response Picklist Fields (User Language)
|
Messaging Plan
|
Historical and Real-Time
|
Messaging Plan Picklist Fields (User Language)
|
Messaging Plan Item
|
Historical and Real-Time
|
Messaging Plan Item Picklist Fields (User Language)
|
Opportunity
|
Historical and Real-Time
|
Opportunity Picklist Fields (User Language)
|
Opportunity Product
|
Historical and Real-Time
|
Opportunity Product Picklist Fields (User Language)
|
Order
|
Real-Time
|
Order Picklist Fields (User Language)
|
Product
|
Historical and Real-Time
|
Product Picklist Fields (User Language)
|
Quota
|
Historical and Real-Time
|
Quota Picklist Fields (User Language)
|
Service Request
|
Historical and Real-Time
|
Service Request Picklist Fields (User Language)
|
Shared Address
|
Historical
|
Shared Address Picklist Fields (User Language)
|
Solution
|
Historical and Real-Time
|
Solution Picklist Fields (User Language)
|
User
|
Historical and Real-Time
|
User Picklist Fields (User Language)
|
NOTE: The User record type does not always appear as the User dimension. Other dimension names used for the User record type are Approver, Final Approver, and Last Approved By. If a user record type is contained within another record type, then the user record type appears in the second level of the hierarchy as you would expect. However, the user-language picklist and the company picklist also appear in the second level of the hierarchy, not under the user record type.
To display the picklist values in the company language, you can continue to use the picklist fields that are under the standard dimension folders. Also the picklist fields, suffixed with the term Code, that were previously available under the main folder are now available under the subfolders (such as Account Picklist Fields (Code), Activity Picklist Fields (Code), and so on) with the suffix removed from the field names. You can continue to use these language independent code (LIC) fields and the optimized version of the base picklist fields in report filters to improve query performance.
In reports, picklist values appear in the user or company selected language. However, picklist fields that do not have a value selected in the user interface are displayed as shown in the following table. The behavior of the picklist value display depends on the type of picklist, which can be prebuilt or indexed custom.
The following table describes the behavior of the picklist value display for Historical Analytics subject areas.
Type of Picklist
|
Language Independent Code
|
Company Language Dependent Value
|
User Language Dependent Value
|
Prebuilt
|
Unspecified
|
Unspecified or Blank. If the value is set to Unspecified, then this text appears in the company selected language.
|
Unspecified. This text appears in the user selected language.
|
Indexed custom with or without custom values defined
|
Unspecified
|
Blank.
|
Unspecified. This text appears in the user selected language.
|
The following table describes the behavior of the picklist value display for Real-time Reporting subject areas.
Type of Picklist
|
Language Independent Code
|
Company Language Dependent Value
|
User Language Dependent Value
|
Prebuilt
|
Blank
|
Unspecified. This text appears in the company selected language.
|
Unspecified. This text appears in the user selected language.
|
Indexed custom with custom values defined
|
Blank
|
Unspecified. This text appears in the company selected language.
|
Unspecified. This text appears in the user selected language.
|
Indexed Custom with no custom values defined
|
Blank
|
Records are deleted.
|
Unspecified. This text appears in the user selected language.
|
|