CRM Analytics introduced Custom Fiscal Year (CFY) support in Winter '21, allowing datasets to inherit custom fiscal year definitions configured in Salesforce Setup. This feature enables organizations with non-standard fiscal calendars to use custom fiscal periods in CRM Analytics dashboards and SAQL queries.
However, this feature has several known limitations that affect how custom fiscal year configurations are applied in CRM Analytics. Organizations that use advanced fiscal year customization options in Salesforce Setup should review these limitations before relying on CFY in CRM Analytics.
Custom Quarter Names are not supported.
In the Advanced Customization section of the Fiscal Year setup in Salesforce, the "Choose Quarter Name Scheme" setting must be set to "Numbered By Year". Select a Prefix from the available options. Using a custom quarter naming scheme is not recognized by CRM Analytics.
For guidance on configuring fiscal year labels, see Customize the Fiscal Year Labels.
Custom Period Names are not supported.
Similarly, the "Choose Period Name Scheme" setting must be set to either "Numbered By Year" or "Numbered by Quarter" with a supported Prefix. Custom period names defined in Advanced Customization are not recognized by CRM Analytics.
"fiscalMonthOffset" and "isYearEndFiscalYear" metadata overrides are ignored.
When Custom Fiscal Year support is enabled in CRM Analytics, any metadata overrides related to fiscal date handling in Dataflows (specifically the fiscalMonthOffset and isYearEndFiscalYear properties) are no longer applied to ingested data. If your org previously relied on these overrides to align fiscal dates, enabling Custom Fiscal Year support will change how fiscal date data is calculated in datasets.
Recommended action: Before enabling Custom Fiscal Year support in CRM Analytics, audit your existing Dataflow metadata overrides for fiscalMonthOffset and isYearEndFiscalYear. If these overrides are in use, test the impact of enabling CFY in a sandbox before applying it to production.
000388864

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.