Populate prior weeks data when have zeros — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Populate prior weeks data when have zeros

Received Response
1
Views
2
Comments
Jack
Jack Rank 4 - Community Specialist

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 ....)

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    +1 to Gianni

    "zero values", NULL, '', 0 are completely different things and technically, logically and mathematically not to be used interchangeably!