HOME

BLOGs are one of the fastest-growing means of mass communication, which are fun to read, write, answer and improve ourself and can be enjoyable too. Started with a passion to view the blogs of the legends in OBIEE and later it became mandatory for me to keep a note of all the note-worthy informations blogged and collect new things around me. I would like to thank my friend 'VKK' to come up with this method of blogging and all the good hearts.
This Blog is only for finding solutions related to OBIEE. Please find this place to post your questions and answers related to OBIEE.  Some of the contents are already published in other blogs, but this is just a collection of them and all heartfelt thanks to each and everyone who supported for this cause.

5 comments:

  1. Hi there,
    We are having issue with export functionality on OBIEE 11g reports. The issue is common for all types of export like XLS, PDF and PPT.
    Issue:
    The complete report is exported to a single page making the export look extremely small for viewing.
    I would assume there should be a set-up to manage this. Can anyone help me with this?
    Thanks,
    Srini

    ReplyDelete
  2. Try having the reports downloaded with different browsers. I dont see the export options causing problems. And also try to increase the width and height of the sections and check.

    ReplyDelete
  3. Hi All,

    I have an existing RPD layer with Products,time and Qty table.
    Products contains PID,time contains time and Qty table contains Qty and Primary key value.

    chair--FY12MAY--300
    PHONE--FY12JUN--200
    CHAIR--FY12MAY--300
    Need help in aggreagting data per pid and time ie (300+300).I just need one records.
    Though i used aggregation levels like sum/avg/etc ,it didnt not work out.

    Any help on it please.....

    ReplyDelete
    Replies
    1. You need to use the column for which you need aggregation rule in the group by clause.
      like select sum(qty) from tables where condtion group by colum names.

      Delete
  4. Kindly post your questions in 'YOUR QUESTIONS' Tab/ Page.

    ReplyDelete

Thanks to Comment
--Add--