If you read the error OBIEE return you when using your formula you see that TIMESTAMPDIFF is used to get the difference (in your case in days) between 2 dates, so your "-7" isn't really a date ... Maybe you wanted to use TIMESTAMPADD ? With your current parameters it will work, so if you set a filter like "date" >=…

What Christian said for sure will work. Just one question: it sounds like your organization is good with SQL Server and know how to best tune it, so why did you use an Oracle database for the OBIEE RCU (so the usage tracking as well) ? Pay an Oracle DB license just for that and lacking the DBA-side knowledge to best manage…

Well ... You don't get any interaction anymore, so not just drill down but also master-detail, mouse over etc. You end up with just a bunch of pictures in your dashboard and that's it. (can't remember if all these things were already there in OBIEE 10). Really time to think about an upgrade, OBIEE 12c use HTML5 and so no…

You know people say that size doesn't matter .... Well ... it does

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…