Analytics Report Using Rank() In Column Formula Is Failing With nQSError:42046 (Doc ID 2940024.1)

Last updated on APRIL 20, 2023

Applies to:

Oracle Analytics Server - Version 2022 (6.4) and later
Information in this document applies to any platform.

Analytics reports using Rank() in column formula is failing with below error.

[nQSError:42046] Lookup functions cannot be combined with any other logical columns in a single conditional expression in the filter

Reports are migrated from OBIEE 11G to OAS 6.4

	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

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