Tag Archives: performance

Performance on Dashboards

Hello there!

There are 2 very good TNs that talks about performance on dashboards. I’m sharing those with you guys. Below are the links:

http://community.microstrategy.com/t5/Web/TN31503-Data-Preparation-at-the-Intelligence-Server-level-for/ta-p/182414

http://community.microstrategy.com/t5/Web/TN31462-Client-Rendering-Optimizations-for-Dashboard-Performance/ta-p/182373

 

Hope it helps!

God bless you!

Enabling HTTP Compression

Hello there!

There is a nice way to increase performance on Mstr Web using HTTP Compression.

You can set that on IIS or Tomcat. Below is the link that explains the steps to do that:

http://community.microstrategy.com/t5/Web/TN31501-Network-for-Dashboard-Performance-Optimizations-in/ta-p/182412

Hope it helps.
God bless you

Report Performance Tips

Hello there,

I was searching for report performance and I found a nice post in this url:

https://community.microstrategy.com/t5/Reporting-Dashboards-and/Report-Performance-Tips-and-Tricks/m-p/278300#M11431

The user Omar V wrote some tips to help improving the report performance that you should try and see if those VLDB settings works for you.

Hope it helps!

God bless you

Performance in Unix

Hello there!

Here is a compiled list of all good TNs to troubleshooting performance issues in Unix environments:

http://community.microstrategy.com/t5/Server/TN19155-Recommended-performance-logging-counters-to-enable-when/ta-p/179379

http://community.microstrategy.com/t5/Server/TN36843-How-to-determine-CPU-intensive-tasks-on-a-Linux/ta-p/187130

http://community.microstrategy.com/t5/Server/TN14769-How-to-use-NMON-and-NMON-Analyser-to-obtain-detailed/ta-p/175234

Hope it helps!

God bless you!

Improving responsiveness of MicroStrategy Intelligence Server 9.4.x in a cluster

Hello there!

Microstrategy has released an excellent TN about performance in cluster environments.

To read about it, just use this link below:

http://community.microstrategy.com/t5/Server/TN240525-Improving-responsiveness-of-MicroStrategy-Intelligence/ta-p/240525

Hope it helps!

 

God bless you!

Performance in Reports (Part III)

Hello there!

Today I’m going to talk about a simple technique to reduce the amount of cache used in your project.

As you may know, Microstrategy is able to cache the reports to run it much faster than normal. It’s stored in memory ram and disk. So, it reduces the amount of space of your Hard Disk and Memory RAM of your Intelligence Server machine.

The idea is pretty simple:

Create a single report to be used in more than one document.

For example, if you have to bring: category and subcategory in one report and region and city in another one, you can create 1 report that contains all of those attributes and use this report for a dashboard that contains region and city and another one that contains category and subcategory.

So, always think about creating 1 report to cover more dashboards instead of creating one report for each document.

Hope it helps.

God bless you!

Performance in Reports (Part I)

Hello there!

Today I’m going to talk about a very good tip about increasing performance in reports. Ths is a very easy and simple to do. So, let’s go!

PS: This tip is only possible if you have more than 2 descriptions attribute forms in your attribute and you will not display all of it.

For this example, I’m going to:

1. Create a new report in Microstrategy Tutorial project and add: Customer and Cost to rows and columns respectively. I will only display “First Name” for Customer attribute.

pic1

pic1

Check the SQL. As you can see, Microstrategy brings the ID, First Name and Last Name from the DB.

create table ZZEA00 (
    CUSTOMER_ID    LONG, 
    WJXBFS1    DOUBLE)


insert into ZZEA00 
select    a11.[CUSTOMER_ID] AS CUSTOMER_ID,
    sum(a11.[TOT_COST]) AS WJXBFS1
from    [CUSTOMER_SLS]    a11
group by    a11.[CUSTOMER_ID]

select    pa11.[CUSTOMER_ID] AS CUSTOMER_ID,
    a12.[CUST_LAST_NAME] AS CUST_LAST_NAME,
    a12.[CUST_FIRST_NAME] AS CUST_FIRST_NAME,
    pa11.[WJXBFS1] AS WJXBFS1
from    [ZZEA00]    pa11, 
    [LU_CUSTOMER]    a12
where    pa11.[CUSTOMER_ID] = a12.[CUSTOMER_ID]


drop table ZZEA00


So, instead of removing it from your SQL, the Microstrategy Query Engine is bringing all data to the report execution, and can you choose which one you would like to display at runtime.

But, if you will never display “Last Name” column, for example, it’s not a clever thing to do.

So… Let’s really remove “Last Name” columns from your SQL.

2. Go to Data-> Attribute Display -> Select Customer from the dropdown list -> Check the second option “Use the following attribute forms” -> Remove Last Name from the Report Data Objects area.

pic2

pic2

3. Go to SQL View and now as you can see, there is no “Last Name” column!

create table ZZEA00 (
    CUSTOMER_ID    LONG, 
    WJXBFS1    DOUBLE)


insert into ZZEA00 
select    a11.[CUSTOMER_ID] AS CUSTOMER_ID,
    sum(a11.[TOT_COST]) AS WJXBFS1
from    [CUSTOMER_SLS]    a11
group by    a11.[CUSTOMER_ID]

select    pa11.[CUSTOMER_ID] AS CUSTOMER_ID,
    a12.[CUST_FIRST_NAME] AS CUST_FIRST_NAME,
    pa11.[WJXBFS1] AS WJXBFS1
from    [ZZEA00]    pa11, 
    [LU_CUSTOMER]    a12
where    pa11.[CUSTOMER_ID] = a12.[CUSTOMER_ID]


drop table ZZEA00

Doing that, your query will run faster and you will get the same result as would expect to. It’s always a good idea to remove the columns that you aren’t going to use in your report because it will decrease the amount of data brought from your Database and the amount of data transfered by the network.

If you would like to remove that column to never get that by default while using that attribute, you can:

1 Edit your attribute -> Go to Display tab and remove “Last Name” from the Display object forms section.

pic3

Hope it helps.

God bless you.