dbTalk Databases Forums  

TIP: How to deal with case sensitivity in AS2K 64bit.

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


Discuss TIP: How to deal with case sensitivity in AS2K 64bit. in the microsoft.public.sqlserver.olap forum.



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

Default TIP: How to deal with case sensitivity in AS2K 64bit. - 06-15-2005 , 06:18 AM






May be this will be helpfull for somebody,
Our original problem is that the following filter did not work for us
because case sensitivity
iif(COUNT(
FILTER([Users].[User].MEMBERS, USERS.CURRENTMEMBER.NAME = USERNAME)
)=0

we found that this will deal with will make the filter case insenistive
using intersection
"select intersect(
FILTER([Security USERS].MEMBERS, [Security USERS].CURRENTMEMBER.NAME
<username+"!"),
FILTER([Security USERS].MEMBERS, [Security USERS].CURRENTMEMBER.NAME
Quote:
=username)) on 0 from ..."
this seems to work for us ..not sure of the performance if applied in other
scearios..

I'd love to get feed back from people hwo deployed 64bits specially on the
topic "is MDX sustainable without VBA"
Also an official list of VBA functions integrated into MDX in SP4 will be
very handy.

Thanks
Nabil Majoul




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.