Uploaded image for project: 'Pentaho Analysis - Mondrian'
  1. Pentaho Analysis - Mondrian
  2. MONDRIAN-1227

Properties function does not implicitly convert dimension to member; has documentation typos

    Details

    • 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

      Go to http://mondrian.pentaho.com/documentation/schema.php#Calculated_members

      Note the following example:

      <CalculatedMember name="Store Sqft" dimension="Measures" visible="false">
      <Formula>[Store].Properties("Sqft")</Formula>

      According to the MDX specification for the Properties function, the syntax is the following:

      Member_Expression.Properties(Property_Name [, TYPED])

      See http://msdn.microsoft.com/en-us/library/ms144821.aspx

      If you attempt to use Dimension.Properties(Property_Name), you will receive the following error in your logs:

      mondrian.olap.MondrianException: Mondrian Error:No function matches signature '<Dimension>.Properties(<String>)'

      Also note that in the example, the CalculatedMember is not closed.

        Attachments

          Activity

            People

            • Assignee:
              bbruce Brandon Bruce (Inactive)
              Reporter:
              bhagan Brian Hagan (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: