Hierarchy – XLCubed Blog ../../../ XLCubed Blog Thu, 10 Jan 2019 08:20:17 +0000 en-GB hourly 1 https://wordpress.org/?v=5.3.21 ../../../wp-content/uploads/2016/09/cropped-logo_512_512-150x150.png Hierarchy – XLCubed Blog ../../../ 32 32 Report Flexibility, with Control ../../../2015/05/report-flexibility-with-control/ ../../../2015/05/report-flexibility-with-control/#respond Tue, 12 May 2015 07:01:06 +0000 http://blog.xlcubed.com/?p=4219 Sometimes we want to let report users modify the structure of a report but to govern exactly what they can and can’t do. While Grids can be restricted at a granular level to enable and disable functionality, that approach still requires some degree of product knowledge by the user. XLCubed provides the XL3SetProperty() formula, which […]

The post Report Flexibility, with Control appeared first on XLCubed Blog.

]]> ../../../2015/05/report-flexibility-with-control/feed/ 0 Parent-Child Dimensions in Analysis Services – Performance Walkthrough ../../../2011/06/parent-child-dimensions/ ../../../2011/06/parent-child-dimensions/#comments Thu, 30 Jun 2011 09:21:29 +0000 http://blog.xlcubed.com/?p=2480 Parent-child hierarchies are a good fit for many data structures such as accounts or employees, and while they can speed development in some cases, they can also cause performance problems in large cubes. We often see customers with these type of performance issues, and thought it worth sharing a simple technique for altering the dimension […]

The post Parent-Child Dimensions in Analysis Services – Performance Walkthrough appeared first on XLCubed Blog.

]]> ../../../2011/06/parent-child-dimensions/feed/ 13