I have cubes that work fine.
They show an Employee dimension with
Member Key Column = Employee_ID
and
Member Name Column = Employee_Name

When my users view the cubes in an Excel pivot table, they
see one Employee column with the Employee's name, but they
don't see the Employee's Employee_ID.

I know I could change the Member Name Column property to
Employee_ID + ' - ' + Employee_Name

But they don't want that.

They want to see Employee_ID and Employee_Name as 2
seperate columns that are available to be dragged to the
pivot table report.

If I add a 2nd Dimension for Employee_ID it doesn't work
because the cube doesn;t know that there's a 1 - 1
relationship between the Employee_Name dimension and the
Employee_ID dimension.

Is there any way I can show 2 columns in the cube from a
single dimension?

I want my cube users to see Employee_ID and Employee_Name
as seperate columns in their Pivot tables.

thanks

Maybe you can put a new level in your dimension.
When the user drill down from the name, the ID appear.

Also, an MDX query can resolve your issue (but not easy to create for a
simple user)

Other option :
Creating 2 hierarchies in your dimension, 1 with the name only and the
second with the ID + name.
The user cannot used the 2 hierarchies at the same time.

Also...
Excel XP can display the properties of a member in the sheet, so the user
can display the name + the id (and other informations)

good luck !

"louis garrett" <louis315 (AT) hotmail (DOT) com> a écrit dans le message de
news:360001c3401a$61dee1f0$a601280a (AT) phx (DOT) gbl...

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.495 / Virus Database: 294 - Release Date: 2003-06-30

Make sure PTSlight or PTSfull is installed on all clients.
Saves a lot of trouble.
Also, if accessing cubes via Excel and VBA, make sure
MSOLAP.2 is used in the connection string.

All Cubes need to be reprocessed, I think.

Other than that it works well.

HTH Lutz

Sorry, I meant to post elsewhere

Lutz

Nevermind. I figured out how to show member properties in
my pivot table.

But I can only show Employee_ID to the RIGHT of
Employee_Name, and of course, my users wanted to see it on
the left!

Build your dimension based on ID and then make name a member property. ID
will then show up on the left.

Sean


--
Sean Boon
SQL BI Product Unit

**This posting is provided AS IS, with no warranties, and confers no
rights.**
"louis garrett" <louis315 (AT) hotmail (DOT) com> wrote


Nevermind. I figured out how to show member properties in
my pivot table.

But I can only show Employee_ID to the RIGHT of
Employee_Name, and of course, my users wanted to see it on
the left!