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

If you wait a formal / official answer from the "Oracle" side you will need a SR or at least to ask them to move the post in the MOSC space (but even there it isn't as official as a SR).

Hi, What version are you talking about? If it's 12c (that's my guess at least) you must not start things randomly by hand, you have a start.sh and stop.sh script provided which make everything in the right order. And talking about the order if you look at the script it's nodemanager, weblogic admin server, weblogic managed…

I didn't, and when you explained your time dimensions you actually did what I generally avoid: a week can't fit in a month, so for most of the project the time dimension split in 2 alternate hierarchies: year > quarter > month > day and year > week > day . The "week" between month and day often give issues because it just…

What you can do is a really simple test: you have an absolute sequence at the year level, so try an analysis with just the year, a measure and the same measure with AGO year-1. So a super simple one which is supposed to use your absolute column instead of ranking. How does the query looks like? (simpler than that it can't…

Hi, So adding the info you posted in the comments on https://gianniceresa.com/2017/01/sequence-numbers-time-dimensions-new-obiee-12c/ I have this view on your need: you have an AGO at the year level for measures at the week level (so something like sales of this week compared to sales of the same week last year). You set…

Why do you keep it? If you used a column in a CASE statement (another column somewhere) you don't need to keep the original column, the reference is done directly to the right object even if not present itself in the analysis. It also looks a bit weird that "Supplier Name" is shown as measure, I hardly see what kind of…

You have the official documentation of OBIEE which talks about variables and also this one which must return you quite some links ....

Hi, Session variables, that's what they are for as they are user-based. You are welcome.