Thanks, make sense (the "increase factor by" was the mysterious part ). I still believe there is no need to disturb LAG / LEAD. You can get the value of the previous row for your calculation by using MSUM() and some logic. MSUM("your column", 2) - "your column" = the value of the previous row of "your column" You now have…

For that you generally set a count (or count distinct) aggregation on the ID (PK) column of your data. Don't you have an ID or don't you want to use it? You can also try by creating a column as "derived from physical mapping" and in the formula of the column you set 1, you then add an aggreation of SUM on it.

I guess the same but as he blurred a lot I'm not going to guess more and wait for his answer

Christian already gave you a big piece of the answer. I personally wouldn't disturb analytic functions of your DB because 1) you maybe don't have an Oracle database as source and so LEAD/LAG are useless and 2) there are still ways to do it in OBIEE ... What makes one row different from the other? What define the order of…

So that's not a "the OBIEE sample app", it's just OBIEE, nothing to do with the sample app at all. (The default content you can decide to deploy during the configuration is sample app lite, a bunch of reports based on XML sources).

It just sounds strange that joins are "broken" by the different version. I can open a 11.1.1.9 RPD with a 12c Admintool and the joins didn't move at all ... So would be good to make some more checks on the integrity of the source RPD first and, as you say, align dev and prod as it's not acceptable but it also just make no…

That's not normal at all ... What's the context? How do you have mixed versions of RPD and Admintool ?

+10000 Thomas It's crazy the number of people hitting that issue and not seeing their Windows File Explorer is hiding extensions ....

And aren't you expecting them? (they weren't there in the previous versions?) With new versions the checks changes setting new "default rules" and so you can now have a warning for something being fine earlier. Now I don't really see what help you look for as you don't post a single one of the errors. By the way: are they…

Actually the real doc is: Managing Usage Tracking (the other one was during a migration from 11g). To disable it you set ENABLE to NO and it's disabled. But it takes the same time to enable it and configure it properly...

So you just did the SMTP config or also setup / enabled agents? Because you say that "when the agents are removed" it's fine again. What kind of agents? How many? Lot of "run as recipient" ? How many recipients?

As said it's ages since I had a SQL Server in front of me and I also don't have any available to test. So can't really give you detailed steps. Oracle manage it quite simply as the first object underneath the database itself is the schema, so adding multiple schemas is really easy. I really hope SQL Server can also accept…

Ok, UT = Usage Tracking, it's a log collecting all the executed queries. Your RPD doesn't have any UT database or connection pool but apparently UT is enabled and that's why you get errors about UT. Look at Configuring Usage Tracking (no idea which version of OBIEE you use as you didn't posted it, this is for 12c, for…

3247300 wrote:no issues until we configuration the Oracle Delivers Agent functionality. What kind of config you did? The SMTP details? Because I don't really see a link between agents and login issues, it sounds more just a coincidence you first saw the issue after configuring agents ...

John305 wrote:i uploaded my new RPD Again: does your "new RPD" has the UT settings? Are they correct? Does the database / connection pool for UT have the right names and types based on the configuration? Was the system working before you uploaded your "new RPD" ? If yes => fix the UT config in your RPD, if no => make the…

3351099 wrote:I'm not trying to do anything special here - just running the sample app with a totally bog-standard setup. Well ... do you mean the official OBIEE SampleApp (OBIEE Samples ) ? So you imported the VirtualBox image to AWS ? Just that is not really "anything special", so difficult to say if something didn't…

In addition to what Christian said: is UT enabled on your server? As you uploaded a new RPD, did you add in your RPD the right database and connection pool for your UT?

Sorry to ask but ... do you know OBIEE ? All the answers are already above ! You must find a way to server via a webserver your images, adding them into s_blafp isn't a good idea as with the next bundle patch you lose them. There is something that is generally called "analyticsRes", it's a custom deployment in weblogic…

By the way, what's the point of opening 3 identical threads in various spaces? Is their any chance to display the images in the report level in 11.1.1.9.0 Is their any chance to display the images in the report level in OBIEE 11G 11.1.1.9.0 It's an OBIEE question and nothing to do in a EBS or DB forum.

The wizard to import metadata only know a limited number of sources, but you can set many more in the database object itself.