Question: Is it possible to sort the product by the account data value “Sales” and have the product with the greatest sales first etc.?
Question (Cont)
A Cube View was created which has a row defined as S#ACT “Actuals” and a Column defined as U1#Product.Children. An Advanced Chart was created with the Diagram Type = XY2D, Swap Axes set to True and Type is Bar Stacked. Otherwise, defaults are selected. The Advanced Chart was added to a dashboard and the products display on the Y axis in member order.
Answer
It should be possible to sort Products by Sales to display the products with the greatest sales first utilizing our XFR_MemberListRanked business rule, which is attached. Our example uses Customers in UD4 but can be used with any UD dimension like Products.
Question Follow Up:
How do you see the total for the ranked list?
Answer:
Use a dynamic aggregation in the cube view itself. Adding up the rows or columns.
Source: Office Hours 2019-11-26 Partner Enablement
Updated 2 years ago
Version 4.0