COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: EP_explorer on 15 Jan 2010 02:03:48 AM

Title: How I can create in Analyst saved selection based on 2 dimensions automatically
Post by: EP_explorer on 15 Jan 2010 02:03:48 AM
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.

Title: Re: How I can create in Analyst saved selection based on 2 dimensions automatically
Post by: EP_explorer on 15 Jan 2010 02:58:28 AM
Thanks for everybody.

The answer is @DCubeDeselect and @DCubeIncreaseSelect functions