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).

Not only the JavaHost knows, but also OBIPS knows when you do an export. If you enable advanced logging in OBIPS you can also track those actions. Surprised by an answer from Oracle saying the functionality doesn't exist when it's there for many years (at least 5-6 minimum), even more asking for "points" with that answer .

It isn't a separate thing, it just bypass fully the models in the RPD and only use a connection pool to have a connection to a database. I don't know if you can still buy licenses by "component", which would maybe be the only case to check if it is part of "Answers" or explicitly part of something else.

What is transactional data? Just data, not more, not less. OBIEE doesn't care if you define a DWH table in the RPD or a "transactional data" table. The RPD works as model to let OBIEE know how to generate query, what is the usage of the tables underneath, doesn't matter and OBIEE doesn't care. Tell OBIEE how to connect…

It's OBIA, https://www.oracle.com/middleware/technologies/bi-applications/ OBIA contains OBIEE as one of the products it comes with.

Something along this line would make it ... You can have a LTS with the dim members just for the count(distinct member ID), and another one with the dim members left outer join fact purchase which can answer to both the count distinct and the sum of points. OBIEE will do the job of picking the best one for the need.

Your purchase table is a fact table, nothing to say against this one. But does this prevent you from having the member dimension also as fact table? Not really... By using both as fact tables you can achieve your need without problems. The member dimension is used for the count(distinct member id), the purchase table is…

Going in the same direction as Christian: your model isn't ideal. You are "cheating" by using a dim attribute as fact and this generate that "nice" query. If you have to count members, that one must be a real measure which can exist without needing the dimension (even if you will keep using it because of your filter on the…

What is the thing with the horizontal and vertical scroll inside the page? Is that an analysis? Is that a section? Is that an embedded content from somewhere else?