Different question: any specific reason for wanting to "change" that? When you start OBIEE with the start script you will have tons of "info" messages, but that's just what they are: informations. Because behind there are tons of things starting, each one will have some debug output about what happens and what the tool is…

As extension to Joel, if you look into Sample App 607 (https://www.oracle.com/middleware/technologies/obiee-samples-downloads.html ) you find some scripts and dashboard to display those information. If you really want to go down to the physical table, once you have the info from the catalog you also need to get the…

There would be a way, which I would highly suggest you will never adopt because you will regret it soon or late: create shortcuts I almost feel bad even just mentioning it. That would be a quick fix while you start doing the proper changed (as Joel said, manually or by search&replace). Do not keep shortcuts on the long…

I don't see why OBIEE would use a LTS knowing it doesn't have a column. Did you check all the content levels are set correctly?

You can set the priority group for LTS1 and LTS2 to make LTS2 a higher priority than LTS1. Priority group numbers rank your logical table sources in numeric order, with 0 being the highest-priority source. In your case you seem to want to use LTS2 when only A1, B1, C1, M1 are selected, and use LTS1 only when D1 is part of…

Hi, The 2 solutions are at different levels. OBIEE is the analytical platform itself: it comes out of the box empty. No database, no model, no analysis or dashboard. You can link various sources to it, model those sources into logical models and use the result to create your analysis and build your dashboard. It's really…

Programmer Analyst wrote:Talking to myself: Why does Oracle want to make it so complex? No wonder other BI tools are dominating now. Why is an enterprise analytical platform any different than Excel? The answer to your "why does Oracle make it complex" is as simple as defining the difference between a client application…

First thing first: what version of OBIEE are you talking about? Do you want the permissions associated with every analysis or do you want to resolve all the security dependencies and, for every single application role, get the list of all the analysis they are allowed to open? Because this is something totally different…

First, there isn't a "correct" way because there isn't really a wrong one. There also isn't a "best" way. Your database can be as you want, and it's generally not the BI defining it but more the DBAs and the security rules you have in place. I would say that a "not good" practice for me is creating synonyms to have all the…

The tValidator.getSubjectArea() maybe return a value encoded in a way or another, so you would want to check that. For your issue that you get an error just by having the russian character, try encoding it, like using the ASCII value or one of those alternative ways to get that char out from standard characters.

My guess is that the behaviour is correct and it acts like if you would have the 3 columns in your analysis. If you had separated columns for "location", "source name" and "file name" and an extra column for your "# transactions", clicking on an action link on the "location" column would only pass the "location" value down…

What is the database type of the database object in the physical layer of the RPD? You have attributes and measures in the same table, and you say they are from the same LTS, which is, by design, wrong as a fact logical table must have only measures (aggregates) and anything else must be in a dimension.

As Joel said, the BI Server generate queries based on what the RPD tell it to do (and some settings telling the system what your database understand). So far it's a very generic thread without examples or queries, so not sure what else could be said. What I can say, and you will not like it, is that my OBIEE doesn't do…

Not having a system in front to check, but doesn't the breadcrumbs at the bottom of the page give you that by default? Javascript to use browser "back" button is just like if you press the button in the browser itself: not fully compatible with how OBIEE is designed. There is too much javascript doing things to simply go…

A logical fact table doesn't have logical keys, just as it doesn't have attributes. All it must have is measures. You need to clean up that model because right now it's "strange".

I would say both replies you had before were pointing there. The problem is in the meaning of things: JosephX wrote:it runs daily and always selects data from the current period, based on whichever period that day is in There isn't something called "current period" having a universal meaning. "Current period" generally has…

What I can already say from the query is that your model isn't clean: how come that attributes and measures comes from a single table being an aggregated one? A logical fact table must have only measures (aggregations), attributes must come from logical dimensions. Without a proper model with clean hierarchies on your…

And the physical query is? That one is the logical query. By the way: the Oracle database is telling you that you have another issue: ORA-01017: invalid username/password; logon denied

You have a popup message in VA with a link to a thread in the forum? Would be easier if you write all the details in this thread, otherwise there is no way somebody could guess all the possible things happening. Info like exact versions etc.

Still, did you check the query the BI Server is sending to the database? (that feeling of repeating myself ) Run an analysis giving you the error and find the physical query the BI Server sent to the database generating the error (either in the manage session page or the log files). What is this query like? Why do I…