SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


The CHILDREN function expects a member expression


The CHILDREN function expects a member expression

Author
Message
Duncan Lawrence
Duncan Lawrence
SSC-Enthusiastic
SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)

Group: General Forum Members
Points: 146 Visits: 167
Hi, using SSAS 2005

I have a fully functioning cube with many measure groups and dimensions all bar one of which work fine. The exception is found when drilling-down from a level in an hierarchy when the following error message is returned

Query (5, 7) The CHILDREN function expects a member expression for the 0 argument. A level expression was used. (Microsoft SQL Server 2005 Analysis Services)

There are two members at level one. Drilling-down exposes a list of, in this case, properties (houses, that sort of property). Drilling-down on one member works fine. The error is returned when drilling down on the second

There's no MDX code to post as I'm using BIDS to develop and deploy the installation

Originally the keys for this member were integers, I thought this might be the problem and so changed them to strings but the same error is returned

Any thoughts, ideas or suggestions will be gladly received

Thank you for your attention

Duncan


All the best,

Duncan

Mackers
Mackers
SSC Veteran
SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)

Group: General Forum Members
Points: 239 Visits: 499
What are you doing - just drilling down on a hierarchy in BIDS or are you querying a calculated member?

It might be worth just running a trace on the server to get the MDX or just try using Excel to connect to it incase its a funny in BIDS

Mack
Duncan Lawrence
Duncan Lawrence
SSC-Enthusiastic
SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)

Group: General Forum Members
Points: 146 Visits: 167
Hi, thanks for the response

The error only occurs when browsing in the dimension editor of BIDS

I did use the profiler and carriedout the query is MSSMS and Excel.

In these environments the query returns a complete list of leaf node members, no matter which of the two dimension members I drill-down from

I tried filtering the query to a total of 978 records (in this case rented properties), 954 are "Not Let in the Period" and 24 are "Let in Period". The measure used is a base measure, i.e. it is derived from a column in the fact table called Nr properties

Drilling down on the "Let in Period" dimension I would expect just 24 records. In fact the complete list of 978 properties is returned although the sub-total reports 24

There are really two problems here; the CHILDREN function error, and, the complete leaf node data-set being returned

Any ideas, help will be appreciated


All the best,

Duncan

Duncan Lawrence
Duncan Lawrence
SSC-Enthusiastic
SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)

Group: General Forum Members
Points: 146 Visits: 167
Cracked it

The level name was identical to a member name consequently the MDX was getting itself mixed-up

Changed the hierarchy and level labels and loo and behold, it all works


All the best,

Duncan

Mackers
Mackers
SSC Veteran
SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)

Group: General Forum Members
Points: 239 Visits: 499
ahhhhh that issues rings a bell Hehe I think it's specific to BIDS tho
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search