iBI Framework

1. What is iBI Framework?

iBI Framework is an infrastructure solution package that provides essential automated management modules for building and operating Microsoft Business Intelligence (BI) systems.
Tasks that typically require extensive custom development—such as large-scale table partitioning, OLAP cube partition automation, SharePoint/Cube usage log analysis, and bulk Active Directory (AD) user management—are automated through simple configurations.

iBI Framework Microsoft BI Infrastructure Solution Package Overview

2. Table Partition Automation

Table partitioning is essential for maintaining high performance and manageability across large-scale datasets, especially when managing multiple Fact tables or fine-grained partitions.

iBI Framework Automated Fact Table Partitioning Screen

3. Cube Partition Automation

In addition to table partitioning, automated OLAP Cube partitioning is critical for managing large-volume analytical data and fine-grained Fact table partitions efficiently.

iBI Framework OLAP Cube Partition Automation Screen

4. SharePoint Usage Log

Administrators can analyze page view frequencies across SharePoint BI portals, identify underutilized screens, and track per-user page access patterns to improve operational efficiency.

iBI Framework SharePoint Portal Page Usage Log Analysis

5. Cube Usage Log

Tracks OLAP Cube query and screen access frequencies so administrators can identify unused cubes or reports and optimize BI server performance.

iBI Framework OLAP Cube Usage Frequency Log Screen

6. Integration Services (SSIS) Extraction Log

Systematically records and monitors execution history, package status, and error logs for SQL Server Integration Services (SSIS) data extraction and loading processes.

iBI Framework SSIS Data Extraction Log Monitoring Screen

7. Active Directory Management

Microsoft BI relies on Active Directory (AD) for user authentication. While small user groups can be managed manually, iBI Framework provides automated bulk user and permission management for enterprise-scale deployments.

iBI Framework Bulk Active Directory (AD) User and Permission Management

8. Stored Credential Management Automation

Automatically provisions and manages stored credentials so users on non-domain-joined machines can securely access designated BI servers.

iBI Framework Stored Credential Management Automation for Non-Domain Users

9. SharePoint Web Parts

Provides ready-to-use SharePoint Portal Web Parts—such as date pickers and organizational hierarchy selectors—to enhance end-user convenience.

iBI Framework SharePoint Portal Date and Organization Web Parts

Frequently Asked Questions (FAQ)

Q. What environment is iBI Framework designed for?

iBI Framework is an infrastructure solution package that modularizes essential automation and management features required for building and operating Microsoft Business Intelligence (SSIS, SSAS, SharePoint) environments.

Q. How does iBI Framework automate large-scale partition management?

To optimize query performance and manageability for large Fact tables and OLAP cubes, it automates both Table Partitioning and Cube Partitioning through simple configuration settings.

Q. What operational and user management features are included?

It provides SharePoint page and Cube usage log analytics, SSIS extraction log monitoring, bulk Active Directory (AD) user management, automated stored credential management for non-domain users, and SharePoint web parts.