So not a supported OS, a desktop OS instead of a server OS, not setting an address (static) to the fake adapter which is supposed to be the only way for OBIEE to have a fixed matching hostname/ip and restarting your laptop probably getting a new IP from the DHCP ... There were little chance (just to not say no chance at…

Hi Dilek, The certification matrix for browsers gives your the minimum version (the + in "31+" for example means version 31 or above, so 32 etc.). Of course the problem is that the certification matrix is aware of browser existing when the matrix is produced, they can't be aware of the version of browser released 2 years…

Hi, A solution? Sure .... find out what happen ! https://speakerdeck.com/rmoff/still-no-silver-bullets-obiee-12c-performance-in-the-real-world Look at logs, analyse the generated query, analyse where the time is spent: is it in the DB? is it somewhere else? Based on these information you will probably directly find how to…

I do not have a 12.2.1.1.0 available right now but it works fine (as expected) in 12.2.1.2.0. I assume that by "contraint on" you mean "limits values by" in the prompt column. If the "limits values by" are set correctly and only on the 3 (product, color and month) with a dependency on the respective column (type, brand,…

Inside the SampleApp you have a dashboard with all the reports about lifecycle managements and other management things, and in each page you find details of the required scripts. The scripts are inside the SampleApp itself.

Hi, You mean open it in the Admin tool or open as in "deploy that RPD on the server" ? I would say no: with the password the file doesn't open in any of these places. Even the various scripts converting the RPD to XML require the password first.

user12116294 wrote:I am using obiee 12c version.I have multiple prompt in a single dashboard and multiple prompt coming from different different dimension. What version exactly? (full version & patch number if applicable as there are differences between each one) And still didn't understand how your 6 prompts you described…

Hi, What version of OBIEE are you talking about? Are all the fields in a single prompt or you have multiple prompts in the same dashboard page?

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?