Twin graphs on OLAP Cube

[Newbie]

Hello,
Is it possible to build 2 Cubes, one for year 2005 and one for year 2006,
then to share/merge the 2 data cube in one graph which'll show January 2005
and January 2006 alongside...etc ?
Thanks

 

[Marc Soester]

Hi Newbie,

At this stage you are not able to splitt the cubes, but I believe you dont
need to, since 2005 and 2006 data will be in one cube. If you would split the
cube and then have a virtual cube to bring them back together, you may as
well use the one cube you have.
I believe that within Portfolio analyser you are able to create 2 Graphs
anyway. ( I have done this a long time ago). Have a look and play with the
portfolio views and I am sure that you are able to do what you want to have.
I hope that helps

 

[Newbie]

Marc,

<<able to create 2 Graphs>> ?
I want only one graph with a 12 months X axis (January to December), and for
each month the 2 Work values : 2005 and 2006. Do you think that's possible ?
Thanks for any suggestion.

 

[Marc Soester]

Hi Newbie,
I see this was a misunderstanding on my behalf.
What you can do is create a calculated memeber within the Portfolio
Analyser. You can refer to the "work" measurement and give it a filter of
2006. This would allow yo to display the "normal" work and the "filtered"
work on your Graph. I hope this puts you in the right direction