ishirvani opened a new issue, #30184:
URL: https://github.com/apache/superset/issues/30184
Apache Superset currently lacks native support for SQL Server Analysis
Services (SSAS), a popular OLAP (Online Analytical Processing) platform.
Integrating SSAS into Superset with support for MDX (Multidimensional
Expressions) queries, dimension and database management, pivot table
functionalities, and domain user login would greatly enhance its analytical
capabilities.
### Motivation
Adding these features to Superset will provide several benefits:
1. **Advanced Query Execution**: Allow users to execute MDX queries directly
within Superset, facilitating complex analytical operations on multidimensional
data.
2. **Dimension and Database Management**: Provide functionality to browse
and manage SSAS cubes, dimensions, and databases, similar to how Excel
interacts with SSAS.
3. **Pivot Table Capabilities**: Enable users to create and interact with
pivot tables directly within Superset, offering a familiar interface for data
analysis.
4. **Domain User Login**: Allow users to log in with domain credentials that
have access to SSAS cubes. This feature will integrate domain authentication,
simplifying user management and access control.
5. **Streamlined Workflow**: Integrate SSAS capabilities directly into
Superset, reducing the need for additional BI tools and streamlining workflows.
### Proposed Solution
1. **Connection Support**:
- Implement support for connecting to SSAS using appropriate drivers and
connection strings. Add configuration options for SSAS connections.
2. **MDX Query Execution**:
- Develop and integrate a custom SQLAlchemy dialect to handle MDX
queries. Enable users to execute and visualize MDX query results within
Superset.
3. **Dimension and Database Management**:
- Implement features for browsing SSAS cubes, dimensions, and databases.
This functionality should be user-friendly and similar to Excel’s interface
with SSAS.
4. **Pivot Table Functionality**:
- Integrate drag-and-drop functionality for creating and manipulating
pivot tables using SSAS cube data within Superset.
5. **Domain User Login**:
- Add support for domain user authentication. This should allow users to
log in with their domain credentials that have access to SSAS, simplifying the
process of accessing and managing SSAS data.
6. **Documentation and User Guide**:
- Update Superset’s documentation to include instructions on configuring
SSAS connections, executing MDX queries, managing dimensions, using pivot table
features, and setting up domain user logins.
7. **Testing**:
- Conduct comprehensive testing to ensure that the SSAS connection, MDX
query execution, dimension management, pivot table functionalities, and domain
user login work seamlessly. Include unit tests and integration tests with SSAS.
### Additional Context
- **Use Case**: Many organizations rely on SSAS for complex analytics and
multidimensional data analysis. Adding these features to Superset will provide
a unified platform for advanced analytics and reporting, especially for users
relying on domain credentials for access.
- **Related Issues**: If there are any related issues or discussions, please
link them here for reference.
### Steps to Implement
1. **Create a Custom SQLAlchemy Dialect**: Develop and test the custom
dialect for handling MDX queries and SSAS connections.
2. **Develop Dimension and Database Management**: Implement browsing and
management features for SSAS cubes and dimensions.
3. **Integrate Pivot Table Functionality**: Enable drag-and-drop pivot table
creation and manipulation.
4. **Add Domain User Login**: Implement support for domain user
authentication with SSAS.
5. **Update Documentation**: Provide clear documentation and examples for
users.
6. **Perform Testing**: Validate functionality through rigorous testing.
Thank you for considering this feature request. Implementing these
enhancements will provide significant value to users who depend on SSAS for
their business intelligence needs and wish to leverage Apache Superset for
advanced analytics.
---
iman shirvani
_Originally posted by @ishirvani in
https://github.com/apache/superset/discussions/30182_
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
