Thanks Chris.

Thanks Joel.

Thanks Gianni, Joel, Chris. Sorry my fault, i meant to ask if there are additional config/setting changes need to be done in RPD or front end to connect to OLTP sources like EBS, Siebel versus an Oracle or Teradata or some other relational data warehouse.

It is a simple column which i have added to an existing MS SQL Server stored procedure. FYI the original stored proc definition's select statement do not contain this column but one of the tables in the same database has this column. I added this column in the RPD physical layer.…

Hi Gianni, Version is 12.2.1.4.0. 1. i did not made any online changes 2. yes, i logged out after deploying RPD, and logged in. 3. yes, i can see the default variable value in the dashboard text block. Thanks.

Agree, my mistake

Thanks Joel, we are on 12c, If possible kindly share word or pdf version of the link you posted as right now have no access to Oracle support account. Also i am trying to capture the query as performance is the main concern. Report is taking 40 seconds to run which is unacceptable. Please also share any documents/tips on…

Hi Gurus, Please share any inputs on this.. Thanks

Hi Chris, Set both ARBORPATH and ESSBASEPATH, It did not help. As a last option, will be creating that bat file and run. Thanks

Could not find any doc on support site explicitly for OBIEE 12c versions, every article says "applies for OBIEE 11.1.1.X or later" versions.

Hi Gianni, I found a doc on Oracle support (doc ID 1368858.1) , ( it says for OBIEE 11.1.1.5 and later versions), in that they mentioned to set environment variables in "bi-init.cmd" and "opmn.xml" files ---- these are not present in OBIEE 12.2.1.4.0 then if that don't work, they suggested to set environment variables…

Hi Gurus, Please share any inputs on this. Thanks.

Asking abt performance because Oracle says Opaque views should be the last option and complex sql need to be generated to retrieve data using them.

Thanks Chris, will there be any performance impact if we go with Opaque views vs direct SQL server native declaration ...

Hi Chris, Could you please elaborate "Unless you write it all in views" Write what ? and where ? Thanks.

Hi Gianni, the team just want to use that server as kind of sandbox and to ensure all BI developers use the same version of tool avoiding compatibility issues down the line. (instead of each developer installing client on his local) the developers just login to that server and work using that client tool. Thanks.

You are spot on. It says "you need permissions" to perform this action.

I right clicked, selected "properties" and i see "read only" checked in both my local and this remote server. Below is remote server Below is local

Yes it is. Below is the folder structure i see in that path. (i have the Admin tool installed on my local and the folders match with those i see on this remote server) Admin tool on my local is working fine.

Its remote Windows Server 2012R2. Admin tool version 12.2.1.4.0