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…

As Christian said the answer is in your logical model. You have a physical snowflake, so depends on how you reduced it to a star in the logical model ...

As a side note 4000 is also the max limit OBIEE accept, so you are playing with limits with quite many things Honestly your query looks like a workaround for something. First it is a DDR which return just a bunch of information, to use to dump a long list of people info is OBIEE really the best tool for the job? The way…

More in detail about the filter: if you set a filter which limits the content of the hierarchy (in your case "Agency B"), the hierarchy will be correctly limited to only the values matching that filter (so you see the parent of Agency B=Pennsylvania, Agency B=Pennsylvania and then only the children of Agency…

Hi, A filter is set in the query to the source, the data will be filtered at the source. "Keep Only" is a selection step, it's just a visual (on screen) filter but the query returned all your data (a kind of pre / post query filter). You better to not play/select/drill/click on the hierarchy while editing an analysis in…

Sorry @Mark T. , it was a totally not serious comment (because it's Saturday) and it's just totally absurd as thing. Scores have always been numbers (actually percentages without the '%' sign), and it's totally dumb that there they are sorted as text. Worth opening a SR asking for a fix I would say (maybe there is always…

Do you see numbers? Not me It's known that right after 0 is 100 and all the others come after

Similar type of information isn't the same type of information ... You generally add in the same logical table sources which complete each other (partitions like current data in a table and historical in another one) or same data at different level of details or the "reduced" snowflake. But otherwise by putting them in the…

If you got what you were looking for you can maybe close the thread and mark as required? Right now it's still This question is Not Answered.