Oracle Bi Solutions
Monday, 4 November 2013
OBIEE11g - Custom BI Time Dimension Populate Database Script.
›
1) Create database function to populate the time table in the database. CREATE OR REPLACE PROCEDURE update_day_dim (start_date IN DATE, no_o...
OBIEE 11g - Enable Report Performance Improvement in the Analysis
›
OBIEE 11g analysis has query performance option to " Share query with multiple users " To enable this option, 1. Analysis' Adv...
OBIEE11g - Enable Log-Level from Advanced Tab
›
In the Advanced tab, Add below tag in the prefix and click Apply SQL. SET VARIABLE LOG_LEVEL = 2; Log from Administration > Manage S...
OBIEE11g - Calculating First Day of Year, Quarter, Month in Answers
›
First Day of Year: TIMESTAMPADD(SQL_TSI_DAY, -1*(DAYOFYEAR(CURRENT_DATE )-1) , CURRENT_DATE ) First Day of Quarter: TIMESTAMPADD(SQL_TSI_...
Sunday, 3 November 2013
OBIEE11g - Changing Default Chart Colors
›
Change default chart colors in the OBIEE11g OBIEE 11.1.1.7.x <Middleware>/Oracle_BI1/bifoundation/web/msgdb/s_FusionFX/viewui/chart/ d...
›
Error : [nQSError: 13015] You do not have the permission to set the value of the variable View Display Error Error getting drill information...
OBIEE 11g - Query Limit
›
Query limit and number of minutes a query can run per physical layer database connection, follow the below steps. > Login to Repository u...
›
Home
View web version
