Hi, are you aware that there are various settings that effect this, not just a single simple case of increasing the row limit, there are also limits to the number of row / column combinations for pivot tables etc etc, like; - <CubeMaxRecords>9999999</CubeMaxRecords> < CubeMaxPopulatedCells>999999999</CubeMaxPopulatedCells>…

Hi, More performant would be to get your ETL process to populate all levels with the same parent as previously where they are currently missing, I have done this previously using coalesce as the means to 'push' the values into the gaps. Otherwise I do not believe that there is the means to fulfil your full requirement…

Have you seen => https://www.rittmanmead.com/blog/2015/09/obiee-bi-server-cache-management-strategies/

Have you tried viewing html source through your browser of choice to see if it gives you any clues as to why these are not appearing?

You could build report selector by having a list of values which was displayed the reports and had html content to provide go_url functionality to navigate the user to the report in question. There is no prebuilt for this though, beyond the elements that I have described. Alternatively you can use the folder display that…

I have seen this previously, the issue usually comes down to temporary issues around your AD. Next time you get it I would get your AD administrators to prove that they can see the users in question roles are working across the network, then try the same test through weblogic and query the users and make sure you get the…

Is this helpful => https://gerardnico.com/wiki/dat/obiee/obis/source

Thanks to @Christian Berg and @Gianni Ceresa Curious why this would not be in the synyax palette, but I guess it is not alone in this respect.

Okay, this had passed me by, a recent addition? And is there a To_Date also? I suspect this will also be a godsend to user3507711 in simplifying the syntax (and actually making it work which is always a bonus...)

Hard to read your mind on what you don't understand but here goes; - If you have a Total year measure then it must be based on either an ETL process populating an all year number, which does not seem likely, or a value that is aggregated and has its detail level set to the total level of your time hierarchical dimension.…

The number of times I wish OBIEE had to_date to_timestamp the same as Oracle DB (I know you can use evaluate, but it is not as performant) as converting dates / timestamps is invariably painful...

Did you also try my suggestion of just rebuilding the base query as table presentation and applying your filter group and see if you get the same behaviour when it is 'from scratch'?

And the column selector applies to both, or just the one with the problem?

Yes, simplify until it works, then you know the straw that broke the camels back...

AGO ALL YEARS makes no sense (give me one period before everything?!) Your time period based measures need to reference the base measure. So you need the base measure to use generally, and to use as the basis of your time period. You need a copy, which is pinned to TOTAL_YEAR and so always gives the same number. You can…

Okay, then create a mini dashboard and try your functionality just with the two answers and the single prompt, see if you get the same behaviour. Also, nothing else in your compound views, just the single presentation and a title? (This is my when it gets weird simplify principal, when it stops being weird the last thing…

You are clear, then as I suggested pin a copy (drag / drop or copy it on to the hierarchy level) of your base measure to TOTAL in your time dimension hierarchy and rename it as appropriate, that will do what you describe, and can then be used in conjunction with time series measures, but the time series measures still need…

And there are no other "relationships" that could effect this like master / detail or members in the dashboard prompt area of another table or graph on the same page? (Or hidden prompts on the same page) - I ask this because 'Is Prompted' is easy to use, but frequently 'catches' prompts that you do not want it to, a lot of…

Okay, you have to use the AGO measures with a period that pins them to what they are AGO relative to, BUT, you could solve this from the other direction by creating a FULL YEAR measure by duplicating the base member and pinning it to YEAR or TOTAL level (I am not clear what ALL_YEAR means, if it is full year then the…

Hi, have you tried the clear all from the drop down to see if this resolves the issue (I am not sure what exactly you mean by 'delete date and month', if it is a prompt you would have to pick new values OR use the clear all / revert to defaults or use select all (if on your list of values)? If this does not help can you…