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.

Hi, You don't provide much details (versions, context etc.), so waiting to get more did you try Google? Like the first result is https://wapcobiee.wordpress.com/2015/12/18/obiee-foprocessor-cannot-run-without-a-valid-tmp-directory/ Have a look ... PS: when you ask a question let it marked as such

As Christian said the clean and simplest way is search/replace in the whole catalog, just make sure your search criteria can't be confused with something else which doesn't need to be replaced (like if you want to replace "/shared/Mktg" with "/shared/Marketing" but you also have something named…

3520535 wrote:Looking for some information in logs I didn't find anything of interest. Did you check all the logs? Because it's actually the only way to know why something doesn't start. So maybe there wasn't anything you saw but the information was definitely there. And why are you asking about starting things as root?…

@user652652 : How to close thread and mark answers As you never closed a single one and so you are just using the community forum without giving anything back I thought an "how to" was maybe helpful

user12213580 wrote:The report need to run one after one. Do you really have a dependency between the 3 and so they need to be in a fixed given order or it's more to not send all at once to the printer server? Is it a one-shot thing or you need to execute these 3 reports multiple times maybe at fixed schedule?

Making it short: can you clearly define what/where are your prompts? If it's table view prompted columns you can't expect a different export as that's the view you are about to export.

Hi, You can snowflake the table with countries and start/end of quarters by country with the time dimension (day between start and end). So when you select the country it will automatically join and apply the right filtering on the time dimension based on the country etc.

3427576 wrote:I tried drilling on the bin $0 - $100 where AP Amount value is not matching with the grand total. Did you analyse the situation? Which one is right? Did you check the filters if you don't have a mismatch there explaining why you see different things? Did you compare the queries to see if data is coming from…