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.

Well, I don't have anything come to my mind about that. But your example is simple: your fragmentation condition is based on car, boat, bike. And in your 3 tables you don't seems to have these values, so what you can do is to create a logical column for that and you assign to it a fixed (hardcode) value for each one of the…

+1 Christian And your user hasn't access to that part of the home there are chances you also don't have access to only editing of RPD, so the admin tool will not help you a lot... If you just look to open the RPD offline what there is inside you can also open it with a newer admin tool. You will not be able to reuse it if…

Hi, In theory you can do it with a presentation variable defining the forecast. If you change the formula of the forecast column to use the variable to select the right forecast column everything else must work without changing anything else. Not sure why you are trying to do a UNION report here ....

Hi, These 3 tables must not be linked together. If you link them the result would be to have the sales of cars next to the sales of boats next to the sales for motorcycles. Your case is more a multiple logical table sources using the "fragmentation" function of OBIEE to say that all the 3 tables contains sales. This one is…

Hi, No luck for that ... There is not a single permission managing that. Once you have "edit" permissions on a dashboard page you can add anything you want, all you can try to do is to limit the access to the catalog for these users, so they can't select any object from the catalog to be added to the page.

Hi, It will of course depend on how your model looks like but you can also play on hierarchies levels etc.

Well ... You can set an aggregation rule like MAX or MIN and it still return the text ;-)

As you saw it's about pieces of JS / CSS. Many posted the same questions on here and I can't remember a single one coming back to post his piece of code (if they did it). So it's up to you to get your hands into the code. (As far as I remind it isn't too complicated...)