Hi, For word clouds there must be an example in SampleApp using Oracle Database 12c functions (something they added in the 12c release and the highlighted the use in OBIEE SampleApp) or you can also use R to produce it. Both these 2 things are done at the time you open your analysis/dashboard page. Isn't that what you look…

Ah, interesting they suggest to hack their JAR as apparently it's one of the most illegal things ever Based on past past releases the client tool isn't patchable as there are few pieces of opatch but not the main files, so they just have to release a new one. But I guess they will just wait for the next release and in the…

Hi, Is the exported file a CSV? (or any kind of text file) Your characters looks like a UTF8 encoding issue, so if it's a text file use a text editor (not just notepad, something a bit more advanced, they all have encoding options) and save the file changing the encoding. There are chances it's enough to fix the issue.

What URL do they use to access? If I'm not wrong you can have the error because of a slash (or missing slash) like /analytics works while /analytics/ doesn't or the opposite ...

Hi @Jaco P. , You can actually fix the issue with your local Windows machine BI catalog manager by applying the same path you linked (the one you applied on the server). I just did it and it works fine Of course this isn't an official supported way, so backup any file you are going to edit before to edit them (or be ready…

It would be no fun if the name was perfectly readable The russian characters are just represented as UTF16 hexa characters, when you see # followed by 4 chars (0-9,a-f) it's a letter. For example one of your names has this: #043f = п #043b = л #0430 = а #043d = н #043e = о #0432 = в So it's " планов " something (plans?…

Yes, the query must be logged like any other query, that's why you can maybe find some hints there looking at what the server generate to try to find out the format.

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?