False alarm everyone .. I have since double checked date range settings on the GENERAL tab of CUBE INSTANCES, and found a date discrepancy on a cube there. (Nice clear mind at work on a Monday morning!)
So, "kardo_ax" I think this will be the answer for you too. Go to Administration > Setup > Business analysis > OLAP > Cube Definition Manager. Highlight each Cube in turn, click "Cube Instances" button, and check date range held on the General Tab. Note that when I entered blank opening and closing dates on my database, I was given a range of 1999 > 2003! Not what I have in OLAP parameters at all. Sometimes these basic things are not all that clear in the documentation are they? George --- In Axapta-Knowledge-Village@yahoogroups.com, "george_spl" <george.burr...@...> wrote: > > Greetings everyone > > Has anybody come up with the answer to this question please? > > I've struck the same difficulty.. Have the Year Range correct in the OLAP > parameters but the Pivot Table has not accommodated 2009. > > Many thanks > George > > --- In Axapta-Knowledge-Village@yahoogroups.com, "kardo_ax" <kardo_ax@> wrote: > > > > Hi All, > > > > What setup other than the OLAP Parameters does affect the dates the > > cube will show? I have change the start year and End year but still not > > able to get the year specified although data exists? > > > > start year 2008 > > end year 2009 > > > > 2009 is not showing in the pivot table!!! > > > > One more question, in the pivot table, months are showing as > > numbers.How can we show it as Letters, January,... > > > > thnx > > >