Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Help Needed To Resolve Mondrain Internal Error

  1. #1
    Join Date
    Oct 2009
    Posts
    156

    Default Help Needed To Resolve Mondrain Internal Error

    Hi

    This is my MDX query

    SELECT NON EMPTY {[Measures].[x]} ON COLUMNS,
    NON EMPTY IIF("Daily" = "Daily", {[Dim_Day].[Day].Members}, Crossjoin({[Dim_Day].[Day].Members}, {[Time].[Hour_Value].Members})) ON ROWS
    FROM [CB]
    WHERE Crossjoin(
    Crossjoin(
    Crossjoin({[Dim_Year].[2012]}, {[Dim_Month].[March]}),
    {[Ack].[NS]}
    ),
    IIF("2089" = "",
    {[TD].[IB]},
    Crossjoin(
    {[TD].[IB]},
    {[FGV].[2089], [FGV].[2308]}
    )
    )
    )

    I am passing 2 parameters which are hard coded in IIF condition, when i run this query i am getting Mondrian Error:Internal error: Unexpected type: SCALAR execption.

    If i remove this IIF in where clause the query is working fine.

    Can some one help me to fix this issue

    Thanks

  2. #2
    Join Date
    Mar 2007
    Posts
    142

    Default

    Please post a full stack trace along with a schema snippet.
    Luc Boudreau
    aka. Luc le Magnifique
    aka. Monsieur Oui Oui

    Lead Engineer, Pentaho Corporation
    Web: http://devdonkey.blogspot.com
    Twitter: luclemagnifique
    IRC: Monsieur_Oui_Oui@freenode

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.