Rai Qaiser Hussain wrote:Hi @Thomas DoddsI have fixed this problem, thanks for the comments So you can “give back” to the community forum by posting how it has been solved and by closing the thread marking things as required. That’s how a community forum works: never too early to give back and not just take...

What did you do to debug and find where is the issue? Did you look at the logs to check the generated query and understand the reasons of your results there? Did you changed your model/formulas as required based on the analysis of the query?

mrmmickle1 wrote:but it doesn't work as the criteria for a filter... Can you define "doesn't work" ? Do you have an error? Do you just don't have any row back? Before to go into how to find the solution, let's look at your formula, because you are doing your best to overkill it: You take your date, you subtract the…

To extend Christian answer, it isn't OBIEE itself in the background but the web visualization in OBIEE doing that. It's a purely simple CSS property: https://developer.mozilla.org/en-US/docs/Web/CSS/white-space Normal behaviour being that sequences of white space are collapsed, that's what you are seeing right now (looks…

Isn't this a XY problem? (http://xyproblem.info/ ) What is your authentication provider? Doesn't that thing have a proper support of password management? Can't your J2EE app be called as webservice or even just receive a HTTP request and do the job from there? To me it sounds like you "abuse" a bunch of functionality of…

SDD is for a proper cluster (and has been posted as OP asked if cluster didn't have that functionality). If you follow the full doc on how to setup the cluster it must work (if it doesn't you better open a new thread describing your issue), at least many have it up and running without an issue. It just isn't an option for…

Remembering some of your past threads, you always end up having to write your own measures formulas in the front-end. It's like if your RPD is just wrong or modelled for something else than what you look for. All the previous questions and this one is standard normal feature of the model in the RPD. So I struggle to…

Yeah, I posted more as reference but it was clearly not an option. There is (maybe) a thing I read about in 11g (I guess, hoping it wasn't in 10g), an utility which role was exactly what you look for, sync catalogs between 2 separate instances. It was poorly or not documented and there wasn't much about it. I'm trying to…

Hi Alex, I would say the cluster doesn't have any fancy thing for that as it is you supposed to deal with it when you setup the Singleton Data Directory (SDD). https://docs.oracle.com/middleware/12212/biee/BIESG/GUID-60B2E4E4-11AC-444B-A9A6-50DF4CA0F6A0.htm#BIESG9273 PS: hoping I didn't got the thread wrong when quickly…

You really need to have a look at and ask things properly .... "Install a font in OBIEE 12c" is a totally different thing than adding a font in Publisher. If you search in the forum, in MOS and even Google you find many topics covering that aspect. I'm also quite sure it's part of the documentation (it's there!). Never…

OBIEE is a web page, you don't really install fonts in a web page as the browser rendering the page reference fonts available in the system on which it is installed (the browser). But thanks to CSS3 you can load fonts and use them, for that Google is the place where to look as you want to use a custom font in a HTML page,…

Rai Qaiser Hussain wrote:Yes you are right, If such exception raise then I shall return the zero amount.There are two phases of this requirementPhase 1, fullfil the above requirementPhase 2, Add exception for such scenarios Why 2 phases when you can solve it in once? Let's forget phases (if the business gave you the phases…

Rai Qaiser Hussain wrote:I need data of previous month's specific date Your logic is flawed and you didn't provide the real requirement covering these flaws: What is your "previous month's specific date" when you are the 29th or 30th of March? The 29.02 exists (almost) every 4 years, so you could be lucky, but the 30.02…

I would say the subject areas structure is, at some point, the less important. The structure of the business model is way more important as the rule is simple: 1 subject area = 1 business model, 1 business model = N subject areas. So if your business models are structured nicely you can always have huge subject areas or…

Your column is badly defined in the RPD. If the year (I assume it's a year column) doesn't have NULLs, don't define the relative physical column as nullable. The '.00' is maybe because it is defined as a different type than integer?

OBIEE has never been about writing queries. You model things and the tool write queries. The front end is kind of not so important. The RPD is where everything happen. And you need to master SQL to know what kind of queries and models can generate the right queries answering the business needs your model must cover.…

3200605 wrote:I know that anything you do in the front end , a query is generated .... I would disagree on that being a bit pedant. Sure it generate a logical query, but doesn’t mean there is a query sent somewhere else (which is maybe what you mean with your comment). A subquery is a query which is ”sub”, underneath,…

Must admit that Christian has a point: they asked what to do after creating and you answer how to create. By the way: isn’t it on the left? At least every single weblogic I saw it was on “the other right“ Depending on the context (what has been asked before and the role you had the interview for) you could have said that…

And why don't you post your answers as well? So users of the forum can tell you if you answered well or complete what is required ... And is 2) really related to weblogic? You maybe need to provide some context ...

You can't really extend usage tracking itself to add extra pieces of information. You can get the info you look for from the presentation service logs which are more like a webserver kind of logs and there you must have the IP address. You can read about it logging in Presentation Service at…