Category Archives: Berry van den Heuvel
Enable auto-complete for prompts
To enable auto-complete for prompts, follow these steps;
- go to the directory of instanceconfig (Locations of important files)
- edit instanceconfig.xml
- search for </ServerInstance>
- above this tag, insert this part:
</Authentication> <Prompts> <MaxDropDownValues>256</MaxDropDownValues> <AutoApplyDashboardPromptValues>true</AutoApplyDashboardPromptValues> <AutoSearchPromptDialogBox>true</AutoSearchPromptDialogBox> <AutoCompletePromptDropDowns> <SupportAutoComplete>true</SupportAutoComplete> <CaseInsensitive>true</CaseInsensitive> <MatchingLevel>MatchAll</MatchingLevel> <ResultsLimit>50</ResultsLimit> </AutoCompletePromptDropDowns> </Prompts>
- save instanceconfig.xml
- Restart processes with Enterprise Manager
- login to OBIEE with the admin user
- go to My Account
- change Prompts Auto-Complete to “On”
- click OK
- edit dashboard
- click Dashboard Properties
- Change Prompts Auto-Complete to Use user preference settings
When you start typing in a prompt, the value will be autocompleted now
Het bericht Enable auto-complete for prompts verscheen eerst op OBIEE 24/7 | Oracle Business Intelligence.
Change first column or insert column into column selector
Problem:
It is much work to change the first column of a column selector or insert a column into a column selector, when it is not at the end of the list. When you want to insert a column at position m of n, then the columns at positions (m+1, …, n) have to be deleted and have to be inserted after the new column is inserted.
Solution:
It is possible to do this by editing the XML.
- create a backup of the report in the catalog manager
- edit report
- go to the tab Advanced
- copy text in Analysis XML
- paste the text in notepad
You can insert a column or change the first column.
Insert new column:
- search for the column where you want to insert the new column before or after
- copy the part that starts with <saw:choice> and ends with </saw:choice>
-
<saw:choice> <saw:column xsi:type="saw:regularColumn" columnID="d2c6892c517fd1b18"> <saw:columnFormula> <sawx:expr xsi:type="sawx:sqlExpression">[TABLE_NAME].[COLUMN_NAME]</sawx:expr></saw:columnFormula> <saw:displayFormat> <saw:formatSpec suppress="suppress" wrapText="true" interaction="action"> <saw:actionLinks showPopupMenuForOneLink="false" appliesToTotal="false"> <saw:actionLink actionLinkID="d2c6892c517fd1b18_ald3c36d8180dbcc8b"> <saw:actionPath>[PATH]</saw:actionPath> <saw:caption> <saw:text>[ACTIONLINK]</saw:text></saw:caption></saw:actionLink></saw:actionLinks></saw:formatSpec></saw:displayFormat><saw:tableHeading/> <saw:columnHeading> <saw:displayFormat> <saw:formatSpec interaction="none"/></saw:displayFormat> <saw:caption fmt="text"> <saw:text>[CAPTION]</saw:text></saw:caption></saw:columnHeading></saw:column> </saw:choice>
- change [TABLE_NAME].[COLUMN_NAME]
- change all occurences of columnID (for example; change the first character)
- change all occurences of actionlinkID (for example; change the first character)
- change [CAPTION]
- copy the XML
- paste the XML in the report
- save report
- go to the Results tab
The new column is added to the column selector.
Change first column:
- search for the first occurence of <saw:choice>
-
<saw:columnFormula><sawx:expr xsi:type="sawx:sqlExpression">[TABLE_NAME].[COLUMN_NAME]</sawx:expr></saw:columnFormula>
- change [TABLE_NAME].[COLUMN_NAME]
- copy the XML
- paste the XML in the report
- save report
- go to the Results tab
The new column is added to the column selector.
Het bericht Change first column or insert column into column selector verscheen eerst op OBIEE 24/7 | Oracle Business Intelligence.
Presentation level has no display columns
Problem: Consistency Check Error No. 38128
Screenshot:
[38128] Presentation level '"[SUBJECT_AREA]".."[PRES_TABLE]"."[PRES_DIM]"."[PRES_LEVEL]"' has no display columns.
Solution:
- double click on “[SUBJECT_AREA]”..”[PRES_TABLE]”.”[PRES_DIM]”.”[PRES_LEVEL]” in the presentation layer
- select the Display Columns tab
- click on the green plus sign
- select the level on the left side
- select the column to display on the right side
- click Select
- check in the rpd
The error message is not displayed anymore.
Het bericht Presentation level has no display columns verscheen eerst op OBIEE 24/7 | Oracle Business Intelligence.
Deploy another repository
To deploy another repository, follow these steps.
- log in to Enterprise Manager
- click Business Intelligence – coreapplication
- click Deployment – Repository
- click Lock and Edit Configuration
- click Close
- click Browse…
- select the repository file (rpd)
- click OK
- enter Repository Password
- enter Confirm Password
- click Apply
- click Activate Changes
- click Close
- click Restart to apply recent changes
- Restart processes with Enterprise Manager
The new rpd is deployed now.
Het bericht Deploy another repository verscheen eerst op OBIEE 24/7 | Oracle Business Intelligence.
No fact table exists at the requested level of detail
Problem: Display Error in report
Screenshot:
Screenshot text:
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 14025] No fact table exists at the requested level of detail: [,,,,,,,[NAME.NAME],,,,]. (HY000)
Possible cause:
Initially, the physical tables were dragged from the physical layer to the business layer. Because of this, the logical join was created automatically. Recently, the physical join is changed, but in the Business Model the join is not changed (automatically).
Possible solution:
- open Administration Tool
- open repository
- show Business Model diagram
- remove logical join
- add logical join again
- check in
- refresh report
The error message is not displayed anymore.
Het bericht No fact table exists at the requested level of detail verscheen eerst op OBIEE 24/7 | Oracle Business Intelligence.
