Without any custom authenticator and just using the default embedded lightweight LDAP and the weblogic account, you should look at the logs and see what happen when you try to login. You maybe have some connection issues and some init blocks keep you waiting till a timeout or something like that (that's also what Steve…

@SHARAD KUMAR JAISWAL , You described how you did the out of place upgrade, but the login part is mostly "outside" OBIEE (except if you are still using init blocks for number of things). The security configuration in WebLogic is also the piece that isn't covered in the OBIEE content migration. Is it exactly the same? Did…

Not to be negative or not "appreciating" the 3 replies, but I'm quite sure Kristian wouldn't have asked if he had a marketplace OAS 2024 instance. Because just like he knows that his marketplace OAS 2023 instance is OL 7.9 (which is surprising knowing that OAS is certified on OL8 for some years, and OL7 is reaching end of…

As Steve said, you should post in (many categories for OCI services) or raise an SR if it's a paid account.

@Satya.Munagala , no need to post in the OTBI category, this one has been moved there. Also, next time feel free to use the "body" of the question (the big textarea underneath the title) to provide more information. Things like a product name and a version always help, what you tried, and more details about the question.

@User_534UY , please do not double post, it generates parallel threads often abandoned and doesn't solve your problem faster than a single post in the right category. This one is closed now, keep following your other thread:

How about you upgrade to OAS which has that feature? OBIEE is "end of life" somehow, OAS is OBIEE, just rebranded with a different name (even Oracle in their support documents sometime still called the first OAS as OBIEE 12.2.2.x). OBIEE is not going to receive any new feature, it does just receive error correction.

And the product name and version are? Is this OBIA? Is this OTBI based on some Fusion data? You are maybe not even in the right category, but to move the thread where it does belong, some extra pieces are needed…

Hi, When you ask a question, the field labeled "Question" is more a title, a short form of the question, and then in the following field you write the details. Things like a product name and version and something that is more than 10 words. Do you mind providing some more information about your question?

I want to be able to display data from both tables, thats why I need to join the tables You are talking about RPD: what's the role of those tables? Are they attributes tables? Are they measures tables? How about you show an example of what you are talking about? You are still not really wording the requirement in something…

Thread closed! It has been abused enough… Deleting the content of the question for whatever reason after replies are posted is not really how one should behave in a public, community, forum.

Isn't this the exact same thing as your other thread? (despite you deleting the content of the question…) I assume your "orders" are just like the SRs you were trying to analyze in the other thread. Or how is this one different? (Because you marked the other one as answered.)

@Mrudula Kothapalli , Are you asking about ODI as part of a BI Apps usage? Or purely ODI standalone? The first would be covered by this forum, just a different category, and your question can be moved there. The second would need to go in a different forum, because ODI isn't part of the Oracle Analytics products. Your idea…

trying to query data from two tables You are still not answering the question of: how do you want the system to behave? Query data from two tables doesn't mean much… Maybe you don't need to join these 2 tables at all, maybe you do. The thing is that nobody here knows because you aren't really sharing any information to…

Hi, First, keep in mind this is a public forum and not an internal Oracle forum… You talk about something that you assume everybody know, while it isn't really the case. What do your dataset looks like? What have you done exactly, where, and how? Well, more details are needed if you want a more precise reply.

The easy solution would be a second dataset where you apply a filter to only have distinct (ID, WEIGHT, SEX, REGION), because that's the real unique values and HOBBY is the one duplicating your rows. Having 2 dataset would be the cleanest: (ID, WEIGHT, GENDER, REGION) and (ID, HOBBY) and you can join them on the ID = ID.…

I would say that it is still valid, because it's your duty when you install the product to install on a certified environment. Therefore you should always check the certification matrix to make sure you are working with supported versions and products. If you decide to use something not certified, when you face an issue…

@User_5TZYH , Please do not double post. You marked your other thread as answered, but you marked as a "valid" answer a list of questions asking for more details. Go back in that thread and keep following up there providing more details as requested.

How would you query these 2 tables together if they don't connect in any way? You first need to know how you want the system to behave, then you can model you RPD accordingly. But you aren't really providing any information for a more precise answer.

The enter manual SQL option in OAC doesn't support all SQL syntax. @Bret Grinslade - Oracle Analytics-Oracle , is there a documented official list of what is supported and what not? It's known that the WITH clause isn't supported because the query is generally already embedded inside a WITH clause and some databases…