You maybe still have the second init bloc defined? (you forgot to delete it...)

From cache it will load the values of the prompt (all the values) if something is in cache ... Do you maybe set a presentation variable or something?

Challenge the ETL process populating the data: who decided to apply that logic? Is it used somewhere? If the answer is "yes" you have another problem: in your organisation there are 2 different rules for "fiscal date", and this is an issue as the role of OBIEE is to provide a unified enterprise model, so with 2 rules ...…

Hi, Did you set the scope of your prompts? Because what you see is the default behaviour for a prompt with a scope wider than just the page.

So you are saying your time dimension is built in that way (a fiscal year return calendar dates of the previous year) and you want to change that? Well ... the answer you have it: change the time dimension. What is the point in having a fiscal year column if it's not the values you want? It's not OBIEE role to fix data…

Hi, 3174977 wrote:It should retreieve data for 2015 right ? Well, not right ... You must know how you built your time dimension, you must know how you modeled it. So is it right to get 2014 data when selecting a 2015 fiscal year? Yes, just because that's what you created as data and as model. OBIEE will never guess things,…

Hi, Why don't you just merge the 2 queries together and return both variables from a single init block? It's pure SQL, so you can perfectly do it ...

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.