September 2, 2011 at 2:37 am
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!
September 3, 2011 at 2:48 pm
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?
Data Enthusiast | @SQLbyoBI | www.opifexsolutions.com
September 5, 2011 at 12:07 am
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...=(
September 5, 2011 at 4:00 am
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?
October 25, 2013 at 1:27 am
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