We know that in OAC and DVD, the default month start date is 1st of every month. How to customize or define the start date? Let's say the start date is 15th of each month then the end date will be 14 of next month.
I guess it depends on your use case and where you are trying to define this constant start date of the 15th.
What function or expression are you using that gives you the default start date of the 1st as a reference?
You can use constants to include specific dates in expressions:
DATE [2020-11-15] or TIMESTAMP [2020-11-15 12:00:00] this would calculate based on this date depending on your function or calculation. Then you may be able to couple that with the TODATE or AGO functions.
Otherwise, the best and most flexible case would be to create a DATE dimension in your database to define your specific start and end dates for each month and reference those within your Projects.
Brian
The "proper" way to do this is normally to have a custom date dimension with your company's own date logic.
OAC and DVD are blackboxed, hard-coded solutions which do not allow this kind of approach.
Finally, I added a date offset column in the database.
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…
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!
Hi Team, Has anyone upgrade OAS system from the 2024 to 2026 version? if yes, could you please share the resposne files. Regards, Chand
