2955702 wrote:Login is slow & refreshing reports is slow too. Compared to what? Is it a feeling like it's slower than something else? Did you just expected something else? Did you spent some time analysing what your system does? Worth a look at @rmoff Silver Bullets presentation:…

It depends a bit on your OBIEE (there are tons of 11g versions) but it works fine with a DB 12c. If it's a production or similar system then it's better if it is certified and for that you generally need to update your weblogic to 10.3.6 (from the base 10.3.5 provided with your OBIEE). As said it works even without that…

Not really, the filter view show you the column name or formula, so if you used a formula instead of a column from the RPD you see the formula.

In the RPD you can set the aggregation to MAX on the logical measure and then by setting the correct content level force the "by" or let it free based on the analysis the users build.

And what is the function supposed to do? Return you the last value of something? As long as you model it right in the RPD you can set a LAST aggregation on measures...

Hi, If it's for development I would follow Christian with VMs as you can easily have multiple versions. If you mean Admin tool sure, not a problem, you can install as many as you want next to each other. If you mean full OBIEE on your server it's also a yes, as long as you install into different folders and you pay…

Hi, There are many ways to manage this requirement in OBIEE. First you need to be able to identify for each user which branch they will be allowed to see (by querying a database table of employees locations or something like that). The idea is to have a session variable defined for every user in your system and use that…

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…