|
Excel OLAP Tool 2.0
|
OLAP slice. - Member grouping on any hierarchy level without changing the hierarchy levels structure. - Separate hierarchy or dimension sorting on any level. Ability of any sorting method overriding. - Ascending or descending sorting based on any column value in the OLAP grid. - Supports filtering of any set of hierarchy members with or without applying these filters in the OLAP calculations. - Auto filtering of the hierarchy members depending on
pivot, pivottable, pivoting, analysis, olap, drilling, asp net, hierarchy
olap & sql tool for building reports and analyzing data What you do with the Tool You build up reports. Table reports, table & graph reports. The reports are based on local cubes, MSAS OLAP cubes or SQL relational databases or plain excel files. First of all you have to set up datasources to be able to build the reports on. The data source could be an cub file built from excel or odbc against an excel sheet or a general odbc against a relational
reporting, olap, report, intelligence, msas, excel, free, services, business, platform, analysis
OLAP-Reports. The latter are particularly powerful tools to interactively summarise, slice and filter data without the need of an OLAP-Server. All the reports are portable and therefore ideal for off-line working forces. Quella data warehouse, reporting and data analysis package consists of two complementary computer programs: Quella Creator: ETL-Processing, Data Warehousing, Report Desing and Creation. Quella Cognitus: Charting, OLAP-Analysis, Spreadsheet
chart, data warehouse, extraction, meta data, olap, data warehousing, list, cube, loading, decision support sytem, data analysis, transformation, report