XLCubed Blog | Page 3 of 16

Optimizing Excel Reports on Mobile Devices

Ambika Aggarwal/ 15th May 20195th November 2019/ Dashboard Design, Publication & Distribution

Want to view your Excel report on a mobile device? Tired of having to zoom in on your data? Well then look no further, XLCubed has you covered!

With the XLCubed Mobile App, you can take your Excel reports with you. Workbooks published to XLCubed Web can be accessed by other users on any mobile or tablet device. Furthermore, with XLCubed’s dynamic dashboards, you can optimise the display for any size screen. This eliminates unusable cut-off screens, zoomed-out views, and large amounts of scrolling.

Creating a mobile accessible report from an existing Excel spreadsheet is easy to do. Here I will show you how quickly it can be done.

XLCubed: A Beginner’s Advice

Ambika Aggarwal/ 2nd May 20192nd May 2019/ Dashboard Design, Grid & Report Formatting

I have been working with XLCubed for approximately two weeks now and when I first started, I wasn’t sure what to expect. I had come from a Mathematics background and so had no in-depth technical IT background.

Over the last two weeks, my main priority has been to get to know XLCubed like the back of my hand. At first, I was advised to run through all the XLCubed YouTube Tutorials and I must admit, it was a nice way to start learning this brand-new software. The videos were not complicated and gave a good introduction to all the different features. While watching the videos, I would try and recreate some of the things shown in the video such as grids and slicers, etc. and so was able to get a good feel for the software. However, the videos alone were not enough to get a full grasp of XLCubed and this was where the Partner Packs came in very useful. These are sample reports we provide for our partner network, and the steps to build them are documented.

Continue reading “XLCubed: A Beginner’s Advice”

Monitoring Data Comments

Gary Crawford/ 24th April 201924th June 2019/ Publication & Distribution, Reporting & Analytics

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.

Advanced Grid Reporting – MDX:

Colin Overton/ 11th April 201911th April 2019/ Reporting & Analytics

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

Antonio Remedios/ 4th April 20198th April 2019/ Reporting & Analytics

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”

Member Searching To Create A Product Details Page

Catherine France/ 27th March 201911th April 2019/ Dashboard Design, Reporting & Analytics

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”

Member Searching

Neerja Maudgil/ 21st March 201921st March 2019/ Data

Did you know how easy it is to search for members within XLCubed?

Continue reading “Member Searching”

Okta and SAML 2.0 SSO support in Analysis Services with XLCubedWeb

Craig Salter/ 4th March 201924th June 2019/ Publication & Distribution

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 2.0 authentication with Analysis Services and XLCubedWeb

Craig Salter/ 4th March 201924th June 2019/ Publication & Distribution

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”

Common Row Highlighting

Catherine France/ 20th February 201931st May 2019/ Grid & Report Formatting

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”