4

SSAS Cube Action Enhancements

With the new version 6.40 of BI Office, we offer  enhanced support for SSAS actions (DrillThrough and Row set) plus support for a new action: 'Proprietary'.

The enhancements include:

  1. Multi-Select Slice elements support for SSAS actions.

  2. Custom or calculated measure support for SSAS actions.

  3. SSAS ‘Proprietary’ cube actions with the BI Office API. This is detailed in a separate post.

Multi-Select Slice Element support for SSAS Actions.

With this new ability, users will have an easy and powerful way to deep dive into the source data that drives the business while slicing and dicing the data based on business needs.

An Important note is that this functionality will work on any SQL Server version with BI Office, i.e. not just SQL 2016  + Excel 2016.

In the past whenever there was a multi-select element list in the slicers, for example, 2008 & 2010 on years, the SSAS actions (Drill through and Row set) would be disabled due to limitations in SSAS.

The new capability will now allow the actions to be triggered and will return the COMPOSITE result set of those selections as expected.

 

In order to enable this functionality the switch to allow multi-selects must be enabled in the administrative console -> Action and enable it.

 

After we switch on the functionality the user can activate the SSAS action and retrieve the combined results.

 

SSAS Actions with Custom / Calculated Measure support.

In the past, if there was a custom or calculate measure in the query context, SSAS would block actions (DrillThrough and Row set). As a result, BI Office would not show the action options to the user.

With this new ability, users will have an easy and powerful ability to deep dive into the source data that drives the business while slicing and dicing the data based on the business needs even if they have used a custom measure in the query design.

 

In order to enable this functionality the switch to allow custom measures must be enabled in the administrative console -> Action and enable it.

 

After we switch on the functionality the user can activate the SSAS action and retrieve the results.

 

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like4 Follow
  • 4 Likes
  • 3 yrs agoLast active
  • 1242Views
  • 1 Following