the attributes of Fact Table could not be displayed when drill through?

thank Edward,

I know the Measrues could be as part of drillthrough action.

I think I would correct my example as following:

For Example:

There are three dimensions and attributes:

[Dim_Product]: P_Key, P_Name, P_Unit.

[Dim_Customer]: C_Key, C_Name, C_Address.

[Dim_Store]: S_Key, S_Name.

There is a Measuregroup:

[Measures]: Amount

A Fact Table and its attributes:

[FactSales]: PK, P_Key, C_Key, S_Key, Amount, Description.

When I set drill through, the display columns could be any columns in the Dimensions (P_Key, P_Name, P_Unit, C_Key, C_Name, C_Address, S_Key, S_Name) and Measures (Amount).

The attributes of Fact Table (PK, Description) could not be displayed.

So how could I let the attributes of [FactSales] (PK, Description) displayed when drill through?

My key point is that Description is a attribute of Fact Table, not a dimension or measure.

And how could I let the Description displayed when drill through ?

thanks,

ivanw at 2007-8-30 >

thank Michael,

Yes. Finally, I create a dimension (fact table). Then, the column "Description" could be displayed when drill through.

But another problem is derived from creating a dimension (fact table).

There is 30 miliion records in the fact table. It means the amount of member "Description" maybe 30 million , too.

It costs much time during process because of lot of members(Description).

So, is there a better solution?

ivanw at 2007-8-30 >

thank Vladimir,

The data type of Measure usually is numeric, right?

I have no idea What "text measure" is,

Please give me more information about "text measure" .

thank,

ivanw at 2007-8-30 >