Hi, your syntax is a mixture of dates and timestamps, this will not work, you need to be consistent. Always explicitly cast rather than relying on implicit conversions, implicit will 'bite you'. So where you have dates currently cast them to timestamp instead, you will have to have the right default formats 00:00:00 and…

Okay, but again - what out of the current functionality is 'wrong' for you, then we can stand more chance of ascertaining if we can get to your requirement?

Hi, assuming you have access to the rpd my preferred method for your requirement would be to; - Use AGO functionality to build your new measures for last period as a logical function Create a new logical measure that uses your two time series measures as the basis of your X - Y calculation If I have not described your…

With this being evaluate could the differences be on the underlying databases, can you check a use of a function that is available to all on the DB like "nvl" (assuming it is Oracle DB) just to double check that the problem is evaluate and not rights on the function that you are trying to call on the DB.

Hi, you could create an action link to navigate to an alternatively scaled subset of the data, with the target having an 'Is Prompted' to catch the key click and filter accordingly. You can use column or view selectors to emulate similar, and / or use this in conjunction with a slider selector or even drive the graph…

Sure, and the UK voted for Brexit and the Americans for Trump - mass approval does not validate a bad idea.

So stupid formed a group, what else is new?!

I have alluded to this issue in previous posts on the forum where I expressed reservations about using jscript to deliver user requirements. My reasons for this as I believe leaving the user with a solution that can be supported by those with core OBIEE skills is preferable to building a solution which is essentially not…

If it looks like a duck, walks like a duck and quacks like a duck it may just be an over-engineered swan...

Hi Charles, beware, all of OBIA uses the "Core" business model, Oracle went for a single business model that uses conformed dimensions to the max, BUT, there is many a 'fudge' in here as Gianni is alluding to, for me (others may disagree), Oracle should have created business models only for the dimensions / facts that will…

Hi, you can do this with standard functionality using the column selectors or view selectors, depending on your exact requirement.

Thanks, it is refreshing to meet a newbie on the forums who explains their problem well, assigns correct answers and expresses thanks. Sometimes I have patiently provided considerable detail and a user has done none of the above and frankly it makes you disinclined to help the user again. So thank you!

From your SQL I suspect that your only hope on this is either create a DB view that reflects the joins you want or an opaque view equivalent. By its very nature it is going to be massively less performant than the original. Could you "emulate" pulling in the nulls using a union report?

What you need instead is someone to set you up a current month rpd variable, so you can save your own version of the report using that variable as the basis of the filter, or create equivalent using standard OBIEE functions.

Hi, if you have a structure (physical) that is thus; - Fact => Dimension => Dimension Then in the business model you should flatten this to Fact => Dimension With the physical joins on dimension giving you an outer join to the 2nd table. However, irrespective of however many outer joins you have, if you have filters on the…

Mea maxima culpa! I stand corrected. The document is a little sparse on the detail, do you have to populate every role for this, or is it group level security in terms of OBIEE function based security?

Hi, you need to define "short" before anyone can answer that. if 'short' is a user intelligent abbreviation of the current content then you have to have a manual exercise to explicitly populate exactly what you need in the DB, then you need to model the column through OBIEE if it is not already there, or use a lookup table…

Initialization blocks is only partial security, typically used for row level filters specific to end users, it does not handle initial user login and general OBIEE function based security. On the rest see => https://docs.oracle.com/cd/E28280_01/bi.1111/e10543/legacy.htm#BIESC307

On 1 - that is a 'no', you do not have to delete anything, just change the order of precedence as previously described, BUT, there is no 'magic' switch that will lift everyone in your LDAP and convert them all into native users, you would have to configure them yourself to achieve this. On 2- there is no external database…

And I don't have a crystal ball to see the syntax of what you tried...