Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: DEsgion studio 4.0:Xaction Get Data from OLAP cientific expresion

  1. #1

    Default DEsgion studio 4.0:Xaction Get Data from OLAP cientific expresion

    Hello everybody,

    I have a strange problem and i think cause Get data from OLAP because de same sentence in the JPIvot Analysis viewer don't do that. I have a MDX sentence like this:

    With Member Measures.estadistica as
    SUM({Crossjoin(Crossjoin({[Comercial].[{parametrocomer}]},
    {[Empresa].[{parametronombre}]}),
    {[Fecha].[{parametroanyo}]})},Measures.[Ventas] )/
    SUM({Crossjoin(Crossjoin({[Comercial].[All Comercials]},
    {[Empresa].[{parametronombre}]}),
    {[Fecha].[{parametroanyo}]})},Measures.[Ventas] ) *100
    member [Measures].[suma] as (Sum({Crossjoin(Crossjoin({[Comercial].[{parametrocomer}]}, {[Empresa].[{parametronombre}]}), {[Fecha].[{parametroanyo}]})}, [Measures].[Ventas]))

    select NON EMPTY {[Measures].estadistica,[Measures].suma} ON COLUMNS,
    NON EMPTY [Articulo].[All Articulos] ON ROWS
    from [CapriCubeDEmo]

    select NON EMPTY {[Measures].estadistica,[Measures].suma} ON COLUMNS,
    NON EMPTY [Articulo].[All Articulos] ON ROWS
    from [CapriCubeDEmo]

    The sentece is perfect but when it return a SUM with values > 9.999.999,99 then it returns like this
    1.241985901E7(cientific expresion) and not this 12.419.859,01. Why? in Analyzer rusn perfect but in the Get Data from OLAP runs(Xaction).

    Thanks.

  2. #2

    Default

    Hello i find the response.

    With function Math.abs i resolve my problem.

Tags for this Thread

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.