If you are unable to create a new account, please email support@bspsoftware.com

 

How to Pick Product with Highest Quantity Shipped (Go Sales(Analysis) package

Started by msp_cognos, 08 May 2009 11:30:37 AM

Previous topic - Next topic

msp_cognos

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 ?

Filip.Cuppens

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