I have the following star schema



TIME

-----

Year

Quarter

Month

Time_id



Market

--------

Country

State

City

Market_id





Areas

-------

Area

Market_id

Area_id





SALES (The fact table)

--------

Time_id

Market_id

SALES





CALLS (this is another fact table)

--------------------------------------

TIME_ID

MARKET_ID

AREA_ID

CALL_COUNT (This is the measre)





Now I made two cubes 1 for sales and another for calls



Sales cube have dimensions Time and Market, and fact table sales



Calls cube have dimensions

TIME and Market (composed of Market and area tables i.e

market and area are snowflaked for calls cube)



Now I want to create a combined virtual cube named combined

The dimensions of this cube will be

time

market



The measures of this virtual cube will be

SALES

CALL_COUNT



The problem is, its not shoiwng the sales and call_count side by side.





How can I achieve this



Thanks



Asim Naveed


--
Posted via http://dbforums.com

You might need to use the VALIDMEASURE() MDX function in order to see the
data that you want. You'll just need to create calculated members in the
virtual cube that wrap your base measures in the VALIDMEASURE() function and
it should allow you to view the data.

Sean



--
Sean Boon
SQL Server BI Product Unit

**This posting is provided AS IS, with no warranties, and confers no
rights.**

"asim73" <member31195 (AT) dbforums (DOT) com> wrote