Just wondering what’s up. I have a pretty small data set and I’m looking to merge the dimensions of two queries for a high level summary. The dimensions are pretty basic, just 4 four-letter codes. When I do a MERGE DIMENSIONS, it runs for a long time until I get bored and crash-close WebI.
Anyone know what’s up?
Robbo75 (BOB member since 2009-08-24)
I have seen this on occasion. The merge process usually is very quick and takes little time. When I see it get stuck on the merge dimension screen (after clicking on OK) for more than 10 seconds I know it will not return. I then get completely out of Webi and close the internet explorer window to get the java runtime to shut down and go back in and it will work fine the second time. It doesn’ happen often and when it does happen it doesn’t seem to matter which fields I am merging or how much data I have in the report.
Couple of things you might check is to try to do the merge prior to pulling data back although I have not seen a pattern on whether I do it before or after refreshing the report. You also might check your java runtime version to make sure you have the correct version installed.
jbarnes794 
(BOB member since 2008-06-13)
Thanks! I’m about to try that but can you help me with which runtime I should have? I’m current on Java.
Also, does it matter that the merge field values come from lookup tables? I’m working with a normalized table here so most of my fields are lookups. Should I include a class with key values to be used for merges?
Robbo75 (BOB member since 2009-08-24)
As long as the objects are defined as dimensions you should be able to merge on them regardless where the data for each object comes from in your database. At the point that webi merges the data it is looking at the datasets from each dataprovider not your databases structure.
The version of Java Runtime to use differs depending on your environment. We are using BOXI 3.1 and have found that you can use java runtime version 6 update 3 to update 11. I have tested BOXI 3.1 SP2 with the latest version of Java and it seems to work fine but we have not moved out of testing yet with BOXI 3.1 SP2.
jbarnes794 (BOB member since 2008-06-13)