MDX AGGREGATE FUNCTION FOR UNIVERSE DESIGNER

[Former Member]

Hallo Friends,

I'm trying to get the summatory of a meassure in Universe Designer for a certain period of time, and I think I can make it with the function AGGREGATE MDX but it always results in an error, I've tried to make it in some different ways but I have again an error. Could somebody please help me with an example of this function in Universe Designer.

Thanks in advance!

[Henry_Banks]

Hi,

It's probably (definitely) easier to do this in the Bex layer, but here are some useful samples for you to digest:

https://www.sdn.sap.com/irj/boc/index?rid=/library/uuid/c0a45246-ce76-2b10-e688-f5c8206203eb&overrid...

regards,

H

[Former Member]

Hi Henry,

Thanks for your answer, I already have this document bu it could't get the sentence without errors and like you don't have corrections in Universe Designer it's becomes difficult to know what's happening till I get the errors in Web Intelligence, do you have some information about this Bex layer that you mentioned.

Thanks a lot for your help!

Araceli G.

[Henry_Banks]

i was meaning bex query designer - restricted and calculated key figures

regards,

H