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?

Hi, Do you mind posting the screenshot again? The "double" scroll is at different levels, but I prefer to see your screenshot before to randomly guess things

I assume your model is clean, and therefore that "USD Amount" is a real fact with an aggregation rule. If you think at it as a measure (which is probably what it is), you easily see why it behave differently than what you think. That column isn't the value of a single row most of the time, it's probably a SUM. That's…

It only impact how the prompt's elements are visualized on screen: a long list vs multiple columns list. It only impact how the prompt itself is visualized, not the analysis or anything else. Without checking the "new column" on any prompt element => long list of prompts one under the other. By checking the "new column" on…

Go into the dashboard properties and you can rename every page from there. The layout is available once you have many objects inside the section. With just one object you can't really expect to have a choice between a vertical or horizontal layout as it's just one. With 2 or more, it's either displaying them one next the…

When you have many prompts it allows you to have them into multiple columns (visual layout of the various prompts) instead of a very loooooong list.

Your thread isn't marked as a question, so it can't have a "correct answer".

Hi, You are trying to add that filter, fine. And what did you try? What was the issue? Not sure Timestampadd is what you look for, it isn't really made for "fixed" dates logic but for logic based on a relative delta from a given date. In your case you can use the function to get the year from the current date (which is…

https://datacadamia.com/dat/obiee/admin/12c/bar#import (read twice about the parameters and take backups before to execute if you can't afford to lose, by mistake, existing content)

True, because when you deploy your own RPD you replace the existing one. If you want to keep both RPD you need to merge them or develop all your content inside the sample RPD.

If you see that subject area in your browser, you can find it inside the RPD. In 12c it isn't "just" a RPD anymore, it's a .bar file. Search your OBIEE install folder for .bar files and you will find the the sample one. But it isn't a RPD...

It sounds like you start from the very beginning. Don't expect something quick or just taking 3 clicks. https://apexapps.oracle.com/pls/apex/f?p=44785:24:0:::24:P24_CONTENT_ID,P24_PREV_PAGE:12166,1 If you want to just connect 2 tables and build a chart on top of it, maybe you want to look at Data Visualization, even if the…

So what's the version?