Pentaho Analysis - Mondrian
  1. Pentaho Analysis - Mondrian
  2. MONDRIAN-560

StrToMember function doesn't use IgnoreInvalidMembers option.

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Severe Severe
    • Resolution: Fixed
    • Affects Version/s: 3.1 GA
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      Description

      It seems that StrToMember MDX function doesn't correctly handle the case when member is not found but IgnoreInvalidMembers mondrian property is set up to true.

      Example (for Foodmart):

      after setting mondrian.rolap.ignoreInvalidMembers=true in mondrian.properties we can put invalid member (for example, [Products].[All Products].[Drugs]) on column/row and it will be ignored (no error).
      But if we specify instead StrToMember('[Products].[All Products].[Drugs]') it will fail.

        Activity

        Hide
        Julian Hyde added a comment -

        Fixed in change 13595.

        Show
        Julian Hyde added a comment - Fixed in change 13595.
        Hide
        anikitin added a comment -

        I expected this fix to be included in 3.2.0 but it doesn't.
        What are the plans about it?

        Show
        anikitin added a comment - I expected this fix to be included in 3.2.0 but it doesn't. What are the plans about it?
        Hide
        Julian Hyde added a comment -

        I'm almost certain this is in 3.2.0.13661. I also added test cases to FunctionTest. Please double-check.

        Show
        Julian Hyde added a comment - I'm almost certain this is in 3.2.0.13661. I also added test cases to FunctionTest. Please double-check.
        Hide
        anikitin added a comment -

        Yes, checked against Foodmart – probably I was wrong, sorry for confusion.

        Show
        anikitin added a comment - Yes, checked against Foodmart – probably I was wrong, sorry for confusion.
        Hide
        Golda David added a comment -

        Customer says this issue is resolved.
        hence marking this as resolved.

        Show
        Golda David added a comment - Customer says this issue is resolved. hence marking this as resolved.

          People

          • Assignee:
            Golda David
            Reporter:
            anikitin
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: