Hi Jerry, Yes you can use a CASE in a physical join. But you have to go into the Expression Builder as you don't have a special button like in 10g to create a complex join vs. a normal join, so OBIEE automatically makes it complex if required and it will decide based on the condition you write into the field inside the…

Hi, Adding a proxy in front of it? Or are you trying to deploy 2 instances of OBIEE or things like that?

Not really ... What you ask is doable with many prompts (like 3-4) and you can enter a name into each one, but just one per prompt. Your condition isn't one that you can apply on a list of elements, so you ask to be able to split the value you enter based on the " ; " and then build dynamically a filter condition joined by…

In addition to what Christian said, the "SUM(.... by something)" is like a group by something in SQL, so it's more to get subtotals and things like that.

Your query is not being sent to the DB, it actually stops in the cache as there is a match. But if for any reason your cache contains bad or wrong data (maybe because of when you started building things etc.) you don't get any data out. And because of the cache you also don't see the physical SQL sent to the DB. So as you…

Hi, As it's a web page with many elements into other (tables into cells etc.) it's a bit complicated to clearly manage column width .... Did you set the width of the column on the header as well? Did you enable the "wrap" option on the column? If you start setting the width you want at all the levels you generally manage…

If you look at your logs how does OBIEE translate that simple logical SQL into a physical SQL? Because if it does you clearly see the physical query and you can find out what the server is asking to your DB, if it doesn't you generally have some messages around telling you what stopped the query. You can also have filters…

While looking at logs (based on Christian's link) did you try to connect with a LDAP client and enter the same criteria in the search? Do you end up with all the users or just few of them? (Maybe the AD guys didn't really told you the truth about their LDAP and so your settings aren't really working ...)

Hi, The concept managing a community forum is that people share their findings and solutions. So if you solved your own issue by yourself would be cool if you post, in your own thread, the solution and flag it as the right answer instead of just saying it's assumed answered and the next user with the same issue... good…

In OBIEE 11g it's normal, online changes aren't replicated on all the nodes (it's written somewhere, can't remember if in the DOC or in a MOS doc, the same question has already been posted). But if you restart all the nodes end up with the same RPD...

Hi Joe, You can do it by using conditions to show or hide sections in your dashboard. You dashboard page will contains 3 sections with one single analysis per section, you must create 3 analysis acting as conditions. The conditions to display or hide a section is not based on the content of the analysis for only on the row…

Hi, The first thing to keep in mind: you don't assign security on groups but on application roles (the old webcat groups are officially not there anymore in 12.2.1.1 and deprecated since 12.2.1.0 and advised to not use anymore in 11.1.1.9 etc.). So assuming you have all the application roles you need, there is no reason to…

Hi, You can't ... In a weblogic group you can add the weblogic users, but the AD users will not be available there .... The AD users will have their own AD groups (based on your config) so you can have both a weblogic group and an AD group and add both of them to your app role.

Hi, Please do not double post: Time series functions using fiscal year issue You have the same exact question with already some answers, so close this thread and follow up on the other one...

Actually it's when you edit the dashboard page, you go to the properties of the dashboard prompt you added in the page and there you find "Scope". By default it always set itself on the "Dashboard" value. Switch it to "Page" and try again. (You must do that on all the 5 pages)

Actually I don't think there is a setting managing that but it's also what I saw. It generally isn't a problem as integer can be a double (the opposite would be a real issue). Does this change from integer to double give you problems somewhere?

Sorry for not having posted a direct reply but @Christian Berg did (as he knows the case). It was all about the browser temporary files : at some point they got corrupted somehow and things started to not work, mainly things related to JS (so that's why your description made us point there).

What is your CALENDAR_WEEK column? Because your CASE can return a double (QUANTITY), a xxxxx (CALENDAR_WEEK) or a number (the ELSE).

Did you set the scope of your prompts to the page instead of the dashboard? (on option on the prompt when you edit the dashboard pages) What you see now (the value being passed between pages it's because the logical column used in your prompts for region is the same on all the pages and most of the time you would expect…

Ok, so the answer above about using 3 logical tables with fragmentation still apply for the sum of sales part. And you then add a new logical table source for your profit fixing the content level to say it doesn't exist as a detail per sales person but just at the top "kind of sales" (car, boat etc.) level.