DataSelf Light lets you build custom reports by mixing dimensions like state and salesperson, adding color legends and filters, then drilling down to transaction details. The demo shows switching between 10 dimensions and 10+ measures, which the presenter says creates more than a million possible combinations.
Questions this video answers
0 to 200,000
$100,000
$100,000
10 dimensions on each list
More than a million ways to slice and dice the data
Chapters
Data cell flight ad hoc report providing more than 1 million ways to slice and dice your data. Right here I'm looking at the query currently showing by state showing sales for some fiscal periods according to the filter selection and dimension. I can come to this drop down list and just pick any of the options and these options are easily customizable. I'm going to choose salesperson. For now let me add one more period to this query. Let's take a look to see how color legend works. Right now we set to look at sales and this is the automatic color range. This only applies to the actual amounts, not to the totals. That's configurable. If you want to change the color legend to manual. I'm going to choose manual now. 0 to 200,000. This example, if sales is below the average, $100,000 is going to show in red. Above 100,000, $100,000 is going to be in blue. These other filters right now the top one relates to this box. So the salesperson and I have all salespeople here and I could unselect some of them in this. Total sales is actually the range of values available on this column. So right now my smallest salesperson by total sales is this one right here. And the top one is this one which is right here. If I want to only see salespeople with at least $100,000, I put the number in here, press apply and then it filters out salespeople that did not meet that criteria. Let's see the variances from period over period. I'm going to choose sales and select Sales. Sales variance and Sales variance percentage. So right here I see sales for every period and then the variance in the variance percentage. What if I want to see the correligence based on variances, I can select variance percentage. Let's make automatic. So here it highlights which ones are growing the most or decline the most in variance percentage. For now I'm back to the report looking at sales only. Let's drill down and see more details. Click the mouse over here and click the plus signal. Now I have a new column and I can pick what I want to see in this new column. Let's say sales by salesperson by warehouse. There it is. Let's drill down further. Let's put the mouse over the row header. Click the plus signal. Now I can slice by a new dimension. Let's say customer. Now when you have three different dimensions like in this case, depending how much data you have, this query can become really huge. So it usually is a good idea to start filtering this report, let's only look at customers with at least 100,000 in sales. Another way of filtering is you can pick any of these data points. Let's select this salesperson and click keep only or exclude. I'm going to click keep only for now. And let's say I want to drill down further. Let's say I want to see now product. To simplify this query, I'm going to collapse the year. So right now I have only one column. I'm still only seeing for those four periods. And I want to add quantity sold. And let's sort this in a descending order by sales amount. There it is. By just using the drop down lists Here, you have 10 dimensions on each of these lists. That means the combination of just changing all of these lists is 10 times 10 times 10 times 10, which is 10,000 possible combinations. There are more than 10 measures here, so that goes to 100,000 combinations just by using this dropdown lists and and when you look at the additional filters here, the total possible combination you can do with this query is over a million ways to slice and dice your data. What's more, if you select data points in this report like right now I'm selecting and you choose transaction details, you're going to see at the bottom all the invoice details associated to those data point selected and you see the underscored items where if you click on them you can actually open directly in acumatica this invoice or you can open the customer. If you want to explore this list in more detail, you can come to the next tab. 5.1 ad hoc details. You see the same information now with more real state you don't forget to watch the other data cell flight videos. Thanks for watching.
