Making it short: if you go in the way of a piece of javascript be ready to spend few weeks on it and end up with something not working. The prompt in OBIEE aren't just simple input HTML object, there is a ton of JS all around, many event handlers etc. @Thomas Dodds gave you the best idea and @Manoj Dixit extended the same…

If the error come right after the login (so you don't see anything) check the "My Account" to see if you aren't pointing to that dashboard which doesn't exist anymore. Also double check PORTALPATH as suggest by Sherry George, even if I can't imagine why the hell you would set a sample dashboard as the default one for your…

Hi, Start by opening the "Odbc driver returned and error" message and get the full message and post that one Things working yesterday and not working today generally means something changed: you or somebody else maybe changed the analysis or something else in the system, yesterday you had a cache effect and didn't see if…

Ok, but ... does the file exist? Why do you still try to access the Sample Lite content if you promoted your own? Is the "Quickstart" your default dashboard? So if you switch to another one problem solved (in "My Account").

Is the file there in that folder? (it's hidden) Do you have permission to open it? Without access to this file (or without it) you dashboard can't be opened... The support document you found is for BIApps, you have an issue on Sample Lite, the default deployed content. Actually you don't even need that content as you are…

Christian already gave you the links, read that and you find answers to all your questions 1) depends on your needs, from none to all, nothing mandatory 2) for year if no gaps you can use it, for others of course you will be required to create extra columns 3) the impact is fairly limited in a normal situation If you don't…

The good new is the formula looks good, the bad news is that your analysis/model is weird As you can see with a normal model and a normal analysis it just works fine. As yours isn't working at all ... there must be something weird... Can you look at the generated query (logical and physical) to find out what's going wrong?

Hi, Your numbers seem to make sense, just in a different way APAC FYW40 = 14,614 USD & RSUM: 14,614 EMEA FYW40 = 41,946 USD & RSUM: 56,560 = 14,614+41,946 So the RSUM is doing the sum by region first and then jumping back to fiscal week. To keep the RSUM inside the region week by week (so each region restart from 0 and the…

Yes, in OBIEE 11g they are written in that file, in OBIEE 12c it's a different story again, but there isn't a log saying when/who/what changed. If required must be done outside OBIEE/Weblogic.

Breath in, breath out ... Feeling better? 3466124 wrote:thank you so much for being the worst support community in the world. it's enough that I have to deal with this shitty technology, but the official oracle help is worth NOTHING. I have been working with Oracle 5 years, and not once, NOT ONCE any of you so called…

Chaitanya wrote:I need some inputs about OBIEE with the following parameters. Please Share your inputs as early as possible.Parameters:1. Data volume handling 2. Performance3. user handing4. Analytical capability 5. Visualization6. Security 1) as good as the infrastructure is as long as the right tool is used for the right…

Not really .... That part could in theory be caught if you enable extra logs at the "web server" level of Weblogic Admin server, but you would only see the page has been loaded, a form posted etc. If you write about your use case it's possible to give you different alternatives ...

Hi, You know that it would help a lot if you post at least what OBIEE you are talking about? There are around 20+ different versions (counting the various bundlepatch). So I assume you have a old OBIEE and now using a really new Firefox (52.2 smells like ESR and not the generic one), so you have many chances things doesn't…

To open the link pointing to a MOS document you need a valid and active Oracle Support subscription. The link point an official Oracle support document and that's part of what you get when paying the support. If you don't have any valid support contract do not expect people to post the content here as it's strictly…

Syed Hamd Salman wrote:...from OBIEE 12c OPSS(Oracle Platform Security Services) are database based and it is still unknown(at least to me) where application role and group assignment are stored in OBIEE 12c onward There are a bunch of tables in one of the schemas created by the RCU, but it's isn't a simple relational…

Can you give it a try by creating the same analysis from scratch again? So do not duplicate it or copy/paste code but start from a new analysis and replicate it (same columns formulas etc.) and try to see there if the views works fine (no need to focus on the look and feel for this test, just the data and formulas and same…

Plan B similar to first option about row numbering: add an aggregation on your "appt time". Something like MAX or MIN depending on the one matching your logic the best. This will return you a single row and not 2 anymore.

Hi, To exclude a row you must be able to identify that row and filter it ... A possible way would be numbering rows by "name" (or "appt key" depending on your business logic) and only keep row number = 1, so all the others will be filtered.

Hi, Would help if you provide enough information ... What version, what's the context, does it works in other cases, does your charts have something special, does it work if you create a new analysis from scratch etc.

Hi, Did you try searching in MOS (My Oracle Support)? They have few matching document covering this error like for example https://support.oracle.com/epmos/faces/DocumentDisplay?id=1966781.1