Sree!!! wrote:Give me some solution. Some solutions? Don't lock your pc, install a different browser, turn 5 times around your desk before to unlock it .... </sarcasm> How To Ask Questions The Smart Way Do you really believe you provided the minimum amount of required information to give you a real answer?

And something called "versioning" ? You are supposed to keep a track of that value. If you don't, seems to be your case, just stop looking right now as it's logically impossible to do what you ask and OBIEE can't do anything about it. If you don't have that "step" value versioned how do you want to have a logic knowing if…

If you really want to change that 9999 try to change it in the RPD. Check the features of your database definition in the Physical layer. There is an entry named MAX_ENTRIES_PER_IN_LIST, if you change the limit there you must be able to get more than 9999. (But again, I would highly suggest to make that with joins instead)

Hi, Did you try to put 11k values in a IN in your DB physical query? Don't you get the same error? More in general .... do you really have to have a query with 11k values in a IN ? That's what joins are used for in SQL ...

Hi, Your answer depends on your data... You must not send the email when your "step" is = 5, you must send the email when "step" = 5 AND previous "step" = 4. So your data and model must link step with time and you must be able to query the current and previous step (based on time and not on step values). That's how you can…

Are you surprised it doesn't work if you want to do things in a random wrong way? There is something called the official OBIEE documentation and it cover in details how to create a custom skin / style. Search into the "Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition" and…

Instead of exiting the dashboard and enter again did you try the "Clear my customization"? Because that's what it's supposed to do ... reset all your changes you did while using the dashboard page. PS: not really sure which one is the question actually in your post....

Yes, that one will accept the setting (and you will not kill your presentation service )

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…