assumed you have a SAP Query with 2 fixed struktures.
As answered in many threads MDX shows only that structure elements as single members in Crystal Reports which contain the key figures. The other will be presented as a single item with several rows of data.
The result is not only a painful work to format and sort data records e.g. with data record number .
In particular if the keyfigures are positioned in the lines the axis of the report is getting transposed and then you have to deal with multi column format with all its restrictions (fixed column width, 1 detail section etc.)
Could anyone give a statement if that issue is on the worklist for further improvements of SAP integration??
great question that one!
We have also trouble with custom structures. Even the behaviour of the key figures in the first query structure is not satisfying. First of all the clumsy field descriptions are disturbing me. (See also thread/answer: [Clumsy fields names of BEX Query Structure in Crystal Reports|])
It's really a painful work to select the correct key figure at some parts of the software.
So, any comment or advice about the plans to improve the structure integration will be highly appreciated.