My Oracle Support Banner

Cannot Combine Current Metrics With Calendar Components (Doc ID 2781952.1)

Last updated on OCTOBER 04, 2022

Applies to:

Oracle Retail Merchandising Insights Cloud Service - Version 18.0 to 22.1 [Release 18.0 to 22.1]
Information in this document applies to any platform.


Need the ability to create a report that combines calendar components with the ‘current’ metrics. For example, the business needs a report that displays sales by item and location over a selected range of Fiscal Dates along with Current EOH and that cannot be created for them.Tried using the FILTER function on the individual sales metrics and the UNION functionality and neither method works.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.