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?
Sounds like you need master / detail ->
https://gerardnico.com/dat/obiee/obips/master_detail
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)
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.
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!
Yes, you are right, is this possible?
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!
Thomas is 100% spot on. And also to re-iterate my other post: Get some training on the basics!
Does Oracle Analytics Server 2026 include AI features such as a built-in chatbot or AI Assistant? If not, are there any plans or indications that these AI capabilities will be introduced in a future OAS release?
we have two seperate environments in air gap… 1- oas 2024 2- oas 2026 developers in both env, required extensions like push button, racing bar, guage…. where to download.
I am getting syntax error when im trying to add full table hint in evaluate for an obiee report analysis column. This is the function im adding the below: why isnt the syntax working, what is missing or incorrect here in the function?
Hello everyone, We use OBIEE 11.1.1.9, on Oracle Linux. We have set up Usage Tracking. It shows users but it misses some of them. How can I see all users?
Hi everyone, I have a cascading prompt setup in OAS Classic (OBIEE 12c) that works for single selection but fails on multi-selection due to variable formatting. The Setup: Column Prompt 1: "Cost Center" (Multi-select enabled). Sets variable @{COSTCENTER_CONCAT_PROMPT}. Column Prompt 2: "Organizational Unit". Filters its…
