Cube View

[cogman]

Hi all;

We have a cube that runs every night and the cube contains products information.everyday we add many new products to the cube  but at the same time our users create cube views on the cube,so when ever a new product has been added ,the cube view will throw an error.The error says that it cannot find the specified product in the cube.we have manually replace the product in the cube view .Can anyone help how to overcome the situation.

Thanks
CM

[almeids]

I'm not sure I fully understand the issue from your description...the error doesn't sound familiar and when it comes to views and new additions the usual problem is that the new categories just don't show up.  But, in general, if things in a view don't "stick" from one cube build to the next it's because Transformer is generating unique categories when building the cube.  If that's your problem the solution is to make sure your query is supplying a unique value (e.g. product ID) for use as the level Source so that Transformer doesn't have to make it unique and the internal identifier will be the same from one build to the next.
If I'm off track post back with more details...

[cogman]

you are on mark. we don't use any product id's for products.We have to change our cube structure.
Thanks almeids.

[almeids]

You're welcome.