Category Archives: Berry van den Heuvel
Calendar icon not displayed in prompt
Sometimes after editing a variable prompt, the calendar icon is not displayed anymore, while the Variable Data Type is Date.
To show the icon again, follow these steps;
- make a copy of the prompt
- open the catalog manager
- move to the prompt
- edit XML
- change
-
<saw:promptUIControl xsi:type="saw:editBox">
in
-
<saw:promptUIControl xsi:type="saw:calendar">
- save the XML and log in to OBIEE
- the calendar icon is displayed again and a date can be selected after clicking on it
Het bericht Calendar icon not displayed in prompt verscheen eerst op OBIEE 24/7 | Oracle Business Intelligence.
Apply patches
You can apply patches for OBIEE by following these steps.
- download the patches at www.oracle.com
- create a temporary directory. For example;
mkdir /Patches
- go to the directory
cd /Patches/
- copy the patches to this directory
- unzip the downloaded files (this can take a while)
unzip -q '*.zip'
- add the path to OPatch to the PATH directory
ORACLE_HOME=/u01/app/oracle/fmw/Oracle_BI1 export ORACLE_HOME PATH=$PATH:$ORACLE_HOME/OPatch export PATH
- run the stop commands
- for each patch, change the directory to the directory with name = [patchnumber]
- apply the patch for each patch seperately (answer Y on any question proceed?)
opatch apply
- verify if all patches are installed
opatch lsinventory
- run the start commands
OBIEE is patched now! 
Het bericht Apply patches verscheen eerst op OBIEE 24/7 | Oracle Business Intelligence.
The physical column has property Length set to zero
Problem: Consistency Check Warning No. 39064
Screenshot:
WARNINGS: GLOBAL: [39064] The physical column '[PHYSICAL_SCHEMA].[PHYSICAL_DB]."S_NQ_ACCT"."QUERY_BLOB"' has property Length set to zero.
Solution:
When you view data in physical layer, the column is not displayed in the results
- double click on the physical column, in this case QUERY_BLOB
- set Length to 4000 (= maximum size)
- click OK
- check consistency
Het bericht The physical column has property Length set to zero verscheen eerst op OBIEE 24/7 | Oracle Business Intelligence.
HTML in column heading
It is possible to use HTML tags in column headings.
- edit a report
- edit column formula
- check Contains HTML Markup
- enter Column Heading (for example the tag <br> is used)
- go to Results
The tag <br> is read as a HTML Markup and handled as a “break”. We can see that the “C” is under the “B”.
Het bericht HTML in column heading verscheen eerst op OBIEE 24/7 | Oracle Business Intelligence.
Logical element has no physical data link
Problem: Consistency Check Error No. 42004
Screenshot:
[nQSError: 42004] Logical element [ELEMENT] (ID=2006:232445) has no physical data link. [nQSError: 23013] An error occurred when extracting the metadata definition for the Attribute '[SUBJECT AREA].[TABLE].[COLUMN]'. [nQSError: 15023] Error in setting up logical column measure: [COLUMN]. [nQSError: 15001] Could not load navigation space for subject area [SUBJECT AREA].
Cause:
The physical column that belongs to the presentation column [ELEMENT] is deleted, but the logical column where this physical column was mapped to, is still in the logical model.
Solution:
- insert the physical column again or remove the logical column
- check in
Het bericht Logical element has no physical data link verscheen eerst op OBIEE 24/7 | Oracle Business Intelligence.
