Category Archives: Berry van den Heuvel
Change “signing-in-failed” message on Sign In screen
Per default, the Sign In screen looks like this;
When a user enters the wrong User ID – Password combination or when the user is locked, the Unable to Sign In and An invalid User Name or Password was entered messages appear per default.
To change the An invalid User Name or Password was entered message, follow these steps;
- log in to the server
- change directory
cd /XET/FMW/Oracle_BI_XET/bifoundation/web/msgdb/l_nl/messages/
- create a copy of securitysysmessages.xml
cp securitysysmessages.xml securitysysmessages.xml_orig
- edit securitysysmessages.xml
vi securitysysmessages.xml
- search for kmsgSecuritySysInvalidUsernameOrPassword
/kmsgSecuritySysInvalidUsernameOrPassword
- change the text between <TEXT> and </TEXT>, for example;
<WebMessage name="kmsgSecuritySysInvalidUsernameOrPassword"><TEXT>Please visit www.obiee247.com to change this message! :)</TEXT></WebMessage>
- save the file
:wq
Het bericht Change “signing-in-failed” message on Sign In screen verscheen eerst op OBIEE 24/7 | Oracle Business Intelligence.
Table is functionally dependent upon level, but a more detailed child level has associated columns from that same table or a more detailed table
Problem: Consistency Check Error No. 15019
Screenshot:
[nQSError: 15019] Table [TABLE_NAME] is functionally dependent upon level [LEVEL], but a more detailed child level has associated columns from that same table or a more detailed table. [nQSError: 15001] Could not load navigation space for subject area [SUBJECT_AREA].
Possible solution:
There are 2 columns from the same table in 2 different levels in this dimension.
- click Go To or double click on the dimension that contains the level
- remove the column that is on the incorrect level
- check in the rpd
The error message is not displayed anymore.
Het bericht Table is functionally dependent upon level, but a more detailed child level has associated columns from that same table or a more detailed table verscheen eerst op OBIEE 24/7 | Oracle Business Intelligence.
Key in logical table is a superset or subset of another key in this table
Problem: Consistency Check Warning / Error No. 39011
Screenshot:
[39011] Key '"[BUSINESS MODEL]"."[LOGICAL_TABLE]"."[KEY_NAME]"' in logical table "[BUSINESS_MODEL]"."[LOGICAL_TABLE]" is a superset or subset of another key in this table. Any redundant table key should be removed.
Solution:
- click Go To or double click on “[BUSINESS MODEL]”.”[LOGICAL_TABLE]”
- select the Keys tab
- select the incorrect key
- click remove
- click OK
- check in the rpd
The error message is not displayed anymore.
Het bericht Key in logical table is a superset or subset of another key in this table verscheen eerst op OBIEE 24/7 | Oracle Business Intelligence.
Level has no defined key to uniquely identify members
Problem: Consistency Check Warning No. 39002
Screenshot:
WARNINGS: Business Model Koninklijke Bibliotheek: Uitleningen: [39002] Level "[BUSINESS_MODEL]"."[DIMENSION]"."[LEVEL]" has no defined key to uniquely identify members.
Solution:
open logical model
- open the BUSINESS_MODEL
- open the DIMENSION
- double click on the LEVEL
- click in the section Key Name
- insert the name of the key
- click in the section Columns
- select column that uniquely defines the level
- click OK
- check consistency
Het bericht Level has no defined key to uniquely identify members verscheen eerst op OBIEE 24/7 | Oracle Business Intelligence.
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.
