To use Infoprovider restriction at RKF level
This is based on the below discussion, where I amazed with Yasemin options:) First of all thanks to Yasemin for bringing so many options.
Coming back to my question:-
In the mentioned thread, it was suggested, to restrict the Customers count based on Infoproviders.
Suppose I have my DSO with only Materials and another cube with sales details where I have customer and material details along with transaction details. and both are added in Multiprovider.
Now if I want the customers count for those having the materials present in the DSO, how to achieve in BEx query? Will we able to get it by Infoprovider restriction along with material char by someway.
This would be really helpful, if someone can advise on this.
I think this can also be achieved by using i_step = 2. In the routine, get all the materials from your DSOa= and store in the Formula varibale. Then use this formula variable to get your customer as suggested by Yasemin.