If you look for rules they are available easily in the FAQ: I would say the main one to check is and . The rule to not double (actually you did a triple) posting is because of everybody does this place will be a useless mess. The idea is to be helpful not for the individual but for the community (and the individual asking…

Aren't your technical reasons that you didn't setup content level correctly to define the conformed dimensions etc. ? Because if you think at your need from a row point of view you see that there is something that can't work: you want colA from an analysis next to colB from another one, but things are put one next to each…

First: does it still make sense to reply to this thread and try to give you hints if you just don't care and open new thread with the same question? How to retrieve a value based on a month selected by the user in Analytics I already wrote it once! You can't modify the value selected before to store it in a variable, so…

Your use case make much sense now, and it's where we were going... You just have to change a bit the order of your actions as it's not exactly how you imagine it: 3350649 wrote:for example. when a user select a month, in this case, January = 01/31/2017, or February = 02/28/2017, internally I want to convert this month to…

Hi, Again I believe you just missed part of my answer as it still apply .... You add a prompt, in your prompt instead of column prompt you select variable prompt and a presentation variable is more than enough. Then you have a query: the idea of OBIEE is not to write SQL but to model things and let OBIEE generate the…

Hi, Are you looking to use a presentation variable as filter condition in your analysis? Not sure why you talk about repository variable as it's probably the last option ... You add a prompt on your page, ideally the prompt just select a value from your time dimension so you avoid all the issues of formats etc. and all the…

Don't you have the "abbreviate" option to set to "none" in 11g? (I don't have an 11g available to test directly ...) I guess it was already there ... If not: what exact version of 11g?

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…