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...)

That's the default behaviour of a table / pivot in OBIEE : it will merge dimensions values (if the same). Just keep in mind that to be able to have OP1, OP2 etc. in a "month" column they must be a measure and not a dimension attribute...

Well, of course you lose all these things. But you can't really ask to have OP1 and OP2 acting like independent cells but be into the same cell, at some point you must chose ... All these things (drill, style etc.) happen on the cell as each cell represent a single value. STATUSJAN 16NEWOP1OP2 If you want to keep them…

So you want to use a text column as measure that you can aggregate (concatenate). Well ... depends on the physical DB as for example in Oracle you have LISTAGG and you can call it by using EVALUATE (google for that related to OBIEE and you find many examples even here in the forum).