Linking it all together

As we’ve seen in the past, XL3Link is a flexible formula that is really worth knowing about to help easily build interlinked reports. To some extent it’s like a Swiss army knife – multi-purpose!  From highlighting a series on a chart to hosting a tooltip,  XL3Link is a flexible formula that can help make your reporting more interactive at multiple levels.

In this post we’ll be discussing a few more novel ways to use XL3Link.

Continue reading “Linking it all together”

Excel page with dynamic search

Member Searching To Create A Product Details Page

XLCubed is a great tool when it comes to member searching: it allows you to quickly and easily find members as well as dynamically update a report based on search parameters. Take a read of our last post to get started with this functionality.

The example in this post uses these searching methods to create a product search page. The left side provides search functionality for all the products contained in the cube, with a link to select the product which displays the full details on the right side.

Continue reading “Member Searching To Create A Product Details Page”

Okta and SAML blog header

Okta and SAML 2.0 SSO support in Analysis Services with XLCubedWeb

We previously briefly covered the updates to XLCubedWeb to support single sign-on using SAML 2.0, in this blog we will go through the process needed to setup SSO in XLCubedWeb using Okta and the steps required to map the users through to cube-defined roles in Analysis Services.

Continue reading “Okta and SAML 2.0 SSO support in Analysis Services with XLCubedWeb”

SAML Authentication blog header

SAML 2.0 authentication with Analysis Services and XLCubedWeb

With the upcoming maintenance release of V9.2 we are introducing support for Single sign-on in XLCubedWeb, this can be configured to use any SAML 2.0 identity provider and provides some useful functionality for integrated user-level data access in Analysis Services.

Continue reading “SAML 2.0 authentication with Analysis Services and XLCubedWeb”

Result

Common Row Highlighting

Last week’s post looked at the fundamentals of formatting XLCubed grids. A lot can be done with these techniques but sometimes more interactive formatting is desired. Within an XLCubed grid you can set Interaction Options to track which cell has been selected and output the selection and/or format it. In this post, we will look at how to apply this to highlight a row across multiple grids.

Continue reading “Common Row Highlighting”

Dashboard Designs: Dynamic Cards

Dashboard cards are a great way to group related data and make key information more accessible. The flexibility of Excel and XLCubed means there are a number of ways you might choose the incorporate a card-based design into your dashboards. In this blog we will consider one way to do this using XLCubed dashboard sheets and paged viewports.

Continue reading “Dashboard Designs: Dynamic Cards”

Combining Sets

XLCubed has lots of options for Ranking, Sorting and Filtering (And Searching. And Grouping. And, and and … 😉)

As well as all of these, one often overlooked aspect of the Advanced member selector is the member combination mode.

This enables lots of interesting scenarios, especially as you can run more advanced selections on the results of these.

Continue reading “Combining Sets”

Propagate across Sheets

Propagate across Sheets

Today’s blog will run through Propagate across Sheets – it’s an XLCubed feature that’s been around for some time but is definitely one of our hidden gems!

Propagate across Sheets is some great functionality that allows users to quickly replicate a report onto additional sheets within the same workbook or a new workbook.

Continue reading “Propagate across Sheets”