Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Analytics Cloud and Server

Get week of year, actual week and last week number - OBIEE 11.1.1.6.9

Question

Views

Comments

user5688661 Rank 1 - Community Starter

Mar 23, 2017 8:36AM edited Aug 13, 2024 7:18PM in Oracle Analytics Cloud and Server

Hi, I have OBIEE 11.1.1.6.9 on analysis, I need get actual week of year and preview week of year to get table and alway sync when deploy report on pdf, because I need change each week filter on variable.

On column / operator / values 1;2:3

If possible some query to get on filter variable.

My screenshot

Also I have special table with calendar. Maybe

https://ibb.co/cSkcFa

https://ibb.co/bWQBaa

MFA for Oracle Community

Oracle Analytics Cloud and Server

Categories

Get week of year, actual week and last week number - OBIEE 11.1.1.6.9