Hi, I see you "liked" some answers. The board convention is if your question is answered to Mark Correct / Helpful, or close your question using Assumed Answered if you are feeling less generous. Note 'helpful' does not close your question, only Correct or Assumed Answered does. If you need further clarification on the…

This is why I was asking if they could compare Smart View versus OBIEE then you are comparing with an objective benchmark.

Sorry, on re-reading your requirement and don't think the union is what you are asking for. You mean you have columns A,B,C,D and you want to add E,F,G from another subject area? What you are asking for is only possible without changing the rpd if you have conformed dimensions between the two subject areas which allow you…

'I see data that shouldn't show in 12c' - is it possible that in 11g you had applied additional filters at the physical or logical level to limit what was passed through to the reports?

I think you are describing a union all - have a look at the subject area in answers analysis design, the control to add another data set from another subject area is there on the right hand side.

Hi, to paraphrase Gianni you need to cut your problem down. IT is a bit like plumbing. When the water comes through a funny colour you need to trace it back step by step. With admin rights; which is to say no security; if you construct a simple query against pre / post subject area do you get the same data? Then apply…

Or as Thomas rightly says, the best way is to do it in the rpd, creating a specialised measure using equivalent case logic to give you count by white (etc)

Hi, I would look into case (function) or bins for this, you can do; - sum(case when YourDimension.Colour = 'White' then '1' else 0 end) Or the equivalent using Bins. Oracle business intelligence enterprise edition 11g By Sarat: Using Bins in OBIEE

If you have access to your rpd then I would take a look at the campaign metrics in conjunction with the dimension hierarchy for which you are saying that the results are invariant. You will probably find that the measure is associated with certain levels of that hierarchy. You need to do a parallel association with the…

I might be misunderstanding, but don't you just need ranges for this? Section for Workforce - ROWCOUNT('Dummy_report_for_view') == 1 Section for Hire - ROWCOUNT('Dummy_report_for_view') == 2 Section for Exit - (ROWCOUNT('Dummy_report_for_view') > 2 and ROWCOUNT('Dummy_report_for_view') < 13) Section for New Entry -…

If your question is answered could you kindly close it / mark correct / helpful as appropriate.

If your question is answered could you kindly close it / mark correct / helpful as appropriate. If not could you provide detail?

If your question is answered could you kindly close it / mark correct / helpful as appropriate.

If your question is answered could you kindly close it / mark correct / helpful as appropriate.

If your question is answered could you kindly close it / mark correct / helpful as appropriate. If not could you provide detail to clarify your requirement?

Hi, a case statement works on one or more fields in one row. case when 'A' then 1 when 'B' then 2 else 3 end So I do not understand your question; - " if it is possible to create own CASE in this dummy report which will return specific number of rows"? On 'not worry about the future' you can have logic in your case…

No, this is unsupported, there is no document and if you persue this course of action then you invalidate your license agreement and are entirely unsupported.

Agreed, I was addressing his one off tactical issue, not the bigger strategic one, I have implemented exactly what you describe in the past - sometimes via Apex - which provides a simple but effective container to control and log exactly what is being run when...

So the idea is that you use something like trunc(sysdate) < max(last_update_date) or similar logic as a high water mark.