So, a simple sql statement to get the SalesTerritoryGroup from the adventure works database. It has done a select distinct DimSalesTerritory.SalesTerritoryGroup from DimSalesTerritory where not DimSalesTerritory is equal to ‘NA’ order by DimSalesTerritory. When we hit show data and you can see the SQL that has been issued. We will turn on capture SQL so you can see what is going on. We are calling the result at A A which is called a capsule variable. It is getting us all the territories except the NA one. You see this is dim sales territory out of the adventure works database. Now the first thing we have is this thing called a sales territory query. This is the capsule I am going to show you today. You can see I have opened up a folder called Adventure Works.Īnd inside that folder I have another folder called report examples.Īnd inside that folder I have a capsule with Adventure Works Example Report 01. So here we are on my meta5 workstation desktop. That’s what we are going to show you today. “What makes Meta5 different to SSAS? Why would we use Meta5?” This is a demonstration for more technical people who are asking: Todays demonstration is the details of showing you how that is possible.
That is what the previous demonstration was all about. Then put it into the One Drive, and have the one drive send it out to the users, ready waiting for them at 9 o’clock in the morning when they come in to work. What this demonstration shows you is that it’s possible to produce the excel spreadsheet in a centralized location, say, near your data warehouse or near your ER. Or if you have to be linked back to an SSAS server for them to do that and you have to have high speed connections? So if you have a large number of users who want excel reports across your organization and it is costing you time and effort and trouble to do that? The prior demonstration was to show you at a high level that this is possible, this is viable, and it gives you the ability to do excel reporting out to the masses across your company, faster, cheaper and better. The placement of excel reports in folders is controlled through the capsules. Your users receive their excel dashboard via such mechanisms as the one drive or sharepoint portal or whatever mechanism is being used to receive reports. These dashboards are sent out via such tools as One Drive, and then your One Drive distributes the reports according to the rules that have been defined. It is just a 10 minute video that shows you that it is possible to create what is called a Meta5 capsule.Ĭapsules can run in your ETL stream after all your data is prepared and capsules can create many reports.Ĭapsules can send out individual, customized Excel dashboards containing only the data that is necessary for the individual people who are the users of those dashboards. The prior video we just released talks at a very high level. Todays video is going to be the very detailed demonstration of our prior summary video about Meta5 and Excel reporting. I really appreciate your attention so thank you very much for that. My name is Mihai Neacsu and I am the business development manager here at BIDA.įirstly I’d like to say thank you very much for coming along and watching our latest video today.
0 kommentar(er)
