Hi everybody,
I'm trying to create a simple query object with a relation between GeneralJournalAccounEntry and "Financial Dimensions tables". I'm using LedgerDimension Field to join it with DimensionAttributeValueCombination, I also join DIMENSIONATTRIBUTEVALUEGROUPCOMBINATION, DIMENSIONATTRIBUTEVALUEGROUP, DIMENSIONATTRIBUTELEVELVALUE, and from this I get the DisplayValue. I filter the Dimension value using the Ordinal field from DIMENSIONATTRIBUTELEVELVALUE, when I do that for one dimension, works good, but I need to get all financial dimensions using several joins to DIMENSIONATTRIBUTELEVELVALUE table, using this the logic works as "And" but it needs to work as "Or".