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!
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
Hi All, We are using Oracle Analytics Server (OAS) and noticing different behavior with the Act As feature in Classic dashboards vs. DV workbooks. When FullAccessUser acts as RestrictedUser, Classic Answers dashboards work as expected. The user context switches correctly in nqquery.log, and HCM row-level security and data…
What am I doing wrong here? There is only one selection in the Target Canvas??
In BIP. I was able to group tables. Is this possible in OAC
I creates a parameter "Role Name" and then I put the Role name field in the filter and made a bind to the parameter, When I add the value in the parameter, it works. When I delete it from the parameter it give me <empty> How do I get rid of the <empty>
Hi, all, I have been struggling with connecting to Teradata in OBIEE Admin tool. I can't import Metadata to the RPD that exists. I am not sure about if it is due to my config of ODBC Teradata is incorrect or anything else? Please find the following errors as attached: Many thanks for your help!
