Legacy AtScale
Installer-based AtScale
Best Practices
- Tips to Reduce Aggregate Rebuild Time to Meet the SLAs
- Using a Parameter Dimension to Implement a Server-Side Dynamic Lag Expression
- Tableau Best Practices and Support for Tableau Workbook Authors
- Setting Up AtScale API with Okta SAML
- Script to Backup/Cleanup AtScale Postgres Logs
- Modeling Month Name Object in an AtScale Cube and Sorting in a Proper Order in Tableau
- How AtScale Optimizes OLAP Queries
- How AtScale Handles Incremental Aggregate Builds
- Deploying AtScale Query Engine
- Customizing the AtScale YAML File
- Create Date Dimensions for Better Query Performance
- Changing the Default Userid and Password After Installation
- Calculated Variables Involving Aggregations in Tableau
- Avoiding Costs During Downtime
- AtScale Tabular Report Expression Examples
- Administration Tasks Best Practices
- AtScale Aggregate Best Practices
- Maintenance Plan
- AtScale Webhook Capabilities
Demos
- Security Restricted Measures Demo
- Dynamic Default Member Expressions Demo
- Excel Grouping / Ungrouping Functionality Demo
- PBI CalcGroup Formatting Demo
- Excel Date Slicer Demo
- Excel Keep Hide Support Demo
- AtScale PBI Tabular Expressions Demo
- Dimensionally Modified Aggregates (DMA) Demo
- Server-Side Context Modification Functions: ALLMEMBER() and ALLMEMBEREXCEPT() Demo
- Improved PeriodsToDate Compatibility (YTD, QTD, MTD, WTD) with Calculated Measures Demo
- Server-Side Context Modification Function: NULLEXCEPT() Demo
- I2024.2.2 BI Features and Improvements
- i2024.2.4 New Features and Improvements - Distinct Sum
- i2024.2.4 New Features and Improvements - Calculation Group References in Calculated Measures
- i2024.2.4 New Features and Improvements - Multiple Hierarchy Support for Semi-Additive Measures
- i2024.2.5 New Features and Improvements - Currency Conversion with CROSSJOIN Function
- I2024.2.7 BI Features and Improvements - System-Generated Distinct Count Aggregate Improvements
- I2024.2.7 BI Features & Improvements - Enhanced Moving Window Capabilities
- I2024.2.7 BI Features & Improvements Calc Group Expression Overrides
- DatesPeriodsToDate MDX Functions Demo
FAQ
- Why does a BI query return no data only for a particular user?
- What should be the size of the Connection Pool when AtScale is used with Impala and Admission control?
- Do I need to synchronize individual users from Active Directory or LDAP?
- When having multiple country fields (billing country, shipping country, customer country) in a physical fact table, is there a need to duplicate the Geography Dimension to link to each of these country fields?
- Why do I see Limit 0 queries on the AtScale Query screen?
- What access is needed in Sentry for Impala if UDF schema override is setup in AtScale?
- What is the difference between connection.pool.group.maxConnections and connection.pool.user.maxConnections?
- Why does the system use predictive aggregates after predictive aggregates were disabled?
- Why do BI queries execute multiple times against the raw tables instead of aggregate tables?
- When do old aggregates get deleted?
- Can the password for username "Admin" be changed through an API?
- If queries go over number of connection pools, do they get cancelled if queued for a long time?
- Can aggregate trigger files be placed in GCS instead of HDFS?
- Does AtScale purge aggregates from time to time?
- Can customers use Log4j to ship logs to their log platform?
- What Format are AtScale Aggregate Instances Stored as in HDFS?
- How do I find which cube a particular aggregate belongs to?
- Can I set "Allow access to all users" to default to OFF/Unchecked?
How-Tos
- Shut Down and Start Up Procedures for Multi-Node AtScale Environments
- How to propagate an AtScale query ID with the ID found in the SQL Engine
- How to minimize aggregate maintainer / stats checks
- How to install AI-Link
- How to implement a right outer join between fact-dimension joins
- How to disable the AtScale query cache
- How to Use AtScale GCP with a Load Balancer
- How to Update a Custom Engine Property Through the Design Center
- How to Take a Thread Dump of the Engine Process
- How to Tail Logs Directly from the Supervisor
- How to Set the JWT/Web Token Expiration
- How to Set Up an Okta Directory
- How to Set Up AtScale on GCP
- How to Scale Out an AtScale Single Instance
- How to Rebuild User Defined & System Defined Aggregates at Regular Intervals
- How to Move a Cube to a Different Database
- How to Model Complex Related Dimensions
- How to Minimize AtScale Postgres Logging
- How to Manually Upload Summary Zip/Logs from the Command Line
- How to Leverage Partition Pruning Functionality in Hive When Incrementally Building Aggregates
- How to Integrate DataDog Webhooks
- How to Integrate AtScale with Azure SAML
- How to Install the Unlimited JCE Policy in the JDK and Check if JCE is Enabled
- How to Install Standard Clustered AtScale
- How to Implement a Left Outer Join Between Fact-Dimension in AtScale
- How to Enable XMLA Query Size Protection
- How to Enable System-generated Aggs Created Based on Joins
- How to Enable Statistics for Impala SQL Engine When Hive SQL Engine is Used to Create Aggregates
- How to Enable AtScale to Use AWS Load Balancer
- How to Download Support Logs and Upload to AtScale FTP Server
- How to Disable Demand-defined Aggregate Generation in User Settings Indefinitely
- How to Deploy the PowerBI Gateway with AtScale
- How to Create, Edit and Delete a User with the API
- How to Configure VARCHAR Size For Your Data Platform
- How to Configure AtScale to Connect to HDFS Configured with HDFS HA
- How to Collect Aggregate Usage Details (# of hits, last-accessed-time, etc.) When the AtScale Engine Considers Aggregate as Unused
- Collibra - Data Catalog Software
- How to Set parquet.block.size
Product Updates
- AI-Link 2.6.0 Release Summary
- AtScale Release I2024.1.0 Summary
- AI-Link 2.7.0 Release Summary
- AtScale Release I2024.1.2 Summary
- AtScale Release I2024.1.3 Summary
- AtScale Release I2024.2.1 Summary
- AtScale Release I2024.2.3 Summary
- AtScale Release I2024.2.4 Summary
- AtScale Release I2024.2.2 Summary
- AI-Link 2.8.0 Release Summary
Technical Solutions
- With a Small Cube (Less than 20 elements), when Clicking "Update Now" or "View Data" from Tableau or Excel, There's a Planning Errors
- While connecting to AtScale cube from Excel, users are getting "No data fields are available in the OLAP cube" error.
- Where Clause is Missing in Outbound Queries on Dimension-Only Queries
- When using Excel to connect to an AtScale cube, an error prompt occurs "Errors in the ole db provider. An error occurred while loading the connection dialog box", preventing any connections to the cube.
- Unable to open client transport with JDBC Uri: jdbc:hive2://...: null: org.apache.thrift.transport.TTransportException
- Unable to load CA certificates while connecting with Tableau using an AtScale-generated .tds file
- There are more system Aggregates present than the value the retention limit is set to
- The Correct Way to Model Multiple Hierarchies Under the Same Dimension within AtScale Cube
- Running Tableau Report Causes the Following Error in the Design Center: Error during query planning: Expected two arguments for a binary operator URL Name
- Running Tableau Report Causes the Following Error in the Design Center: Error during query planning: Expected two arguments for a binary operator
- Postgres shows IPv6 socket message in logs
- Pointing existing Tableau Server reports at AtScale cubes causes slow report performance
- Modeler_backend service keeps restarting after upgrade to 2023.4.1
- In Tableau Desktop, sometimes using a filter causes an error "This query would contain joins or aggregations that are not allowed" in AtScale Design Center's "Queries" page.
- HiveAccessControlException Permission Denied: user [atscale] does not have [DROP] privilege on [hll_aggregate]
- Error after TLS/SSL implementation: Caused by: java.security.cert.CertificateException: No subject alternative names matching IP address <xx.xxx.xxx.xxx> found
- Ensure there are sufficient connections in the JDBC pool for concurrent aggregate settings
- AtScale Mitigation Procedures for CVE-2021-44228
- AtScale Fails to Sync Users Due to Timeout Issues with LDAPs Configured in the Environment
- An Aggregate/UDA is continuously attempting to build after failing with: "Timed out after total timeout [5 hours], queued for [None], with message [Timed out by master timeout control]"
- Aggregate rebuild is not being triggered by Rest API or through Design Center UI → Aggregate → Rebuild aggregates or HDFS File Location change
- After setting up TLS on AtScale HA, modeler.stdout file keeps recording "http: TLS handshake error from <IP_address>:<port>: remote error: tls: bad certificate" frequently
- Logs show error "java.lang.OutOfMemoryError:unable to create new native thread"