No harm, no foul - surely?

Licensing aside back when I worked for a niche BI consultancy I was certain we included technical content doing what I described, not as a way around licensing, but as a feature that could be validly utilised. In a similar fashion I once had 800 users all using the same login, not to avoid licenses, but to apply my own…

Hi Christian, are you sure on this, I thought there was a way to 'seed' e-mail addresses and security based on another report content, is that not so?

Beat me to it!! - there was another very like this on the boards very recently...

Can you also show your exact syntax, I note that you say date column, do you cast your presentation column also to a date column when passing it in to the call to evaluate?

Have you looked into => https://www.oracle.com/uk/database/database-vault/index.html It sounds like your solution scale has reached the point where the 'cheap' solution is no longer cost effective!

I take it revert to back up is not an option?!

Sure, previously I have used a parallel process to row level security implemented in the business model layer against the physical column via a formula, essentially giving users true or false and putting it through a case statement to the extent of; case when user.col1key = true then underlying.columnHere else 'Redacted'…

Hi, you can do {PresentationVariable}{DefaultValue} and use the default value in a case statement to do the equivalent of value = value when the default value is the result. On sort descending, you did try order by 1 desc on the end of your sql statement?

You would have to set a presentation variable with the first prompt and right logic in the section to use it to filter the results, this could be fiddly if your first prompt allows multiple selections and it is a text type. Not clear on your sort requirement, doesn't sort by 1 desc on your second prompt achieve it?

Sure, I understand, like on the SQL forums when newbie's think that there are one or two golden 'bullets' that will make any code run faster? So I am inferring from your posts that in practise you might make individual analytics not use stitching if you invest sufficient time to understand and discover the various settings…

Hi Christian, no offence intended Christian and mockery not aimed at you, but entirely at Oracle support - I agree entirely with everything you say, it is just I despaired many years ago of getting useful, timely advice via the medium of the Oracle SR, particularly when it comes to development activities. I usually find it…

Or were you serious

See => IBM ERROR: You are not licensed to use this DataDirect Technologies ODBC Driver, when using ClearQuest - United States With this being Linux could it just be that your user does not have the necessary rights on the license file?

And yes, Apex appears on a lot of projects as it has a short learning curve, produces some nice web form functionality and you can point someone relatively junior at it and get reasonable result quickly.

Free! https://apex.oracle.com/en/

Probably a tick box exercise, so if it is on anyone's 'Must Have' list then OBIEE is still in the cut... Why does no one ever have a tick box for 'Quality Well Delivered Functionality'?

Indeed! Was at first surprised by write back in OBIEE, then when I knew more excited by the concept, finally when I understood the execution deeply disappointed... So it goes...

With write back you can make your A, B, C values differ at row level, so facilitating modelling that differs at whatever level of detail you deem appropriate, however, kindly note that write back is not the most flexible tool however, if you really want flexible insert functionality then you might want to also consider…

By the way, I have used the exact method I describe previously to facilitate % and absolute uplift of values, selected by other prompts so you could model sub-sets of the entire budget in this fashion. It works, but as advertised it is what it is, very limited.