StrToTuple very slow compared to StrToMember (even when one member passed to strtotuple)

hi all,

i've got utility dimension dynamically filters measures.

scope([dim benchmark].[benchmark name].members);      ([dim benchmark].[benchmark name].members = strtotuple([dim benchmark].[benchmark name].currentmember.properties("benchmark source member"),constrained));   //   ([dim benchmark].[benchmark name].members = strtomember([dim benchmark].[benchmark name].currentmember.properties("benchmark source member"),constrained));  end scope;  

and data drives dim (need change column name now...)

it working 'ok' until got requirements needed measures have 2 'benchmarks' applied , changed mdx code use strtotuple instead of strtomember

my performance (for single member benchmarks) went 15-18 sec slowest measures 80-90 sec.

anything can speed or convert tuple member when has 1 member?

the thing can think of adding flag view that'll indicate whether source tuple or member, wondering if there's more elegant mdx solution

thanks

---

jakub @ melbourne, australia blog

why not push of 5 calculations directly scope statments in mdxscript? avoid strtoxxx measures entirely.

---

http://darren.gosbell.com - please mark correct answers

SQL Server  >  SQL Server Analysis Services