This topic has 2 replies, 2 voices, and was last updated 4 years, 1 month ago by 
.
-
Posts
-
-
Can we create a view that shows product category sales by sales region showing all product categories, whether they have sales or not?
-
There are options in the rows (and columns) properties that allow you to show all unrelated and empty rows. These work slightly differently depending on if the listed dimensions are related and/or virtuals. That said the general idea in your example would be for you to turn off the relationship filter and the empty filter on the rows. Be careful using these options on large dimensions like product and ship to since you will get a list of everything. You can control the detail list (prod cats in your case I believe) using a user list and/or filter. With prod cats you are probably ok to just let the list happen since there are probably not a ton of prod cats. You might want to use an axis filter to remove the ‘?’ and ‘%’.
-
Thought I’d post an example of a void view using some of the techniques mentioned in earlier posts.
Couple of things – note that the Relationship Filter and the Empty Row properties are set to No. This allows all data to display, even if there is no data, in this case sales, for that row. Sounds good for void reporting until you realize that means ALL, as in all customers and/or all products. You need a way to limit what displays when we are showing empty rows.
So…..in this view only the customers in a particular City are displayed – this is controlled by the relationship of City to Customer, which is defined using the virtual dimension concept. Basically the City is an attribute (PUF) of the Customer SoldTo, so Stratum knows to only show those customers that are in a particular city. Virtual dimensions are one way to control what is listed in a view that has the Relationship and Empty filters set to No.
Also note that only certain Products are listed, instead of ALL products. The list of products is being controlled by a User List that selects a set of target Products. This filter means only those products in the list will display instead of ALL products.
Last note that the blue cells are where we have no product sales for a give customer/product combo. Also note that last years sales are displayed. You could add traffic lites to show where customers bought last year but not this year and/or where sales were down this year vs. last.
Not a bad View if you’re looking for voids within your customer base for certain products. You could do this view at levels above product as well, say product line or group.
-
You must be logged in to reply to this topic.
