locked
All member not working in MDX query RRS feed

  • Question

  • hi All,

    [DIMCustomerBuyer].[CustId].[CustId] is working.

    [DIMCustomerBuyer].[CustId].Allmembers is not working any hint why this is not working.

    Regards,

    Manish

    Thursday, May 28, 2015 2:48 PM

Answers

  • Hi manishcal16PPS,

    In your expression, [DIMCustomerBuyer].[CustId].[CustId] only returns members under [DIMCustomerBuyer].[CustId].[CustId] hierarchy or level. [DIMCustomerBuyer].[CustId].Allmembers returns all members under [DIMCustomerBuyer].[CustId] hierarchy. If [DIMCustomerBuyer].[CustId] is level expression, it will return all leave members under this level. 

    These two expression are under different scope. So if you are working on [DIMCustomerBuyer].[CustId].[CustId] hierarchy (for example, define calculation on this scope), it supposed to be not working when you replace a higher level hierarchy or level.

    Regards,


    Simon Hou
    TechNet Community Support




    Friday, May 29, 2015 2:37 AM

All replies

  • HI,

    thats a bit less information. What is not working, Where do u want to use this - in Calculation script, Query, set, calculation,.. ?

    Thursday, May 28, 2015 3:09 PM
  • Hi manishcal16PPS,

    In your expression, [DIMCustomerBuyer].[CustId].[CustId] only returns members under [DIMCustomerBuyer].[CustId].[CustId] hierarchy or level. [DIMCustomerBuyer].[CustId].Allmembers returns all members under [DIMCustomerBuyer].[CustId] hierarchy. If [DIMCustomerBuyer].[CustId] is level expression, it will return all leave members under this level. 

    These two expression are under different scope. So if you are working on [DIMCustomerBuyer].[CustId].[CustId] hierarchy (for example, define calculation on this scope), it supposed to be not working when you replace a higher level hierarchy or level.

    Regards,


    Simon Hou
    TechNet Community Support




    Friday, May 29, 2015 2:37 AM