OnDemand User Group

Support Forums => Report Indexing => Topic started by: tjspencer2 on May 08, 2015, 06:47:50 AM

Title: Index Values Required?
Post by: tjspencer2 on May 08, 2015, 06:47:50 AM
We're on 8.5 MP and I have a user with a question.

When defining an index for an application, if the value is not located, is it okay for an index to be NULL?

I'm thinking ACIF needs to populate a value, and if it doesn't find the value in the specified coordinates then a default must be supplied, correct?
Title: Re: Index Values Required?
Post by: Justin Derrick on May 08, 2015, 07:20:50 AM
Correct.  NULL values aren't allowed in CMOD.  (How would you ever find that document?)  You should set a default value, or improve the quality of the data you receive.  (Or remove it as an index if it isn't important enough to have a value every time.)

-JD.
Title: Re: Index Values Required?
Post by: tjspencer2 on May 08, 2015, 07:28:25 AM
Thanks Justin - those were pretty much my thoughts too.

My user does have other index values that she knows she'll find.

Isn't it also correct that if she doesn't want to apply a default and instead just identify the value as  "Field" that she won't be able to add it to her Folder and search by it?

And that this consequently means she'll only be able to filter/sort by it when she retrieves results in Webi?

Thanks for your help!!
Title: Re: Index Values Required?
Post by: Justin Derrick on May 09, 2015, 06:14:43 PM
Isn't it also correct that if she doesn't want to apply a default and instead just identify the value as  "Field" that she won't be able to add it to her Folder and search by it?

I'm not sure what you mean by this.

She can set a default value, and exclude it from the search pane, and only display it in the hitlist, if that's what you're going for...

-JD.