You can have A1, A2, A3 as subpages of A. Of course you can't expect A to have content and subpages, if this is your case, the first subpage of A should be the content you expected in A.... While OBIEE is "just a web application", there is a ton of UI components around and you can't easily mess around with frames and…

Changing the SMTP doesn't prevent the notifications inside OBIEE because the agent still run, it just fail on the delivery side. Technically even an admin isn't supposed to have access online to the users personal folder, practically the catalog you can either "destroy" the default security model to open the door or go…

There has never been been a one-click-thing to enable or disable all agents in OBIEE, it is something you can write (a few lines of javascript could do it for all the shared agents, for users agents permissions will not let touch them). I don't remember 11.1.1.7 anymore as it is 8 years old, but it has components already I…

Did you try the "subpage" functionality? When you edit your dashboard, add a subpage and get your content there (you can drag&drop full pages content into the new subpage or I'm fairly sure you can also play with shortcuts to point to existing pages somewhere else).

You didn't say anything about your version and I thought you were on the latest OBIEE. These functions have been added in 12c if I'm not wrong. Worth considering an upgrade, maybe directly to OAS, if you are on anything before 12c.

Hi, Did you try using the functions for binning? https://obieeil.blogspot.com/2016/01/obiee-12c-advanced-analytic-part-2-bin.html

OBIEE can see everything you connect it to. If you connect it to a datasource with real time data, OBIEE will see real time data. OBIEE isn't a database, it doesn't store data locally, therefore it sees and uses what the sources you connect provide. (Of course don't enable cache and expect to see real time data as it…

I'm not 100% what you call the BIP client, I know about BI Publisher Desktop which is a tool mainly to build Publisher reports templates in Office to generate Word documents etc. But it's correct: if you have OBIEE you have a fully working BI Publisher inside it, no need to install anything else to get started. Create a…

BI Publisher is embedded into OBIEE. BI Publisher is a different kind of tool, mainly used for pixel-perfect-reporting. BI Publisher reports can be of various kind, either generated as web pages visible online from inside OBIEE or as generated files (or both).

Double posting is against the rules of the forum. What is the difference between this and https://community.oracle.com/tech/apps-infra/discussion/4478943/how-to-control-rownumber-function-in-obiee-12c#latest ? Your thread is far from being explicit in what you look for. OBIEE generates queries based on models and formulas…

Your process of testing this is flawed. If you look at the help coming with your Admintool in the "Merge Repository Wizard" screen, you see that there are simple diagrams showing the process. And the doc also shows (and says) that in this case the final "production" repository is now becoming like the development…

Damn Christian, at least add a "sarcasm" hint to your post: there are people who are just going to do what you said 🙄 😂😂😂

That config node is gone in 12c, and it would anyway impact the search window which does already work as you want but you don't want to use. All in all, based on everything posted, there is an obvious data quality issue and you can't expect OBIEE to just deal with that and solve all the problems. Sure you can turn your…

The config file has an explicit message next to that flag: "Case sensitivity should be set to match the remote target database". Is your database case insensitive? If it isn't, you can't expect OBIEE to do miracles as it isn't a database.

If you use the "search" windows of OBIEE when selecting the value to filter by, by default OBIEE does a case insensitive search in the values you can then select what you were looking for. I believe you want to add a filter in the criteria as you say you know how to deal with that in a Dashboard, or what else do you mean…

I would change the "can" to a "must": once an hierarchy exists in a business model, all dimensions must have one. You should have a warning if not an error in the consistency check if it isn't the case.

The logical joins drive the list of options you see or not. Because the joins decide what is the role of the logical table: dimension or fact. Once your dimension has a logical join joining it to a fact table, the content level of the LTS of the dimension only shows the hierarchies of that logical table. If you look at a…

Hi, What does "not working" mean? Do you have an error? Do you have no value? Do you have a number you don't like? What are the formulas you tried already? In case you had numbers back, where did that number came from? Isn't it that the formulas worked as expected but you wanted some other numbers (meaning that you don't…

The certification matrix always give these things. Only OAS works on FMW 12.2.1.4.0, OBIEE 12c (.3 and .4) are on 12.2.1.3.

You are not the only one after this, maybe the other one is just one desk away from you? 😁 https://community.oracle.com/tech/apps-infra/discussion/4477192/how-can-i-display-both-number-and-percentage-data-markers-in-a-bar-graph-in-obiee#latest