How to Hide/avoid with clause in OBIEE server Query

Question

Hi Experts ,

My user asking us to avoid with clause in BI server generated query . Hoe can i do that , in order to avoid with clause in BI server query what are the configurations i need to follow . Please explain all the steps .

Thank you so much for your help in advance

Joel Acha · Answer

Hi @2844292

take a look at Gerard Nico's blog post

it shows how to configure settings in your repository's physical layer.