Loading
View RSS Feed

Recent Blogs Posts

  1. Usage Tracking in OBIEE

    Introduction
    The Oracle BI Server supports the collection of usage tracking data. When usage tracking is enabled, the Oracle BI Server collects usage tracking data for each query, and it writes statistics to a usage tracking log file or inserts them directly into a database table.
    The Oracle BI Server supports the accumulation of usage tracking statistics that can be used in a variety of ways such as database optimization, aggregation strategies, or billing users or departments based ...
    Categories
    Oracle
  2. Oracle Database 11g: Advanced PL/SQL

    Dear All,

    Please download the whole dump from from here:1Z0-146.doc


    Sample Questions and Answers:

    Which two statements are true about the initialization of internal LOBs?
    Which two statements are true about the initialization of internal LOBs? (Choose two.)
    A.
    The EMPTY_CLOB() and EMPTY_BLOB() functions can be used to initialize only null internal LOBs.
    B.
    The EMPTY_CLOB() and EMPTY_BLOB() functions can be used ...
    Categories
    Oracle
  3. Oracle 1Z0-525 Dumps: Oracle Business Intelligence Applications 7 for ERP Essentials

    Dear All,
    In this blog, we are posting set of questions asked in the Oracle Business Intelligence Applications 7 for ERP Essentials (1Z0-525) certification examination.


    Please comment below to let us know in case of any concern and query.

    Download the full set of questions with answers:1z0-525 dumps.doc

    Oracle Business Intelligence Applications 7 for ERP Essentials

    Oracle Business Intelligence (BI) Applications are complete, prebuilt ...
    Categories
    Oracle , OBIEE
  4. Step by Step Solution: Oracle PL/SQL Developer Certified Associate

    Dear All,
    Being Oracle PL/SQL Developer certified gives you the highlight from the other associates. In this blog, we will post the process of getting OCA certified.

    Oracle PL/SQL Developer Certified Associate
    Oracle PL/SQL Developer
    Oracle offers a complete, integrated set of application development tools that support any development approach, technology platform, or operating system.
    Oracle PL/SQL Developer Certified Associates demonstrate expertise in building ...
    Categories
    Oracle
  5. Key Points of Data Warehousing

    Dear All,

    In this blog, they key points related to Data Warehouse is given. We will keep updating/inserting new findings.

    Here are the key points:

    • A data warehouse is a relational database that is designed for query and analysis rather than for transaction processing.
    • It usually contains historical data derived from transaction data, but it can include data from other sources.
    • We can divide IT systems into transactional (OLTP) and analytical (OLAP).
    ...

    Updated 10-01-2013 at 09:27 AM by angad

    Categories
    Oracle , OBIEE
  6. Scripts to Create and Populate Parent-Child Relationship Table in OBIEE 11G

    Dear All,

    Please find below the code to create the code to create the Parent-Child Relationship Table.
    Table name : SAMP_CREATE
    Code:
    CREATE TABLE SAMP_CREATE ( MEMBER_KEY DOUBLE PRECISION, ANCESTOR_KEY DOUBLE PRECISION, DISTANCE NUMBER(10,0), IS_LEAF NUMBER(10,0) )
    Please find below the code to create the code to populate the Parent-Child Relationship Table.

    Code:
    declare 
    
    v_max_depth integer;
    
     v_stmt varchar2(32000);
    
     i integer;
    ...
    Tags: obie11g, pl/sql.
    Categories
    OBIEE , Oracle
  7. How To Display Multiple Values In A Single Row With Session Variable in OBIEE 11G?

    How To Display Multiple Values In A Single Row With Session Variable in OBIEE 11G?
    The below stated method is generally used when to assign the multiple security groups to a single user and displaying the same in the reports in a single row.
    Suppose a person is provided three security roles.
    ROLE_A, ROLE_B, ROLE_C
    Now, when a person logins to the OBIEE analytics and the requirement is to display the roles in single row.

    ...
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	session7.JPG 
Views:	58 
Size:	18.6 KB 
ID:	1435  
  8. 1Z0-051 Dumps: Oracle Database 11g: SQL Fundamentals I

    Dear All,
    In this blog, we are posting set of questions asked in the Oracle 1Z0-051 Oracle Database 11g: SQL Fundamentals I certification examination.

    Please comment below to let us know in case of any concern and query.


    Download the full set of questions with answers:
    1z0-051_dump_tf4u.rar

    Oracle Database 11g: SQL Fundamentals I
    ...
    Categories
    Oracle
  9. 1Z0-047 Dumps: Oracle Database SQL Expert

    Dear All,
    In this blog, we are going to post set of questions asked in the Oracle 1Z0-047 Oracle Database SQL Expert certification examination.

    Please comment below to let us know in case of any concern and query.


    Download the full set of questions with answers: 1Z0-047-SQL dumps.zip

    Oracle Database SQL Expert
    ...
    Categories
    Oracle
  10. 1Z0-144 Dumps: Oracle Database 11g: Program with PL/SQL

    Dear All,
    In this blog, we are going to post set of questions asked in the Oracle 1Z0-144 Oracle Database 11g: Program with PL/SQL certification examination.

    Please comment below to let us know in case of any concern and query.


    Download the full set of questions with answers: 1Z0-144_v1 Dumps.zip

    Oracle Database 11g: Program with PL/SQL
    ...
    Categories
    Oracle
  11. 1Z0-515 Dump: Oracle Data Warehousing 11g Essentials

    Dear All,
    In this blog, we are going to post set of questions asked in the Oracle 1Z0-515 Oracle Data Warehousing 11g Essentials certification examination.

    Please comment below to let us know in case of any concern and query.

    1.
    Identify the true statement about REF partitions.
    Indentify the true statement about REF partitions.
    A.
    REF partitions have no impact on partition-wise joins.
    B.
    Changes to partitioning in the parent ...
    Categories
    Oracle , OBIEE
  12. C Program To Copy a File Using Command Line Argument

    C Program To Copy a File Using Command Line Argument:-

    Code:
    # include <stdio.h>
    # include <conio.h>
    # include <stdlib.h>
    # include <string.h>
    
    void main(int argc,char *argv[])
      { 
         FILE *p,*s;
         char a;
         clrscr();
         p=fopen(argv[1],"r");
         s=fopen(argv[2],"r+");
           if (argc!=3)
             {
               printf("Wrong
    ...
  13. C Program To Remove The Repetition Of Each Character In a File Using Command Line Argument

    C Program To Remove The Repetition Of Each Character In a File Using Command Line Argument:

    Code:
    # include<stdio.h>
    # include<conio.h>
    # include<stdlib.h>
    # include<string.h>
    
    void main(int argc,char *argv[])
    {
    FILE *p,*q;
    char a,i;
    char b;
    clrscr();
    p=fopen(argv[1],"r");
    q=fopen(argv[2],"r+");
    if(argc!=3)
    {
    printf("wrong number
    ...
  14. Oracle 1z0-591Dump: Oracle Business Intelligence Foundation Suite 11g Essentials

    Dear All,
    In this blog, we are going to post set of questions asked in the Oracle 1z0-591
    Oracle Business Intelligence Foundation Suite 11g Essentials certification examination.

    Please comment below to let us know in case of any concern and query.




    Oracle 1z0-591
    Oracle Business Intelligence Foundation Suite 11g
    Essentials

    QUESTION NO: 1
    When a customer wants to get sales numbers by day, how is data ...
  15. Realtime OBIEE Reporting With No Cache Hit On Each Run

    OBIEE is for ad-hoc reporting on an OLAP database. This might be near to real time but not real time. Sometimes requirement might ask for realtime fetch of results hitting OLAP database bypassing all types of cache (i.e, Server, Presentation and even Browser cache). Every time, you open the report you get the latest data sets available in the database. The report becomes so realtime that once you insert,update and delete a row in a database, the report run will show exact resultset change when run ...
    Tags: obiee
    Categories
    OBIEE
  16. Solution For- 'Error retrieving user/group data from Oracle BI Server's User Population API' In OBIEE 11.1.1.6.0

    Hello Friends,

    Last week I went through a pathetic situation where I deployed bundle Patch 8 to my ongoing project implemented on 11.1.1.6.0. Several bugs in 11.1.1.6.0 are turned out to be showstoppers and we had no other way than deploying the latest BP8 patch set. We were very relaxed thinking that patch deployment would not be big deal as Oracle claims it to be flawless and several blogs here are there are explaining about this without mentioning any big issue as such.
    ...
    Tags: obiee
    Categories
    OBIEE
  17. OBIEE 11 G : Tips To Remember Before Creating Reports.

    To make reports in OBIEE is not very difficult. OBIEE is so user friendly and easy to use. Dragging the columns and putting the required filters will do the minimum needed. There are lot of other very dynamic features in OBIEE. OBIEE is a very helpful reporting tool.

    If you are working on small project, then you need not plan much. But when you are working on big project and there is requirement of much number of reports, then a serious planning before making reports would help you ...
    Categories
    Oracle , OBIEE
  18. How To Make An OBIEE Dashboard Behave Like A Link To An External Website Or Another Application?

    Sometimes when we integrate any other application with OBIEE, we need to create a link to the other application. OBIEE only allows creation of Dashboard and Pages, and Links can only be added to pages. But it is quite unprofessional to click on a Dashboard to land to a page and then click on the link on that page to navigate to another application. We need to make the Dashboard link behave like an external link so that when we click on that OBIEE will navigate directly to another application or ...
    Tags: html, obiee
    Categories
    OBIEE
  19. Solution For "OBIEE 11.1.1.6 Installation Fails or Hangs At Configuration Progress Step"

    Recently, I upgraded my system to Windows 8 and decided to load OBIEE 11.1.1.6 for exploring the new feature in it. After several attempts I found that the installation is either failing or hanging at configuration Progress step (13 of 14). Javaw.exe process becomes inactive and does not seem to be utilizing any CPU and memory resources. The system hangs and disk utilization shows 100%. In such circumstances I have no other option than killing the processes. But at last I succeeded in installing ...
    Tags: obiee, oracle
    Categories
    OBIEE
  20. How To Export Internet Explorer Favourites (Bookmarks) To Android Stock Browser (Default Internet Browser)?

    In today's world web browsing is frequent activity in Smartphone as it is in Desktop/Laptop. You might want to sync your Desktop bookmarks or favourites with Android. People often talk about the bookmarks sync in Android Firefox and Chrome. But what about the Internet Explorer?

    In this post I will discuss about the steps required to export your IE bookmarks to your Android's default browser (Stock Browser).

    System and Software used for the steps:-

    i) Windows ...
Page 1 of 29 12311 ... LastLast



Disclaimer: Users of techforum4u.com are responsible for ensuring that any material they post (article, blog posts, images or other mulitimedia content) does not violate or infringe upon the copyright, patent, trademark, or any personal or proprietary rights of any third party, and is posted with the permission of the owner of such rights.Anyone who violates these rules may have their access privileges removed without warning.