Christian, are you saying you needs points?

Well, at least they have an opinion, not really fixed and changing over time but an opinion At some point they will have to limit the 17+, mainly if there is a major change in FF coming, but good for you it's working with FF 38 (it's anyway time to start thinking at what your upgrade plans are).

Or also simply open the Job Manager (installed with the Admintool) as it's uses the tables Christian is referring to... Not a dashboard in the way OBIEE does it but a tool at least

Hi, Maybe because browsers are now released every few weeks and version is incremented and so it is now impossible to identify a browser main version (like let's say IE11 including none or tons of patch but still named IE11). And I doubt Oracle will update all their certification matrix every single time Firefox or Chrome…

So can you close the thread? Right now it is still This question is Not Answered.

The name of that checkbox is wrong as (we all agree on that) you are not retrieving NULLs values but inexistant values. As I said in a table/pivot you can display 0 by setting a custom format mask on the value, on the chart I suspect it has no effect at all (didn't test it, so give it a try ....). The only other option to…

IFNULL will not work because the data is not null, it doesn't exist (and it's different). So the formula with IFNULL is not evaluated for "nulls" values (the physical query retrieve the dimensions attributes in a different query than the fact so dimensionality attributes aren't restricted by the facts). On the screen in a…

user13326079 wrote:Can I expect a response/doc/relevant information regarding the issue. Sure you can expect one, assuming you asked something providing all the details to answer (for example you forgot to say which version you are using ... it's the most basic information you must always include in all the questions).…

That's the best thing to have (in theory) a feedback from them. Can you now close the thread? For now it's still This question is Not Answered.

3025352 wrote: Here are the screenshots! I am using the CASE in a column filter Are you really using that in a filter? You know what a filter is, right? In SQL a filter is a condition supposed to be resolved into TRUE or FALSE to include or exclude results from the resultset ... So just your CASE WHEN can't be a filter !!!…

Can you try by adding "DATE" ? CASE WHEN "Agreement Sent Date"."Date" <> DATE'1969-12-12' THEN "Agreement Sent Date"."Date" END

Same issue on SampleApp 511, did you try to contact MOS for that to see if it's a known issue and if not to report it? Didn't check if the last bundlepatch they released some days ago change something ...

1969 or 12-12-1969? Because you talk about "Agreement Sent Date"."Date" is 1969 but then check only for the 12.12.1969 (so you are missing the other 364 days of 1969 ....). Second thing: why CAST(null as timestamp) ? Null is just null, so simply return NULL directly and don't lose time trying to cast something that can't…

Thanks Christian Shubham, Just to be clear: you want to have a variable list of values in the prompt based on the role or it's only the default selected value that must change but the list of values is always the same? (it changed between your first post and the last one ...)

And you can also open a ticket with Oracle for that so maybe you will have access (as tester) to an earlier patch before to be publicly available in a BP.

Hi Ali, The official tutorial cover the basic basic things, but the tool is quite big and is extremely powerful in generating queries, so you will never have a tutorial covering all the topics. I would say that for all these things you better start following the main blogs about OBIEE and ideally attend events with a BI…

Well, the error is different at least, already a good step All your rows have a value for Candidate UDF Value 01 ? All the values are a valid date ? Don't you have Nulls values there somewhere ? If one is NULL you must manage it.

Sorry but if you posted that your date is in the format "yyyy-mm-dd" why are you trying to use a "mm/dd/yyyy" format? Cesar did 2 examples, one as the format of date you posted (yyyy-mm-dd) and it works fine. So what does your date really look like? Maybe double check that part as you aren't really sure (I don't think you…

It depends on the format of your date but try with TO_DATETIME('your value', 'the date format')

So you want a DISTINCT C1, C2 ? Because I don't really see what you try to have with a GROUP BY but no aggregation ...