As I said just use some extra logic to create a new field, turning your Jan:Dec into (say) 2:13 and your start period / end period to 0 and 14, job done!!

Not knowing your data structure - but suspect you can use union functionality to sit your start and end figures in the same 'column' as your period movement figures, you probably also need some additional logic to add to give you 'sensible' sorting, maybe using bins or a case statement to put your now non-calendar in the…

You mean you didn't get Oracle's shipment of OP mind reading hardware?! ;-)

Hi, if I understand you correctly then you can use bin functionality on count(emails by whatever your fields are) or filter based equivalent to solve your 20+, 15-19, 10 - 14 etc requirement You can also use a column selector to allow users to add various optional fields, but this may make the logic of the above…

You need to restart your services. (IT fix #1 turn it off, turn it back on)

Have a look at go_url, you can pass as many filters as you need, and please no 'M' word - they will wash your mouth out with soap and water... The link is a little old, but the principal remains the same -> https://gerardnico.com/dat/obiee/obips/url_filter

See this recent post on a similar theme; - Fact is not showing data Against the Dimension..

Hi, to get the answer you want then both fact tables need to share (have conformed) dimensions for all of the dimensions that you use in the analysis. If there is a missing link between any fact to dimension (logical and physical), or its content level is not sufficiently granular for the request you are trying to run,…

Good to meet you Michael, hope it goes well with the bug! Best Regards, Robert.

Sorry did not see your new post before posting. And wow, that is a lot of prompts. cf my previous comment above data combinations - it is possible that any of these other prompts is ALSO reducing the valid data and hence making it impossible for your month to have a valid combination than still exists on the restricted…

One more thought, are you sure that data exists for the region / sub-region selection when the Year and Quarter values are set? i.e. the data is filtered based on the underlying table data combinations? Kindly note also that your default value will clash with this also as it is currently a very small time frame - the last…

Glad I stuck with you, I needed closure on this, even if you did reject my answer first time round ;-) And I agree, the all or nothing on page breaks is massively sub-optimal - maybe one to see if you can get Oracle to recognise it as a bug - especially as 11.1.whatever did not behave like this! One list hint before I go,…

As you present it it would make sense to have; - Year - NO limit values. Quarter, Limit Values by Year Month, Limit Values by Quarter

So, exactly which of View By, Year, Quarter, Month have the 'Limit Values By' ticked and which columns are they 'listening to'? I would expect any that have the values ticked for any of the columns that are currently being changed to revert to 'Select Value' - is this not what is happening? So for the screenshot you showed…

So everytime, for that column, either Year or Quarter are changed, then the prompt will go back to the default position, that is what the 'Limit values by' tickbox does, and then the column in question will be filtered such that only combinations that have data for the Year / Quarter selections will be presented to the end…

What I am asking you is are any of these ticked -> Under the section ->

Yes, but if you create a default table and default view, simple as you can, then I am guessing you do not get the page break - yes? If so, given that the title that you have just added is a default title with no settings changed, then the problem must lie in the combination of table and title and the settings of table…

Okay, can you tell me what this is please (in English) I don't have your environment version to hand and I am weary of google translate for technical content...

Did you also try changing the setting as described? "'Datenanzeige' -> 'Fasten Header mit Inhalt mit Bildauf'"