VLDB Setting for Report Optimization - MicroStrategy

[@pramodbhat123]

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

[@vaishnaviv3049]

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?

[@sreism]

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.

[@JamesOliver]

Have you tried partitioning and/or sending the underlying queries to your DBA to ensure they are properly indexed?

[@fahd3710]

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

[@JamesOliver]

What is the question?

[@fahd3710]

@@JamesOliver Thanks brother, I use self service(I'm still a beginner) and I have a problem that I need help with. 1: How to fetch all columns? 2: Are there specific settings on the same page so that only the first character is typed and a drop-down list for all queries appears while writing SQL so I can choose what works for me? I appreciate if u can help 😃 Thanks,

[@JamesOliver]

@@fahd3710 Are you referring to the free MicroStrategy Desktop product?

[@fahd3710]

@@JamesOliver Hi Dear James, I do not mean that, I have a USER in the microstrategy and I receive reports ready from him, and I know where to find SQL report, and I want to modify some of them through self-service, so I asked the questions in the previous conversation. I wish you a good day. BR,

[@JamesOliver]

@@fahd3710 Ok so the only way you can modify the SQL directly is if it is a free form sql report. If it is a normal report MicroStrategy generates the SQL automatically. Yes you can view the SQL but you cannot modify it directly. Try saving the report to your "My Reports" folder. You should be able to modify it there. Hopefully this helps but I'm not totally sure that I'm answering your question.