You could manually add a "grouping" level above the Salespersons. Just add
a level above SalesPersons and in the "Advanced" properties tab set
Grouping property to "Automatic". AS2K will automatically put the
salespeople in different groups with names like "Abbot - Franklin", "Fraser
- Hewlitt", and so on. This will make your dimension a "changing"
dimension, with some negative performance impact on processing and querying
the cubes if the groups change, so it's not necessarily the best idea.
It's pretty easy to get the first letter of names, so you can end up with
A, B, C, ... . Add a level above Salespersons, based on the same name and
key columns as Salespersons, and then edit the level's Member Key Column
property in the "Basic" properties tab. If you click twice inside the key's
text area (not double-click) you can begin to edit its text. Change it to
Left ("dimTable"."SalespersonName", 1)
Edit the Member Name Column to be the same thing.
I would definitely mark this level as having unique names and keys as well,
assuming there is no higher level.
> Is there a way using which I can create a Manual Level in a Dimension.
> I have a Salesperson Dimension table containing the names of all sales
> persons. What I would like to do is to create a level like Alphabetical
> Listing and have categories like A - D, E - H, ...etc. The salesperson
> with First name starting would be in A - D, starting with H in E - H
> and so on.
> I can do this by creating an additional column in my salesperson table
> but is there a way I can create this OLAP Services manually. Tools like
> Cognos and Biz. Objects can do this.
> Thanks for all your inputs in advance.
> Seasons Greetings,
> Posted via http://dbforums.com
Chief Architect / OLAP Solution Provider
ISVs & IT organizations: Find out how DSS Lab can speed your development!