dates and columns

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Analysis Services » dates and columns

12 posts, Page 2 of 2

««1 2

dates and columns

Rate Topic

Display Mode

Topic Options

Author

Message

Mackers

Posted Thursday, March 21, 2013 4:00 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 4:25 AM
Points: 117, Visits: 473

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

astrid 69000

Posted Thursday, March 21, 2013 4:22 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, May 09, 2013 3:26 AM
Points: 40, Visits: 72

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 »

12 posts, Page 2 of 2

««1 2

Permissions