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…

If the code of this view doesn't work directly as source for a dataset in OAC, I would call it a bug. Because you weren't returning JSON objects (or the view would also not work when used in OAC), and it's the dataset definition having a bug in not being able to handle something correctly, and also not being able to report…

@User_0K99C , What product are you using? OAS or OAC? If you are on OAC you don't really have access to anything, but if you are in OAS you should still be able to see some kind of logs maybe telling you what's going on.

The question has been moved in the OTBI category. Being a "content" question, you could also consider asking in the Fusion forum if you find a matching category ( ).

Hi, Could you please share product name and version? Based on your reply the question can be moved to the right category, or you can be pointed to the forum covering the product you are using (if it's a Fusion product).

@User_T2LGL , As Arjun mentioned, this is not the right forum for your product. You should find a forum covering your product and post there (this question can't be moved there because it's a different forum instance). Other forums you could explore to see if they cover the product you have a question about are:

@User_W0H93 , Yes, "classic" (everything /analytics) didn't really change. All the permissions and privileges is the same and behave the same.

Because you are on OAS 2023 already, how about upgrading to OAS 2024? You could then consider using the Semantic Modeler instead of the Model Administration Tool. Just make sure your RPD is "compatible" (currently only relational sources are supported), but if it is, it will make your release / promotion of code a lot…