Post reply

The CHILDREN function expects a member expression

  • August 31, 2012 at 8:15 am

    #150107

    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

  • September 13, 2012 at 2:13 am

    #1537057

    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

  • October 12, 2012 at 7:54 am

    #1548652

    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

  • October 12, 2012 at 8:11 am

    #1548663

    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

  • October 12, 2012 at 8:13 am

    #1548668

    ahhhhh that issues rings a bell :hehe: I think it's specific to BIDS tho

  • May 1, 2019 at 8:53 pm

    #3605099

    Please elaborate on this?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply