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. 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
  3. 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
    Oracle , OBIEE
  4. 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:	897 
Size:	18.6 KB 
ID:	1435  
  5. 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
    ...
  6. 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
    ...
  7. 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
  8. 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
  9. 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
    OBIEE , Oracle
  10. 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
  11. 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
  12. 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 ...
  13. Preview Your Password Before Signing In To Any Web Account In IE (Internet Explorer) 10

    After upgrading my Windows 7 to Windows 8 Pro, I started exploring IE 10. I am astounded by the fact that truly IE 10 is performing better than my all time favorite Firefox. Moreover, all of a sudden, I came across a very useful feature which allows users to preview their password out of masked dots (........) . Sometimes, while typing a password we get confused of the letters typed and need to start over. Password faults may also occur from time to time and you don't get to know about that until ...
    Tags: ie 10, windows 8
    Categories
    Windows
  14. How To Save A Webpage In PDF Instantly Using Android Devices?

    You save a webpage to PDF for later use, either for reading or printing somewhere else. Moreover, saving a webpage to HTML format is now old-school activity. Had the web browsing restricted to only desktop then there would have been lots of options available for the purpose like CutePDF, Google Chrome etc. But, web browsing is increasingly becoming essential activity for Smartphone and Tablet users.

    If you are using android devices, then the conversion is possible instantly with ...
    Categories
    Smartphones
  15. How to Read a Text File Using a Java Stored Procedure?

    You can read a text file using a Java Stored Procedure. This involves the following steps:

    1. Create a text file called test.txt in the tmp directory to run the sample.

    2. Create the Java Class from the JAVA source provided.

    3. Create the PLSQL wrapper function for the java class and method being exposed.

    4. Grant the proper FILE IO permissions to the USER that will call the JSP.

    5. Call the Java Stored Procedure.
    ...
    Categories
    Oracle
  16. How To Create Large Number Of Hypothetical or Dummy Users Using Oracle PL/SQL For Performance Testing Of An Application ?

    Generally, for performance testing of an application we need instant dummy users which can act as real users signing in to the application at the same time. Authentication is then controlled through a table which might contain the users and the corresponding password (and any other info you might include like User Name etc). For large user base of around 1 million or so we need accomplish the user creation task with the help of anonymous PL/SQL block.

    Let us create a table driving ...
    Categories
    Oracle
  17. How To Convert Text Files To PDF Using Android Devices?

    Recently, an update from one of my favourite android app compelled me to share it with all the members out here. At last, someone has come up with an option of converting text files to PDF. Yes, now you can create a PDF file easily using your android devices.
    OfficeSuite 6 Pro allows you to do this with it's latest update.

    Update your pro version now and do the following:

    1) Open full version of OfficeSuite 6 Pro.

    Click image for larger version. 

Name:	OfficeSuite6.jpg 
Views:	6176 
Size:	63.9 KB 
ID:	1335
    ...
  18. How To Use V$SESSION To Identify The Performance Bottleneck?

    Identify the State of the session
    Code:
    SELECT sid, state
        FROM v$session 
     WHERE username = 'Schema_name';

    Identify the EVENT the session is waiting for

    Code:
    SELECT sid, state, event, seconds_in_wait   FROM v$session 
     WHERE username = 'Schema_name';



    Identify the blocking session

    Code:
    SELECT sid,state,event,blocking_session 
      FROM v$session 
     WHERE username = 'Schema_name';

    Analyze what the blocking session
    ...
    Categories
    Oracle
  19. SQL Query To Prepare Gather Stats Statements For All Tables In A Schema

    The PL/SQL package DBMS_STATS lets you generate and manage statistics for cost-based optimization. You can use this package to gather, modify, view, export, import, and delete statistics. You can also use this package to identify or name statistics gathered.

    The DBMS_STATS package can gather statistics on indexes, tables, columns, and partitions, as well as statistics on all schema objects in a schema or database. It does not gather cluster statistics--you can use DBMS_STATS to gather ...
    Categories
    Oracle
  20. SQL Query To Find Out The Indexes Details In a Schema

    We all know the importance of Indexes and how it benefits in optimizing the SQL query.

    In short , we can say that indexes are useful for faster access to rows in a table, where as they can be disadvantageous when the table size is small and we use the index to get the data.In my project issue , I came across this SQL query that performs fetching the details of indexes
    in a table .

    Note: Execute this query in the schema from which you want to fetch details ...
    Categories
    Oracle
Page 1 of 28 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.