If you look in Sample App (OBIEE Samples ) there are scripts provided to extract all the permissions of all the objects in the catalog and load them into a table of your DB so you can build reports on that. Sample App has few example reports built on that data.

I wouldn't say to back up the Weblogic config & co files every time you change them as you have the risk to forget once and so your back up strategy will not work. I'm more for a periodical backup, can be daily or weekly (or a mix like daily and then keep only weekly snapshot longer and then monthly snapshot longer etc.)…

Abinash2707 wrote:... I got to know that even BISystemUser has been deleted. Do you have a backup? First you unplug the PC of your team mate from the network, then you restore a backup of the Weblogic files with the internal LDAP etc. At least you go back to a known status instead of discovering missing pieces one at a…

You only deleted the OBIEE application roles from EM? Because the access to console isn't based on that, so if you lost access to console too you maybe did something else (worse)?

What's the context? If you got what you were looking for in your thread you can maybe mark and close it? It will help others with the same answer, for now it's still This question is Not Answered.

First thing: OBIEE 11.1.1.9 isn't officially certifies for Windows 10, so if at some point you end up having issues ... you are alone, don't even try ask Oracle for support. You entered the password for the administrator account, it's the admin account you created during the installation of OBIEE. Generally the username is…

True, on a vm you need to install the OS, for Windows I guess you can have trial periods for Windows Server installs etc. On the linux side I would suggest Oracle Enterprise Linux. It's free (ok, never read all the license details but I'm kind of sure for personal usage it's free) and all the Oracle tools works fine on it.…

Sadly the UI is a bit inconsistent .... For a chart you must hide the column in the "Criteria" tab (so it will be hidden for all the views), "Column properties" > "Column Format" > "Hide" (a checkbox on the top-right).

Hi, Ideally you set the "sort order column" attribute in the RPD for the "Month Only + Year" logical column (in the business model) as it allows your to sort textual months in the right way. But sometime this sorting doesn't work well (I saw that mainly in pivot). If you don't want/can't do that (or it doesn't fix your…

I assume your browser know how to resolve LPT-67, right? Then of course what nm.Mani said : did you start OBIEE ? Because if your don't start it no chance to connect, it's not like Excel or things like that were you just open and close it like that ... If you started then you must go back to check your log files. Just a…

You can look into OBIEE SampleApp (OBIEE Samples ) for some examples on how they used it. Like http://slc02ojt.oracle.com:7780/analytics/saw.dll?Dashboard&PortalPath=%2Fshared%2F10.%20Lifecycle%20and%20Admin%2F_port… (Prodney / Admin123)

Hi, No need to do anything as it's already there. Just look the table next to it: S_NQ_DB_ACCT, there you find the physical query.

You are welcome Give it a try and if you got what you looked for come back to close the thread (right now still This question is Not Answered. )

The logs will still log things. A scheduled analysis is executed as any other analysis, just not by a "human", the logs will capture the queries based on log levels.

Your node manager is probably not running ... Node manager is the "piece" making the weblogic servers communicate together, so the admin server can talk to the manage server etc. Simplest way: stop OBIEE with the Windows Start shortcut, when done try to start everything again with the shortcut. If you still end up with…

@3388135 : step back from your keyboard! You are having having problems and reading only half of the answers here and clicking around randomly. 1) Did you saw Analytics working on your system? Did you login once at least? As you are using the wrong port number I'm not sure, so why the hell did you went on deploying a RPD…

Hi, First thing first: you look for Analytics in the wrong place: look at your last screenshot, the "bi_server1" is listening to port 9704 (last column on the right), so Analytics will be on localhost:9704/analytics . Your issue now is more that the state of "bi_server1" is unknown, which doesn't mean anything good. So…

Hi, Well, you have to start from the beginning: is weblogic admin server up? is the managed server up? are the components up? Everything is green in Enterprise Manager? What does the logs tell you?

Sorry but ... aren't you looking for a custom style/skin? Because doing that you can customize everything and then you set that custom as the default for the system or you select the style at the dashboard level. The good thing with this approach: customisations will survive patching etc. (as long as you do it the right…

Yes, that's why I started by "I would agree with Christian" But, if after cleaning up the model, making sure there aren't double joins and circular joins etc. the result is still the same ....