hi all,

i have a dimension table with these fields..

sun_site
site_name
opening_date
store_type
store_group
district_type
district_name
region_name
store_type2
site_status
colsing_Date
group_code
no_of_mpds
district
store_grade
jiffy_kitc
carpark
area_rais
coolerdoor
pos
building

Siteid is the primary key and i have the fact table is like this

siteid
Period
Amount

this is just sql query what is the equalent for mdx..

select * from pricegap a,opertypenew b
where a.siteid = b.siteid
and b.store_grade = 'AA'

i want to pass the query like this to cube

SELECT {[Measures].members} ON COLUMNS,
NON EMPTY [DrOperTypeNew].[store grade].members ON ROWS
FROM drpricegap
WHERE([DrOperTypeNew].[store grade].[AA]

I created a cube with name drpricegap and dimensins drpricegap time dimension
and other dimension is DrOperTypeNew
When i execute the above query it is giving me the following error...

formula error- duplicate dimensions across(independent) axes-when calculating a query axis

i am new to this tech so let me know how to do solve this..

I have created a dimesion in sql server that is star schema..design.
what should i do.

thanks