Retail Predictive Application Server (MOSC)

MOSC Banner

Index is not returning -1

edited May 2, 2015 10:00AM in Retail Predictive Application Server (MOSC) 2 commentsAnswered

Hi,

We need to provide a facility to business user to enter like item (rather than pick from a picklist with all valid items).

We used index function index([prod].[item], likeitem) to find the index of an item entered by user into a measure.

If the user entered an invalid item, I expected the index function to return -1. However its returning index 0.

can anyone please tell me why its returning 0 and not -1 for invalid item?

Regards,

Anusha

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center