Categories
- All Categories
- 70 Oracle Analytics News
- 7 Oracle Analytics Videos
- 13.9K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 38 Oracle Analytics Trainings
- 56 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 2 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Pass Same prompt values with different way
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?
Answers
-
Sounds like you need master / detail ->
0 -
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)
0 -
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.
0 -
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!
0 -
Yes, you are right, is this possible?
0 -
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!
0 -
Thomas is 100% spot on. And also to re-iterate my other post: Get some training on the basics!
0