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

ALLMEMBER function error Expand / Collapse
Author
Message
Posted Friday, September 2, 2011 2:37 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, August 11, 2014 4:17 PM
Points: 39, Visits: 245
Hello,

I have a query statement below but whenever I run it I get an error: The ALLMEMBERS function expects a hierarchy expression for the argument. A member expression was used.

SELECT
[Measures].[Time Entry Hours] ON COLUMNS ,
[Time].[day].[Fiscal Year].ALLMEMBERS ON ROWS
FROM
[TestCube]

I have set the AttributeHierarchyEnabled to True. Am I missing anything on my query?

thanks!
Post #1169084
Posted Saturday, September 3, 2011 2:48 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 1:01 PM
Points: 416, Visits: 531
quasar_phoenicis (9/2/2011)

[Time].[day].[Fiscal Year].ALLMEMBERS ON ROWS


this looks wrong...maybe its just the naming of your objects...

is your dimension name "time"?
is your user hierarchy name "day"?
is "Fiscal Year" a level in your user hierarchy?
Post #1169656
Posted Monday, September 5, 2011 12:07 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, August 11, 2014 4:17 PM
Points: 39, Visits: 245
sorry bout that, the query is below:

select
[Measures].[Time Entry Hours] ON COLUMNS ,
[time].[fiscal trans date].allmembers on rows
from [sa]

the time is the dimension and the hierarchy is the fiscal trans date. the next level would be the fiscal year but even if i add it to the query i still get the same error:

Query (3, 1) The ALLMEMBERS function expects a hierarchy expression for the argument. A member expression was used.

i tried the query using a different dimension but it ran successfully. i just don't know why for the time dimension it won't.

please help as i am not that good in mdx...=(
Post #1169842
Posted Monday, September 5, 2011 4:00 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, August 11, 2014 4:17 PM
Points: 39, Visits: 245
i think i know the culprit but i wanna make sure first...

in the dimension table there's an attribute named Fiscal Year and in the hierarchy there's also Fiscal Year.

Is this possible?
Post #1169895
Posted Friday, October 25, 2013 1:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 10, 2014 12:13 PM
Points: 3, Visits: 16
select
{[Measures].[Time Entry Hours]} ON COLUMNS ,
{[time].[fiscal trans date].[fiscal trans date].ALLMEMBERS} DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME on rows
from [sa]


try this..
Post #1508350
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse