#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 17
Default CUBEMEMBER

Does anyone know if you can use a wildcard with the cubemember function, and
if so, how? I am trying to pick up all product IDs that start with KRLMJ129*
(ie, KRLMJ129arj, KRLMJ129lik, KRLMJ129pwr, etc.). Is this possible? I have
tried adding the * at the end of the ID, but it doesn't work.

Using Excel 2007 with OLAP data source from SQL Server '08.
Thanks in advance!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using cell referencces as values in MDX formulas - cubemember Graham Whitehead Excel Worksheet Functions 0 February 11th 09 02:11 PM
OLAP Blank results in CUBEMEMBER and CUBECELL Formulas sansimeon Excel Discussion (Misc queries) 0 October 4th 06 06:21 AM


All times are GMT +1. The time now is 05:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"