Improve Web Report Studio performance by carefully choosing processing locations

2

Information Map Studio allows data managers the ability to join tables, create new data elements, and label/format data items for business consumption. However due to this flexibility users must weigh the benefits of customizing information maps against the performance impacts of completing many of these tasks within the Information Map itself.

From anecdotal evidence (in 3.1), I have seen information maps successfully join small tables and display a few custom measures. However, when large tables are joined or a large number of custom measures are utilized, the performance (within Web Report Studio at least) can be dramatically impacted. (Note - I have found that running a test in Information Map for these cases is not indicative of the performance in Web Report Studio.)

So, once all the Web Reports are created and the performance improvements are required, how (in 3.1) can we switch where the custom measure is derived (from an expression within Information Map Studio to a data item in the source table/cube) without crashing the Web Reports?

Two options:

  1. You can add these items and modify the associated web reports by hand - or
  2. You can modify the XML to ensure that all the web reports use the new item instead.
Add the new measures into a copy of the original imap. Save out the xml & copy the new data element items from within the <ExternalResourceList ...> tagged area (located around the end of the xml file). Now in the original imap, export the XML and copy these new measures within the <ExternalResourceList ...> tagged area.
Then to switch the dataitem from a calculated expression to one of these new data elements follow the example below.

Included is what a simple calculated expression looks like in the information map XML:
<expr>
<resourceawarestrexpr exprtype="2" scope="2">
<reposobjuse prid="XR1">
<string strvalue="/">
<reposobjuse prid="XR2">
</resourceawarestrexpr>
</expr>

In order to 'trick' the information map into using a different data element, you need to change the entire xml block below into the following:
<Expr>
<ReposObjUse prid="XR3" />
</Expr>

Where the XR3 corresponds to the new data element item in the <ExternalResourceList ...> tagged area added earlier.

Of course - ALWAYS take a backup of the Information Map (and all associated WRS reports) since XML editing can introduce it's own problems.

Share

About Author

Angela Hall

Senior Technical Architect

Angela offers tips on using the SAS Business Intelligence solutions. She manages a team of SAS Fraud Framework implementers within the SAS Solutions On-Demand organization. Angela also has co-written two books, 'Building BI using SAS, Content Development Examples' & 'The 50 Keys to Learning SAS Stored Processes'.

2 Comments

  1. Thanks for the info..

    Can any one help me with this plz

    I need to create a bar-line chart where i can use the "Subgroup" option "stacked bar" which is available under the Graph type-"BAR" and also a bar-line "Line-height" in the same bar, which you see under graph type- "Bar-Line".

    Example display:-

    Bar height- Total Salary
    line height- No. of Employee
    Category- Month
    Bar- subgroup- GENDER( Male/Female)

    Hope to hear from you sooner!

    Thanks!
    Amit

Back to Top