Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Text-field of parameters (MDX)

  1. #1

    Default Text-field of parameters (MDX)

    Hi.

    I'm using a query MDX with parameters, as follows:

    Parameter "pFirm" receives a MDX query data. The "value" field is "::column::2" and Display Name "::column::1". So the value is a member ([Firm.Firm].[Enterprise Inc.]);
    In the query with the report data I'm using the command "StrToMember(Parameter("pFirm", STRING, "[Firm.Firm].[All_Firm]"))".

    So far is OK, but I need to appear in the report the value of the selected parameter. If I put the parameter "pFirm" in the report the value presented is "[Firm.Firm].[Enterprise Inc.]", but I need to be just "Enterprise Inc."

    There a way to do this?

  2. #2

    Default

    I did it!

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.