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