Thanks Joel. Appreciate your help. i have follow-up question - Can I seed the query cache while having the ENABLED flag set to NO ? If it is YES, then the space allocation will be used by all queries, which we are trying to avoid as we only want to cache those huge analyses where we can see tangible performance gains.…

Thanks Gianni for sharing your knowledge . Appreciate all your suggestions.

Hi Gianni Thanks for your suggestion. I was to get the label/caption in the xml of the Analysis. If I want extract all the custom headings in all the analyses in the system and load into a DB table and model it for reporting data dictionary, what method would you suggest ? Unix scripting or any OBIEE 12c API ? Please…

Thanks Gianni. will look into the model to find where we messed up.

Hi Gianni No, we did not cut the inheritance to the authenticated users. We haven't denied anything to the Authenticated User role. We are trying to find a solution where only privileged users(member of specific LDAP groups) can access OBIEE. Regards Rakesh

Hi Christian, Yes, I was accessing the Catalog in online mode. will access it offline. Thank you 

Hi Gianni, Thanks for this important insight. Very pertinent information. I was led to believe that a plug-in does the exports and pdf reader does the rendering part.. 

Thank You Joel. this information is very helpful.

Thanks Gianni. Yes, you are correct in saying that this is more of a cosmetic need that anything. Regards Rakesh

Hi Joel Thank You for responding. I am trying to restrict the information displayed on the Catalog page to look like this - instead of looking like this - Regards Rakesh

Hi DPal Thank You for your suggestion. It seems to work for my need. Please see my previous update. Regards

Hi Christian, I deleted the entire Init block & variable. recreated again, but I could not get it to work. It would only show me the default value of the variable. Not sure if this is a bug . If I remove the default I get the error - [nQSError: 23006] The session variable, NQ_SESSION.Reg_Cd, has no value definition. I…

Thanks Christian. So, I purged the cache, unchecked the cache and gave a default value(04) to the variable "Reg_Cd" and ran the query. I am only getting the default value back. Doesn't look like the Init Block SQL Query is executed. Please help me figure out what's missing. Regards.

Hi Christian, I am afraid I did . When I checked Row-Wise Initialization I think the cache got checked as well & I never gave a default value to the variable. How can I correct this ? Thank You.

Thanks for the additional information. I would still check out the link where you have the slides. Never know, on a good day that site might just be up

Hi Gianni, Thank you. I wanted to check out the slides but the link doesn't seem to work.

Thanks Gianni, I wili try this option and see if I can the delta in a cell. will test this and get back.

Thanks Christian. Will try your suggestion and get back..