Hello All

I use OWC 10 to view my cube. The cube is enabled for
drillthru and it is viewable using drillthru component
supplied by microsoft.

is there a way i can specify the order of columns for my
drillthru view.

for now i can select which column to display for drillthru
but not the order of it.

Any info on this is highly appreciated.

Madan

If you make your Fact table a view, you can specify the order of columns there and that's how they will come out in the drillthrough.

Hi Andrea

Thanks for your input.

I have a situation where not only from the fact table, the
columns are shown in drill thru but also from the
dimensions. What i would like to have is a column from
fact table and then a column from dimension and then a
column probably from fact table again.

As of now, i have achieved this by altering the order of
the columns from the recordset built by Microsoft
Drillthru component. I do this before it is bound to the
owc component for display at client side.

if i can do this on the serverside then it would be nice
and i can avoid this work around.

Madan


in the drillthrough.