Index aware prompt in IDT not working in Reports

[former_member196948]

Hi All,

I have created "Index aware prompt in IDT" based on example shown in "Information Design Tool 4.1: Create an index-aware prompt".

i have checked prompt in IDT Query, where Prompt is working fine. But i am getting error in webi/launchpad when i am fetching objects and global filter .

Regards,

Jeet

[sateesh_kumar1]

Hi Jeet ,

Is your global filter has also the same object which is used in custom LOV ?

can you refresh the report without using Global filter ?

to validate , create Query in IDT itself with all the required objects and prompts as you are doing in webi using "Queries" option.

Thank you.

[former_member196948]

Hi Sateesh,

Is your global filter has also the same object which is used in custom LOV ? : Yes.

can you refresh the report without using Global filter ?: when i am checking without Global filter it is working fine (fetch object in to qry pane and trying then i am getting correct result eg. filter based on  country ID)

I have checked in Queries in IDT and there Prompt is working fine.

PFB screen shot  when we are fetching object in qry pane in webi

Regards,

Jeet

[sateesh_kumar1]

Can you apply same LOV created with Index aware to the Global filer and try ?

seems , a conflict occurring to get the values for the same object !!

[former_member196948]

Hi Sateesh,

PFB screenshots

Please let me know if i missed something

[sateesh_kumar1]

few things noticed ,

1.the datatype has to be string in the LOV.

2.you shouldn't compare the Key with text values in the IN statement .

Ex : Country.country_name in (@prompt())

Index aware makes to search the values and process the logic using underlying Key instead of text (mostly indexes preferred to be on primary keys)