My Oracle Support Banner

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

Last updated on JUNE 08, 2021

Applies to:

Oracle Retail Merchandising Insights Cloud Service - Version NA and later
Information in this document applies to any platform.

Goal

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.

Solution

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
Goal
Solution
References


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