Kyubit Business Intelligence · Microsoft Analysis Services

SSAS Reporting Tools for OLAP Cubes and Tabular Models

Give your existing SSAS models a browser-based reporting and analytics interface. Explore measures and dimensions, build interactive dashboards, and share reports with your colleagues—all on your own infrastructure.

Kyubit connects directly to SQL Server Analysis Services Multidimensional and Tabular. Keep your existing semantic model and business logic, and give users a visual way to answer their own questions.

Download Kyubit & start your trial See the analysis experience
  • SSAS Multidimensional
  • SSAS Tabular
  • Self-hosted
  • Browser-based analytics
Kyubit SSAS analysis grid with sales measures, country and state hierarchies, and visual slicers
Explore your SSAS data in Kyubit, then save the results as reports and dashboards. View full-size screenshot.

Why use Kyubit with your SSAS environment?

Your cubes and models already contain valuable measures, hierarchies and business rules. Kyubit makes that investment accessible through self-service reporting.

Use the models you already have

Connect to existing Multidimensional cubes and Tabular models without rebuilding them in a new semantic layer.

Explore beyond a dashboard

Work with multiple measures, dimensions on both axes, drill-down and slicers in an interactive analysis grid.

Create reports visually

Business users can build analyses by dragging measures and dimensions. Kyubit generates the queries behind the interface.

Move from analysis to reporting

Save the analysis, present results in Report View, or use your SSAS data in charts, KPIs and dashboards.

Share and schedule results

Give colleagues access to saved content and schedule email delivery for recurring reporting tasks.

Deploy on your infrastructure

Run reporting within your environment, with Windows authentication and SSAS access configured for your organization.

Watch SSAS OLAP reporting in action

See how Kyubit connects to Analysis Services and lets users explore measures and dimensions, drill into results and create dashboards.

Watch the SSAS demo on YouTube or browse more Kyubit product videos.

From an existing SSAS model to a shared report

  1. ConnectConfigure a connection to your SSAS server and select the cube or Tabular model.
  2. ExploreSelect measures and dimensions, then drill, slice and filter to answer a business question.
  3. PresentSave your analysis as a report or build a dashboard with charts and KPIs.
  4. DistributeShare the saved content with colleagues or set up scheduled delivery.

Built for SSAS Multidimensional cubes

Make existing OLAP cubes available through a web interface. Users can navigate dimensions and hierarchies, explore measures and calculated members, and drill into results without rebuilding the cube.

Connect to SSAS Tabular models

Use the measures and hierarchies exposed by your Tabular model in the same reporting environment. Your SSAS model remains the source of business definitions and calculations.

Kyubit queries SSAS directly. Results reflect the data available in the model; model processing, query complexity, server resources and configured caching affect freshness and response times.

Explore SSAS data in an interactive analysis grid

Start with a business question, then change the view as you investigate. You can add dimensions to rows and columns, compare measures side by side, and move from a summary to a more detailed view.

Drill, slice and refine the analysis

  • Drag and drop measures and dimensions onto the grid.
  • Drill down on both axes to explore hierarchy levels.
  • Expand individual items or expand the dimensions in the view.
  • Use slicers and Quick Slicers to focus on a product, region or time range.
  • Sort results and use calculations to examine performance.
  • Drill through to detail records where the model and permissions support it.

See more examples of interactive OLAP analysis tools and drill-through analytics.

Present the results in Report View

Once you have the values you need, switch to Report View to present the results with fewer analysis controls. This gives readers a focused view of the numbers while analysts retain their interactive workspace.

Keep technical flexibility

Visual analysis does not require users to write MDX or DAX. For technical users, Kyubit also provides browser-based MDX query functionality.

SSAS grid analysis: measures, hierarchies and slicers
SSAS grid analysis: measures, hierarchies and slicers

Answer recurring business questions with time intelligence

How are sales changing?

Use relative time selections such as Last 7 Days, Last 6 Months or Year to Date, and compare performance with previous periods.

Where is the difference?

Break results down by region, product or customer, then drill and filter to investigate which parts of the business changed.

Are we meeting our targets?

Analyze actual and budget measures where available in your SSAS model, and present performance through KPIs and scorecards.

Explore time intelligence for OLAP analysis. Available period selections depend on the time dimension and its configuration.

Period comparison: current values, previous values and change
Period comparison: current values, previous values and change

Turn SSAS results into dashboards your colleagues can use

Combine charts, KPI cards and scorecards to present the measures that matter. Use dashboard filters to focus the view and configured interactions to move into more detailed analysis.

Monitor performance at a glance

Show sales, margin, operational metrics or financial results using the measures already defined in SSAS. Add trend charts and period comparisons to provide context.

Share a common reporting workspace

Give authorized colleagues browser access to saved dashboards. Configure refresh and caching to suit the reporting workload and the processing schedule of your SSAS models.

Kyubit interactive dashboard for SSAS reporting
Present SSAS measures through charts, KPIs and interactive dashboards.

See Kyubit dashboard capabilities.

Share, schedule and distribute SSAS reports

Share saved reports and dashboards

Organize results in a shared reporting environment and manage who can access them. Readers can return to the saved report while analysts continue exploring the underlying data.

Automate recurring delivery

Set up scheduled subscriptions for regular report and dashboard delivery. Provide weekly sales summaries or recurring management updates without manually preparing each email.

See scheduled report and dashboard delivery for supported output and scheduling options.

Choose the delivery schedule and recipients to match your reporting workflow. Scheduled output uses the configured execution identity; email attachments contain copies of the results.

Keep SSAS reporting on your own infrastructure

Install Kyubit on your own infrastructure. Users access the application in a browser, and the Kyubit server connects to Microsoft Analysis Services. Your existing SSAS model remains the analytical source.

Kyubit deployment: browser access, web server and SSAS Multidimensional or Tabular models
Deployment: browser access, Kyubit web server and SSAS models

Windows and Active Directory integration

Use Windows authentication and configure the identity used for SSAS connections. SSAS permissions apply to the identity executing the query; preserving individual users' data access requires the appropriate connection and impersonation setup.

Control application and data access

Manage access to Kyubit reports and dashboards alongside permissions in SSAS. Review connection identities, subscription credentials and any delegation requirements during deployment.

See the installation and administration guide (PDF) for server setup and Active Directory authentication.

SSAS reporting capabilities at a glance

Core functionality for existing SSAS environments. Availability depends on what your model exposes and the configured permissions.
CapabilityMultidimensional cubesTabular models
Direct SSAS connectionSupportedSupported
Measures and hierarchiesUse cube metadataUse model metadata
Visual grid analysisSupportedSupported
Drill-down and slicersSupportedSupported
Drill-through to recordsSubject to model and permissionsSubject to model and permissions
Time intelligenceRequires configured time dimensionRequires configured time dimension
Reports, dashboards and KPIsSupportedSupported
Scheduled deliverySupported; configure execution identitySupported; configure execution identity

Review the product documentation for setup and model-specific behavior, and validate your SSAS environment during the trial.

Is Kyubit the right reporting front end for your SSAS models?

Evaluate it against the tasks your users perform most often. The trial lets you test the reporting experience with your own model, permissions and workload.

Interactive exploration

If users need to change dimensions, drill down through hierarchies and answer follow-up questions, test Kyubit's grid with a real analytical task.

Repeatable reporting

If readers need the same results regularly, test Report View, dashboard access and scheduled delivery with a representative report.

Deployment and access

If self-hosting is a requirement, review server requirements and validate Windows authentication, SSAS roles and the connection identity in your environment.

What users say about cube analysis

“Ad-hoc querying against existing cubes is far superior than using Excel add-ins out of the box.”
David O'Brien · Suburban Propane
Customer testimonial published on the Kyubit homepage

Before you install: plan your SSAS evaluation

Validate your SSAS setup

Connect a representative Multidimensional cube or Tabular model. Test hierarchies, measures, user permissions and reporting workloads using the product documentation.

Frequently asked questions about Kyubit and SSAS

Can Kyubit use my existing SSAS cube without rebuilding it?

Yes. Kyubit connects directly to your existing SSAS model. You do not need to recreate its semantic layer in Kyubit to analyze and report on it.

Does Kyubit support Multidimensional and Tabular?

Yes. Kyubit supports SSAS Multidimensional cubes and Tabular models. Measures, hierarchies and available detail operations depend on the model you connect to.

Do business users need to write MDX or DAX?

No. Users can build visual analyses with measures, dimensions and slicers. Kyubit generates the queries for these interactions. Technical users can also work with its MDX query functionality.

Does Kyubit preserve individual users’ SSAS permissions?

SSAS evaluates permissions for the identity used by the connection. Configure authentication, impersonation and any necessary delegation to apply the intended user identity. A shared connection identity does not automatically preserve each viewer’s individual SSAS restrictions.

Can I schedule SSAS reports and dashboards?

Yes. Kyubit provides scheduled subscriptions and email delivery. Configure the execution identity, recipients and output options for the content being distributed.

How current are the results, and what determines performance?

Results depend on the data available in SSAS and your refresh and caching settings. Response times depend on the model, query complexity, result size, server resources and workload. Test representative analyses during the trial.

Can I try Kyubit with my own SSAS environment?

Yes. Download the trial, review the installation requirements, and connect a representative cube or Tabular model. Validate analysis, reporting, user permissions and scheduled delivery before production deployment.

Try Kyubit with your own SSAS data

Connect a cube or Tabular model and test the complete workflow: explore the data, save a report, build a dashboard and share the results. Start with the questions your team needs to answer.

Download Kyubit & start your trial

Explore related SSAS and OLAP capabilities