Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 49 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 287 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 110 Oracle Analytics and AI Trainings
- 21 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
LAST_PERIOD function
user12045713
Rank 1 - Community Starter
Hello,
Did someone successfully used LAST_PERIOD function?
I need to use that but there is no diffrence in physical query if compare it to query with LAST function. No difrence in results. "Data is dense" flag is checked.
I need that becouse LAST returns the last non-null value, whereas LAST_PERIOD returns the last value, regardless of whether it is null.
It is hard to find any information about this function.

Thanks,
N.
0