Hi James,

I have also formula like this connecting to DB cube:

=EPMOlapMultiMember("CCS4792508,CCS4792509,CCS4792 534,CCS4792540,CCS4792544,CCS4792537,CCS4792542,CC S4792546,CCS2822501W,CCS4792547,CCS5162501,CCS5162 502,CCS2862501W,CCS4452501W,CCS4450701W,CCS1882501 W,CCS1892501W,CCS3032701W,CCS3092501W","000;002;00 1","[COSTCENTER].[PARENTH1].[CCS4792508]","[COSTCENTER].[PARENTH1].[CCS4792509]","[COSTCENTER].[PARENTH1].[CCS4792534]","[COSTCENTER].[PARENTH1].[CCS4792540]","[COSTCENTER].[PARENTH1].[CCS4792544]","[COSTCENTER].[PARENTH1].[CCS4792537]","[COSTCENTER].[PARENTH1].[CCS4792542]","[COSTCENTER].[PARENTH1].[CCS4792546]","[COSTCENTER].[PARENTH1].[CCS2822501W]","[COSTCENTER].[PARENTH1].[CCS4792547]","[COSTCENTER].[PARENTH1].[CCS5162501]","[COSTCENTER].[PARENTH1].[CCS5162502]","[COSTCENTER].[PARENTH1].[CCS2862501W]","[COSTCENTER].[PARENTH1].[CCS4452501W]","[COSTCENTER].[PARENTH1].[CCS4450701W]","[COSTCENTER].[PARENTH1].[CCS1882501W]","[COSTCENTER].[PARENTH1].[CCS1892501W]","[COSTCENTER].[PARENTH1].[CCS3032701W]","[COSTCENTER].[PARENTH1].[CCS3092501W]")

I tried following:
=EPMOlapMultiMember(C10,"000;002;001",D10)
But I am getting an #value error.
In C10 I put part before "000;002,001"
and in D10 the part after.

Could you advise me please?
Many many thanks in advance,

Tomas.