Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

MDX 101 Question Expand / Collapse
Author
Message
Posted Monday, May 13, 2013 3:37 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, June 14, 2013 1:40 PM
Points: 18, Visits: 63
Anyone know why the following doesnt work?

SELECT
{
[DimX].[DimId].Members,
[DimX].[DimId].currentmember.properties("value" )
} ON ROWS,
[Measures].[Mea_1] ON COLUMNS
FROM Measures

This keeps throwing the following exception:

Query (2, 2) The function expects a tuple set expression for the 2 argument. A string or numeric expression was used.


As an aside, is a way to maximize the performance of querying for member properties?

Thanks in advance
Post #1452344
Posted Tuesday, May 14, 2013 7:52 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, November 21, 2014 4:04 AM
Points: 69, Visits: 336
check this out :

MEMBER MyValue as 'DimX].[DimId].currentmember.properties("value")'
SELECT
{[DimX].[DimId].Members, MyValue} ON ROWS,
[Measures].[Mea_1] ON COLUMNS
FROM MyCube

also check out http://www.mdxsamples.com/ ...on why using properties is slow (see bottom para)






Post #1452589
Posted Tuesday, May 14, 2013 1:55 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, June 14, 2013 1:40 PM
Points: 18, Visits: 63
robinrai3 (5/14/2013)
check this out :

MEMBER MyValue as 'DimX].[DimId].currentmember.properties("value")'
SELECT
{[DimX].[DimId].Members, MyValue} ON ROWS,
[Measures].[Mea_1] ON COLUMNS
FROM MyCube

also check out http://www.mdxsamples.com/ ...on why using properties is slow (see bottom para)


Thanks for responding.

I see how you declare the member before the select. Is it possible to do this inline, after the select?
Post #1452817
Posted Wednesday, May 15, 2013 3:23 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, November 21, 2014 4:04 AM
Points: 69, Visits: 336
hi ,

I've been down the mineshaft on trying to learn mdx coming from a TSQL background ...its been one step foward, 3 back all the time...a real ball ache. Don't know why it does not work inline ...but works when declared as a member. One thing I've found is that doing all the donkey work in using declared sets and members seems to work in situations when you would think in line it would work as well

I'm no guru..but contact me again if you need further help...lets share the knowledge...

Post #1452987
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse