Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Pass Same prompt values with different way

Received Response
62
Views
7
Comments
Rai Qaiser Hussain
Rai Qaiser Hussain Rank 5 - Community Champion

Hi All

I have single prompt (Date), I want to pass date to my performance tile (already working fine) but I want to pass month without creating new prompt to Date wise revenue analysis.

Is it possible?

two_Parameters.jpg

Tagged:

Answers

  • Teresa Modesta
    Teresa Modesta Rank 5 - Community Champion

    Sounds like you need master / detail ->

    https://gerardnico.com/dat/obiee/obips/master_detail

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    in reality you are wanting to show all the days from the same month and year, correct?

    in your filters you'd want something like:

    Year(date_column) = Year(prompted_date)

    AND Month(date_column) = Month (prompted_date)

  • Teresa Modesta
    Teresa Modesta Rank 5 - Community Champion

    Or he could create Month based measures "Current Revenue Month" which he pulls onto the month level of his time hierarchy to make it not change at that level of detail.

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    yes - that's another viable option to have a Revenue Month that represents the MM-YYYY of each date in the month. 

    I've always said a well formed calendar/date dimension is 101 fundamental and pays for itself minutes after deployment!

  • Rai Qaiser Hussain
    Rai Qaiser Hussain Rank 5 - Community Champion

    Yes, you are right, is this possible?

  • Teresa Modesta
    Teresa Modesta Rank 5 - Community Champion

    Yes, cornerstone I would say!

    And on possible, duplicate your existing measure, rename it, drag it onto the month level of the time hierarchy, easy!

  • Christian Berg-0racle
    Christian Berg-0racle Rank 10 - Analytics Guru

    Thomas is 100% spot on. And also to re-iterate my other post: Get some training on the basics!