Skip to content
Dashboard Gear Logo
  • Solutions
    • Connectors
      • Finance
      • Human Resources
      • Supply Chain
    • Other Solutions
      • Consulting Services
      • Report Distribution Toolkit
  • Events
  • About Us
    • Company
    • Contact Us
  • Resources
  • Request a Demo

Filtering Data in Excel with Cube Pivot Tables

In today’s session, we’ll demonstrate the various ways to filter your Analysis Services Cube Data when doing a Pivot Table.

rsbendickson2020-09-04T11:48:55-06:00August 28th, 2020|Categories: Friday LIVE Recordings|Tags: Analysis Services, cubes, Video|
Read More

Conditional Formatting Cells in an Excel Cube Query

Join Rich Bendickson of Dashboard Gear as he discusses how to conditionally format cells in a SSAS Excel Cube Pivot Table.

rsbendickson2020-08-07T08:55:32-06:00August 7th, 2020|Categories: Friday LIVE Recordings|Tags: cubes, Excel, Video|
Read More

Excel « CubeValue » Function

How to use the CubeValue function in Excel to extract an aggregated value from an Analysis Services Cube.

rsbendickson2020-07-24T14:18:35-06:00July 17th, 2020|Categories: Friday LIVE Recordings|Tags: Analysis Services, cubes, Excel|
Read More

Benefits of a Datamart and Analysis Services Cubes

Why you need to have a datamart and cubes as part of your data solution.

rsbendickson2020-07-24T14:13:03-06:00July 10th, 2020|Categories: Friday LIVE Recordings|Tags: Analysis Services, cubes, Datamart, Video|
Read More

Using an Excel Slicer with a SSAS Cube

Discover Excel’s powerful filtering mechanism – the slicer. Join Rich Bendickson of Dashboard Gear as he walks through how and when to use a slicer with your SSAS cube data.

rsbendickson2020-06-10T10:13:45-06:00May 26th, 2020|Categories: Friday LIVE Recordings|Tags: cubes, Excel, Video|
Read More

Supply Chain Reporting and Analytics Webinar

Learn how Dashboard Gear’s Reporting & Analytics Platform for Infor Supply Chain helps make reporting & analytics simple and accessible for Supply Chain/Procurement professionals.

rsbendickson2020-05-20T14:12:11-06:00July 10th, 2018|Categories: Past Webinars|Tags: cubes, Reporting, Supply Chain, Video, Webinar|
Read More
  • Role Properties

Analysis Services Security

We commonly receive questions about Analysis Services security. In this tutorial, we walk through the steps of how to define users and what they can access.

rsbendickson2020-05-20T14:12:32-06:00June 12th, 2018|Categories: Security|Tags: Analysis Services, cubes, Video|
Read More

Search

Weekly BI Tips and Tricks to improve your reporting and analytics skills.

Don’t miss it!
Subscribe to our
YouTube Channel.

Archives

  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • March 2020
  • August 2018
  • July 2018
  • June 2018
  • May 2018

Recent Posts

  • How to Freeze and Repeat Headers in SSRS
  • Using Temp Tables in SSRS Reports
  • Percentage of Sales Calculation in SSRS
  • SQL Server Linked Servers
  • Connecting PowerBI to Microsoft Analysis Services Cubes
Copyright 2020 Dashboard Gear | All Rights Reserved | Powered by WordPress | Terms of Service | Privacy Policy
facebooktwitteryoutubeEmail