You know that searching the forum would take less time than writing a post? Same topic 3 times per week in the last 2 months ... https://dimensionality.ch/2017/05/06/installing-oracle-bi-on-windows-7-8-10/

Isn't this the exact same thing as getting error while installing OBIA 11g you posted 4 days ago? Please avoid double posting: the result is 2 threads with their own life which will probably not get any follow up ...

Great decision Dimensions is really something making the difference in OBIEE and the analysis you can do, and I'm sure the benefits of this dimensions (with the 2 levels) will easily compensate the extra work now to create it.

PavankDatti wrote:you would have create fake join here between D1 and F2 and map to Total Level No, a fake join is useless, content levels exist for something. And if with "fake join" you think at a 1=1 I don't believe you really want a cartesian product between a fact with millions of rows and a dimensions that can easily…

First thing: conformed dimension. I hope all your dims are confirmed or I would ask you what they do there if nobody confirmed they want these dims. 3231180 wrote:my question is without throwing any error here Is that a test? What do we win if we answer right without having anything as input? I would bet on a wrong…

The "Implicit Fact Column" is defined by opening the properties of the subject area in the RPD. As said only one column can be defined as implicit per subject area. So you must manage to identify a measure being the most generic as possible.

The question was more about what kind of source you wanted to use to point you in the best direction (like OCI instead of ODBC if Oracle etc.). But you fixed, so enjoy

What is your "External Source" ?

Based on https://community.oracle.com/docs/DOC-891037#jive_content_id_1322_Helpful_and_Correct_ you must have a button to mark an answer as correct and this will also flag the thread as solved/answered.

Good to hear So can you maybe close the thread and mark answers as required? It will help others looking for the same and for now it's still This question is Not Answered.

Hi, You just need to check the checkbox "Limit values by" in the options of your prompt for name. To make it work fine if the 2 columns aren't coming from the same logical table you must define the "Implicit Fact Column" in the RPD for that subject area. When querying dimensional attributes only the filter will be done…

Hi, The way you describe your need and issue it sounds more like a (data) model issue. You say you have organizations and suborganizations, the relationship is they start with the same set of characters. In a ideal model organizations and suborganizations would be 2 different column and the "same set of characters" rule…

WLS host the domain OBIEE create, so it's not about WL and BI on the same domain. But as Christian said the order is: WLS first, OBI install after. This one is like the "software only" install on 11g, it put all the files there but doesn't create any domain or configuration. Then you run the RCU and finally configure OBI…

What's the history of that install? Did it ever worked? What changed since last time?

920799 wrote:what is the use of installing OBIEE with out RPD access The use is the concept of client - server: OBIEE is the server, Admintool is the client. And all the linux/unix setup are in the same situation: you can't open the RPD from the server as the Admintool doesn't work there, so you use a client to connect to…

First: Abhishek pointed you in the right direction, there are 6 zip parts to download. You need all of them as they aren't independent zip, it's a single zip separated in pieces to make it easy to download, so you need all of them as 7-zip will process them all in once. Second: vinaymc wrote: files got downloaded without…

There is a tool giving you all the presentation columns with a visibility condition. Open the RPD, "Tools" > "Query Repository..." and there you set the condition. You select "Type = Presentation Column" and add an additional Filter with the condition "Visibility filter <> "" " and there you have a nice list (and you can…

A report is just a query, first LSQL and then a physical query is generated. Did you look at the logs for the report? Did you see the physical query? Does it contain a filter, condition, join explaining that data isn't updated? If yes => you know what to look for (it can be in many places in your system, so not going to…

What do you mean by hidden fields in the Presentation layer of your RPD? You mean you used the "Hide object if" option and want to find all the presentation objects with this option set?

Double posting with How to sort by a column not used in a graph Solved in the other one ... @3294318 can avoid double posting in the future? Double posting generally gives less answers and more unfollowed threads, and it's the same people anyway most of the time around the few spaces on BI & co. So close this thread (as I…