Excel Cube Formulas | Locii Solutions

Following requests by some of our clients, we have created a video that demonstrates OLAP cube formulas, and how they are used in many of the dashboards/ reports that we create for Insight users.

via Latest News.

http://office.microsoft.com/en-001/excel-help/excel-functions-by-category-HA102752955.aspx#_Toc309306707

While PivotTables are an ideal tool for quickly exploring your data and finding a wide variety of answers in an ad hoc manner, they are not as well suited for building fixed reports with irregular or custom layouts. Here are a few quick examples:

  • “Asymmetric reports,” wherein the rows or columns don’t follow a fixed pattern in terms of the data they contain (more on this below)
  • Reports that mix data from multiple data sources
  • Reports that require a lot of custom spacing and/or precise grouping and ordering, often in a different way than the data is stored in the data source

via Excel Blog – The Excel 12 Blog Rides Again, or “CUBE Functions Part 1”.

How to approach a cube function report, using a scrap sheet
Mastering the CUBE Functions in Excel 2013 | TechEd New Zealand 2013 | Channel 9.

How to use cube variables in report titles
http://www.cimaglobal.com/Thought-leadership/Newsletters/Insight-e-magazine/Insight-2013/Insight-September-2013/Excel-extras-using-Excel-Cube-functions-with-PowerPivot/

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s