Hi, thanks for your input, a college spotted my problem, I had the sub-query answer filter protected, removing this one check box and all is well. For the record the two analyses were based on different subject areas, but the prompted dimension members are shared / common / conformed. Robert.

The error that I receive is 'Ago Function may not be used when the time dimension source is horizontally partioned' Functionally I have no need for a partioned time dimension, but how can I make it work with a single time dimension but everything else partioned, from my experiments with fragmentation even though all I am…

The fragmentation is based on the calendar dimension year, using a repository variable as the comparator; thus; - Year >= VALUE_OF(CURRENT_YEAR) Year < VALUE_OF(CURRENT_YEAR) This same condition is referenced on the fragmentation content of ALL FACTs and DIMs All have combined ticked.

Hello Gianni, thanks for the suggestion on remapping with an alternative calendar join, this might be too big an ask with the scale of the repository, but at least I have options to present. On your comment that AGO does work with fragmentation can you point me at a reference source which details the exact requirement for…