OLAP Cube Dispatcher Tool

The project is in master Branch

Description

The OLAP Cube Dispatcher Tool is designed to simplify the process for account managers to connect to SQL Server and generate OLAP cubes through an intuitive interface. This tool eliminates the need for SSAS Analysis Services, making it accessible to data engineer managers without extensive training or expensive resources. Account managers can easily select analysis axes, measures, create calculations, generate OLAP cubes, and dispatch them, providing full access to the generated data.

Features

• 🧩 Connect SQL Server Interface: Easy-to-use interface for connecting to SQL Server.
• 🧩 Select Server and Data Warehouse Star Schema: Choose the server and the desired data warehouse star schema for analysis.
• 🧩 Select Dimensions and Facts: Select the dimensions and facts needed for your work.
• 🧩 Choose Measures with Functions: Select measures and apply functions such as sum, average, and count.
• 🧩 Generate OLAP Cube: Generate the OLAP cube based on your selections.
• 💾 Create Calculations Interface: Create calculations (e.g., KPI) using a user-friendly interface (e.g., measure1 * measure2).
• 🔍 Test OLAP Cube via Excel: Verify the OLAP cube by testing it in Excel.
• 🔍 Manage Calculations on Existing Cubes: Manage and update calculations on existing OLAP cubes.
• 🔍 Dispatch Cube Structure: Dispatch the cube structure to other data sources without needing to recreate the interface for generating OLAP cubes.

Getting Started

Prerequisites

• Visual Studio 2019
• Mtero Framework
• Sql Server 2019
• MDX
• Analysis Service
• Microsoft Excel
• SSIS

Contributing

Contributions are what make the open source community such an amazing place to learn, inspire, and create. Any contributions you make are greatly appreciated.

1. Fork the Project
2. Create your Feature Branch (git checkout -b feature/AmazingFeature)
3. Commit your Changes (git commit -m 'Add some AmazingFeature')
4. Push to the Branch (git push origin feature/AmazingFeature)
5. Open a Pull Request

License

Distributed under the MIT License. See LICENSE for more information.

Contact

Mohamed Nour KHammeri - @My-Web-Site - mednour.khl@gmail.com

Project Link: https://github.com/mednour2019/devolap