ISSUE:Accessing OLAP cube with dynamic calculated members from Excel Pivot table


I had built a cube with a calculated member which is derived by making use of a custom vb function call which passes two parameters to sql server procedure and reyrns the value.Function call is working fine and it returns correct values and i can browse the data in Cube Editor.

But when trying to access the same from Excel pivot table,returns 0 for the above mentioned calculated member!
Can anyone help me out to solve this issue.Your kind help will be highly appreciated..!


Regards
Jophy