My Oracle Support Banner

Get Wrong Result From Expression Relation EQ NA (Doc ID 1421866.1)

Last updated on NOVEMBER 22, 2019

Applies to:

Oracle OLAP - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample or bulit-in schema(s), Public Documentation delivered with an Oracle database product or other training material.  Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.

Adding values to an integer dimension where the relation is NA, it returns the correct value, but if adding values again, then getting  wrong values and the last added values are not counted.

For example:

DEFINE EXAMPLE.LIMIT PROGRAM
PROGRAM
define intdim dimension integer
define otherdim dimension id
maintain otherdim add 'FIRST' 'SECOND'
define idotherdim relation otherdim <intdim>

maintain intdim add 100

limit intdim to idotherdim eq NA
show statlen(intdim)

maintain intdim add 200

limit intdim to idotherdim eq NA
show statlen(intdim)
END

->example.limit
100


The result is still 100, instead of, 300.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.