OBIEE Analytics - How to display more values on charts ?

Mithandir

Hello everybody,

I have to display a lot of values in one line chart. When i get to about 2000+ values for one criteria i have this error :

“Exceeded configured maximum number of allowed output prompts, sections, rows or column

Error Details

Error Code: IRVLJWTA

..."

After some research, i guess i have to edit some parameter in my instanceconfig.xml file, but i can't figure out wich one is the one used in charts. I could use some advice.

Thanks !

Sébastien

Joel

You'll need to look at the XML Schema Definition which defines the XML elements - Oracle Business Intelligence OBIEE 101: OBIEE obips_config_base.xsd

This should help you identify which elements you need to modify in the instanceconfig.xml file

Mithandir

This did the trick :

Added these lines to instanceconfig.xml (inside the <View> brackets)

</Pivot>

<Charts>

<MaxVisibleColumns>50000</MaxVisibleColumns>

<MaxVisiblePages>25000</MaxVisiblePages>

<MaxVisibleRows>10000000</MaxVisibleRows>

<MaxVisibleSections>50000</MaxVisibleSections>

<JavaHostReadLimitInKB>10240</JavaHostReadLimitInKB>

</Charts>

And edited one line in the config.xml file of the JavaHostComponent directory

   <DVT>

      <InputStreamLimitInKB>16384</InputStreamLimitInKB>

   </DVT>

Then reboot Presentation service & JavaHost Component.