Hi, I don't see where is the issue ... Row numbering is done at the query level, a visual reordering in the front end is not supposed to change that. If you make a SQL query with a row number column, export to Excel and sort by another column of your data set does the row numbering column change? Not really ... So it works…

Even without cache you have temporary internal caches that are still there, but it's not a real storage, more like an operational storage (like an app creating tmp files while running etc.). If you schedule an analysis with an agent? The output of the analysis is sent out based on your config. As data flow through OBIEE in…

@Amol Palkar : define your join in the physical layer as Christian showed, if you already have an existing join like columnA = columnB delete it first as you can't change it on the fly (it's because of 2 different kind if join: "physical foreign key" vs "complex join"). In the formula window you see you have lot of…

You can relate it with data but you have to "translate" the kpi OSSM references into data yourself, it's not a simple A = B relation with what is stored in the DB table.

Can you please close the thread? (I guess "assumed answered" is the best matching as the answer is that you asked something else ...)

Good for you Can you mark yours (the one about SR > Oracle > patch) as the answer and close the thread? It will help others with the same issue. For now it's still This question is Not Answered.

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 ...