There isn't a setting to control the formats of the export. It's either all there or none. What you can do is more a UI trick to hide the Excel 2007 option. By using some JS/CSS you can hide it. Based on the code you can make it work on a single analysis or on the whole browser page (= dashboard page). You add the code to…

Who told you it is files? The tool manage these things internally, you can't touch them in any possible way, all you can do is to set some permissions on them. Nothing else. They aren't objects of the catalog like analysis, pages or DV projects, they are different.

Yeah, for your need this option is absolutely not what you look for. The behaviour is fine because it's better from a performance point of view to not have a WHERE condition instead of having it with 10'000 values. But your need is fairly different and not so common. By using hierarchies (so having an higher level on that…

"All Column Values" doesn't include all the values of the column, it actually bypass the filter and tell OBIEE to not filter on that column. Therefore what you look for it's impossible because of how "All Column Values" work. And there is nothing in OBIEE allowing you to do what you ask for. Workarounds could be achieved…

Instead of MAX, use a reversed RANK by INVNO, so you can filter on this new column = 1 to get the highest SUBMIT_ORDER by INVNO.

Hi, You are talking about a pre-packaged product, so you must ask in that product forum. OBIEE comes with no content out of the box. Based on your product you can move or ask a MOD to move your thread to the right place.

It is in the catalog, in the system folder. So if you migrate the whole catalog via a BAR you are covered, it will come with it.

Not sure I'm going to answer your question (if it isn't the case, maybe you can post a screenshot just showing what the issue is?) You are using the prompt functionality of the pivot view, as the name says it acts as a prompt. Just like the dashboard prompt does, where you select a value and this is generally used as…

Good news: soon we will have OAS and on-premises will be just like OAC I would say that by the nature of the changes the import of a BAR does, a restart is to be expected (or all sessions gone as you say at least). And because of that I wouldn't be shocked if doing it while off is required, but at the same time I remember…

Mmmhhhh .... I have a blank right now (damn, I really have to run those commands more often to not forget them!). @Joel Acha & @Christian Berg please feel free to cover my missing memory on this one (probably the answer will come in 7-8h, midnight now here in Europe...)

Hi Adam, The BAR approach is safe and so disconnected from the original server which allows you to deploy that BAR anywhere, including your DR environment. Just need to make sure the weblogic embedded LDAP also has a process taking care to sync it as it isn't included in the BAR. You definitely have a good point on what…

Is 'opatch' the command not found? Make sure it's in your path, I don't think it is by default. Adding %ORACLE_HOME%\OPatch and %ORACLE_HOME%\bin to the PATH generally is enough to make your system able to find and run opatch.

user10473801 wrote:Currently, weblogic has no permissions (couldn't Edit) some folders in "Shared Folders". Also, some folders, he gets an error message whenever trying to access them:"access denied for user to path /shared/..."Could that be solved by checking the "Manage Privileges" page? Nope. Permissions are on every…

As Joel said there isn't a single source for that, the database can only give you the users / groups / role part if you ask nicely. Everything else (Catalog permissions) must be asked to OBIEE directly. As alternative to WLST you can also query the OPSS schema tables. It's less documented and require some "creativity" but…

Do you have the Essbase client installed and the paths configured? That was the cause in 11g, in 12c I don't remember (just because last time I loaded a cube was ages ago) if it's the same or it now goes via the javahost config on the server directly (but if that is the case I expect a message saying the javahost isn't set…

You have to check if your applications roles exist at the source: in Weblogic. There is where you can create / delete them, they aren't generated in the RPD, so you have to check in weblogic what's the status of your users, groups and application roles (and their members). Also check the "manage privileges" page in the…

The system-jazn file also doesn't really work in the same exact way in 12c, and I would avoid replacing it as you could run into more issues than you have. Start checking in Weblogic if your users and application roles are there. Are you really using the embedded LDAP as the only authentication? That one is more a dev…

Having a database object with the daily values will make your work in OBIEE easier as you can either change the joins and granularity of the current one or just add the new one as a new source for your current logical fact table. By telling OBIEE that this new database object can go down to the daily level OBIEE will…

The weekly split being always = 100 sounds like a percentage, so that you can take the weekly budget and make it a daily budget by applying the %. This is something which would work better at the ETL level: you don't have a fixed split anymore, you start with 2 special weeks but potentially you will have 52 exceptions or…

Hi, Those 2 issues you had are solved, right? That's my assumption based on the lack of question mark The name of the RPD doesn't matter anymore, in 12c the RPD itself works in a really different way than 11g, so don't pay attention to the file name but look at the content of things instead.