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

      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: