Hi, Sure you can .... It will require a CASE WHEN in the formula of the column, that's how you can replace the 0. So something like CASE WHEN <your thing> = 0 THEN '-' ELSE <your thing> END Assuming you really talk about existing 0. If it's what you display when there is no value it is set in the format of the column (you…

Hi, Isn't this something you have to ask the weblogic people for? The page you post is the Weblogic Administration console, even if it's for the "bi_server1" managed server it's still on the weblogic side, so not something coming from OBIEE.

Did you see the "is null" filter in the query or OBIEE thought to be smarter and removed it? If you change the direction of the join (right outer or even full outer) it will work in this case, but this will also change the business meaning. Do you have other usage of this outer join you need to keep or that kind of…

Hi Dilek, What you saw it perfectly normal, OBIEE uses the joins in the physical layer to perform the outer join. Filters aren't join conditions, but definitely WHERE conditions. Can't you try to workaround the issue by adding another piece of filter to generate a " OR end.e_donem IS NULL" in your analysis?

Sunny26 wrote:In Internet Explorer 9 it is working fine, but for Internet Explorer 11 it is not working. So you are saying nothing changed other than the browser? Do you still have both IE9 and IE11 available now and tested now with both? (and not that you used IE9 few months ago and now you are on IE11 but maybe something…

Just a reminder: BI Publisher exists and can actually perform that kind of exports better.

Hi, When you work online and import the database tables with the wizard etc. you are working with the setting on your laptop/workstation. If you use a connection based on a tns name (as apparently it is the case), you use your local definition of TNS names. The server probably doesn't know what these TNS are, where they…

Data types matter! A INT in OBIEE is a 32 bits signed integer, which means the maximum positive value is 2,147,483,647. Your number is definitely bigger than that, so don't even try to convert it to INT. A prompt doesn't have a format mask, it display the default format mask based on type and a double has a decimal…

Can't be installed on top of 12.2.1.2.0.170418 : conflict with the 12.2.1.2.0.170418 bundle patch. There is a .so file conflicting, but because it's a .so => binary I couldn't look more into things to do a "manual" merge.

The "N" in front is to tell SQL Server (or client) to take the following text as unicode (required for chinese and similar languages). When OBIEE send the query to SQL Server without the "N" the chinese text is treated as varchar (non-unicode) and result into ??. I guess I saw a note on MOS about how to handle that, just…

Just for the records: 12.2.1.2.0.170418 patch doesn't fix or change anything: 1 detail = works, 2 details = not working (on OL 7.3) And of course the patch posted above by @DanPryke is now conflicting with the 12.2.1.2.0.170418 bundle patch ... Thanks Oracle

Good news (ok, not really but ...): 12.2.1.2 doesn't work with 2 details and is ok with a single one, same result as yours. MOS doesn't seem to have a note about this issue, so not sure if it's fixed maybe in the 170418 patch. (I have en environment with that one, just can't start it right now because lack of RAM )

Hi, What you try to do is supposed to work and works fine on a 12.2.2.2.0 (OAC based). Can't exclude if it isn't a bug or something on your version (12.2.1.2.0), will need to spin up an instance and gives it a try there as well ...

Hi, You can do that in a kind of simple way (at least the code already exists and you only need to put things together). You need 2 things: all the content of your catalog and Usage Tracking. UT must already be in place (I hope you enabled and configured it when you setup OBIEE), if not ... enable it now and wait 6 more…

Where does the requirement come from? I bet on an Excel file, right? Just keep in mind OBIEE isn't Excel, things are done based on models and playing with attributes (dimensions) and measures (facts).

You aren't missing anything ... technically speaking ... From a technical point of view there isn't really a huge issue making it impossible to align the features of the tool in all the versions (cloud & on-prem). There is some extra work for testing: cloud is on a highly controlled environment, they manage every single…

Did you already looked once at what your browser does when you load a dashboard page? Did you look at what happen when you change the value in a prompt which is going to reload analysis in the page with the new filter? If you didn't it's maybe time to give it a try ... Do not think OBIEE is a little simple webpage with…

Mark T. wrote:We are having trouble imagining any technical reason that this feature would have been included in the cloud version but not in the on-prem version. It seems to us that VA is VA, no matter whether its host computer is in Data Center "A" and accessed remotely in the Cloud, or is in Data Center "B" down the…

Hi, OBIEE never required Java in the browser. It was Flash first (10g & 11g) and now full HTML5 (from 11.1.1.9 as option, 12c by default), so no plugin anymore (Flash being unsafe and more and more disabled by default). So no issue

Hi, Yes, totally possible: "2.50 Scorecards" is a dashboard "Smart Watchlist" is a page