Max Object Not working in BO

[Former Member]

Hi,

I am using the following Versions BOE XI 3.1 SP3 FP 3.6 and SAP Integration kit XI 3.1 SP3 and FP 3.6 and my Backend is SAP 7.0 EHP2.

We are using the Infocubes created by the SAP BW team as the Source and creating the Universe. I want to create an MAX Object at the Universe level for the Date. Can you please let me know what the Synatx is? Here is the Object Technical Name [ZCMPLDT].[LEVEL01]. Please let me know how can i achieve to get the Max date from that object.

Thanks,

Ashwin

[Henry_Banks]

Good document on MDX functions here: http://scn.sap.com/docs/DOC-6965  (written by Didier Mazoue)

Also, check the documents written by Marc Daniau in this SCN.

also, MDX function librabry can be found here for Microsoft Analysis, here's an example for MAX:

http://msdn.microsoft.com/en-us/library/ms145601.aspx

regards,

H

[Former Member]

Any Inputs are really appreciated!!