994426 wrote:None is working. What does it mean? You get only data for ABC? You don't get anything back? You have an error? If you don't have an error did you check what OBIEE does when receiving your request with the various formats? If you look at the LSQL you can maybe have a hint on what to change to make it work as…

Hi, Not really sure what you are asking ... You have the table, the structure and you clearly see what's inside. So you have all the elements to make your analysis, no? 3371002 wrote:...for users from a specific campus (university data) ... You are the only one knowing how to link a user to a campus, S_NQ_ACCT gives you…

No, you are correct in what you saw (and the understanding wasn't right), the style doesn't stop at the dashboard and its content but cover the full OBIEE interface (the most visible part being the top banner with colors and logo defined by the default style). So the default style will apply to all dashboard not having a…

This thread like every other you ever opened (~70 with the exception of 1 or 2) is still This question is Not Answered. Maybe time to review the concept of community forum and how you are supposed to help others when you ask a question by reviewing answers and close the thread if got what you were looking for as it helps…

Hi, Forget your Mbean things, in 12c Mbeans aren't part of the equation anymore. Officially you have a command line script to upload/download the RPD, that script make a HTTP call to a URL to download/update the RPD. There is actually a really nice post by @Andrew Fomin. giving all the details and sample code:…

chillychin wrote:But for the rest of the ports do I also need to open them all up? Or are the 3 ports I listed sufficient? If you open only these ports you have web access, catalog manager access (9500 / 9502), admin tool access (9514) and if you need job manager access it's going to be 9511. The other ports it's about you…

Not easy if the admin doesn't even tell you the right kind of LDAP they have ... So you can close the thread as everything has been solved, for now it's still This question is Not Answered.

Hi, if you have many prompts of course they store the values in independent variables, so that's easy. If you select multiple values from a single prompt the variable will contain the list of values, so you can still cut it in piece and isolate independent parts. But it will not keep track of first selected etc. the list…

Hi, Do you still have a question? Because you marked your thread as "This question is Assumed Answered.", so it's a bit confusing ... PS: if you found yourself the answer to your question would be nice if you post it back as this is a community forum (where people give and not only take)

Honestly? Really don't think so ... That's not how OBIEE generate and process queries. You have 2 situations: OBIEE manage to push down to the database everything and you end up with a single query, many WITH blocks but still a single query, or if you do things OBIEE can't push down to the database the BI Server will do…

Hi, Not sure to really understand what you want to do ... You would like to execute your subquery, the SELECT X, store the result somewhere as values and then use these values as filter in your main query. And you don't want the query to be embedded inside the other, right? Well ... you are trying to solve issues of your…

Nice requirement ... Not possible out of the box, by default OBIEE doesn't hide columns at all, even if empty. In this case how is OBIEE supposed to know if the column contains only NULL? It's a row by row check ... If you remove the header of your column it will be really small, so it's not going to take too much space.…

If you compare the current (broken) config.xml file with the backup you took before to edit it, what is different? Didn't you by mistake broke the XML or duplicate something or things like that instead of just updating values?

What you did before to get that error? Did you maybe play with the config file of weblogic? Or did something in Weblogic console ?

user545194 wrote:When configuring OBIEE 12c - step 8 the configuration progress hanged at some point. So you don't have a valid OBIEE configuration. Weblogic Adminserver works fine as it's isn't impacted by the OBIEE config, so it's normal that EM and Weblogic Console works fine. So the best thing to do would be to first…

user545194 wrote:When configuring OBIEE 12c - step 8 the configuration progress hanged at some point. So you don't have a valid OBIEE configuration. Weblogic Adminserver works fine as it's isn't impacted by the OBIEE config, so it's normal that EM and Weblogic Console works fine. So the best thing to do would be to first…

What @FTisiot said will definitely fix all your issues (linking objects to the new name). Just a detail: make sure you have a backup and you can actually restore it as the search/replace doesn't have a "undo" button, and you destroy half of your catalog as easily as you fix the few objects pointing to the wrong SA name

Hi, You can move things at the filesystem level directly, just keep in mind you need to move 2 objects all the time: the analysis itself and the .atr file with the same name. (first make sure you have backups and they really work!) At the catalog level you can do copy/paste + delete. And you know that moving an analysis…

Hi, I don't see the link between PDB and OBIEE. First you don't have to create a new CDB as CDB is the base and in case you will add a new PDB, but again OBIEE doesn't need a new database, it just needs the one you used when you did the setup. You said you installed, but did you also configured OBIEE?

Once again, read the documentation! Configuring Oracle Business Intelligence to Use Alternative Authentication Providers Everything (but really everything) is covered, if you take 30 seconds to open the link and read the steps you will see where the jar file is located and where you have to copy it and all the details.…