search

mikeking27 / ranet-uilibrary-olap

Automatically exported from code.google.com/p/ranet-uilibrary-olap
0 stars 0 forks source link

Mdx Formattter Error #19

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
step 1 input mdx:
Select 
{[Measures].[List Income-ERP Fact Wholesale Item]} DIMENSION PROPERTIES 
PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME, CUSTOM_ROLLUP, UNARY_OPERATOR, KEY0 
ON 0, 
 NON EMPTY (CrossJoin([SourceSystem].[Source Systems].Levels(0).Members, [Book].[BookProperty].[BookProperty].Members)) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME, CUSTOM_ROLLUP, UNARY_OPERATOR, KEY0 ON 1 
FROM 
(SELECT {[SourceSystem].[Source Systems].Levels(0).Members} on COLUMNS From 
(SELECT {nonempty(Generate({[SourceSystem].[Source Systems].Levels(0).Members} 
AS [XL_Filter_Set_1], TopCount(Filter([XL_Filter_Set_1].CURRENT * 
[Book].[BookProperty].[BookProperty].Members,Not IsEmpty([Measures].[List 
Income-ERP Fact Wholesale Item])), 3, [Measures].[List Income-ERP Fact 
Wholesale Item])))} on COLUMNS From [BISSAS]
)) 

step 2 Click "Format MDX Statement Button":
line 1:554 mismatched input 'AS' expecting ')'
line 1:782 extraneous input ')' expecting '}'
SELECT
  { [Measures].[List Income-ERP Fact Wholesale Item] }
  DIMENSION PROPERTIES PARENT_UNIQUE_NAME , HIERARCHY_UNIQUE_NAME , CUSTOM_ROLLUP , UNARY_OPERATOR , KEY0 ON 0
, NON EMPTY CrossJoin
  ( [SourceSystem].[Source Systems].Levels ( 0 ).Members
  , [Book].[BookProperty].[BookProperty].Members
  )
  DIMENSION PROPERTIES PARENT_UNIQUE_NAME , HIERARCHY_UNIQUE_NAME , CUSTOM_ROLLUP , UNARY_OPERATOR , KEY0 ON 1
FROM
( SELECT
    { [SourceSystem].[Source Systems].Levels ( 0 ).Members } ON COLUMNS
  FROM
  ( SELECT
      { nonempty
        (!ERROR while parsing MDX!
        , TopCount
          ( Filter
            ( ( [XL_Filter_Set_1].CURRENT
              *
                [Book].[BookProperty].[BookProperty].Members
              )
            , NOT IsEmpty ( [Measures].[List Income-ERP Fact Wholesale Item] )
            )
          , 3
          , [Measures].[List Income-ERP Fact Wholesale Item]
          )
        )
      } ON COLUMNS
    FROM [BISSAS]
  )
)

Original issue reported on code.google.com by anshancu...@sohu.com on 19 Jul 2011 at 2:32

Attachments:

GoogleCodeExporter commented 9 years ago 
SOS

Original comment by anshancu...@sohu.com on 19 Jul 2011 at 2:36

GoogleCodeExporter commented 9 years ago 
Thank you for report.

Original comment by Galaktik...@gmail.com on 19 Jul 2011 at 11:41