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