MDX - Converting Properties to Members in another dimension

#1

Hello,

This could be an issue of your VB6.dll.
I had an similar problem. Just replace this
dll with an actual version.

Hope this help
Jörg

Quote:

-----Original Message-----
Hey Guys,

I am trying to achieve this:

Basically -
Dimension 2 has a property that contains a Key. I want to
take that
key and convert it into a member in another dimension.

select
{[Measures].[Unit Sales]} on columns,
{StrToMember("[Dimension1].&["+cDbl([Dimension2].&
[1].properties("Test"))+"]")}
on rows
from Sales

But it's giving me an error. Is not able to use cDbl.
Can you help?

Thanks and regards,
Harsh
.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

MDX - Converting Properties to Members in another dimension

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

MDX - Converting Properties to Members in another dimension - 08-20-2003 , 02:41 AM