Report Portal

ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Named Set error		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

goupil

France
2 Posts
Posted - 09/07/2016 :  07:27:27  Show Profile  Reply with Quote
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

admin

1635 Posts
Posted - 09/07/2016 :  12:04:22  Show Profile  Reply with Quote
Descendants returns members. Try using ucase and generate like:

ucase(
GENERATE(
Descendants([Business].[BusinessHierarchy].&[293]),
[Business].[BusinessHierarchy].CURRENTMEMBER.NAME, " AND ")
)
Go to Top of Page

goupil

France
2 Posts
Posted - 09/08/2016 :  04:34:42  Show Profile  Reply with Quote
Thank you very much, it works well !
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page