So in .4 you have the Lightweight SSO enabled by default.

Sangeeta Pandey wrote:Yes, Version is 12c. That's why me or Christian keep asking for precise versions: 12c is many different versions and the Lightweight SSO is on by default only in some of them.

SSO is already enabled (you didn't said what exact version you are on, but I believe it's one of the latest 12c), the lightweight SSO is on by default to allow a to access both DV and Answers.

Application roles are in the Enterprise Manager Fusion Middleware Control Console, login there and in the BI instance you can edit application roles. As said before you have to know how the product is designed: "Console" (the Weblogic Console) is pure weblogic, it doesn't know at all that OBIEE exists.

It's known that an upgrade require fixes. You come from a very very very old and unsupported version and upgraded to a very very old one. One of the tasks of the upgrade is to review the new version and fix all what requires a fix. Your thread is extremely generic and sound more like a rant than a question.

Did you compare the application roles of weblogic and bi_admin (checking "My Account" once logged in OBIEE) ? Are they the same? Are they different? If you review how the security of OBIEE works, you will see that a Weblogic LDAP group doesn't really mean anything from an OBIEE point of view, one is not necessarily…

sanjay kumar roy wrote:Can you please help me. Help us helping you! And keep in mind it's a community forum: if you don't do any effort in expressing your issue in your thread, while would somebody invest his own free time trying to first guess what you could be asking and after coming up with an answer? Even this reply…

You can always, as quick workaround, add it back to the layout and edit from there in case the bottom-left keeps not working (don't remember if it lets you do that without removing it first from the view selector, but in both cases it's just few clicks more).

There is SmartView as well. Search Oracle documentation or google for the details as, once again, it's can easily be a long topic which doesn't fit in a forum ...

Sangeeta Pandey wrote:Why I am asking this because I read that I need system DSN with BI server driver for Direct Database Request connection. I'm not sure to understand that and what you did read ... Do you want to do a Direct Database Request analysis? Because I don't see the link between the ODBC connection you try to…

This is OAS, but 11g was already like that (just with different colors ...)

I don't have an 11g anymore, but on the left side of the screen you must have a place with the list of all the views of the analysis (at the bottom maybe). From there you can edit, delete, duplicate etc. every single view.

As Christian said: Catalog Manager in offline mode allows you to change permissions. Keep in mind inheritance is a thing: a "deny" is really strong and can be inherited by your weblogic account too. Instead of deny you often avoid setting permissions, which (if there isn't an explicit grand inherited) has the same effect…

2634558 wrote:I believe BIAdministrator should be able to view all the permissions. "BI Service Administrator" is just an application role like any other, it's called administrator but it doesn't mean that it will always have access to everything... Is that a new instance you just installed? Or maybe somebody already…

Do you really need to use timestampadd? A quarter isn't a date, it's a string like '2020 Q3'. In your time dimension you are supposed to have them as part of the hierarchy: year > quarter > month > date. So when you talk about: Joe Choueiri-Oracle wrote:...need to create an analysis to show deals for the current quarter…

For a more precise description on how to find the 9514 (including a screenshot), look at the second to last post in this thread: System DSN for live RPD

The Admin tool doesn't connect to the web interface port, it connects to the BI Server directly. It isn't a browser connection at all. If you look in Weblogic EM, the Business Intelligence instance components you see the ports of each component, the BI Server is on 9514 by default.

As extra info, this is the kind of logging I talk about: https://docs.oracle.com/middleware/12212/biee/BIESG/GUID-BC51D576-D373-4EEF-8C09-47FD10127F68.htm As you can see the writer implementations aren't many, not much more than logging in a file or standard output. It isn't like a Java logger which could more easily write…

You have to script that part yourself. Usage Tracking and agents execution logs are the only things that OBIEE writes directly in the DB, the other ways of tracking things are really fully based on log files. The process must be done by yourself (there are many tools which can be used to automate the job, but it's all…

True, it is more work. The original request isn't precise enough to know how many more things must be tracked on top of usage tracking for auditing (guessing based on the request).