Error using multiple measures and dimensions in columns

[Enrique Maldonado]

The version 1.0.0.5 works perfectly in Excel 2010 and Mondrian 3.7, 4.0

But in version 1.0.0.19 when you attempt to add more than one measure in columns that already contains a dimension, throws an error message. This works fine in version 1.0.0.5.

1. When trying to add two measures into the columns that already contains a dimension

Caused by: mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'SELECT NON EMPTY CrossJoin(Hierarchize(AddCalculatedMembers({DrilldownLevel({[Combustible].[cmb].[Todos]})})),CrossJoin({[Measures].[Consumo],[Measures].[Precio]})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS , NON EMPTY Hierarchize(AddCalculatedMembers({DrilldownLevel({[Fecha].[Fecha].[Todas]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON ROWS  FROM [comb_quemados_scom] CELL PROPERTIES VALUE, FORMAT_STRING, LANGUAGE, BACK_COLOR, FORE_COLOR, FONT_FLAGS'

Caused by: mondrian.olap.MondrianException: Mondrian Error: No function matches signature 'CrossJoin (<Set>)'

---

2. When trying to add a dimension into the columns that already contains two measures

Caused by: mondrian.olap.MondrianException: Mondrian Error: Internal error: While parsing SELECT NON EMPTY CrossJoin({[Measures].[Consumo],CrossJoin([Measures].[Precio]},Hierarchize(AddCalculatedMembers({DrilldownLevel({[Combustible].[cmb].[Todos]})})))) PARENT_UNIQUE_NAME DIMENSION PROPERTIES ON COLUMNS, NON EMPTY Hierarchize (AddCalculatedMembers ({DrilldownLevel ({[Date]. [Date]. [All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON ROWS FROM [comb_quemados_scom] CELL PROPERTIES VALUE, FORMAT_STRING LANGUAGE, BACK_COLOR , FORE_COLOR, FONT_FLAGS

Caused by: mondrian.olap.MondrianException: Mondrian Error: Syntax error at line 1, column 79, token '}'

[Alexandra Davidoiu (Iancu)]

Yes, we broke it somewhere between. We will provide a fix asap. Meanwhile you can make it working by disabling the functionality that breaks it as follows:

1. Stop Excel.
2. Go into Program Files\Arquery\XMLA connect and edit the file mondrian_dialect.txt. Comment or delete the following line:

subst CrossJoin(%1,%2,%3)=CrossJoin(%1,CrossJoin(%2,%3))

1. If you run 64 bit Windows go do the same for the file in Program Files (x86)\Arquery\XMLA connect

We will post here once we fix this problem but meanwhile this will fix it.

[Enrique Maldonado]

OK, commenting on that line, works.
but now, not run some queries, with the following error:

Mondrian Error:No function matches signature 'CrossJoin(<Set>, <Set>, <Set>)'

for example:

with
 set __XLSlice0 as { [Generadores.por agente].[Todos] }
 set __XLSlice1 as { [Hora.hora].[Todas] }
 set __XLSlice2 as { [Generadores.por central].[ADTO] }
 set __XLExistingMembers as
Filter(
[Dia].[Año].allmembers,not isEmpty(
CrossJoin(__XLSlice0,
__XLSlice1,
__XLSlice2)
.Item(0)))

 set __XLExistingRangeMembers as SubSet(__XLExistingMembers, 0, 1000)
 set __XLNonExistingRangeMembers as
Iif(__XLExistingRangeMembers.Count = 1000,
        {},
        SubSet( Except([Dia].[Año].allmembers, __XLExistingMembers),
                        iif (0 - __XLExistingMembers.Count < 0, 0, 0 - __XLExistingMembers.Count),
                        1000 )
        )
member [Measures].__XLRelated as Intersect( [Dia].currentmember, __XLExistingRangeMembers ).Count
 set __XLTargetSet as SubSet(Union(__XLExistingRangeMembers, __XLNonExistingRangeMembers), 0, 1000)
member [Measures].__XLPath as
Generate(
        Ascendants([Dia].currentmember),
                                [Dia].currentmember.UniqueName,
                                "__XLPSEP")

select { [Measures].__XLPath, [Measures].__XLRelated } on 0,
__XLTargetSet on 1
from [valores_generadores]
cell properties value

[Alexandra Davidoiu (Iancu)]

Can you test the provider in the attach? It should handle the entire topic better

[Enrique Maldonado]

Awesome! It works perfectly. Thanks a lot.

I like to much to contribute to the project, as I do?

[christopher68]

When encountering errors while using multiple measures and dimensions in columns within a data analysis or visualization tool, it's important to troubleshoot based on the specific software or platform dunkin donuts egypt menu being used. Often, such errors stem from incompatible data types, improper aggregation settings, or conflicting formatting requirements between different measures and dimensions.

[slpfrsly]

When using multiple measures and dimensions in columns within a data visualization or reporting tool, errors can occur due to improper configuration or incompatible data types. This typically happens when the software cannot reconcile different aggregation methods or when dimensions of embroiderer near me are not properly aligned with measures.

[Unknownop]

여러 측정값과 차원을 열에 사용할 때 오류가 발생하는 것은 시각화 도구의 데이터 구조 처리 방식 때문입니다. 이러한 기술적 문제를 해결하는 데에는 스포츠중계 데이터 구조 이해와 구성 방식 조정이 필요합니다. 이와 유사하게, 스포츠중계 플랫폼 ssbbtv는 복잡한 스포츠 경기 데이터를 사용자에게 명확하게 전달하는 데 중점을 둡니다. 다양한 경기 정보와 실시간 중계를 효과적으로 구성하여 사용자 경험을 최적화하는 것이 ssbbtv의 핵심입니다.