I have 2 cubes built, 1 for delivered sales data and 1 for written sales data. I have attempted to make the models as identical as possible i.e. I have verified that all categories in both models are all setup the same. I believe this is where the problem might be? Something that the written cube can not translate when attempting to open a report created with the delivered cube prior. I have created many many reports with the delivered cube and was trying to open them with the prompt for cube selected so that I can duplicate the reports except using the written cube. I am getting numerous "na" in many columns and some columns disappear all together. Any suggestions?
dan
dan