Best Practices

  • AtScale Aggregate Best Practices

    Overview To gain a comprehensive understanding of the available aggregate options and their descriptions, it is essential to review our AtScale documentation. This document, howeve...

  • AtScale Modeling Best Practices

    Introduction This document presents an overall first look at properly creating an AtScale Cube, adding best practice recommendations to common modeling routines. Naming Conventions ...

  • Change Management

    Introduction Critical systems are typically required to go through change management. Change management is a structured approach to implementing change in an organization. This art...

  • Maintenance Plan

    This document communicates the ongoing maintenance required to keep AtScale running at a high uptime by creating a repeatable schedule for a stable deployment. This document is no...

  • Administration Tasks Best Practices

    Although this list is not exhaustive, it outlines some essential duties an administrator must perform. Maintain username/password policy of AD use in directory configuration Ma...

  • AtScale Latency Myth

    This document will show what makes AtScale perform under a high concurrency workload and can impact query latency. In this document, I will show a different performance based on clu...

  • AtScale Tabular Report Expression Examples

    Introduction This functionality begins with release AtScale I2023.4.1 Tabular models and the Data Analysis Expression (DAX) language offer Microsoft Power BI users enormous analyti...

  • AtScale Webhook Capabilities

    The easiest way to set up a webhook is by setting up a public webhook.site to get the unique URL ID to do the demo. This document describes how to use AtScale with webhook.site and...

  • Avoiding Costs During Downtime

    Data warehouse platforms often support auto-suspension after certain inactivity time. This helps reducing the costs. Within this document, this is referred to as 'downtime'. The ...

  • Calculated Variables Involving Aggregations in Tableau

    Most Tableau users would have created calculated variables involving Aggregate functions (Eg, COUNT([City]), which is a straightforward way of creating a count of measures. When y...

  • Changing the Default Userid and Password After Installation

    After installation, AtScale will automatically set up the following default userid and password:Userid = adminPassword = adminChanging the password for the default user ID after in...

  • Create Date Dimensions for Better Query Performance

    If Date dimension attributes are used in filters (i.e., Year = 2016, 2017), you will get better query performance by creating an AtScale dimension from the date field in the fact t...

  • Customizing the AtScale YAML File

    This article describes how you can customize the YAML file, depending on what you want to accomplish in the AtScale topology.  Basically, we can split most of the services into a d...

  • Deploying AtScale Query Engine

    On-Prem Query_Engine This document will serve as guidance on how to deploy Query_Engine for AtScale. Requirements Three EC2 instances + n instances for query_engine Two network l...

  • How AtScale Handles Incremental Aggregate Builds

    This document describes how AtScale handles incremental builds for different scenarios. Not all aggregates are created equal. First Scenario This will show different table scenario...

  • How AtScale Optimizes OLAP Queries

    BI applications send their queries to a cube hosted on the AtScale engine. This cube metadata is used to interpret the SQL queries sent by the BI tools, optimize them for the best ...

  • Modeling Month Name Object in an AtScale Cube and Sorting in a Proper Order in Tableau

    USE CASE 1: Having Year prefixed with Month name When users model month names prefixed with Year, Tableau reads it as a string and sorts it as a string. Users need to sort the mon...

  • Script to Backup/Cleanup AtScale Postgres Logs

    This document provides instructions on how to backup Postgres logs and deletes as needed.Below commands can be used (If HA, then on both nodes) for backing up the Postgres logs per...

  • Setting Up AtScale API with Okta SAML

    This is a procedural guide on how to set up an AtScale API call when security is set with Okta SAML. Pre-requisite: you must already have Okta fully integrated with AtScale and ca...

  • Tableau Best Practices and Support for Tableau Workbook Authors

    Introduction Using AtScale with Tableau provides powerful big data performance advantages coupled with industry-leading data visualization.  The AtScale architecture allows Tableau...

  • Tips to Reduce Aggregate Rebuild Time to Meet the SLAs

      Information to Collect Check current customer aggregate lifecycle settings in  Summary Zip -->  engine --> aggregates -->config.json file. If the config.json file is empty, the...

  • Using a Parameter Dimension to Implement a Server-Side Dynamic Lag Expression

      This example aims to illustrate a model design that can compute the cumulative sum of 12 months based on a user-specified starting month and crossing year boundaries. Conceptuall...

  • Vulnerability Disclosure Program Policy

      Introduction AtScale is committed to ensuring the security and privacy of our customers. We recognize the importance of identifying and addressing security vulnerabilities in o...