This IT project is part of our digitalization and optimization of our customers’ IT landscape. Through targeted measures, we promote technological progress, optimize cross-system processes and create a sustainable basis for future developments. Our IT reference projects serve as a basis for orientation. They support the reusability of tried and tested concepts as part of project implementation.
This is one of 4837 IT projects that we have successfully completed with our customers.How can we support you?
Rights management for analysis services
Project duration: 8 months
Brief description
As part of this project, a tool for user-friendly rights management is created for Microsoft SQL Server 2005 Analysis Services, which replaces the Microsoft Management Studio for this function.
Supplement
The tool is developed in Microsoft .NET as a Windows desktop application. AMO (Analysis Management Objects) and ADOMD (ActiveX Data Objects Multi Dimensional) are used to access the SQL Server 2005.
Subject description
In the project, a tool is to be created that users without any knowledge of the Analysis Services syntax (MDX) can use to assign rights to cube cells and cube dimensions. Dimension authorizations are to be copied from one database role to other roles. Furthermore, a user interface is created in which roles can be tested and the test can be documented.
IT project data
- Industries pharmaceutical industry
- Specialist tasks authorization management
- DP tasks Data Warehouse
- System environments Client/Server
- Procedure model PTA project manual
- Programming languages C-Sharp, MDX
- Development and test tool MS Visual Studio .NET
- Operating systems Windows 2003, Windows XP
- Middleware and frameworks MS SQL Server Analysis Services (SSAS)
Project period30.11.2006 - 31.07.2007
Customers who trust us
