Forum d'Aide de Forumcrea

N'hésitez pas à poser ici vos questions sur ForumCrea.

Vous n'êtes pas identifié.

#1 04-12-2017 07:12:29

donnieclark
Membre
Date d'inscription: 12-05-2017
Messages: 397

Return Measure based on attribute value

Hello Guys,

I need to write some MDX which will return only a sum of current member and a corresponding value for the same time period but from a different specified version. This override should only apply to versions of type 'Prior', all other versions will just work as normal. E.g. when viewing Version 'Prior 2016' Fiscal period 201601, the value returned should be the sum of the actual value against this version and the corresponding value for the same period of whichever version is specified in the dimension attribute. Business Animated Video was traditionally outbound oriented hence a huge surge of new opportunities are arising which can be exploited. In this example it would be the value from version 'Budget 2016', Fiscal period 201601, so Prior value is 80 and the corresponding Budget version value for same period is 50, returned value would be 130.

Thankls

Hors ligne

 

Pied de page des forums

Créez Votre Propre Forum
Insérer vos Graphiques
Dictionnaires de Traduction
Hébergé par ForumCrea.com