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…

And what does the logs say? It's the first to do: look at your logs to find the reason why your components aren't starting ...

Hi, Oracle publish an Excel file named "Certification matrix" which provides all these info: http://www.oracle.com/technetwork/middleware/fusion-middleware/documentation/fmw-1221certmatrix-2739738.xlsx In the "Database" sheet you can filter on "Microsoft SQL Server" as "Database Vendor" and you find your answer: Oracle…

yaseennawaz wrote:... in which scenario do we add a column in physical layer to a logical table and in which scenario do we add it to a logical table source? It sounds a bit confusing ... You can't add a column to a logical table source (LTS) as this doesn't mean anything, but when you add a logical column to your logical…

Ok, at least now it's clear what you try to achieve Honestly I have no idea but I guess the answer will be found on the google side. Did you try searching on Google for that? You are probably not the only one looking for it, like for example http://stackoverflow.com/questions/26515033/google-analytics-getting-raw-data-logs…

You will need something a bit more complex for the filter as it must still be a SQL-like condition .... So you can try a filter like : ( '@{Dim}{xxx}' = 'Month' AND DAY_NUM_OF_MONTH = 30 ) OR ( '@{Dim}{xxx}' = 'Quarter' AND DAY_NUM_OF_QUARTER = 90 ) (Just to be sure: this is a filter you want to use in your Criteria tab in…

Plan B: set the format of your column to do the same work ...

<a href="...your URL..." target="_blank">URL <img src="...the path of the little picture..." /></a> Just use a bit of HTML to concatenate around your URL or something like that ...

Hi, You can't really interact with a column selector to know which column your user selected, so not really doable with a column selector. But you can do it with a normal prompt... You create a prompt containing your 3 columns and store the value in a presentation variable, in that way you can use the variable in the…