I've worked with mdx and cubes for only 2 weeks, so excuse me if this
is a silly question.

I'm facing this situation

I've a cube that calculates data like

id_product, total qty, total $

(this is an example)

I need to generate, (via asp but this is not the matter) a report like

id_product, name of product, dimensions, weight, total qty, total $

I think I have two possibilities
1) create one dimension in the cube for each attribute (name,
dimensions, weight) flat (ie,with no hierarchy) and then select them
via mdx with a crossjoin (4, actually) in the "on rows" clause like
(pseudo mdx)

select total qty, total $ on columns,
non empty (crossjoin(crossjoin (idproduct,dimensions),weight) on rows
from cube

OR

2) create the cube only with id_product, and then in the asp page
access the db with standard sql to look for details about the
id_product. But this could be slow (one select for each row of the
cube)

I'll tell you, I dislike both of this solutions... is there a nice and
simple solution to this problem ?

than you very much,
Alberto

Look up "Member Properties" in BOL.
Also, you could approach this using Actions.

HTH,
--
Brian
www.geocities.com/brianaltmann/olap.html


"Alberto" wrote:

If you subscribe to SQL Server Magazine, which I would encourage everyone to
seriously look at -- it is a GREAT resource -- Russ Whitney had an
outstanding article on Member Properties which you might find very useful.
"Member Properties Boot Camp", August 2003 issue, Instant Doc ID# 39384
http://www.winnetmag.com/Article/Art...384/39384.html
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Brian Altmann" <findme@thesignaturewebsite> wrote

Thanks, Member properties do the "trick".

Now I have another problem:

I need to to something like

SELECT measures.qta on columns,
[product].id dimension properties [product].description
from cube
where [product].18

That is, I use dimension product both on axis 1 and WHERE clause.

But mdx does't allow it.

Is there a workaround ?