3808468 wrote: Is it compulsory to move OBIEE 11g scheduler tables data in to OBIEE 12c.? As Joel said you don't need to migrate anything which wasn't migrated by the migration process. Why would you want to migrate the scheduler tables content? Do your agents have some "smart" logic checking on their last execution…

You got the "Oracle" reply in the other thread in MOSC: Is Microsoft Edge Chromium certified for OBIEE 12.2.1.3? Practically Edge Chromium share the same core as Chrome (that's also why Chrome extensions can be installed in Edge Chromium), which means it must to work and there is no reason for Oracle to not certify it at…

mchorazy wrote:Must I set something else? Something else? What did you already set? Isn't this just the exactly what you asked in Error with start obips1 service ? You don't have to open a thread for every message you want to post, you must keep replying into the same thread if it's the same issue and still you are trying…

If you get rid of one of the PERIODROLLING calculation, you can just use the one PERIODROLLING you are left with and it will work. You can achieve the same result as PERIODROLLING by modelling a join not with fact.date = date_dim.date, but as a BETWEEN. In this way the joins will return a PERIODROLLING value by default…

It isn't calculating the reverse difference, it is just doing what the function is supposed to do. By using it as you did, you will get the number of days between OPEN_DATE and ACCEPTED_DATE, and that supposed that OPEN_DATE is an older date than ACCEPTED_DATE. Thanks to the fact that an Oracle database can use…

Hi Joe, You will need to do an extra effort ... First by being explicit on the product and version (OBIEE and Publisher are packaged together while being 2 very different products). Joe Choueiri-Oracle wrote:... for some reason I am getting the total number of orders, basically, the filter is being ignored.Any idea? No…

Answered the same thing 2 days ago: Turn rows in columns or filter columns by another column

Set an aggregation rule at the column level into the pivot view for "value" and it works. If you know all the possible values of "type" you can create as many copies of "value" as needed and add inside a CASE WHEN condition to display the value only if "type" is = to every single value. With this you can keep your table…

Use a pivot view instead of a table view.

Sangeeta Pandey wrote:This OBIEE repository will be part of DB server and can be different than OBIEE server. OBIEE server will connect with DB server to access metadata reps to refer these metadata? No, the import is a real import. But only an import of metadata. More than an import you can see it as looking what the DB…

Sangeeta Pandey wrote:import metadata through Connection point at physical layer of RPD, I guess it brings the object from DB server to OBIEE server? It's called "import metadata", therefore the only thing which will be retrieved is metadata, no data will be moved.

Sangeeta Pandey wrote:transferring objects to physical layer is taking a great amount of time. I selected only 5 tables and waiting for last 1.5 hours to get it transferred. Nothing is being transferred! The menu is called "import metadata", not "import data" or "transfer data". Only metadata is collected, nothing is…

Hi Sangeeta Pandey wrote:1) I can see 2 connection points at RPD, OHI Analytics CP and OHI Analytics Language CP. Why 2 different CP required and what is purpose of each? Your RPD is yours, nobody else has the same. OBIEE comes with an empty RPD. Therefore it isn't possible to tell you the meaning or reason for those…

If you check MOS or even just Google, one of the first hit will be the DISPLAY variable. Maybe somebody had it set when restarting OBIEE and that's your issue? It's generally the first thing to check when no charts is visible in OBIEE ...

Weblogic is supposed to encrypt the password the first time it will open the boot.properties file. Try the "simple" one first, just replace the content of the boot.properties file (they are maybe 2, just check the folders searching for those files and check what they have inside and update all the required one). Enter your…

Aggregate using COUNT and sort that counting column in descending order.

Aren't you having a "modelling" issue? Your reason for concatenating things in the prompt seems to be "the user has a clue of what they are picking up": why is it like that? Can't you use the "Descriptor ID column" in your RPD? So that the human-readable column has the "technical" 2 characters column set as descriptor ID…

LEFT isn't applied to every single elements of the variable (if multiple values) before to add ' ' and add them as options in the IN but it is applied to the final string itself, which means you are breaking it. To use it with LEFT you must make your variable single value only and change your IN into a = .

As Christian said, you are just looking to install a very old tool on a recent OS. Why don't you also update OBIEE at the same time as your OS? If your IT asked to update to a newer OS, there is no reason the same doesn't apply to OBIEE. RHEL 7 and 8 didn't exist when OBIEE 11.1.1.7 has been released (it was April 2013,…