Restricted measure in SAP OLAP Universe

[Former Member]

Hi all,

        Im trying to make the following restricted ratio but it doesn´t work.

<EXPRESSION>(([Measures].[DD3WO888TSB6MM01CDAXI5A6V] , [0VTYPE].[LEVEL01].[50])</EXPRESSION>

I get this error when i execute the web intelligence:

"An error occur in the database. The text error of database is: The MDX query WITH MEMBER [Measures].[xxxxxxx] AS ´(([Measures].[xxxxxx],[0VTYPE].[LEVEL01].[50]) ´ SELECT {[Measures].[xxxxx]} ON COLUMNS, NONO EMPTY {[0CO_AREA].DEFAULTMEMBER} ON ROWS FROM [ZIP_PA/ZQY_PA_CONTABLE_2] SAP VARIABLES [0P_COAR3] INCLUDING [0CO_AREA].[CAL][0P_FYRA] INCLUDING [0FISCYEAR].[Z82013] failed to execute with the command error MDX not valid [50]. (WIS 10901)"

Any idea?

Thanks!!

[former_member184594]

You are not supposed to create restricted key figures on universe level. You should do this in Bex Query Designer not the universe. If you are using BW cube directly and created your universe on top of BW cube, you should definitely consider using Bex Queries otherwise you'll have a lot of problems and good luck with BW cube universe.

You are not able to use Calculated KF, Restricted KF if you are creating universe on top of BW. It is not recommended by SAP as well.

Please check out the links below for further information.

http://scn.sap.com/docs/DOC-6965

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c05314bb-e5a3-2e10-0e81-9e5a2db58...

http://scn.sap.com/community/businessobjects-web-intelligence/blog/2012/07/19/bics-vs-bapi-vs-df-rel...

[Henry_Banks]

Actually, there is nothing strictly 'wrong' with defining custom-MDx objects in the universe.

it's a design/implementation choice .

although, yes, typically you would want to centralise the maintenance of this complexity in the easiest single place, & where the functionality is richest - and that would be BEx.

Regards,

H