VLDB Setting for Report Optimization - MicroStrategy

preview_player
Показать описание
In this video I will show you a VLDB setting that could help you optimize long running reports or resolve issues with reports that are timing out.
  1. James Oliver
  2. microstrategy vldb settings
  3. microstrategy intermediate table
  4. microstrategy report optimization
  5. microstrategy report timing out
  6. microstrategy report time out
Рекомендации по теме
VLDB Setting for 0:04:23

VLDB Setting for Report Optimization - MicroStrategy

VLDB Settings Pre 0:05:16

VLDB Settings Pre Post Statements - MicroStrategy

UDO: Universal Database 0:20:36

UDO: Universal Database Optimizer (VLDB'22)

VLDB Settings - 0:04:02

VLDB Settings - Custom SQL Column Pattern - MicroStrategy

VLDB 2015: Multi-Objective 0:17:39

VLDB 2015: Multi-Objective Parametric Query Optimization

AutoSteer @ VLDB 0:09:45

AutoSteer @ VLDB 2023

VLDB Settings for 0:06:49

VLDB Settings for Left Outer Joins - MicroStrategy

AIDB@VLDB 2020 Autonomous 0:17:36

AIDB@VLDB 2020 Autonomous Index Tuning

[VLDB 2023] SageDB: 0:15:01

[VLDB 2023] SageDB: An Instance-Optimized Data Analytics System

VLDB 2018 Talk 0:17:06

VLDB 2018 Talk (Vocalization)

Data Vocalization at 0:25:33

Data Vocalization at VLDB 2017

MicroStrategy Performance Tips 0:07:49

MicroStrategy Performance Tips and Tricks - Top 5 Tips and How to's - Omars BI Blog

Demand-based Sensor Data 0:07:02

Demand-based Sensor Data Gathering with Multi-Query Optimization @ VLDB 2020

VLDB-2020 Talk for 0:09:58

VLDB-2020 Talk for Paper16D-3-657

Database Tuning Tools 0:09:40

Database Tuning Tools that 'Read the Manual' (VLDB'21)

VLDB 2021 Video: 0:10:00

VLDB 2021 Video: Applying Machine Learning-based Database Tuning in Production

Identifying Insufficient Coverage 0:09:46

Identifying Insufficient Coverage of Databases with Multiple Relations || VLDB 2020

VLDB 2021 0:10:14

VLDB 2021

Quantum Computing for 0:23:49

Quantum Computing for Query Optimization (VLDB 2016 Talk)

vldb demo 0:05:32

vldb demo

ScalarDB @VLDB'23 0:14:17

ScalarDB @VLDB'23

SQL Performance Tips 0:08:47

SQL Performance Tips

[VLDB 2021] CoroBase: 0:09:59

[VLDB 2021] CoroBase: Coroutine-Oriented Main-Memory Database Engine

Databases: How to 0:01:37

Databases: How to optimize concurrent restoration of multiple VLDB user DBs?

Комментарии
Автор

Hi Oliver, I'm new to Mstr and I need your input here: We have around 5 datasets plugged into the dossier and that dossier takes forever to run. I tried to optimize the SQL within those datasets (in-memory reports with up to 350k rows in each report) but no luck. Also, there is a huge grid visualization in the dossier with more than 20 attributes and metrics from those 5 datasets. Currently that dossier runs for several minutes and sometimes it even times out. What can I do to optimize performance?

vaishnaviv
Автор

Need your input Oliver, We have around 15 dashboards which uses a cube and some users create vi dashboards on the fly using this cube .so is there any vldb settings I change at the cube level which can help in improving the performance and data retrieval faster.

sreism
Автор

Additional pass for the lookup table also helps in improving query performance.

pramodbhat
Автор

hi Dear, if u Can how to used Self- Service. Tax

fahd