CubeProcessFeeders on multiple cubes

[JamiseBondi]

Hi,

I'm trying to use a single TI process that will cater for one of more cubes that need their feeders to be re-evaluated/reprocessed.
In a simple TI process I have a parameter such as pCube1 and in the prolog I've got
CubeProcessFeeders (pCube1) ;

What I'd like is the ability to specify multiple cubes if necessary - could be 1, 2, 3 or more cubes that the user decides to process feeders on but I'd like to just have the one TI process linked to an action button in the web. I'm trying to use this logic (and yes it is failing but it's the idea I'm trying to put across).

IF( (pCube2<>""), CubeProcessFeeders (pCube2), itemskip) ;
IF( (pCube3<>""), CubeProcessFeeders (pCube3), itemskip) ;
etc... maybe this list will have the ability to cater for say 5 cubes but it must work for 1, 2, 3, 4 or 5 cubes being passed as parameters.

I need to have it skip additional cubes if they aren't specified as parameters in the TI.

Thanks.

[declanr]

Why don't you ignore parameters completely and stick a static 0:1 picklist in a 2d cube containing the }cubes dimension, put that as your datasource (zero suppressed) and if the user stuck the picklist to a 1 it will initiate CubeProcessFeeders.

This way it stops you from having a limit of what you can or can't do in one go because of the number of parameters you specified.

The websheet could/should be based on a subset of elements in the }cubes dimension to highlight only those that have rules/feeders in the first place.

[declanr]

Hi Declan,

Excuse me for PM'ing you, I feel I might be missing something simple here but appreciate your idea. I've done as you suggested: created a 2D cube with the }cubes dimension and a measure dim and have used the Picklist on the measure dim, created the view (zero suppressed) as the datasource in the TI but the question I have is:
What would the Prolog tab include?

CubeProcessFeeders ('new2Dcube') ;

I've tried this and its not working - I'm not managing to pass the cubes that have been selected to the TI function.
I need to know how I would use this new 2D cube with the relevant selections on it as a source to pass to the CubeProcessFeeders function. This is probably a simple oversight on my part but I'm not a TI guru by any means so look forward to your input here, thanks.

JamiseBondi,

Sorry to present your question here but it is always good to keep technical discussions within the domain of the forum so that other users can benefit in the future and it also gives you the benefit that other users may be able to suggest a more suitable solution than I am.

If you have the cube view as your datasource, the first variable should be the }cubes dimension, the second variable should be your measure dimension and the third variable will be the value.
For the sake of making it easy, you can rename them to V1, V2 and Value respectively.

In your data tab you could simply put:

Code: Select all

If ( Value =1 );
       CubeProcessFeeders ( v1 );
EndIf;

You wouldn't really need the IF statement as the zero suppression will take care of that anyway but it doesn't hurt to add in the extra certainty.

[JamiseBondi]

Thanks Declan,

I hear what you're saying about keeping it in the forum.
I tried what you've said - works perfectly, thanks for the suggestion, much appreciated.