Category Archives: Berry van den Heuvel

May 30, 2017   Berry van den Heuvel

Value Suppression not working

Sometimes it seems that the value suppression option is not working…

First of all, check if the solution is in Value Suppression

If this was not the solution to your problem, than maybe it has something to do with the columns you are sorting on…

  • open at the Criteria tab

  • add a sort to the column on which you want to apply the value suppression on, with Sort Ascending or Sort Descending

  • (optional) add other sorts with Add Ascending Sort or Add Descending Sort

  • in our example, the criteria look like this

  • open the Result tab

  • now the value suppression is working!

Het bericht Value Suppression not working verscheen eerst op OBIEE 24/7 - Berry van den Heuvel (NL).

Read More
March 29, 2017   Berry van den Heuvel

Rows with only null values are displayed OR option to disable or enable is not working

There is an option in the Pivot Table Properties, to include or exclude rows with only null values that are displayed in reports.

But sometimes, this option is not working in OBIEE 12c! What you can do is edit the XML of the report.

  • search for the tag nullSuppress=”false”

For example;

<saw:views currentView="0" textDelivery="compoundView!1" valueHierarchyIndent="false" parentsBefore="true" includeNewColumns="true" nullSuppress="false">
  • remove the nullSuppress tag
  • the rows with only null values are gone… and now this option is working again!

 

Het bericht Rows with only null values are displayed OR option to disable or enable is not working verscheen eerst op OBIEE 24/7 - Berry van den Heuvel (NL).

Read More
March 29, 2017   Berry van den Heuvel

Error While Downloading To Excel – There was an error processing your download

Problem: error while trying to download to Excel

Solution:

  • edit the config.xml
  • check the tag <XMLP> and edit as follows: 
    <XMLP>
<InputStreamLimitInKB>2048000</InputStreamLimitInKB>
<ReadRequestBeforeProcessing>false</ReadRequestBeforeProcessing>
</XMLP>
  • stop and restart OBIEE services
  • retry to export to Excel

Het bericht Error While Downloading To Excel – There was an error processing your download verscheen eerst op OBIEE 24/7 - Berry van den Heuvel (NL).

Read More
March 22, 2017   Berry van den Heuvel

Maximum number of allowed input records

Problem: error message in report

Screenshot:

Screenshot text:

Maximum number of allowed input records.

Solution:

  • log in to the server
  • go to the directory of instanceconfig.xml
cd /[ENV]/domains/bi/config/fmwconfig/biconfig/OBIPS
  • make a copy of instanceconfig.xml
cp instanceconfig.xml instanceconfig.xml[_orig]
  • edit instanceconfig.xml
vi instanceconfig.xml
  • directly above the </Table> tag, insert this <Cube> section
<Cube>
    <CubeMaxRecords>9999999</CubeMaxRecords>
    <CubeMaxPopulatedCells>999999999</CubeMaxPopulatedCells>
</Cube>
  • save the file and quit
:wq

The error message will not be displayed anymore.

Het bericht Maximum number of allowed input records verscheen eerst op OBIEE 24/7 - Berry van den Heuvel (NL).

Read More
February 24, 2017   Berry van den Heuvel

Bad xml instance! Attribute ‘skipLabels’ is not declared for element ‘labels’

When reports are created in a 12 environment, it is not possible to simply compress the reports in 12 and unarchive them in 11. When we want to run the 12-report on an 11 environment, just copy and paste the XML and apply the XML. Sometimes this error message appears;

When we scroll to the end of the message, we can see what the problem is;

Attribute 'skipLabels' is not declared for element 'labels'
  • edit the XML
  • search for the tag ‘skipLabels’
  • remove the tag skipLabels=”true”
  • apply XML
  • save report

Het bericht Bad xml instance! Attribute ‘skipLabels’ is not declared for element ‘labels’ verscheen eerst op OBIEE 24/7 - Berry van den Heuvel (NL).

Read More
« Older posts