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.
Agenda Presentation: EPM Integrator connectors and Salesforce CRM Connector. Join us to learn more about the EPM Integrator connectors and Salesforce CRM Connector in Oracle FDI. We will explore the enhanced capabilities of the EPM integrator connectors and how you can load data from EPM modules to FDI to deliver a…
Hi! I am looking for audit logging for Analytics objects, such as users creating, modifying, or deleting datasets, dataflows, schedules, etc. The traditional Presentation Services component provides such logging in domains/oas/servers/obips1/logs/auditjson.log, which contains audit information for catalog objects,…
Hello Team, While building a Pivot Table view for my report, 2 out of the 4 metric columns contain completely null values. I'm looking for a way to automatically exclude or hide metric columns whenever they are entirely null or zero. Could you please advise on how to achieve this? Thanks.
I'm trying to index a Local Subject Area so I can use it in my AI Agent, however, I keep receiving the generic error below. Request status(500) : error = {"prefix":"DSS","code":50000,"message":"There was an unexpected error while processing this request. Please try again."}
it is observed that in OAC while using case statements the output is not expected.For example if we have a case statment like case when table1.column1=table2.column1 then 'yes' else 'No' end as Attribute1 Now if i use this attribute with a fact-amount column attribute 1|| Amount on a report then we dont get the aggregation…
