In the DW world, the word “dimension” is overloaded — changes meaning depending on context. Here is an example. On a certain date, a customer walks into a store and buys a product. This example has four dimensions (date, customer, store, product) and one fact (sales). So a typical Kimball star would look like: A … Read more
This sort of approach does actually work very well. You haven’t given any idea of what your data/metadata is like, but the concepts can be explained with a simple example. Consider the following data: We will make a simple report based on this, grouped by the grp column: Sort the groups by total val, from … Read more
Here’s two more ways of formatting a size in bytes: 1) Using a switch() function Format-Size() { [CmdletBinding()] param( [Parameter(Mandatory = $true, ValueFromPipeline = $true)] [double]$SizeInBytes ) switch ([math]::Max($SizeInBytes, 0)) { {$_ -ge 1PB} {“{0:N2} PB” -f ($SizeInBytes / 1PB); break} {$_ -ge 1TB} {“{0:N2} TB” -f ($SizeInBytes / 1TB); break} {$_ -ge 1GB} {“{0:N2} … Read more