Hi All,

I have two tables with names Pricegap,opertypenew
pricegap is the fact table.
Opertypenew is the dimension table.

I created a dimension with opertypenew
i created to cube with pricegap table and inclueded the
opettypenew,OPTN dimensions.

I have one query like

select * from cdh_price_gap a , oper_type_new b
where a.site_id = b.sun_site
and b.store_grade = 'AA'

it retrives me total 21 rows and
i want the equalent query in MDX.

I have the basic query in MDX like this

1)
SELECT

[Measures].members ON COLUMNS,

NON EMPTY{[OperTypeNew].[Sun Site].members}ON ROWS
FROM PriceGap
where [OPTN].[Store Grade].[AA]

it is giving me only one record what is the wrong in the above
statement.

OPTN i created because if i give the following query in MDX

2)
SELECT

[Measures].members ON COLUMNS,

NON EMPTY{[OperTypeNew].[Sun Site].members}ON ROWS
FROM PriceGap
where [OperTypeNew].[Store Grade].[AA]

It is giving the error like duplicate dimensions across independent axes so i tried to create a
new dimension with the same table it is working but the result is not same...as of the
normal select query ...let me what is the wrong in 1 st MDX query



Thanks