Is logging enabled on your system? What's the level? Do you see logs at least in the log files?

An out of topic question: Do you really manage to understand OBIEE with the shitty French translation it has? "Niveau de journalisation pour ce locataire" : I hope the "locataire" pay you a good rent ... A "tenant" in that page isn't a "locataire" at all, even if that's the literal translation. Did you never try to use…

I don't see why SSO would be on a different port ... SSO it's on the default port in general, so it looks more like you are having a proxy issue. Your "SSO" url (without the standard port but on port 443 as you are using https) is acting as proxy to OBIEE on it's default port? If it's the case you maybe have some errors on…

What about using a pivot table view? With a pivot it's like the grand total: 1 click

Based on this screenshot you can only say that when you opened the "TDB - préavis" dashboard there were 3 analysis which has been executed ("Nombre de préavis", "Nombre de conteneurs" and "Nombre e préavis par type de transport"). The page like that doesn't really tell you a lot more. To see if the query has been sent to…

Hi, I'm not really sure to understand what your question is about as you talk about dimension first and then about a prompt on a column .... If you have a "Year" column which is used in a prompt and instead of YYYY you want to display YY-YY (so 2017 => 20-17 etc.) then it will be a string, and you can simple cast the year…

Hi, What about a COUNT DISTINCT ? It count the unique values ignoring duplicates etc. It is one of the standard aggregation available in OBIEE.

In "Administration" > "Manage sessions" you can see the logs (assuming nobody thought it was a smart idea to turn off logging to increase performance (could actually be the case and they did that right after turning on the cache ... that would be for @Christian Berg ). Or the log files directly on the server.

John305 wrote:I just want the OBIEE to retrieve the last data when i execute the dashboard Good news: that's just the normal behaviour .... As long as you don't have a filter in your analysis keeping the analysis to an older period (so worth looking for repository variables with scheduled refresh) and that your cache is…

John305 wrote:And if i want to program the automatic email send of the dashboard , do i have to refresh de data manually ? No, as long as cache is set correctly or you add the disable cache flag as posted earlier. I probably missed something really big here ... but when you open the dashboard it will always show you the…

I guess I saw the same thing just few days ago ... Does this one give you some hints? How to navigate to child report based on value in parent report.

user652652 wrote:D1 and D2 are joined to F1 and confirmed dimensions. CONFORMED ! They are conformed dimensions because if they aren't "confirmed" they aren't supposed to exists ... You maybe want to jump back to How to impliment this in OBIEE? Financial year for India is April to March and have a look at the note the…

Hi, First this topic is asked once or twice per week, so you definitely will find a lot by searching in the forum. If you add an action link to navigate to another analysis on your account number column the value is passed automatically. You just need to have that column in the target analysis and use it as filter ("is…

Everything is in the "dashboard layout" file. A simple 2 pages dashboard : <?xml version="1.0" encoding="UTF-8"?><sawd:dashboard xmlns:sawd="com.siebel.analytics.web/dashboard/v1.1" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" style="" fitContent="true"…

Oh ... missed the question when originally posted :s In the front-end there isn't a visual way (the above workaround is one of the cheating), editing the XML of the dashboard layout is also a way which works well ...

Even if I still believe the OP wants something way simpler than what it can sounds .... On a theoretical point of view not sure disabling cache for the analysis will re run the query if reloading the page. There are different kind of cache, and the flag disable the biserver cache, so the query will not hit the biserver…

John305 wrote:i wanna know if there is a solution to automaticaly autorefresh the data in the execution ? What do you mean "automatically autorefresh data in the execution" ? Start by defining what you really look for and then there are chances that one of the few things posted above will work. Are you looking for a way to…

It has never been an option and custom pieces of codes were posted by users for OBIEE 10g, OBIEE 11g and OBIEE 12c around the forum. So when people search for it they generally find these old threads and they just need to find the right version for them. Important to note that as any custom code it can stop working at any…

Hi, Isn't it a simple sum at the total code level minus the actual value if sum ? So code is part of an hierarchy, you use aggregate at the parent level and then subtract the value for the current row.

Hi, Your customers doesn't have any hierarchy structure, it's a flat list with just an ID, a name and a country. And I guess a customer acting as "parent" for a loan can also be the customer acting as "group" or "customer" for another load. That's why you probably don't have an hierarchy in your customer table, because it…