Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using cell referencces as values in MDX formulas - cubemember | Excel Worksheet Functions | |||
OLAP Blank results in CUBEMEMBER and CUBECELL Formulas | Excel Discussion (Misc queries) |