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"…

Did you look on MOS? I guess I remember a bug related to that, where dashboard do not react to prompts anymore or something like that ...

Google how to embed D3js in OBIEE, there are many blog posts covering the topic. Also keep in mind D3.js is already available in your OBIEE 12c as VA uses it, so you don't have to deploy it yourself, just load the one embedded in OBIEE.

I couldn't find a 11g for the test, will need to find one of the old SampleApp to see how was the 11g world

Hi, You need to open the RPD with the Admintool in online or offline mode, on the right side of the screen you will see the physical layer and there you need to edit the connection pool to point to your database (so database connection string or TNS, username and password). If you do that offline you also need to re-upload…

Hi, Something really like what you posted isn't possible out of the box. The easiest would be to use something like D3js or any other JS library to render the chart yourself (and so you have full control over the visualization). Out of the box, if not wrong (I actually never used it in the last .... 10 years ) I guess you…

Don't you have an issue in the keys you set in the map layers? You can maybe concatenate the state and county if you don't have a county unique ID. For example this layer which is part of SampleApp use a concatenation of County and the State abbreviation to make counties "unique".

Oh, so you mean drill strictly on the map? I thought it was a more generic drill (so also on values in tables etc.). From a modelling point of view hierarchies for all the dimensions are needed in the RPD (it doesn't make it mandatory and allow to not have any, but you are just losing a lot of functionalities and also have…

Hi, Did you check the logical level key to make sure it's unique and it clearly identify each counties? It's a bit like if you think at years and months and for the months level in the hierarchy you set as key the month name (like "January"). Every year has a month named "January", so the logical level key isn't unique and…