Hi @Epistemophile ,
If I understood correctly, it should be pretty simple, you’re just missing to add the GL measure to the rows as well in UX cube settings.
When I have to do crossjoin on rows and columns in UX, I normally add all the referring dimensions I’m using in the MDX on the rows/columns. In the First dim you add your MDX code, in the second onwards, you change to type MDX, but leave the code blank.
In your example:
- Drag and drop 1st the FIN OCoA dim and 2nd the FIN GL measure dimension to the rows.
- On the FIN OCoA you add your MDX code (Appendix B), in the FIN GL Measure dim you change the type to MDX and leave it blank, it should then work.
- Looks like you want to see the Measure column, but you can then potentially hide it, with “right-click > hide column”, as it will repeat the measure name on each row…
Hope this helps!