Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

The CHILDREN function expects a member expression Expand / Collapse
Author
Message
Posted Friday, August 31, 2012 8:15 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, August 5, 2013 4:21 AM
Points: 74, Visits: 90
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

Post #1352836
Posted Thursday, September 13, 2012 2:13 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, January 13, 2014 7:34 AM
Points: 117, 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
Post #1358386
Posted Friday, October 12, 2012 7:54 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, August 5, 2013 4:21 AM
Points: 74, Visits: 90
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

Post #1372142
Posted Friday, October 12, 2012 8:11 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, August 5, 2013 4:21 AM
Points: 74, Visits: 90
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

Post #1372155
Posted Friday, October 12, 2012 8:13 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, January 13, 2014 7:34 AM
Points: 117, Visits: 499
ahhhhh that issues rings a bell I think it's specific to BIDS tho
Post #1372160
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse