Hi team,
We have date format column (6/21/2018 7:01:00 AM) we need extract year and month number ( 2018 06) from the date field in obiee RPD level can someone assist.
OBI Version using: Oracle Business Intelligence 12.2.1.4.0
Regards,
If you look at the available functions in OBIEE there is a whole set about dates, including extracting components from a date. Just look in the UI and you will see the list of functions available.
Thanks for the reply.
We used below year and month functions but format we are getting is 20186, we are looking for 201806 can you suggest on this.
CAST(YEAR("table.Date") AS CHAR)||CAST(MONTH("table.Date") AS CHAR)
is there any other function which we can achieve in 201806 format
It's simple logic, if you don't store the right format in your database, you just have to build it by yourself.
So with some basic logic you could multiply YEAR(date) by 100 and you sum it with MONTH(date) and you can finally turn the resulting number into a char if that's the format you are after.
Try using column data formats or else use string functions as Mr. Gianni suggested.
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
