The steps to calculate various dates in obiee are shown below First Day of the Previous Year TIMESTAMPADD( SQL_TSI_YEAR , -1, TIM...
Read More
Adding Row Number in Answers
Hi Guys, To add a row number column to your analysis, you need to do the following: Add any columns from your subject area to your ...
Read More
Increase Row Limit in OBIEE 11g
Hi All, To Increase the Row limit in OBIEE , add the following tag to the Instance config file. Make sure to take back up :) <View...
Read More
OBIEE With Essbase
Hi Guys, Hope everything is fine. Some time before I had a requirement to work with Oracle's Hyperion Essbase. And now again I am ...
Read More
Aggregate Persistence Wizard in OBIEE 11g
Hi All, Here are the steps to configure the Aggregate Persistence Wizard in OBIEE 11g It’s accessed from the BI Administrator tool, a...
Read More
Import Users from Weblogic to OBIEE 11G
Hi all, This is a problem that is seen in most of the forums. In OBIEE 11G, the users are created and administered using the weblogic ...
Read More
Setting Maximum connections in the Connection Pool
Make sure the “Max Connections” parameter on your connection pools are appropriately set (not too low….not too high!). If in doubt, yo...
Read More
Installing Loop back Adapter in Windows
Open the Windows Control Panel. Select Start > Control Panel > Add Hardware. In the "Welcome" window, click next. In ...
Read More
OPatch failed with error code = 14
Make sure that the opatch syntax is as below opatch apply -jre D:\FUSSION\Oracle_BI1\jdk\jre and make sure that all the process relate...
Read More
Using Oracle OLAP 11g with OBIEE
The cube's dimensions are associated with facts (also called "measures"). In relational terms, the facts have a many-to-one...
Read More
OBIEE Data Modeling Approach
Data modeling in OBIEE using its Administration tools involves defining the physical layer, logical layer and presentation layer . Th...
Read More
How to Fix Common OBIEE Errors
In this post I am going to cover some common errors faced during OBIEE implementation and its resolution, in the windows environment. I...
Read More
OBIEE Technical FAQ
Oracle Business Intelligence Suite Enterprise Edition (OBIEE) is a comprehensive suite of enterprise BI products that delivers a full ran...
Read More
Subscribe to:
Posts
(
Atom
)