Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Populate prior weeks data when have zeros
Hi
I have created a report with 53 weeks data at any point of time. For few weeks i have 0 values .
When we have zero values i need to populate prior weeks data. Can you anyone suggest as how can I update prior weeks data when i have zero data for any week.
Answers
-
"zero values" = no value at all, nothing (not a 0, not a NULL, not a "" ... just nothing)
OBIEE will never generate data which doesn't exist, so you better fix that during ETL to add at least an empty/NULL/zero row at that point.
Or you need to model things to cover this case with the right logic (or use EVALUATE to send a LAG call to the DB and try it in that way ....)
0 -
+1 to Gianni
"zero values", NULL, '', 0 are completely different things and technically, logically and mathematically not to be used interchangeably!
0
