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…

3320848 wrote:Yes, database connection works when i modify connection pool to use data source: server:port/sid How did you check that in the Admintool? Because if it works on the server once the RPD used it's still the same thing: the server can access your DB while your client maybe can't.

Importing in online is the same exact business as importing in offline mode. Or you wouldn't have a check in button anymore if the work would be done by the server. The only exception (in both online and offline mode) is when you are dealing with a special source requiring the server to make the job, and this happen only…

Ok, but are init blocks still setup correctly? If you open the RPD and check them are they fine? The connection pool selected is still valid? Are they based on the second connection pool of a given database? There are by default strong checks on the init blocks, like not being allowed to use a connection pool also used to…

The repository variables works fine in 12.2.1.2.0, they refresh as expected ... So it's up to you to double check the query you use, the connection pool and make sure everything is fine because you must have a little issue there somewhere.

Christian sarcastic? Really? Him? Never ever ... we must be talking about another Christian Worth to have a look at https://www.youtube.com/watch?v=Gznq3_tDQy4 to get to know him a bit (but I find that one really simple on the sarcasm side, he can make lot better )

Hi, Have a look at OBIEE SampleApp , it has an analysis showing variables. Can't remember if it's session or repository variables (or both probably). It uses the "issue SQL" page to call a NQS function returning the list of variables defined in the RPD. So you can use that way of doing things. Same thing is by calling the…

2791486 wrote:Anyways I found the solutions. Thanks Which is what I said was the only way for you to answer your question as it depends on how your week is calculated ... Just to be sure test your formula with end of year and begin of year dates, because that's where the multiple definition of "week" existing even in an…

So you don't want to do anything which would be the right thing to do like having a proper time dimension with the various time attributes neither expose the needed column in the subject area to let people work by referencing a single column and so having all the same logic but you prefer to have a formula which will end…