Hitachi Vantara Pentaho Community Forums
Results 1 to 9 of 9

Thread: mdx axis function not supported in mondrian?

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Dec 2007

    Default mdx axis function not supported in mondrian?

    Hi, i'm trying to calculate a percentage of a column total. I've found the following MDX syntax which works on MSAS but it does not work on mondrian.

    I do not understand the error message i get when trying the same with mondrian. Should the syntax below work with Mondrian? Could it be that the AXIS function is not supported by Mondrian? Is there an alternative to accomplish the same with Mondrian?

    WITH MEMBER [Measures].[Percent] AS '
    [Measures].[Unit]/ (Axis(1).Item(0).Item(0).Dimension.CurrentMember.Parent,[Measures].[Unit]) ', FORMAT ='percent'
    Last edited by ss4ms0n; 01-03-2009 at 02:13 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.