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…

For the records: this thread was the exact same thing as Configuration problem of OBIEE 12c in Solaris 11 system after installation. But they it seems the OP has multiple identities here and instead of closing the one without answers he/she deleted the content here ... So terminating this account is maybe a good idea as…

You definitely need to first test what Martin said: if you use the same credentials as OBIEE with SQL Developer, can you access the required tables? You maybe also want to check the "Require fully qualified table names" checkbox in your connection pool as you aren't using it now, and if you are using a user which isn't the…

@Bhavya P : please close the thread and stay on the first one. Configuration problem of OBIEE 12c in Solaris 11 system after installation. No idea if it's you having posted the other one but word by word identical post with same picture from 2 different OTN accounts ...