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…

Hi, What kind of query is generated? Did you protect the filter with the OR is NULL ? The best thing is really to look at the generated query to see what happened and you probably easily find out you forgot a piece somewhere ...

Hi Robert, Honestly it's a bit like constants vs variables in programming etc. They 2 kind of variables have different targets. From a conceptual point of view it's obvious that a value which isn't personal (so different value based on the user) is better as a repository variable than a session variable. The downside with…

I guess Windows Server is too strict (being a server) on the environment and things like that. While the client really is focused at a client OS (in the past it was easier as you needed an Oracle Client to import metadata from an Oracle DB, now it's all packaged inside the installer).

And there you get the message in logs your init block has been blacklisted. Didn't you?

I guess we are saying the same thing (just in different words and by quick reading while thinking something else I maybe missed few words in your previous one) The case with a child having multiple parents I see it more when you have multiple tables in your LTS and so you time dimension can have a join which duplicate…

Did you try creating a new fake one to see if it does refresh? Because if it does ... you can invest 5 minutes to drop the existing init blocks and create new ones using the same code and pointing to the same variables. It's maybe enough. (It isn't a solution to the potential bug, just a workaround if you need it)

user9255588 wrote: <script src='/analyticsRes/CustomApp/customjs/listRepVars.js'></script> So I assume you deployed analyticsRes and there inside created a "CustomApp" folder with another folder inside named "customjs" and placed "listRepVars.js" there inside? Do not copy things randomly but first look and try to…

Did you looked at what was written in SampleApp and looked how the code they had in their page and looked at the script itself? The idea of the script is to use javascript to send a request to the "Issue SQL" page you find in "Administration". The query will be the "call NQS..." which return some XML (you can run it by…

Robert Angel wrote:So you can have hierarchies of things that are not really hierarchical Yes and no. Of course you can have weeks as children of months, often it just isn't the case as the main calendar is a real one where weeks cover multiple months. And you can have hierarchies of whatever you want but the hierarchical…