I HAVE 2 CUBES: ONE ACTUAL ANOTHER BUDGET. HOW TO CONNECT 2 CUBES INTO ONE
SINGLE TABLE/PIVOT TABLE IN EXCEL ?

Thanks.. Is it possible to build virtual cube wihout SQL server ? I only
have Excel with me.


"hkappleorange" <hkappleorange (AT) yahoo (DOT) com.hk> ¼¶¼g©ó¶l¥ó·s»D
:uf4uDQZuFHA.2064 (AT) TK2MSFTNGP09 (DOT) phx.gbl...

You cannot link 2 cubes in Excel, you will need to create a virtual cube
in AS that links the 2 cubes and then point Excel to that.

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

In article <uf4uDQZuFHA.2064 (AT) TK2MSFTNGP09 (DOT) phx.gbl>,
hkappleorange (AT) yahoo (DOT) com.hk says...

So any workaround if I do not have SQL server ?
"hkappleorange" <hkappleorange (AT) yahoo (DOT) com.hk> ¼¶¼g©ó¶l¥ó·s»D
:uf4uDQZuFHA.2064 (AT) TK2MSFTNGP09 (DOT) phx.gbl...

I think you can do it in one sheet in different cell.

or you may do it one cube one sheet and link 2 sheets together by using
vlookup

have you AS installed on the server?
and have you access to this server?

if yes, then create a virtual cube.
if not, then create Excel calculations.

"hkappleorange" <hkappleorange (AT) yahoo (DOT) com.hk> wrote

Thanks for indicating solution = calculation in Excel.
How to do calculation based on 2 cubes in Excel ?




"hkappleorange" <hkappleorange (AT) yahoo (DOT) com.hk> ¼¶¼g©ó¶l¥ó·s»D
:u#ZVQ5ZuFHA.360 (AT) TK2MSFTNGP12 (DOT) phx.gbl...

No I do not have the AS or SQL server, just Excel.
"if not, then create Excel calculations". Could you please help to give more
advice on this part ? Thanks ...

<Jéj? <willgart (AT) BBBhotmailAAA (DOT) com>> ¼¶¼g©ó¶l¥ó·s»D
:OEwU3lauFHA.3528 (AT) TK2MSFTNGP15 (DOT) phx.gbl...

create 2 sheets, each sheet will display data from each cube
then on a third sheet, simply apply your formula.

but this is not a dynamic option, if you change (like drill down) any of the
first 2 sheets, then the formula is not good anymore.


"hkappleorange" <hkappleorange (AT) yahoo (DOT) com.hk> wrote

If you had a decent excel add-in you wouldn't have any trouble
whatsoever.
Probably the 3 best selling add-ins for AS cubes are IntelligentsApps,
MIS Plain & XLCubed.

Regards,

John Keeley

www.johnkeeley.com