In addition to the very good filter suggestion you can also create a heading area and include the dashboard prompt values and then using the @{MyPresentationVariableNameHere}{MyDefaultValueHere} syntax to include its value in the heading. Or you can include the SQL view that will show you the full make up of the WHERE…

I would suggest what I have previously on write back, point write back at a view; simple or complex; use write back to effect the update. On the database create a trigger on the view that will handle the update, which now can be as complex as you like and, because OBIEE is very crude for data updates you can also ensure…

Why would you do that? Why wouldn't you have a single subject area that covers all of the countries and then apply a security model that filters this so the users only see the data for the country they should? This would be cheaper to develop, easier to maintain, consistent, scaleable...

Hi, I think you need some training, I would get yourself on a course or if this is not an option at least work your way through the Oracle by Example material. The process is that you edit the repository (rpd) via the admin tool to add the tables in question to the physical layer. You alias said tables to give an…

No, sorry as your format is more complex, but you do need to add the IfNull(......,0) to your original; - IfNull("Service Request Attributes"."Problem Code",0)

Btw, if I am understanding you correctly and you are just after getting a number from between marks, like this '-33434.23-' Then why not just use replace; - replace('-33434.23-','-','') Which in your case is; - replace(IfNull("Service Request Attributes"."Problem Code",0),'-','') Or is your requirement more complex than…

I am not sure exactly what you are trying to achieve, but have you tried adding an IfNull around the value that is text numeric, to default it to a format that your formula will presumably translate to zero?

My example syntax assumes that your years are laid out in columns and the year 2016 is in column 1 and 2015 in column 2. On pivot table calculations you would do it as follows; - To create a calculated item for a dimension column (in your case I am guessing something like Time.Year) Click on the “More options” button for…

Hi, You could create a year ago measure to achieve this, or, if you are set on your pivot table course then you can make calculations by referencing the columns in a newly created calculated column; - “($1 - $2) / $2” Hope this helps? Robert.

You don't say if '2016' is a valid value (does it exist in the underlying data set of the subject area you are filtering?) You also don't say if you only have one dashboard prompt and if so is the 'limited by some other column' on the same dashboard prompt as the value that it is being limited by? Also if it is on the same…

Hi, Standard change control, users develop in environment 'X' (call it pre-dev if you like, whatever!) you QA the environ when they tell you that it is ready to be promoted, they fix any issues you have with it before a final QA and then its content is migrated to your DEV environment from where it is properly tested and…

If the scope is page then you are explicitly telling your other dashboard pages that the prompt does not apply to them, if you want synchronised behaviour then; where there is commonality of filters; use dashboard prompts with dashboard scope then when you move from page to page the reports WILL refresh on change of prompt…

On 2 I have advised clients to do this very thing myself, but curiously on one site ran into a problem where excel exports could handle more data than csv, which given the overhead you mention I did find very odd. Thanks for 3 - I had not heard of this previously! What would your comment be on 5 - get them to use Smart…

I take it your pages are driven by a common dashboard prompt(s) with scope of the prompt of dashboard? If so I would expect your reports to rerun when moving from page to page. You could use javascript to force run on the page, but I tend to avoid that if I can.

Very informant and detailed, many thanks for this. One question, and an issue which every OBIEE developer runs into all too often - you allude to 'running very large volumes of data only to export to excel' - what would be your best practise recommendation on this, given that 'Do not do it' is rarely listened to by the…

I am struggling understanding exactly what you are saying your problem is. Can you kindly clarify are you talking about dashboard prompts? Can you give the exact sequence of events with navigation path to describe exaactly what you are doing, and what happens when you do it?

Though if you want fully formed form style functionality you would be better pointing the user at an Apex form.

Also beware of physical versus logic based measures, logical aggregate first and results for multiplication and division can come out wrong for this reason also.

Note also that in the aggregation options on your fact measures you have first / last. This would not work though if your (say) March was null in Qrtr1 and you wanted February that isn't...

I would recommend writing back to a view, and using the learned gentleman's suggestion of putting a trigger on that to handle your logic, it is like building an API and putting the trigger on the view saves you from a host of convoluted logic to avoid mutating table issues - and you can point the data at multiple tables in…