If you think at how OBIEE works you maybe better see why you are looking at the problem from a wrong point of view in a way ... You are mixing some business logic (the condition of an account being in a list of values) with technical aspects (the CSV file). The CSV file can be read by a database as external table, it can…

Inheritance is everywhere, do not assume that by assigning direct permission to the user (which, by the way, we all agree is a bad practice and application roles should be used instead) you override any other application role inherited permission. Rules of permissions overriding aren't as simple as you could imagine ...…

Hi, First: report or analysis? Based on what you wrote I would say it's an analysis and not a BI Publisher report, right? And debugging / analyzing security issues is all about looking at what you have in front of you. Any conflict in permissions? Did you check the various app roles => permissions the user has? You are the…

1043392 wrote:Hi Gianni,Actually 11g and 12c both are the right models. I disagree ... If the model is right (really right) OBIEE would generate either the same query or one returning the same data (except if you played with DB features etc.). If the 2 environments return different results it's because your model isn't…

Hi, But which one of the 2 is right based on the model? Isn't the 11g one which maybe worked "by mistake" ? There isn't a magical flag that make things the same (ok, there is one but what is the point to move to 12c if you force OBIEE to act as an 11g?), so look at the query, look at the model and define if the tool is…

Hi, I highly doubt any 12c product (OBIEE or Publisher) is certified and supported on Windows 7. First of all because Windows 7 is ... old, and second because these are enterprise tools supposed to work on a server and not a desktop OS like Windows 7. Most of the users (will not say all as miracles can exists) who tried to…

It is generally possible using the bar/line chart to have the 2 axis and then switch the line to bars by editing a value in the XML of the analysis.

Review your formula, you must have an issue somewhere ... (in the one you posted for example you miss at least a closing ")" )

Hi, You can ... but maybe not what you want as for that you would have to cast the current formula to a char/varchar and then concatenate a $ in front. But I'm quite sure you can set a column format as "currency" and pick the "$" as sign even when you do a union. You just have to set it on the global column and not inside…

Hi, An iframe being an HTML element it definitely exists in OBIEE. You even have an object representing that when editing your dashboard. On the OBIEE side you will probably not have many issues (I don't guess 11.1.1.7 already implemented CSP, but even if it does you will only need to configure it). Keep in mind Office 365…

You are welcome. Maybe an option could be Docker? https://gianniceresa.com/2017/09/obiee-12c-docker-from-scratch/

I would use that just for training, because there is a lot, but really a lot inside the VM and they took some shortcuts to make things work. So your setup would be quite difficult to maintain and move around because of all these other things there inside. For a small production thing just do your own VM, starting clean,…

For trying things, as long as you are comfortable with it, linux is a lot easier as there are less "external" issues You can also have a look at OBIEE Samples which is a nice VM when trying things etc. My last OBIEE on Windows was ... can't remember when, so can't really help more on what can be the cause of the error you…

Nothing crossing my mind right now .... So you have a database installed on the same server? Is that a sandbox and so you installed everything together on the same box or something else? Any sign that the locally installed DB could have been unreachable at some point?

https://community.oracle.com/docs/DOC-1016040#jive_content_id_2_How_to_mark_questions_as_correct_or_helpful You have to mark one of the answers as "correct" or mark the whole thread as "assumed answered" if it wasn't what you really looked for but don't need anything else.

It's slightly unknown, but so useful ... If you got what you were looking for you can close the thread and mark as required, right now it's still This question is Not Answered.

So you must have the checkbox option avoiding you to have to setup conditions hiding/showing sections in the page (screenshot from that same version).

You don't say what version of OBIEE you are using, so difficult to say if the reply will apply or not .... Check the checkboxes "Prompt before Opening" for the page and the analysis will wait you set prompt values before to execute. A kind of delayed execution once the prompts have been set. Otherwise conditions hiding and…

Ok, so because there is nothing listening on those ports and has status.cmd tell you ... Weblogic isn't running. Now you "just" need to find where it's gone and why Look at the logs of AdminServer to start to see if you see something (inside the domain you have a /servers/ folders containing a subfolder for the various…

I assume, as a "old" windows admin, you make sure you don't have a Windows firewall annoying you and that the server clearly know what its name is? Do you try to access locally from the server or remotely from somewhere else in the network? You must have a status script next to the start & stop script, give it a run and…