Maximum Measure objects in Web I XI 3.1

building reports webintelligence
1

Hi All,

Do we have any limit on maximum number of measure objects in a Web Intelligence Report?

I have a requirement where I need to pull 150 measure objects and 15 Dimension objects from Universe. Also I need to do two calculations on each measure objects in web I report level which will result another 300 (150 * 2) variable (measure) objects.

At the end, totally there will be 450 measure objects and 15 dimension objects. Will this be a issue? Do any one try like this report? Do we have any limits on the number of objects per report?

Appreciate your help.

Thanks
Shabo

shankarbo (BOB member since 2005-11-14)

2

Not knowing how your data is structured on the backend, you may run into a SQL query size limitation before you hit an object limitation.

digpen :us: (BOB member since 2002-08-15)

3

Another problem could be the number of rows fetched from a database into the report. With 15 dimensions, the data set will be very detailed, probably not aggregated at all.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

4

I’ve found that a report I built which uses 50+ variables ‘hangs’ upon opening in View mode, in BOXI 3.1 SP2. Although this is a report I migrated across from BOXI R2, so perhaps the variables or some other component of the report is now corrupt?

There aren’t any problems when opening the report in Edit/Modify mode though.

Aside from a building the report from scratch, I’m unsure of a workaround.

Jamesr60 :uk: (BOB member since 2009-07-14)

5

Hi,

Thanks for all your inputs. Instead of 15 dimensions, I would go only with 3 dimensions (Type, Year, Quarter) as these are required. All others are measure fields. I have reduced measure objects to 110 instead of 150.

I need to create a horizontal table report for each TYPE values QTD and YTD with variance calculation in report level

Below is the report structure:

                       QTD                                      YTD
           <TYPE>            <VAR>           <TYPE>     <VAR>     
   Key Fig1
   Key Fig2
   Key Fig3
    ---
    ---
    Key Fig110

Type has 5 values like - Actual, Plan, Prior Year, Div1, Div2
Variance will have 4 values which is based on Actual like (plan - actual, Prior year - actual, etc)
Variance has both difference and % in the report.

I could refresh the report with 3 dimension and 110 measure object. I am going to create formula’s in report level for Var and Var % which may add another 220 variable. Not sure whether the report will work after the variables created.

Thanks
Shabo

shankarbo (BOB member since 2005-11-14)