ALLMEMBER function error

  • 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!

  • 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?

  • 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...=(

  • 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?

  • 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..

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply