Hi, You can keep data in an Autonomous Database and connect it from OAC but you have not shared size of this data to be archived and will it be used in OAC frequently or not. thanks

Hi, Have you tried Limit Values By to make it dependent as I remember not having access now else could have shared navigation. thanks

You are right but issue is I am unable to save a variable definition for which I had shared a screen shot as well. It says "Invalid connection name for SQL Query". I tried creating two connections but still same error then even removed all spaces or any character and kept simple but still same error. So untill unable to…

I need to execute SQL to fetch security rules for the current user and then assign to the variable which can be used to restrict data. In BIP reports we can use in (select company from security_rules where user = :current_user) but as per my info we cannot use same in semantic model. thanks

Hi, Thanks and I am trying to create session variable but getting error as need SQL to get details, even created second pool so two pools like pool1 and pool2 but same error. Yes you are right it is in the semantic model for sure. The GL KFF having multiple segments and each user can have different while it can be range or…

I have create an Idea post as well so Oracle team can consider certain enhancements,

Hi Pravin, Thanks for sharing your input but still it is really confusing. When we deploy there is notification that successfully deployed white actually it is not. Now if there is a notification/version no desplaying somewhere to know exactly if a new version deployed as this background request can't be seen in the front…

Hi @Henry Cabrera Seems you accepted this as answer but if we read it still DV is mentioned as unknown but classic solution is accepted while I am using DV. thanks

I think there is background process scheduled and we are lucky if it is close to next run then it will imemdiately deploy but no idea sometimes how much to wait. Waiting if someone can provide some details. Thanks

HI, Had to create SR but still issue remained to installed complete instance again and now not facing the issue to connect. thanks

Hi, Anyone faced this issue as both instances Oracle Analytics and Oracle EBS are on premises but still not connecting? Do we need any patch or any setting? thanks

Hi Gayathri, I have clearly mentioned there is not cloud involved both are "Oracle Analytics and Oracle EBS if both are on premises" so in this case Basic or Advance should work? As XMLPublisher is connecting from same instance so IP or port blocking can't be an issue. Now if there is any extra step required to connect DV…

Hi Aman, thanks for your details now I am wondering as Oracle Analytics and Oracle EBS if both are on premises then still we need VPN/Data Gateway as in case of clouse I can understand but since both are local then even Basic connecvitiy should not work? thanks

Hi, It is EBS database details same as using in Oracle SQL Developer & XML Publisher but in this it is giving error like IP, PORT, Service Name, user, password while both are local instances. Do we need any other configuration/agent to use semantic modeler?

Hi Aman, Thanks for the details shared and now when I am trying to create connection it is giving error while all details are correct so hope not a bug? "Failed to save the connection. Invalid connection details were supplied" Thanks

On enabling Oracle EBS getting error, Failed to retrieve data from Presentation ServerCould not connect to OBI Presentation Service

Hi Madeep, Thanks for your response and please have a look there is an option to get authorization from Oracle EBS so if this is used means then user will be able to login using Oracle EBS account/user and if so then will it apply any security. If not then as you suggested how a DS query we can write for the following…