Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

dates and columns Expand / Collapse
Author
Message
Posted Thursday, March 21, 2013 4:00 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, January 13, 2014 7:34 AM
Points: 117, Visits: 499
The syntax looks fine

It will be a problem with a member - best double check that the members of the tuple are correct e.g. is [Chargebacks].[CHB_Tree].[CHB Type].&[IRS VOID] correct?

Mack

Post #1433687
Posted Thursday, March 21, 2013 4:22 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 05, 2014 11:20 PM
Points: 49, Visits: 91
yes it is, i just double checked it.
maybe it has to do with the fact that i am formatting the dynamic date of the chb even though i dont need the actual date written anywhere.
i did try

member [Measures].[VOID] As
(strToMember("[CHB Date].[Year - Month - Period - Date].[Date].&[]"), [Chargebacks].[CHB_Tree].[CHB Type].&[IRS VOID], [Measures].[Purchase - converted to USD])

without the format, but i also get an error.
Post #1433703
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse