Page 1 of 1
Multiple Views in one Worksheet
Posted: Mon Feb 22, 2010 6:00 am
by gujsa01
Hi,
I'm trying to add multiple views from different/same cube(s) to same worksheet. Any examples on this would be very helpful.
Appreciate your help and thanks in advance.
Re: Multiple Views in one Worksheet
Posted: Mon Feb 22, 2010 8:57 am
by kpk
Hi,
A:
Slice the 2 views from the 2 different cube into excel and then cut and paste one of them below the other.
B:
Build it manually from scratch manually or with formula editor (check the Creating Formulas with the Formula Editor chapter).
You can link the common dimensions (e.g. version, time, currency, cc) with Excel references.
Regards,
Peter
PS: I am almost sure that there was an example for this in the user (client?) guide in some of the 7.? or 8.? versions.
Now I have found a sample only for the Active form: "Inserting a Dependent Section".