Search Results for "olap cube excel"

...Supports rich chart types (Apache ECharts / AntV), supports drag-and-drop method to quickly create dashboards. Support direct connection mode, local mode (based on Apache Doris / Kettle implementation). Support various data sources such as data warehouse/data lake, OLAP database, OLTP database, Excel data file, API, etc. Open source and open: zero threshold, quick access and installation online; quick access to user feedback, new versions released monthly. pport multiple data sharing methods to ensure data security.

...You can strongly type your flat file (fixed or delimited) by simply describing a class that maps to each record and later read or write your file as a strongly typed .NET array. The library also has support to import or export data from different data storage types like Excel, Access, SqlServer, etc. In almost every project there is a need to read or write data from/to a file of a specified format. For example, log parsing, data warehouse and OLAP applications, communication between systems, file format transformations (for example transforming from a fixed length to a CSV file). The FileHelpers library is straightforward to learn and use. ...

TNCLinux 2021-2 x64 Base: Ubuntu 20.04.2 LTS Long term support Architecture: Amd64 / x64 Bit processor support Legacy-Uefi Language: Multilanguage / Turkish Kernel: 5.10.18 Xanmod Modify Kernel Popular applications, essential for first and end users, are integrated. Xanmod modified fast kernel is used. It constantly receives updates with the system. It has multimedia, office, system and customized content and applications.

BTable is a component for the Pentaho Community Dashboard Designer (CDE) that extends the standard Table Component with OLAP functionalities and provides a new drill experience. Dashboard users can easily interact with the table through a context menu that allows to: - add, change or remove dimensions - add, change or remove measures - create cross tables - display grand totals and subtotals - sort by dimensions or measures - add additional filters to the table - unlink the table from the dashboard context to stop listening to external parameters - drill a cell or drill a row/column - swap axes - export data and also formatting to Excel - save the current analysis to a file Dashboard designers can build flexible and rich tables with little effort and without writing MDX queries. ...

With Alfresco Audit Analysis and Reporting (A.A.A.R.) is provided a solution to extract, store and query audit data together with the document/folder informations at a very detailed level, with the goal to be useful to the end-user in a very easy way. To reach that goal, to make the data more friendly for the end-user, the data are published in reports in well-known formats (pdf, Microsoft Excel, csv, etc.) and stored directly in Alfresco as static documents organized in folders, versioned,...

Adele was developed to simplify the daily work with data. Use it as a swiss knife to fill the gap between your work with spreadsheet application like MS Excel and enterprise servers like SAP ERP. Specialized tools like Rapid Miner, KNIME or similiary stuff should not be replaced. But Adele is designed for business people working with spreadsheet applications to analyse their data. There are many technical concepts in an easier way included. For example realtime OLAP, transformations, charts, analysis tools,... ...

OLAP technology is very useful for decision makers and data mining tools with BIG data. In this direction, we implement iCubing project with several multidimensional data cube approaches for cube indexing, querying, updating and mining. There are also several cube types, i.e. alphanumeric cubes, text cubes with unstructured data and geo cube with geo types, dimensions, measures and hierarchies, so the OLAP area continues a hard challenge after more than 20 years of the seminal paper of Jim Gray et al. in 1997. ...

...For example all open cases over time, all open cases over time and status etc. Your queries are complicated enough to end up in large SQL Views or dozen's of single SQL Queries. Implementing a real OLAP Cube would be an overkill, because you only have 10.000s of rows. LinqCube was build to reduce SQL Statements and complexity and to have most of the features a real OLAP Cube provides. See the example program for an overview of the possibilities and syntax.

The XMLA Connector provides seamless data connectivity between OLEDB for OLAP (ODBO) clients and XMLA data sources. The connector is designed to interface with XMLA compliant data sources such as Mondrian, SAP, ARQUERY as well as other data sources. The connector was released in 2014 and it is used all around the world, from small businesses to large coorporations. The connector is ODBO compliant and, as such, it loads seamlessly into ODBO clients.

OpenI plugin for Pentaho CE provides a simple and clean user interface to visualize data in OLAP cubes. It supports both direct Mondrian and xmla based connections like Microsoft SQL Server Analysis Services (SSAS), plus provides add-on features like Explore Cube Data, custom SQL for drillthrough data, publishing drillthrough data to external web services etc.

Excel Slicers are a great way to do data Mining and works great as designed. One of the features that Microsoft forgot to add in was the ability to rename a Slicer. While there is a provision to change the name, what gets used in formulas is still the automatic name that was generated. While this is not a great pain in normal circumstances, when you switch to using OLAP cubes (Powerpivot) and need to write cube formulas- You REALLY miss this one.

SIRIUS Ramsetcube 2011 born on the old Ramsetcube project of 2008. It is a powerful and easy to use cube designer aimed to help create and build OLAP schemas. The models can be exported to XML and the data format can be customized for the great OLAP

qb4j (pronounced 'cube for j') is the first open source multi-dimensional logging framework for Java coupled with an OLAP analytical platform. qb4j doesn't create log files. It creates log cubes (or cube logs).

Information manager based on 3D cubes of knwoledgments. You can create a cube with 3 axis (or dimensions), each of them with several elements. The nexus between the elements of three axis compounds a value. From a cube, you can create 2D view queries

Advanced Analysis Services is a Business Intelligence (BI) tool to let users analyze OLAP sources like Pentaho, Mondrian, Microsoft Analysis Services (MSAS) or Hyperion, in an intuitive way, based on analysis templates like Paretto, Ranking and BCG

OLAP-SC is a business intelligence application for spend + savings transparency, strategic sourcing, procurement / purchasing controlling. IT provides an olap cube model, a relational db model and controlling reports. See: http://www.orpheus-it.com

We have develop data mining 'Plug and Play' WYSIWYG Tool on commercial ERP Baan IVc4 which uses Baan 4 GL as extract and transform engine and MS excel as load client . For more information about the tool and the company , please visit www.erpjewels.com

XB-exby-eXcelBuilder is a web app to select/format data into tabular or crosstab format, then download to a *.xls file. It is meant to be a lightweight bridge between raw data and a spreadsheet, with simple options for selection/layout of data.