ReportPortal: Zero-footprint OLAP client for Microsoft Analysis Services

ReportPortal

All Forums

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:

UserName:

Password:

Message:

* HTML is ON
* Forum Code is OFF

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
goupil	Posted - 09/07/2016 : 07:27:27 Hi there, I am trying to put all the result of a named set into capital letters, so i try to use Upper but impossible. Could you please give any clue to solve this problem please. That is my MDX query for : UPPER(Descendants([Business].[BusinessHierarchy].&[293],[Business].[BusinessHierarchy].[Transaction])) Thanks in advance, Goupil
2 L A T E S T R E P L I E S (Newest First)
goupil	Posted - 09/08/2016 : 04:34:42 Thank you very much, it works well !
admin	Posted - 09/07/2016 : 12:04:22 Descendants returns members. Try using ucase and generate like: ucase( GENERATE( Descendants([Business].[BusinessHierarchy].&[293]), [Business].[BusinessHierarchy].CURRENTMEMBER.NAME, " AND ") )

ReportPortal