Cube Viewer - not rendering MDX view saved in Arc

[Radu Cantor]

The Apliqo Cube viewer doesn’t render a view saved as MDX in Arc. See the error in the attached picture.

‌

[Radu Cantor]

MDX below:

SELECT 
  NON EMPTY 
   {[FC Quarter].[FC Quarter].[Q4 YTD^Q1],[FC Quarter].[FC Quarter].[Q4 YTD^Q2],[FC Quarter].[FC Quarter].[Q4 YTD^Q3],[FC Quarter].[FC Quarter].[Q4 YTD^Q4],[FC Quarter].[FC Quarter].[All Quarters Next Year^Q1 Next Year],[FC Quarter].[FC Quarter].[All Quarters Next Year^Q2 Next Year],[FC Quarter].[FC Quarter].[All Quarters Next Year^Q3 Next Year],[FC Quarter].[FC Quarter].[All Quarters Next Year^Q4 Next Year]} 
  ON COLUMNS , 
  NON EMPTY 
   {TM1FILTERBYLEVEL({TM1DRILLDOWNMEMBER({[FC Legal].[FC Legal].[PowerGrids]}, {[FC Legal].[FC Legal].[PowerGrids]}, RECURSIVE )}, 0)}
   * {[FC Mgmt].[FC Mgmt].[PGCO Cons^Cons (PGCO) Total Input],[FC Mgmt].[FC Mgmt].[PGGA Cons^Cons (PGGA) Total Input],[FC Mgmt].[FC Mgmt].[PGGB Cons^Cons (PGGB) Total Input],[FC Mgmt].[FC Mgmt].[PGGI Cons^Cons (PGGI) Total Input],[FC Mgmt].[FC Mgmt].[PGHV Cons^Cons (PGHV) Total Input],[FC Mgmt].[FC Mgmt].[PGJV Cons^Cons (PGJV) Total Input],[FC Mgmt].[FC Mgmt].[PGNN Cons^Cons (PGNN) Total Input],[FC Mgmt].[FC Mgmt].[PGRE Cons^Cons (PGRE) Total Input],[FC Mgmt].[FC Mgmt].[PGSC Cons^Cons (PGSC) Total Input],[FC Mgmt].[FC Mgmt].[Cons (PGSU) Total Input],[FC Mgmt].[FC Mgmt].[PGTR Cons^Cons (PGTR) Total Input],[FC Mgmt].[FC Mgmt].[Cons (PG) Cons^Cons (PG Cons) Total Input],[FC Mgmt].[FC Mgmt].[Cons (Division) Cons^Cons (BA) Total Input]} 
  ON ROWS 
FROM [FC Forecast] 
WHERE 
  (
   [FC Scale].[FC Scale].[BASE],
   [FC Data Entry Level].[FC Data Entry Level].[PG Entry],
   [FC FX Rate].[FC FX Rate].[QTD BR],
   [FC Scenario].[FC Scenario].[Base],
   [FC Month].[FC Month].[07],
   [FC Year].[FC Year].[2023],
   [FC Plan Item].[FC Plan Item].[UV0490],
   [FC Forecast Metric].[FC Forecast Metric].[Value],
   [FC Version].[FC Version].[FC]
  )

‌

[Scott Wiltshire]

If just the MDX statement is copied and used in UX as pure mdx source for the widget does it work?

[Joana MFC Corte-Real]

Dear Radu, the issue has been fixed and wil be part of the 2024.02 FP1

[Radu Cantor]

[like] Radu Cantor reacted to your message: