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…

If it's really the business model then the OP maybe did a full drag&drop of the physical layer to the BMM layer and ignored almost all the rules of OBIEE. If it's the case the easiest would be delete the full model and start again paying attention to what is done.

3512682 wrote:It is also showing the prompts in excel along with the analysis result. Not possible ! Or you are not telling us the full story .... Where are the prompts in my export? Nowhere ...

Why don't you display the "export" link below the analysis you want your users to export? That "export" link is local to the analysis, so the result is just the analysis. As Christian said if you use the "export page" you get, as expected, the full page.

Why not to start from the beginning? 3251920 wrote:using "Where in" clause will return with the following error ORA-01795: maximum number of expressions in a list is 1000 error Of course the best solution would be a join with the tables generating the IN values, in your case you don't have that. Another solution is to use…