Hi

If I crossjoin two dimensions and I want column heading to be displayed for
that dimensions in my mdx how this can be done?

--
Thanks

Hmm...I'm just a chimp here so I apologize in advance for my primate
nievity...but if I run a simple query like this in the MDX Sample
Application...

select
{
[Gender].Members *
[Marital Status]. Members
} on columns,
{
[Measures].[Unit Sales]
} on rows
from Sales

I get column headers. What exactly do you mean?


AM wrote:

Hi

Thanks for the reply

what i want like

If I run this MDX query

select [Measures].[MeasuresLevel].allmembers on 0,
crossjoin([Product].[Product Family].members,[Promotion Media].[Media
Type].members) on 1
from sales

In Result I want to display heading for first column like PRODUCTS so that
it gives idea that it show [Product].[Product Family].members and for
second column heading like PROMOTIONMEDIA for [Promotion Media].[Media
Type].members
Both are used in cross join.



--
Thanks

"OLAPMonkey (http://olapmonkey.blogspot.com/)" <jjanke (AT) spss (DOT) com> wrote in
message news:1118415556.770633.241630 (AT) g14g2000cwa (DOT) googlegroups.com...