CA PPM Unable to create NSQL query

book

Article ID: 140207

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM On Premise

Issue/Introduction

Create a NSQL query for a lookup, even if copy the exact query that is currently working get the following error when trying to preview it:

 

 

Error: NPT-0102: NSQL statement must define at least one dimension.

 

 

 

Cause

Created a query, but not a lookup query

Environment

Release : 15.7

Component : PPM INVESTMENTS, PROJECTS, RESOURCES & NPIO MANAGEMENT

Resolution

Created a lookup query has resolved the issue.