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,…

3516041 wrote:But in one of my dashboard my query is getting different. Any idea why it is behaving like this. Yes, the idea is quite simple: 11.1.1.7 vs 11.1.1.9 11.1.1.9 changed various things compared to 11.1.1.7, therefore the queries can also be generated in a different way. It's part of the activities of an upgrade…

"out-of-place" means that you aren't going to upgrade the domain you have already, but that your OAS is a fully independent install and you move content there and you have to redo yourself the security config in weblogic and those things. As you anyway will have to do that even if you move to 12.2.1.4 first before to be…

mchorazy wrote:But can I migrate directly form 11.1.1.9 to OAS? Yes, from the last 11.1.1.9 you can do an out-of-place upgrade. Seeing where you are coming from (11.1.1.5) there isn't really one being better than another: you will probably have a lot to clean-up and fix because you come from quite far away.

Hi, OTBI isn't OBIEE (OBIEE has ODBC and web services for that). You must ask in the OTBI forum in https://cloudcustomerconnect.oracle.com/pages/home .

There is a WSDL describing all the "classic" analysis (Answers). There is a service for Publisher as well but it's maybe more to execute existing reports (didn't look at it for some years). AFAIK there isn't a proper web service for DV (the new name of VA). There are REST APIs in DV but most of them aren't public and…

If instead of concatenating 'a, b, c' you concatenate '<a href="...">a</a>, <a href="...">b</a>, <a href="...">c</a>' you still get a string as value. The difference is that this string is an HTML string and you can kindly ask OBIEE to shows it as HTML instead of just a string. The HTML contained in your string will turn…

Does your source really store "a, b, c" , "f, g", "10; 20", "40; 50; 10" as values? (so a single string) "a, b, c" doesn't mean Product ID "a", Product ID "b", Product ID "c", it means a string "a, b, c". If somebody somewhere is making up those strings (and I'm quite sure they are: somebody discovered the power of LISTAGG…