Hi, I would say it isn't doable ... Even in 12c I guess you can't do it.

Hi, dumb question first but ... did you successfully run the RCU to create the schemas first? If you check in that database do you see the various schemas ? (with the prefix you are using)

3487945 wrote:Bearing in mind I have about 40 departments all which I want to return a different code. This definitely make @ORA-01033 comment even more important ! You have a column with the department name and you have around 40 departments. It is not manageable by hand in a "IF" to maintain that in the front-end, you…

The BAR is definitely there (search for all the files being *.bar in the OBIEE install path and you will find it). Like any BAR it will definitely replace things when you import it, depending on the parameter you use with the command it will replace everything (RPD + catalog + security) or just pieces. So up to you to…

Hi, Not sure what "virtualbox" option you are talking about, do you mean "SampleAppLite" or OBIEE Sample App (OBIEE Samples ) ? SampleAppLite is a small subject area with few dimensions and it is based on XML files as source. You can deploy that one easily as it's a BAR available in your OBIEE 12c install. Sample App on…

Did you check the official doc? 1 Planning to Upgrade from Oracle BI 10g to BI 11g In Oracle Business Intelligence 10g, you can define users and groups within a repository file using the Oracle BI Administration tool. In Oracle Business Intelligence 11g, you can no longer define users and groups within a repository. The…

Sorry to ask but ... do you know CSS and Javascript? Because the piece of code you posted in mainly Javascript, and if it find a <td> tag with inside exactly (and only) the text "Value Total" it will hide the parent element (which is going to be the <tr> tag, the row). In theory it will work just fine, except for one…

Hi, First it would be good to have a read of ... I guess you got your answers already yesterday in the other thread: grand total issue in obiee You are not in Excel, things works in a given way, based on attributes and measures and by doing things based on these elements. If you display a subtotal in a view for a given…

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 )