Our business unit uses an excel templates where they can get real time analysis. They run these reports on a daily basis.
Every time we do any changes in the structure of dimension, they get these error " the item could not be found be found", and they have to recreate these reports which is time consuming and frustrating to them.
Is there a way out to solve these problems? We constantly add and change things in the cube, but it results on them having re-create everything.
any suggestions? Is there anything I can do from excel standpoint?
View Complete Post