New Data Analysis Views

[Bill Mc]

I'm using PS 2007 and would like to know if there is any good documentation
on how to create new views in Data Analysis? I've been successful in getting
my OLAP cube built but want to make sure that I'm configuring the cube
dimensions corrrectly and then know the nuances in developing new views under
Data Analysis. I have quite a few custom columns and want to do some
reporting that include them. Is there any good documentation available to
assist in creating these views?

Thanks

 

[Ben Howard]

Hi Bill,
The views are fairly easy to create. For training purposes I always start
with a blank view, and then just drap and drop the dimensions in. Note that
for 2007 you have to add in the relevant dimensions to the cube in the cube
configuraiton screen, so you need to do this for your specific enterprise
codes, and these will need to be based on a look up table. Any enterprise
fields that are numeric become data fields, and again, need to be
specifically added to the cube.

PS2007 builds 14 cubes, the fields and descriptions are available in the SDK.

You can add MDX calculations to the cubes, there isn't much on this but for
example if you wanted to calculalate availability you could create a field
called availability and type in [capacity] - [work] in the formula and that
would work for you. You can also use calculated fields in the PWA view
rather than doing it in the cube. I suspect that this is less performant.

Finally, as with all the views, make them specific to a single function,
keep them simple, and determine whether its the values, graphs for both that
people want.

Good luck.