How do I use the Crystal Analysis p

[sparky2708]

How do I use the Crystal Analysis package to interact with an OLAP cube to make entries in Excel look like:

Year: 2001 2002
Month: 1 2 3 4 5 ... 1 2 3 4 5...
<companies> <balances> ...
... ...

I basically want the year and month on different lines. Can't seem to figure out the interface to accomplish this... Or does anyone know how to do this in Excel without selecting ALL the data from the cube.

 

[OlapGuy]

You can only have one dimension on a line at a time. Since this is a common thing to do, alot of people add a second time dimension to their cubes that has just years. Crystal uses this method in some of its examples.
Since you are in excel, if you only want it for formating for printing you can edit the interface to add the line yourself.
If you are not already doing this, take notice of the pop up menus you get when you right click over a dimension. When you right click the crystal analysis plug-in gives you all of the options you have when you use the full client. You can do a tremendous amount of editing with the member selector without selecting all of the members.

-olapguy