If you are unable to create a new account, please email support@bspsoftware.com

 

How I can create in Analyst saved selection based on 2 dimensions automatically

Started by EP_explorer, 15 Jan 2010 02:03:48 AM

Previous topic - Next topic

EP_explorer

A problem:
I have a big cube which I want to update. It makes sence to update it in cycle which are based on the one dimension. At first we calculate data in the first element of the dimension, next I use the calculated data of the first element in calculations of the second element of dimension and so on.

I use @DCubeCreateDSels, @DCubeOpenNamedSel and @DCubeUpdate to create the selection with one element of the first dimension, open D-cube with the selection and Update it. Everything works nicely.

Thus we have a selection which contains one element of the first dimension and all elements of other dimensions.

But I also want to restrict Selection by a set of elements from the second dimension (because it could contain data not in all elements).

Can anybody says how can I do it. Because how I can understand @DCubeCreateDSels works only with one dimension.

Thanks.


EP_explorer

Thanks for everybody.

The answer is @DCubeDeselect and @DCubeIncreaseSelect functions