Workbook format in XLCubed ribbon

Using Grid Styles in XLCubed

This week’s blog is a quick tip on Grid formatting options. Did you know that XLCubed comes with ten pre-formatted grid styles which you can easily switch between?

These are available from the Workbook Format button on the XLCubed ribbon (the option remains greyed out until an XLCubed grid is added).

Continue reading “Using Grid Styles in XLCubed”

A View of Usage Metrics Report

Usage Metrics in XLCubed

With a wide range of reports being accessed and published daily, it is important for administrators and management to be able to keep abreast of their usage. Common questions are:

  • What reports are being published?
  • How many reports have been updated?
  • How long are they taking to open?
  • Who is publishing the reports?
  • Which reports are not being used?

Our latest 9.2.47 release provides an updated version of the Usage Metrics Dashboard for XLCubed Web which gives visibility on the questions above and more.

Continue reading “Usage Metrics in XLCubed”
Monitoring Data Connected Comments In Excel Blog Header

Monitoring Data Comments

Many BI and reporting tools now allow users to collaborate directly with a report. This avoids the cumbersome backwards and forwards of email chains or the need to meet in person.

As useful as this is, some organisations have concerns about the ability to monitor comments made. We will discuss this aspect in more depth after a brief introduction to comments and collaboration.

Continue reading “Monitoring Data Comments”
XLCubed showing an element we wish to remove an update the totals

Advanced Grid Reporting – MDX:

This weeks blog is for the more technically minded among our user base and our partner network – not for everyone, but highlights some potentially very powerful capabilities!

We will be looking at using MDX: and MDXSet: along with Query Generators to create sub-cubes, meaning we can develop advanced reports that would otherwise be difficult to achieve.

Continue reading “Advanced Grid Reporting – MDX:”

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”

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”

Workbook Aspects – Same Report, Different View

A common scenario in business reporting is for different users to want reports to open with ‘their’ view on the data. So for a particular Store or business unit.

Many back-ends already support setting Default Members for different users and groups, for example Analysis Services allows this, but as XLCubed can connect to an increasing number of back-ends we can’t rely on this and sometimes a single report user may have different combinations of views on data (for example, a set of store/product group combinations)

Version 9.2 of XLCubed has added Workbook Aspects to help with this, allowing users to store their own slicer selections and quickly switch between those and also to set the default for when the report is loaded.

With this feature you can define the aspects at a report level, shared by all users, and also allow users to define their own private aspects.

Continue reading “Workbook Aspects – Same Report, Different View”