Hi, Web access is in a way Weblogic ... You will need both access to the AdminServer port and the bi_server1 managed server (by default 9500 and 9502). But yes, in general you will manage to do all you need with that list of access. (You can even remove Essbase if you don't plan to use it for now as well as javahost if you…

https://docs.oracle.com/middleware/1221/biee/BIEMG/datasource.htm#BIEMG4679

Do you have an ODBC driver and an ODBC connection pointing to your sharepoint list? Do you have a JDBC driver? If you don't have any of these ... OBIEE can't really help you: it needs a source it can connect to, and in general "exotic" sources uses ODBC.

The out of the box styles are deployed from ORACLE_HOME/bi/bifoundation/jee/analytics.ear . So you learnt a good lesson: never mess with the default styles, create your own custom style if you want to customize things ! That's the official way to customize the UI in OBIEE, it takes 5-10 minutes and avoid that kind of…

What are you asking exactly? Because you have these files (the original one), so I don't really see what you are asking for ... I can imagine you customized them without following the correct process of a custom style, so go to the source and get them from the EAR from where they come from and do not touch them anymore but…

Open the Selection Steps panel and delete it there.

Your files are named wrong!!! Look at the original files on the webpage, look at the file names in the Deployment Guide and look at your files : yours have the wrong names. Files are named *.001 , *.002, *.003, *.004, *.005 while yours are *.001.zip, *.002.zip etc. Display the real extension of your files in your Windows…

Hi, "Public holiday" already don't mean a lot as your public holiday are different than mine and each place has its own. So you can easily imagine a tool, which job is to do analysis and reports in an agnostic way, has no idea of what a public holiday is. This must come from your data, or of course you can add by hand…

Open the developer toolbar of you browser and analyse the HTML code to find out the source of the spacing. I would say you will always have a space, even if just 1-2 pixels because different tags. So it will require some nice CSS work (and the developer toolbar let you test "live" the CSS you will need to use).

anything with a / will generate an error "division by zero". In general people ask how to make NULL a 0. In this case the "less worse" crossing my mind is really a CASE WHEN "...." = 0 THEN NULL ELSE "...." END.

The good point is that you managed to confirm the issue happen also when running the query directly on the DB side, so in a way it isn't OBIEE's fault (at least this time ). (English below) Beh, purtroppo tutto dipende da come la tabella è fatta, dal database, dai parametri, dalle dimensioni, indici o meno etc. Visto che…

I would definitely prefer the format mask approach, but it requires to first transform the 0 into NULL. Actually a CASE WHEN to make the 0 a NULL and then using the format mask would be the cleaner approach I guess ... (mainly because the column stays a number). I just generally do not like these kind of things as 0 and…

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?