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

I know, but that's why I added the "That's what you get out of the box: take it or leave it" ... As you said above and I also said: nowhere you find that list in a nicely accessible way. Sessions variable are based on sessions, so to get them all at once it means to code a lot by hand. And here is the question is: why? Why…

That's what you get out of the box: take it or leave it (because of all the reasons already posted above)

Nope, the usage of FILTER USING is the one giving you the problem as it is like hidden to the normal OBIEE logic (so passing values from an analysis to another etc.). So what you currently have is the less worse ... Sure take time to manage etc. But at least you can clearly control every single link.

Gianni Ceresa wrote:For the current active users connected to the system you can look in the Admintool in the Manage > Sessions menu.

On the Oracle sites you probably find only the 11.1.1.7.0 version (or 11.1.1.7.1 maybe), but then the one related to a given bundle patch is inside the bundle patch. If you download and extract the bundle patch you will also find it there inside.

Hi, The way you describe things all I get is that you are bypassing OBIEE completely but now expect OBIEE to solve your problem. Things doesn't happen magically ... Do you want to use a direct database request bypassing everything OBIEE does? Fine, so adapt your query to work based on the name and use that variable instead…