Hi, Sometimes the simplest solution is the correct one: CURRENT_DATE

But the CSV export is a lot closer to the real data as it bypass the "visual" layout of the analysis and export the raw data returned by the criteria (so including excluded columns etc.). And the OP said everything is fine when exported in Excel (so it's already working apparently, with doesn't make what has been posted…

Sorry but before to change settings in XML files I guess it's better to understand what the real issue is ... The way the OP wrote his thread is more like some columns looks like merged in the middle of the file (=> resulting on garbage values) and not that the file is incomplete or some parts are missing. So I don't…

Hi, NRB wrote:... some of the columns are merging and showing some garbage value... What does the file really contains ? Is the exported file really having an issue or it's when you load it back in Excel that some columns merge etc.? (so more an issue with fields delimiters, quotes etc.)

Hi, No, it's not the same at all, Sample App Lite is just few standard reports. The SampleApp I'm talking about is the full one: http://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html And you can see it online (as long as the link will work) using what Christian posted.

Hi, As you saw there isn't an ootb box plot chart visualization in OBIEE but you can do something close to it with default line/bar chart. Look at this example from SampleApp This example use stacked bars with custom formatting making some parts of the bars white so they are "invisible" and other things like that. You must…

Hi, That's an Oracle DB error: 3174977 wrote:ORA-06576: not a valid function or procedure name at OCI call OCIStmtExecute: call apps.fnd_global.apps_initialize(1159, 20432, 275, 0,-1) Is your report supposed to call that procedure? Is the user connecting to the DB allowed to call that procedure? It's not really OBIEE's…

Hi, Do you mean that the same exact formula give you a better error message on some environments than others? Because that generic message is normal depending on the issue your formula has, but I'm not aware of any configurable level for error messages on formulas (because it's all about syntax and not execution).

Hi, are you saying that the physical SQL send the filter but you get 10'000 back even if the query does return to your BI server 500 ? That's sounds like ... impossible to me ...

Hi, Just put 2-3 exalytics in a cluster and you are fine I will say that first you must define something: 500+ users doesn't mean a lot ... Is it 500+ users in the same time or just 2-3 users in the same time with a total of 500 users maximum? This is probably an important element to define sizing ...

Hi, As you don't say which version of OBIEE it's not possible to point you to the right certification matrix but you can find all of them here: http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html The answer will be there inside based on your OBIEE. I guess I remember that DB 12c is…

Partners ask their employees to get certified because there are fixed numbers of certified people fixed by Oracle to be listed as preferred partner in BI or another domain and things like that. Also some levels of partnership require a minimum number of certified resources and things like that.

user12240205 wrote: Seriously?? Have your ever heard of a software developer getting fired due to a software bug or design flaw??? I have not. I saw that for a consulting company (I was sitting in their same room at the client). The client managed to find a deal with the financial market authorities and avoided the fine…

Daniel Willis wrote:So the next question is.. has anyone got a study guide for Christian's interview catalog? The only working solution I had till now was to get him drunk before the interview But in general I will say that you can do it if you really use the tool for what it is supposed to do (so forget DDR and spend time…

Personally I saw many people with the certification but just not understand at all what the tool is about and how it works and even worse not being able to work at all (I'm not talking about created a table report by drag & drop but modelling things in the RPD etc.). Your point make sense : how to proof your future…

3010666 wrote:... and please suggest how to redesign the RPD model for that particular report ... You know that we have no idea of what kind of report you are talking, right? Did you watch the recording of "No Silver Bullets - OBIEE Performance in the Real World" @rmoff did? Or at least reading the linked slides? There you…

Hi, the 12c way of doing things is done to allow you to import a new BAR at any time and override everything (RPD, catalog, security). So no need to reinstall everything from scratch to deploy your correct BAR file.

Hi, Just buy a bigger server... OK, forgetting the initial joke I will say your first and only activity is to understand exactly what happen when doing the load. What the process is and where the 150 minutes are spent. Only after you can ask yourself how to improve that as there is no secret a option like…

Hi, I'm joining the party a bit late but reading through what has been posted it sounds like a really inefficient way of solving the problem ... @Thomas Dodds suggested in his post to manage this requirement in the database directly, the options wasn't really discussed and you end up in the end asking for LAG/LEAD…

Hi, This isn't an OBIEE issue or related topic. It's the browsers limiting that kind of local access for security reasons. If you google for that you find details on the why and some possible options and workaround. But it's not because the link is in OBIEE: any page with local folder links will not work in Firefox or…