I am working with Analysis Studio with 'Go Sales(Analysis)' package. I need to know which particular Product has the highest 'Quantity Shipped' in Q1 2007. How can I get that information. In the Product Dimension, I have the Products arranged by Levels..but how can I pull in the actual products to my analysis window directly , so that I can rank them as per my wish ?
Seems this request open is for quite a while, so i guess you've found teh solution by now ?
But if not ...
Right-Click in the insertable objects on any given product, and select Insert level as Rows
Drag 2007 Q1 as column
define Mease Quantity Shipped as Default Measure
Create a Rank => with Top 1 => it will return a report with 1 row, being the Product with the largest quantity shipped
Regards