crossjoin.co.uk

Creating OR Filters With Cube Functions For Power Pivot And Analysis Services Reports In Excel

The Excel Cube Functions are incredibly powerful, and I’m still amazed at the kind of problems they can solve. This post describes how they can be used to build a report with a complex OR filter using ...
crossjoin.co.uk

Excel Cube Functions, Dynamic Arrays And Lambdas, Part 1: Getting All The Items From A Set

After my recent post on using Office Scripts and cube functions to generate Excel reports from Power BI data, Meagan Longoria asked me this question on Twitter: To which I can only reply: guilty as ...
GitHub

lesson-2-6-browsing-the-cube.md

After you deploy a cube, the cube data is viewable on the Browser tab in Cube Designer, and the dimension data is viewable on the Browser tab in Dimension Designer. Browsing cube and dimension data is ...
GitHub

Excel.PivotTable.CreateCubeFile.md

Creates a cube file from a PivotTable report connected to an Online Analytical Processing (OLAP) data source. File Required String The name of the cube file to be created. It will overwrite the file ...