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…

Which is the last option I posted: it will depend on the underneath model, on which we have no idea.

Sorry but, did you read the link which has been posted in the other thread and this one on how to deploy a folder in Weblogic? If you did you can't possibly try to enter https://.../analytics/bi/domain/fmw/user_projects/domains/bi in your browser and hope to see something. Weblogic is an application server, it isn't just…

You create formula giving the total amount on the left, you subtract a formula giving you the total amount on the right and you have your number in a cell. You can then use a narrative view to display it the way you prefer. Grand total in pivot views are automatically calculated by OBIEE aggregating at the required level…