Tree Map Conditional Formatting Performance issue

[Former Member]

Hi ALL,

I have created a Tree map with 2 dimensions and with approximately 1000 rows of data. If i do not use conditional formatting in the heatmap, it performs well. When i apply conditional formatting with 3 simple conditions, the chart takes time to render and sometimes wont even come up. The dashboard just hangs.

Has anyone tried using conditional formatting for a heatmap and faced the same issue?

searched the forum, couldn't find anything with respect to this. Appreciate any suggestions on this.

Regards,

Nithin

[TammyPowlas]

Could you provide more details, like how you are applying the conditional formatting?  My guess is using BEx conditional formatting would be faster than creating the conditional formatting in Design Studio.

[Former Member]

Hi Tammy,

I am using Universe as a data source. There are 4 conditions based on a measure used in chart for color. first condition is if measure value is less than -4 then red color, second condition is the measure value <0 then orange, third condition is the measure value =0 then green and the last condition is measure value >0 then green. Attached is the screenshot. Since there is no between or <= or >= conditions available, i have used the above mentioned condition.

Thanks,

Nithin

[TammyPowlas]

Hello Nithin,

What is your BI4.1 patch level?

[Former Member]

Tammy,

it is BI4.1 SP3

Regards,

Nithin

[TammyPowlas]

Hi Nithin,

Is there any possibility you could go up to BI4.1 SP6, the latest SP?  Usually SAP tries to improve performance on each release.

Otherwise I could try to recreate your universe and see if I run into similar performance issues

[Former Member]

Hi Tammy,

At this point we are not upgrading the environment. If you can try and see if u have same issue or not, it would be helpful.  For smaller data sets its performing well. If data volume is larger, its hanging.

Regards,

Nithin

[TammyPowlas]

I'm on SP6 so it wouldn't be a valid comparison (my take only)

Usually longer-performing queries on BIP go back to a sizing/memory issue; do you have the BI Platform Support tool (free) - see  http://wiki.scn.sap.com/wiki/display/BOBJ/SAP+BI+Platform+Support+Tool to help analyze the performance of your BI Platform?

[Former Member]

Hi Tammy,

The queries are coming up pretty fast. Its the calculating the conditional formatting and rendering of the graph is the issue. Does this internal script of conditional formatting gets executed on client machine or on the BOE Server? any idea?

Thanks,

Nithin

[TammyPowlas]

Hi Nithin - I really don't know the answer to that - my guess is client side

That's why the BEx query is faster for conditional formatting - because it is on the backend.   But I understand - I will try to create a similar situation tomorrow but it's not an apples-to-apples comparison since we're on different BI platform patches.

[TammyPowlas]

Nithin: Would you also please look at this SAP note - http://service.sap.com/sap/support/notes/1931691 steps 2 & 7 are relevant; I recommend at looking at the other steps

I think step 2 may help

Tammy

[Former Member]

Tammy,

I have created a ticket with SAP. Will update on what i hear from them.

Regards,

Nithin