There are VIRTUAL_TABLE_PAGE_SIZE and MAX_SET_OPERATION_BLOCKS both of which were directly limit union (and other virtual table / set based limits)

Thank you also Gianni

Many thanks Christian, and sorry for the gap in replying I was in transit... Just a brief follow on question if you don't mind, given this is undocumented where did you source this, or does the syntax follow some common programming language that is passing me by?

From memory I think you can put a hidden section on a page and navigate to it, but this is sometime back, so I could be wrong? (anyone done this - is my memory playing tricks?!)

Or => Together we can change this!

"to actually read the SR once" - where is the emoticon for 'hurt yourself whilst laughing so hard, but whilst deeply sad inside at the same time' - maybe the german's have a word for this...

Thanks for the vote, and please spread the world, @Gianni Ceresa (and @all other BI movers and shakers) would you too add your vote?

Forgive me if this sounds like canvassing, but I have floated an idea on the boards which could enable our collected voices to be heard by Oracle for issues such as this. As the Unison ads used to say, if you want to be heard speak in Unison. If you find the idea worthy then kindly vote it up, I have no agenda here beyond…

Have you checked the consistency of the keys on the time dimension with this only manifesting there. Is your year dimension key as transparent as 2018 or similar? Are all your chronological keys also set correctly? If you are sure that your DB and physical are both 100% then I go back to use the physical sql generated to…

Your case statement is totally pointless given your where clause, it might be worth trying it without. select variable_value_int from obiee_rpd_variables where variable_name = 'RVAR_PRV_SALES_FISCAL_YEAR' Would achieve the same.

In your position I would be; - 1. Going over the business model with a fine tooth comb, this is standard functionality, there must be something amiss in there - you checked all of the fact / dimension Logical Table Source levels - yes, and you checked all keys - yes, and you checked all joins - yes, that all dimensions in…

And if you access the formula for this measure is it just a physical table column or is there a formula in there? If the latter can you post the formula please?

You don't need a new view for this to work, the modelling I describe purely uses the existing measure in the business model layer, as I said just duplicate your existing measure, rename the copy in the BM and pin it to the dimension level - OBIEE does the rest!

And did you also try what I suggested - in your business model layer pinning a copy of the measure to the Year level in your time hierarchy to make an invariant version 'Year Total' which can be used to keep the same value when the months change?

If you put your prompt into a presentation variable called PromptYear FILTER("Cumulative EUR last year" USING "D1 Time"."Month"='201712') FILTER("Cumulative EUR last year" USING "D1 Time"."Year"= '@{PromptYear}{2017}') Note you originally said not changing for the year, otherwise; - FILTER("Cumulative EUR last year" USING…

You don't need "dynamical values" (is that a thing?!) on this at all, you just need the base measure sum by year, or base measure filter by year. If this is not working then check into your base measure and ensure that it is base and there is not additional logic happening in the rpd. If there is additional logic then…

Hi, if 'Eur This Month' is your base level (lowest level of detail against the time dimension) then sum 'Eur This Month' (full syntax, don't know your folder names!) group by Year (ditto) as a formula should work. Otherwise if there is a straight 'Eur' at detail level use that as the basis instead. The filter version…

Okay for my sum by suggestion; - https://stackoverflow.com/questions/27066406/summing-by-column For using filter; - https://docs.oracle.com/en/cloud/paas/bi-cloud/bilug/editing-formulas-or-calculated-measures.html#GUID-39AE06D2-FB14-46C… I would have liked to give you a fuller answer, but to do so I need you to give me…

Sure, but can you explain the function behind the filter headings at the top of the screenshot that you show, i.e. Cumulative EUR this Year Eur This Month Cumulative EUR last year Do these drive filters and if so how are the filters "caught", do they apply in the traditional way, a filter that reduces the total data of the…

And you have checked the Logical table source levels are correct fact to dimension? i.e. Expand the fact / dimension in the business model layer, see the table source, click on it, examine the detail level, make sure the levels are set as appropriate, which in most cases is detail level, assuming no aggregate fact /…