Hi, Haree wrote:...my requirement is to deliver three different exported file for each region through single mail. One agent = 1 object = 1 file / 1 attachment So 3 different files in a single mail no, not possible. The only way to cheat a bit is to build a dashboard with your different content in different pages (or all…

Conditional formatting on grand totals doesn't work anymore in latest 11g versions and there is no way to make it work as "conditional formatting". The old hack of the XML doesn't work as the structure changed, in the latest 11g there is a different piece of code that can be accepted by the analysis but then the logic on…

Christian Berg wrote:+1 it works upon join creation but will throw that error if you try to modify an existing join If the existing is a simple join with just =, > and < operators as Christian said you get an error. This happen because when writing the BETWEEN it's not a "simple" join but switch to a "complex" join. So if…

Hi, Try again as it works and that's the way to make it ... When you draw your physical join you can't write directly into the "Expression" field, you must click the icon on the right to open the "Expression Builder" and there you can write your full condition (id = id AND date between date and date).

Hi, #2 from @mac2 sounds good but ... your date make it not really fully usable ... Jerry S. wrote:... because Expenditure records do not exist for every Budget item. This one will make your life complicated. What do I mean? Well ... as soon as you bring in the "Color" column you will lose the data relative to pens and…

Oracle Business Intelligence 12c Configuration Assistant not launching Different issue but a common point: Windows 7 = unsupported OS = desktop OS (not enterprise) = issues

Is it because of licensing issues that you look for this? As Christian said it's related to your authentication providers in Weblogic Console....

The little I remember about Outlook / Exchange goes in @rmoff direction. A list name has a meaning only for Outlook / Exchange, but doesn't have any outside. So you must have an email address associated with it, or a forward or something that read emails on address xxx@xxx.xxx and forward to list ABCD. But all that is mail…

Yeah, the 12c message definitely make more sens .... Maybe you can try using inline prompts in these analysis? So it's during execution that users can set filter values (or dashboard prompts if users find these reports in a dashboard page). I guess that if you even try to get the filters outside as saved filters the error…

Hi, Can you be a bit more explicit? What do you mean by "wrong" ? Are A and B correct and A/B isn't the result of the division anymore? You will have to provide more details to expect some real answers, like also the details of what system you are using (tool, version etc.)

Hi, First : you said "catalog group", forget... It's not in 12c from 12.2.1.1.0, everything is done by application roles. As rmoff posted you can get a variable with the roles (not the security groups in the web logic ldap, so pay attention to that, app roles are the step affer). Then to join Andrew you do not setup…

Yes, so his first answer (not possible) still apply. He was asking because maybe you wanted in the chart only the last month and not the previous ones. But you want the 6 months and showing the value of last month numbers next to where your lines end (and that the not available option)....

@Christian Berg : what a nicely signed integer case I assume you are using OBIEE as you posted in the OBIEE forum ... What is the type of your employee ID column? Just to make sure it's not this one limiting you, but it can perfectly be an issue with the function where they maybe coded it using signed integers, so ... not…

As Krishna said it's not doable ... the setting is "always" or "never" (ok, on mouse over).

Not saying Windows 7 isn't a valid OS for your desktop daily work... (and there is also still some form of support for it by Microsoft). But the first and most important thing: OBIEE isn't a desktop application, it is a enterprise level server software. So just this explain why there is no effort to officially support a…

Hi, Did you do some analysis to make sure you aren't getting negative or zero data back? When you do an upgrade in OBIEE you maybe don't touch anything but the tool start generating queries in a different way and return you data in a different way. So I would say to first add a table view to display the values and so you…

Hi, OBIEE is not really the place where to do data cleansing because OBIEE doesn't store data ... So the cleansing process is done again and again each time to run an analysis. As Joel said would also help if you give some extra pieces of information ... I assume you maybe means you get data that are received as varchar…

Hi, Actually you are installing on a OS not officially supported, so if it doesn't work it is not shocking .... Difficult to know if you are supposed to be able to install OBIEE 12c on a Windows 7 because a) it's a desktop OS b) it's a "old" OS c) it isn't supported ....

This evening I'm (you are) lucky: https://blogs.oracle.com/proactivesupportEPM/entry/km_doc_how_to_change

Hi, There is a MOS document about how to uninstall Essbase in OBIEE 11g, and there is an Oracle blog post pointing to a MOS document on how to change passwords (all the password) so that your Essbase will work just fine. Just trying to find the link to the second one (so you can finish changing the password in the places…