Hi all

I am facing some problem with OLAP cube in Excel 2007. When my User use Pivot Groups in Excel 2007 pivot tables, strange thing happen to my cube measures, some are not displayed any more in the folders and some are not displayed in their folder structure.

By this I mean that some of the measures are not visible any more and some are displayed in root instead of their corresponding folder. I did try my best and could not figure out what going on. Can any one please help me?

Thanks in advance

Qazafi

Hi Cutley

First of all thanks for your response. Yes actually it disappear from the Field List and some of them are appear out of the folder structure, which means if my Actual Forecast is in Forecast folder after that it come on the root not in their proper folder and what I found really strange is, I have calculated as well as Fact measure(Database), All the calculated measure stay fine but the Database fact measure has some problem, it might give you some idea what is going behind the scene

thanks in advance

Qazafi

Hi Craig

No I am using Excel 2007 SP1 MSO(12.0.6320.500)

Does this make any difference? Look forward to hear from you

Many Thanks

Qazafi