beginner olap question

[danpurcell]

I am new to MDX and this seems to be a simple question.
I have a database that table that has two columns: one column has the client_id in the other column has the client's name.
Would like MDX query that contains an axis that uses the client's id to query but that shows the client's name.

This works, but shows all the client's id not the client's names.
The client's is also in the ad_dimension table in column called "client"

<Dimension name="Ad">
<Hierarchy hasAll="true" allMemberName="All Ads" primaryKey="ad_id">
<Table schema="oltp" name="ad_dimension"/>
<Level name="Client" column="client_id" numeric="true" uniqueMembers="false"/>
</Hierarchy>
</Dimension>

<Cube name="Events">
<Table schema="oltp" name="events_fact"/>
<DimensionUsage name="Ad" source="Ad" foreignKey="ad_id"/>
<Measure name="Events" column="event_count" aggregator="sum" formatString="#,###"/>
</Cube>



The following query show the


select
{[Measures].[Events]} on columns,
{( [Ad].[2] )} ON rows
from Events

 

[MDXer]

What cube engine are you using?

THe above info doesn't really say much about what information your dimension contains.

is the client ID used as the member key?
what is the member name populated with?
Is the client's name stored anywhere within the Dimension?

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[danpurcell]

The database table has two columns: one column has the client_id int4 in the other column has the client's name text.
I am using mondrian/jpivot.