hi
i think i begin to understand...
i need to obtain columns
from multi-key rows
can olap help me ?

example
starting with that ...

YEAR | PRODUCT | TOTAL
--------------------------------
2005 | A | 190
2005 | B | 200
2006 | A | 180
2006 | B | 210
2006 | C | 300

i need to get this

2006 | 180 210 300

thanks

--
atte, Hernán

Yes, you can make dimensions "Time" with levels Year, Month, Day and
"Product". Make Total as a Measure.

Then a simple MDX query like

select {[Time].[Year].members} on rows,
{[Product].members} on columns
from <your cube name>

would give you the desired result.

HTH

Milind