I've created a custom XL VB function using MDX which effectively grabs a value from an MS cube and returns it to the cell. To invoke this you use the funtion as your would any formula and provide appropriate parameters. However, because I work from home across a 56K modem, the formula can take a while to complete (30-60 seconds). This adds up when you use the formula 40-50 times on a sheet.
Does anyone know any techniques for improving performance of this type of connection and/or query? I've used 'Execution Location = 3' in the connection string and am explicitly refering to the members. I see my modem working for most of the execution time so it tells me that either the formula is not working from the server side and/or it is probably pulling more data back to my pc than I really need.
I've pretty much exhausted all of the Microsoft support opitions.
Thanks in advance!
Does anyone know any techniques for improving performance of this type of connection and/or query? I've used 'Execution Location = 3' in the connection string and am explicitly refering to the members. I see my modem working for most of the execution time so it tells me that either the formula is not working from the server side and/or it is probably pulling more data back to my pc than I really need.
I've pretty much exhausted all of the Microsoft support opitions.
Thanks in advance!
