I have 2 dimensions I am trying to create rollup grouping
for using calculated members.

The first - Product Line - has values of 1, 2, 7, 8. I
was able to group lines 1 and 7 together by using:

[Product Line].[1] + [Product.Line].[7]

The second field - Product Code - has the following
values: A120, A1F0, B1G0. I need to create a caclulated
member to group based on the 2nd and 3rd position of the
Product Code (i.e. group by pos. 2-3 equals 1F or 1G). I
tried the following code and it doesn't pass the syntax
check. The asterisk (wildcard) is not recognized.

[Product Code].[*1F*] + [Product Code].[*1G*]

I don't see any type of susbstring command I can use to
pull values by position. Anyone ever try something like
this or have any suggestions?

Thanks,
Jim

For string manipulation, such as substring, mid, left, and the like, you can reference externally defined functions, such as those in the VBA library, or even create your own and load them up. If you want to use the VBA functions, no action is necessary, since the PivotTable service automatically loads them. Otherwise, you need to issue a "USE LIBRARY" command in MDX

For a list of useable VBA functions, consult

http://msdn.microsoft.com/library/de...sfunct_2wab.as

- Paul

---
Posted using Wimdows.net NntpNews Component - Posted from SQL Servers Largest Community Website: http://www.sqlJunkies.com/newsgroups/