Tell your customer he bought a tool which require to create a bunch of schemas. He doesn't have to question anything: the RCU tool create the schemas, the RCU tool drop the schemas, no human (manual) operation is required inside these schemas. They must not be seen as database schemas but just as a piece of the…

Hi, Isn't what opmnctl already does? opmnctl stopall opmnctl status opmnctl startall You just need to add a piece of logic in between to check if status return everything is down. If you post more about the reason you look to restart opmn components like that it's maybe easier to give you a better answer. You maybe also…

More in general ... You do not have to touch these tables by hand! Never ever if do not know exactly how the scheduler and agents works (and what has a priority over what in defining things). This means you can only "read" content of these tables, and when you look at tables, based on the content and column names it's self…

Hi, Double posting is against the rules of the forum as it's considered impolite. You asked the same exact things Is it possible to use excel Macros in OBIEE 12c RPD and got an answer. Can you please close this thread? PS: a macro has never been a data source, so the answer will hardly change by asking twice

The rule is simple: - 1 or many subject areas use 1 business model (a subject area can't be using 2 or more business models) - a business model using 1 or many sources, same physical source, various physical sources, mixed source (so vertical federation, horizontal federation etc.)

I would more look at a single piece of CSS to be added to that page (to not affect things everywhere).

Hi, For more hints on how to achieve what you are asking it would help if you set a context ... As it's a client-server architecture the concept of "right after report runs" is a bit vague, as you can have none, one or 1258 concurrent users.

Hi, How do you know the issue is OBIEE? Isn't it your smtp server fixing the 5Mb limit? Because if it's on the mail server side you have to talk to your mail server admin as OBIEE can't do anything for you ...

Being you I would not tell the DBA to drop the schemas, as it's not a real DB drop. The drop really need to be done by the RCU tool, as there are things added in other parts of the DB if not wrong (a system registry or whatever it is to list the existing RCU schemas etc.). So do not manipulate it as a simple DB object: RCU…

+1 Martin You have 1 physical table containing 2 dimensions? Why would you design it like that, in a DB you hardly pay based on the number of tables, so just give your 2 dimensions their own tables But it all depends on how this thing is linked to your fact ...

Good that you found yourself the solution So you can you maybe close the thread? For now it's still This question is Not Answered.

That kind of thing need to be set in the RPD. For month columns with months names you set a sorting column to something which can be logically sorted (so 1 to 12 for months for example). If you set the "Sort order column" it will be sorted right everywhere: in prompts, charts etc.

Disorder as in the layout being different? In that case it can be normal, formatting and layout in PDF can be a bit different because ... well ... it's OBIEE

Related to the answer posted above, your issue is that you want to fully display something which is dynamic by nature. Display all of them could be fine if you have 4-5 options, but what if you end up with 150 ? You will have to scroll the whole page just because of the list of options. That's why the prompt comes with…

So you managed to get master-detail to work? Or you managed to fix the dashboard prompt issue not filtering your analysis?

In the analysis you need to add a filter on the column as "is prompted". Because it's a real filter (so the query sent to the source contains a WHERE clause filtering the value, you change the value a new query is executed), while the one you used as example is just a visualization filter (so the query is executed once…

Your screenshot looks like a single analysis with 2 views, right? If it's the case the easiest way is to set a master-detail, so the table view where you have the year prompt will drive the other view on the left (a chart I guess) and change the year directly. If it's 2 analysis or you want it in a dashboard page than you…

If you look at agents you have a condition screen where you can set a condition, and if condition not met then the agent abort (in a way, it doesn't execute and send out anything). So do what Christian said and set it as condition for your agent, and set your agent to run daily: done!

Hi, The result is right, the calculation is doing exactly what you asked: INTEGER / INTEGER = INTEGER Just few hours ago the same topic covered: Remove default floor function while dividing a column by another in OBIEE You need to cast one of the 2 as double, so you have a INTEGER / DOUBLE = DOUBLE

Hi, Aren't you just facing the typical "integer division" ? When dividing or multiplying with integers the result will also be an integer. If your "failure" and "success" are integers you need to cast at least one as double or you will always be doing an integer calculation. If both are already double then use "100.0"…