You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to create a prompt, Year-Month format, in analysis while not having a "Month" dimension?

Accepted answer
edited Mar 31, 2020 2:22PM in General Transactional Reporting (OTBI) 6 comments


The goal is to enable end users to look at an analysis by year-month periods (ex. YYYY-MM, 2020-01), but "Month" dimension is not available within the subject area.


Hello Oracle Community,

Do you know in analysis whether there is a method to create a Year-Month format (YYYY-MM, ex.2020-01) prompt without the availability of a Year-Month dimension within the subject area?  Condition displayed in enclosed screenshot.

The goal is to enable end users to view an analysis in different year-month periods by selecting them on a drop-down prompt.  In the subject area, the only date type dimension available is "Account Established Date", that comes in DD/MM/YYYY format.  Dropping this dimension in prompt section only limit selection to each event date, but not at a upper tier of "Year-Month".


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!