cancel
Showing results for 
Search instead for 
Did you mean: 

BIA - Turning off Individual Queries

Former Member
0 Kudos

Hi Experts,

I'm having an issue with certain queries executed on Cubes indexed with BIA. I know I can deactivate the BIA indexes for those cubes forcing all associated queries to read directly from the cube. However, I only want to deactivate specific queries from using BIA. Is this possible?

Thanks for the help!

Doug

Accepted Solutions (1)

Accepted Solutions (1)

former_member184494
Active Contributor
0 Kudos

go to table RSRREPDIR and in that search for the queries you need to turn off. You will find a cell called NOHPA.

Set NOHPA to X and the query does not use BIA.

Answers (2)

Answers (2)

Former Member
0 Kudos

Thanks Arun and Praveen! You guys were VERY helpful!

Doug

Former Member
0 Kudos

Hi Doug,

You can use program mentioned in note 1161525 to set this flag mentioned by Arun.

Best Regards,

Praveen