Pass Same prompt values with different way

Rai Qaiser Hussain

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?

Teresa Modesta

Sounds like you need master / detail ->

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

Thomas Dodds

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

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

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

Yes, you are right, is this possible?

Teresa Modesta

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!

[Deleted User]

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