![]() You can also create a new calculated (composite) field derived from mathematical functions between 2 or more member fields. For example, we have defined a new hierarchy ‘ Region Wise’ having the members Ship Country > Ship Region > Ship City, all from belonging to the Orders table. You can add a new hierarchy dimension that supports up to five (5) levels of parent-child members. Once you have chosen which fields or dimensions to include in the statistic, you can select functions for those numeric/currency fields to act as ‘measures’ in the OLAP cube, such that, statistics can be generated across other fields, based on the value of the ‘measure’ fields. are automatically pulled out, for inclusion into the cube. In the OLAP Manager (below), notice that all other fields from related tables (linked through foreign keys) such as Orders, Products, Categories etc. As there is a time and expense involved in getting answers from your databases, a lot of business intelligence information often goes unused, due to that fact that, your databases are designed to store your data, and not to help you analyze it.įrom the OLAP Manager, you can connect to a SQL Server ( Express edition supported too), Azure SQL (cloud) or to Access database ( *.mdb, *.accdb) and then select a particular table, typically, a fact or transaction table, to show up all the available fields defined for that table (and their related source tables via the foreign key).įor this example, we are connecting to the ‘ Order Details‘ transaction table of the Northwind Traders sample database, the schema of which is given on the right: Worst, if the report doesn’t have the required information, you will have to start over, wasting precious time. Some organizations even use specialized data professionals and a dozen different software packages, just to produce simple reports. It can also provide other types of valuable information such as which products give the most and least sales, and the optimum levels of goods to keep in stock, and to order.īut often, you might find yourself spending a lot of time and money trying to extract business intelligence information from your database. For example, you can calculate your net profits for first quarter and compare them with the same quarter of the previous year. ![]() And these databases can contain a wealth of information that can help you make informed decisions about your business. Many small and medium businesses to large companies use Microsoft Access, Microsoft SQL Server or Express, or even cloud-based Azure SQL databases for storing information about business transactions, plus other data such as employee and sales records. ![]() No requirement of Microsoft Excel®, Microsoft Access® or Analysis Server.Works with cloud Microsoft Azure SQL databases.Works with all versions of Microsoft SQL Server as well as Express Editions.Share pivot details, reports, offline cube, cube schema files among team members to facilitate collaboration.Export reports as BMP, GIF, JPEG, PNG, TIFF, TXT, CSV, PDF, HTML, XML, XLS.Complete control over the export settings of the grid/chart reports.Support offline cube for use in disconnected mode.Save pivot details to file (*.olapreport) to make it easy for later retrieval and use.OLAP Grid and Chart with highly interactive, customizable and user-friendly UI. ![]() E.g., Total Sales = (UnitPrice X Quantity) + Freight
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |