dbTalk Databases Forums  

StrToMember

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss StrToMember in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
JcT
 
Posts: n/a

Default StrToMember - 09-20-2004 , 05:05 AM






Hello,

I am having problem with the STRTMEMBER functions.

What in need :

([Measures].[Qte Stock], [Date Année Mois].[Année].&[2004].&[6])
, but for current Year and month.

The above formula works, but I cannot get it working with the combination
of Strtomember and the Now() VB;

This should look to something like :

([Measures].[Qte Stock], StrToMember("[Date Année Mois].[Année].&
["+LTRIM(str(YEAR(now())))+"].&["+LTRIM(str(MONTH(now())))+"]"))

the syntax is OK, but I received errors while executing it.
Any help would be appreciated.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.