Hi all
I have a column and the only column i have for date and it is in calendar date.
How can i create a column for display in month?
Thank you.
What exact version? Are you using Answers or DV? Please provide a minimum of pertinent information with each of your questions. Nobody sits in front of your system except you, so we can't help you properly if w don't have the same information as you
Opps, sorry. I am using Oracle Business Intelligence Enterprise Edition 11.1.1.7 (OBI)
Click the formula button f(...) in the "Edit Formula" dialog. Scroll through the functions to the Calendar/Date functions and open those. There are 3 out-of-the-box functions deriving month information from dates:
Also: "11.1.1.7" describes about 50 versions over the whole lifetime of 11.1.1.7, so please provide a FULL version next time, up to the bundle patch information like 11.1.1.7.190324
Also also: 11.1.1.7 as a whole is outdated and no longer supported (premier support) since 2018. In the meantime there were 11.1.1.9, 12.2.1.0, 12.2.1.1, 12.2.1.2, 12.2.1.3, 12.2.1.4, OAS5.5 and OAS 5.9 which itself will be replaced by the newest OAS in early 2022 again.
So you're literally 8 (and soon 9) major releases away from the current state of technology. That's dangerous at best since there are no more security patches being done for your version AND you're missing out on 7 years of product development and features which you'd be entitled to have with your licenses but simply aren't using because you stayed on old tech.
tl;dr version: Upgrade!
Hello Oracle Analytics Community, We are investigating a dashboard compatibility issue between Oracle Analytics Server (OAS) 7.6 and OAS 7.0. Some dashboards originally created in Oracle BI 12c can be opened in OAS 7.6 but fail to open after being archived and imported into OAS 7.0. During our investigation, we found the…
Hi all, We’re running into an issue with an on-premises Oracle Analytics Server 2026 integrated with Active Directory and hoping someone has seen this or knows if a patch is available. Environment: Oracle Analytics Server 2026 (on-premises) WebLogic 14.1.2.0.0, JDK 21, Oracle Linux DB-backed catalog (Oracle DB, BIPLATFORM…
We have a requirement Creating a Bar graph using Cost Center Tree hierarchy as prompt/filter. Created a Bar Graph using Cost Center Tree Hierarchy as a prompt. When I'm selecting values through selection steps from Cost Center Tree Hierarchy, the Bar Graph not refreshing as the selected values are not passing to Graph…
I have 2 tabs on the workbook that use the same dataset. I would rather not use 2 different datasets. Can I code an expression filter or something to remove those records?
Can you please help resolve this error. WebLogic version is 12c. OAS is 6.4