OTM seems to be Oracle Transportation Management, there is an OBIEE component in there (saw a 11g blog post about it )

So if you look for OOTB functionality what's the role of JDeveloper? Open your OBIEE, create a new prompt and add the columns you want. That sounds like what you look for.

Not sure what "OTM BIEE tool" is exactly and how it looks like. Do you have a proper OBIEE or you just see OBIEE content inside something else? Can you develop your own analysis? Do you have access to the catalog page where you can browser through the catalog and see the various elements (dashboards, analysis etc.) ?

Your question is quite vague ... As you ask in the OBIEE forum let's assume that you have 2 OBIEEs in front (cloud or on-premises doesn't change, the tool is the tool). You say reports: do you mean BI Publisher reports or OBIEE Answers analysis (and dashboards, prompts etc.) ? In general a migration is done by archiving…

Join the other thread opened half an hour ago as you ask the same exact thing (weird that 2 different users ask exactly the same thing at the same time) OBIEE 12c integration with JDeveloper 12c

Can you define a bit better what you try to do? Because OBIEE allows you to build analysis and dashboards without needing any coding or JDeveloper, so you probably have something else in mind ...

What you are looking now seem to be "physical tables", while the dimension link to a logical table (with spaces in names instead of '_'). You really don't have them in your 'Core' business model (in the middle of those hundreds of things)?

In my "random" RPD I have a table associated: Do you have these 2 tables? Maybe you "just" need to associate them again (not sure why it wasn't the case already)

3587245 wrote:Do you find any patches released for OBIEE 11.1.17.150120 in oct 2018 release... OBIEE 11.1.1.7.150120 means OBIEE 11.1.1.7 with the 20 January 2015 bundle patch (20-01-2015 => 150120). So for a bundle patch of 2015 you can't have a release in 2018. From the links posted above you can see that the last…

Sorry to not be able to give you more but those things really needs to have the hands on the system to debug properly and find the root cause. All I have is an OBIA RPD coming from not even sure which version (so no DB and nothing else than the RPD).

The SampleApp (https://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html ) has some scripts which extract that kind of information and load them into the database and inside the same SampleApp you also have some "impact" analysis dashboards which allow you to find those kind of links. There…

Yes, that one And when you look into what is "Spend" you see it's not a simple column, it's a CASE WHEN on top of 2 LTS which are each a join of multiple tables. So the generated SQL will be "not really nice to read".

Charles M wrote:We should have the data there. It's OBIA, what is expected is often not there in reality

As Avinash said, you need to check if you have data for the previous year for the "Spend" column as the formula of "Spend Year Ago" uses the AGO function. Being OBIA the RPD is a nice "mess", so that column is a nice CASE WHEN coming from a bunch of tables with inner joins between them and there are 2 possible LTS used. So…

Hi, Did you look at the physical query generated to see what could make the data not being retrieved? Did you already saw that column working? What kind of formula does this column have? Is that using AGO? Is that a physical column in the DB? How is it mapped in the RPD? Well ... more questions than answers

Google for that. There are some videos on youtube and tutorial on Oracle pages which are better referenced by Google than Oracle itself. There has never been tons of content for it as it has been a quite "short life" tool, it appeared in 11.1.1.9 and it kind of died in the same time. It still exists but I didn't hear of…

Adam_K wrote:Would you be able to tell me the details of what it says? That's the most illegal thing we could do. MOS documents are for clients / users with a valid support contract, it's something you need to pay for. It's illegal to copy/paste content from a MOS document and send it around and even more to post it here…

BI MAD is what it is: a limited subset of functionality which was developed at some point to make OBIEE "mobile" friendly. This was when the default OBIEE was still full of Flash. Now OBIEE is HTML5 based, mobiles could render it directly or can do it via the dedicated app. Therefor BI MAD kind of stopped there. I didn't…

How to transfer an analysis from OBIEE to OBIEE Mobile App. Do you hope the answer will be different and on a Monday we will tell you that you can "drag & drop" your analysis into MAD?

After the "and" you don't need the column name anymore, just the value ... Do a proper copy/paste of what Robert posted above.