Very Computer

Hi!
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,

Siddhartha

--
Posted via http://dbforums.com

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
the expression

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.

HTH

Hi George!
Thanks for your prompt reply. The solutions provided by you didnt work
in my case there are multiple levels in the salesperson dimension. So
how can I set all the members to be unique? Is there something, which I
am missing?

Also is there a way by which I can create Custom Level Sales Person
Type and create Members like Internal Sales Persons and External
Agents and assign the respective salespersons to the same?

Thanks for your inputs in advance.

Cheers,
Sid

--
Posted via http://dbforums.com

To use a "grouping" level, the next level down requires unique member keys.
If you can't provide them, then it is true that you cannot use a grouping
level. There is almost always a way of constructing them, but I don't know
whether you have the means to. For example, the salesperson names may not
be unique, but the salesperson keys in a source system will certainly be
unique. As you load new salespersons into a dimension table, you can
maintain a column of unique id numbers (perhaps as an IDENTITY column), and
then use that column for your key.

Sales Person Type with Internal and External requires adding an appropriate
column to your dimension table and populating it.

HTH