This setting (PurgeInstDays) is for the OBISCH config file, so don't even try to add that to the OBIPS config file or your Presentation service will not start anymore. The config file contains only the required tags and not all the existing ones. In this case it must go into <scheduler> and into <ServerInstance> and there…

As I said I was browsing around (I installed it already) it for some time and in DV you don't have at all the data sources you have in DVD, it's still the old list. For the visuals as well the list is the old one.

As @Philipp Kaufmann-Oracle said there are no new features in DV, for sure they don't mirror DVD for that (so the new sources etc. aren't there). For OBIEE same business, the doc is really explicit: There are no new features in this release. Seems to be mainly a bugfix release (after browser around it a bit I couldn't see…

Saurav Singh chandel wrote:When I checked the query it was " Datecolumn between DATE '1974-10-20' and DATE '1950-09-20' " But query is giving no results even i have data between dates. Well, you maybe have data between September 1950 and October 1974, but from a logical point of view no results is right ! BETWEEN…

mac2 wrote:It just started today. Did you patch or change something on your OBIEE server today? Or did you update Firefox to version 49 today? If it's the second then it's Firefox who decided to do something in a different way, if you can't manage to set the color back to something else log a SR and in a future patch, as…

Hi, Why are you surprised it doesn't work? In general when you don't do things in the way they are supposed to be done it doesn't work (if it does it's just by mistake). So why not have a look at the doc? It's crazy how good they wrote things and covered all the steps for a custom style ... Customizing the Oracle BI Web…

I will say that even if in 11g the BI server was doing versioning it's always up to you, as developer or BI admin, to manage versioning of your own code independently. So already with 11g you were supposed to have your own versioning and this same versioning will avoid you issues in 12c as you have all your versions with…

Not really .... Your details analysis contains columns from A, B, C, so the query will go on table A, B, C. The only way to display something in an analysis without querying the DB for it is to display the value of a variable. But your use case don't use variables, so no.

An action link can send the context of the analysis (values of columns). A view selector isn't part of what an action link can send. Your view selector isn't a value of the OBIEE model (not a column / value of your presentation layer), nor it is a variable. It's a pure UI object allowing you to display 2 (or more)…

Does that hierarchy have a grand total level?

You didn't like the other answer? Well, let me remind you what it was ... Stop thinking in terms of rows ... If you really want to continue to think in rows ask somebody to export you the data in Excel and continue doing your calculations there.

So, if you really want to customize the HTTP 500 page weblogic is serving you when the presentation service is down you will need to search in the weblogic documentation how to do that. Or, as Christian said, if in front you have a proxy (Apache, nginx etc.) it's where you have to look as any proxy can show a custom page…

Hi, As far as I remember into the XML of the agent itself you have the info. It probably doesn't help you ... but not sure you find it somewhere else. So for sure in the XML of the agent itself.

+1 Thomas And just a detail: that's not really a measure (how do you plan to aggregate a column having only "Open" or "Closed" as value?) but an attribute. So if you want to make things in the right way it must not be in your logical fact table but in a logical table acting as dimension ...

If your BI Server is down no need to try to upload or download the RPD, the component you want to talk with is down ... As the message you got said you have to check the logs, there is no secret answer like "do that and done", depend on what the issue is.

You don't the account to connect to the server (SSH or remote desktop) that we got it. But do you have an admin account in OBIEE ? By default it's like the weblogic account for example. Because, as Christian said, don't expect a magical way with no user or password (be realist: it's an enterprise tool, not a notepad file !)

Did you try setting the "sort order column" in the logical column representing that level of your hierarchy? Because for a random sort like the one you want there aren't miracles, you have to provide a column which does the sorting ...

First of all: what version of OBIEE are you talking about? 10g, 11g (which one? .5, .6, .7, .9), 12c? Reading your question in a different way I wouldn't say "No" directly ... I guess you actually ask if there is a way without having connect to the server remotely, like via SSH if linux or Remote Desktop if Windows etc.…

That's what a sandbox is done for ... You can't really develop offline and after 2 months of changes deploy your RPD and hope it works .... As a developer you would be more productive with a sandbox where you can develop and test your changed as often as you need, and then you would ideally have a set of regression tests…

Hi, First you could have done a search on here as the question as been asked and answered few times already. The short answer is that you don't have any Gantt chart out of the box in OBIEE. The longer answer is that you have 2 options: 1) you can cheat a bit and generate a kind of Gantt by using a stacked bar chart, have a…