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.
Multiple Views in one Worksheet
-
kpk
- MVP
- Posts: 214
- Joined: Tue Nov 11, 2008 11:57 pm
- OLAP Product: TM1, CX
- Version: TM1 7x 8x 9x 10x CX 9.5 10.1
- Excel Version: XP 2003 2007 2010
- Location: Hungary
Re: Multiple Views in one Worksheet
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".
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".
Best Regards,
Peter
Peter