Ask Me

Post Your Questions Here,so that i’ll get back with answers which you will find in this blog


631 responses to “Ask Me

  1. G Kishore

    August 25, 2008 at 11:39 am

    Hi, Shiva… Glad to meet you..

    • keerthi

      June 13, 2011 at 3:46 pm

      hi can u plz explain use of allias tables in physical layer

      • madasameee

        July 16, 2011 at 11:28 am

        Hi Keerhi,
        The alias table in physical layer aiming mainly at Multiple drill down for a single table. Say a day table “W_DAY_D” has many columns ( Day, Month, Week, Year, fiscal Year ). To drill down everything as per requirement, we create multiple alias table and use different PRIMARY keys and drilling the same table. This is the main use of having Physical Layer.

      • keerthi

        November 25, 2011 at 8:01 am

        why should we avoid circular joins in physical layer

      • Siva Reddy

        February 23, 2012 at 10:43 am

        Hai Keerthi,

        Because of improving the performance that y we don’t use the circular joins in physical layer.and obiee does’t supports self join in this situation we are creating the alias tables it is the best practice technique.

      • sekahr reddy

        May 22, 2012 at 5:24 am

        alias tables are derived from physical tables to meet the particular requirements.
        alias tables are used to join to the tables multiple times with different conditions
        alias tables are provide different information for the different join conditions.

        if u want to use the table more than once in query then we can create the alias tables for that tables

        usually obiee does not support self join functionality to implement this functionality we will create alias tables in the obiee

      • Praveen Chandra

        May 31, 2017 at 3:53 pm

        Hi shiva & All,
        We mainly use for re usability of the table

    • Ramana

      November 6, 2011 at 5:09 am

      HI Shiva,

      We are going to develop reports on R12 Error Tables which are in Oracle Apps. In some Tables they don’t have Primary key column and also don’t have any numeric values.. How can do report on this. Please suggest me. It is little bit urgent..


    • jagadish

      December 16, 2011 at 11:12 am

      Hi Can u plz explain, how to enable grand total button in obiee table view by defaulty.
      by default it is in disable i want to enable by default ie how change xml tags

    • Raja

      May 21, 2012 at 3:46 pm

      Hi Shiva,
      Hi MK,
      My requirement is displayed in bellow columns
      05/10/2012 US 30 50 200 300
      05/11/2012 IND 35 40 200 300
      PRV_QTR_BKG should be calculate on user parameter date like 05/10/2012 means 2012 Q1 in 40 days sum of bookings with combination of dimension columns like geo, product, channel. Same as PRV_year_QTR_BKG
      PRV_ENT_QTR_BKG should be calculate on same parameter but sum(90) days bookings with combination of dimension columns like geo, product, channel. Same as PRV_YEAR_ENT_QTR_BKG

    • Lateralus

      June 5, 2013 at 10:02 pm


      I write from Spain.

      What’s happen with Delivers in OBIEE I think is not there. Have i to install OBIEE Apps to schedule reports?

      My mail is:

      kind regards!

    • Avnish Kumar Singh

      October 19, 2013 at 4:00 pm

      hello sir,
      Please can any one help me how to uplpoad your database on server side my web space on i have didn’t get any option to upload our database on server side

    • kiran

      January 6, 2014 at 1:19 pm

      Hi Shiva,

      I have some table in a db where I need to present it for reporting. Lets say tables are presented in performance schema .so we query these table like select * from performance.table_name ….

      In obiee one developer mentioned all physical tables names as performance.table_name in physical layer of rpd to make obiee server query these table which is present in back end db.

      So I want to decrease development effort .I have some 25 – 30 table for reporting . Could you suggest necessary changes to be done to decrease development effort.

      Satya Kiran.

    • ravi

      April 18, 2014 at 3:15 pm

      Hi shiva,

      i need sorting on month_year(Ex:mar-13) in obiee report and i need to display latest 12 months data in report please reply asap

    • Pavan

      June 9, 2014 at 5:47 pm

      Hi Kishore, i have a date column, in dash board user want see only last month last day data.(ex: this is june month(1 to 30) user can see only may 31st data in dash board. when user in july he want to see june 30 data dynamic.if last month data is not available its go to previous month data EX:- now we r in july its shows may-31st data, its not available its go to Aprial- 30 if not available March-31st data like dat……. need to show in dash board) in obiee

      • mahendra

        July 31, 2015 at 11:42 am

        i think u want to pass the dynamic variable in the dash board prompt as the server prompt ….. for that dynamic variable in the initialition block u pass the sql quarry to get the last month data

    • Pavan

      October 14, 2014 at 3:42 pm

      Hi shiva,

      I have couple of questions regarding on cluster environment.

      we have a 4 node cluster environment and node1 and node2 are configured for failover in EM as primary and secondary servers.

      Q1.Now my problem is when I bring down primary and secondary servers, I was unable to login to the other 2 instances. Its throwing invalid username/password error.

      Q2. I dont see scheduler and cluster component on the other 2 instances.

      Q2. I am rebooting the entire BI Application.

      Here are the steps I am following to bring the application up. Please let me know if I am doing it the right way. My question is should I start the weblogic on all the instances are just on the primary instance.

      1. start weblogic on node1
      2. start node manager node1, node2 ,node3 & node4
      3. login to EM and start the managed servers bi_server1, bi_server2, biserver_3 & bi_server4t
      4. finally start all the components.

      Appreciate your help


    • Reddy Reddy's

      February 1, 2015 at 3:51 am

      Can we apply saved filters to union reports in obiee 11g?

      I am able to apply saved filters for normal reports but not for union reports.
      The catalog pane is blank, when i click on result columns or each criteria.

      The only option i see is to manually create the filters for each criteria, dont i have any choice to use a saved filter for union report?

      • Catherine

        August 31, 2015 at 1:36 pm

        I have found that I can only use saved filters on a union report by adding them in the report before I save the report for the first time. If I save the report, close it and then come back later to add the filters, my catalog pane is also blank. Hope this helps.

      • SATYA

        November 27, 2015 at 5:34 am

        Me to getting similar issue. Please let me the solution of this

    • praveen

      February 13, 2015 at 11:13 am

      Hi Shiva and All,

      I would like to know ,How to update my time dimension records at present the data availale up to 31-Dec-2015 but i need update till 31-dec-2020 how to proceed for this .

      My working application is bi apps , could you please provide the necessary spets to follow.

      Tools versions– Oracle 10g ,Dac 10g, informatica 8.6.1

      Thanks& Regards,

    • hayasri

      April 25, 2016 at 6:59 pm

      I will give one requirement try it
      Suppose I have a report d1, f1,f2
      With pivot table view
      I result I am getting one row as all zeros
      I don’t want to display that row how?

      • Shiva Molabanti

        October 12, 2016 at 12:29 am

        Filter it out on the key column where you dont want to see it.

    • kedharnath

      June 6, 2016 at 5:48 pm

      Hi Shiva

      I created a measure in rpd with count(number), but results are same for all rows.When I checked in physical query its aking sum(count(number)) .

  2. Sripriya

    September 26, 2008 at 8:55 pm

    Hi Shiva,

    When I do a cast(’08/01/2008′ as date) it does not work. It expects me to do a cast(’01-AUG-2008′ as date). But how do I convert strings in the mm/dd/yyyy fashion ?



    • madasameee

      July 16, 2011 at 11:33 am

      yu can use to_date function ( Oracle function can be used and can be converted into date again back)

    • toba

      January 31, 2012 at 11:21 am


  3. Shiva Molabanti

    October 2, 2008 at 4:26 am

    hi sripriya,
    where do you want to do casting in answers? or Repository itself?
    If it is in repository no problem you can cast as your db expects like cast(’01-AUG-2008′ as date).because your DB default format is ‘DD-MON-YYYY’.so cast the same but when you are using the converted column in answers it will display in mm/dd/yyyy format only as it is the default format for obiee answers.

    • gayathri

      March 22, 2014 at 1:48 pm

      Hi Shiva i have a reqirement to display the past 1 quarters data for a report in which the quarter is coming from a the quarter will be changing dynamically every time as user selects.

    • Pawan

      April 9, 2014 at 3:55 pm

      Hi Shiva
      I have to design a data quality dashboard. Requirements already have been collected Can you pls. help in arranging FUNCTIONAL SPECIFICATION DOCUMENT FOR OBIEE DASHBOARDS / Reports.

    • venkat

      March 30, 2015 at 4:27 pm

      Hi shiva,

      I have an issue like we have environment of bi publisher as part of obiee and using oracle fusion middle ware security where we have implemented external LDAP(users maintaining in LDAP) authentication in web logic console and when user login with admin privileges in bi publisher ,permission tab is disabled what will be the problem,how to enable this issue ,is there any procedure ?

      help me on this


  4. Adrian ward

    October 2, 2008 at 8:09 am


    Nice chart of Variables. Please can you refer to it in my blog (I’ll reference your origal post)

    Keep up the good work

    Adrian Ward

  5. Shiva Molabanti

    October 3, 2008 at 10:33 am

    Hi Adrian Ward,

    You can refer my post in your blog.


    • sankarnaveen

      December 23, 2011 at 1:41 pm


      am a new developer in obiee
      can we build a repository using single physical table

      if yes how?
      if no why?

  6. Shyam

    October 4, 2008 at 10:26 am

    Hi Shiva,

    I Have a requirement such that have to display both parent and child values on same report line based on account. The layout will look like as follows,

    Accnt Parent_Amt Child_Amt1 Child_Amt2 Child_Amt3
    123 150 50 50 50
    345 300 125 75 100
    678 100 30 30 40

    Data Model is as follows:

    Parent_id Child_id
    1 10
    1 20
    1 30

    Fact Table

    Acct_id Parent-Child_id Amt
    123 1 150
    123 10 50
    123 20 50
    123 30 50
    345 1 300
    345 10 125
    345 20 75
    345 30 100

    How can i acieve the above layout in pivot view?


  7. Raghu

    October 15, 2008 at 12:17 am


    For the presentation services in OBIEE, I noticed that there is a Tree strcuture and also drag&drop functionality. Is this built using C++ or JSF or somethign else? Also where is the data into the Tree on presentation services coming from? Is this metadata stored anywhere in a relational app specific schema?

    When we installed OBIEE, did not see any schema, there are soem scripts if we need to use scheduling. I understand some proprietary format is used to store metadata information in OBIEE.
    Is there any schema to store any metadata? Also, is there interactiev reporting in the web client or are the reports created/generated in the fat client and published to the web client?

    Is there any functionality to create and generate reports from the web client? Also what is the product using for the drag&drop features on the web client?

  8. Shiva Molabanti

    October 15, 2008 at 7:45 am


    1.The features in OBIEE Presentation services are defined in XML and called via JSF on runtime.
    2.To get the Metadata you need to have UDML script
    3.To generate any reports you should be coupled with BI server,so normally people will provide presentation service in one machine to be queried by users/to generate reports and to maintain load balance we will have clustering concept


  9. Shiva Molabanti

    October 15, 2008 at 8:43 am


    Let me know how the tables are related
    You have given two tables but in any of them tables there is no Primary key.let me know where is the primary key.and you should have the fact table like accnt,parent_id,child_id,Amt


  10. Raghu

    October 15, 2008 at 1:40 pm


    I have seen some style sheets (XSLT) that look liek they are transofrming the data, are these really transforming the XML that you mentioned in presentation services?

    Also, Does the web tier (not the fat client) support drag and drop and how is it implemented?

    Also, can generate reports on the fly from the web application (browser client) and not just the fat client?

    • Yazan

      March 5, 2015 at 6:43 am

      Did you find any way to generate reports on the fly from the web application (browser client) ??


  11. Raghu

    October 15, 2008 at 1:43 pm


    I also read that for the report repository, either a file system or a database can be used.

    Is this true for the metadata as well? Is there anything during the install that prompts a user to chose between a file system based or database based metadata repository?

  12. Shiva Molabanti

    October 15, 2008 at 5:04 pm


    Yes,That’s true we can use any of them like file systems as well as databse to develop metadata repository.
    And there is no option while installing to choose either of these type metadata repository.
    You can use any of them or both.
    Metadata will get the data from different sources not only from the filesystems or Databases
    even from EPMs,

  13. Pratik

    October 30, 2008 at 1:50 pm


    I have created one non system server variable in RPD. After initializing it does not show any error, but when i used the same variables in select query of Table definition, it gives warning that variable does not have any value definition.

    Please note that i am using more than 1 variables in the same query and which even is the last variale, that variable gives warning by “Repository Variable does not have any value definition”

    Can you please guide me on this?

  14. Sripriya

    November 10, 2008 at 11:16 pm

    Hi Shiva, Thanks for responding to my earlier question.

    I now have an issue with Informatica Lookup Transformation.

    To figure out the functional head for an employee, I am going up the hierarchy using a person’s supervisor id and a connect by prior clause.

    CONNECT BY PRIOR supervisor_id = person_id
    START WITH person_id = 1541

    In the lookup, I want to use the input port as in
    START with person_id = PERSON_ID_IN

    It does not seem to like that.

    But I have to use it somehow, without which the START WITH will not work.

    Could you let me know how to achieve that ?

    Thank you so much.

    : Sripriya

  15. Shiva Molabanti

    November 17, 2008 at 7:13 am

    To achieve this starts with functionality you can use the LIKE operator.
    ex:CONNECT BY PRIOR supervisor_id = person_id
    AND person_id LIKE ‘1541%’

    i think it will solve your issue


  16. vijayyajurvedi2008

    November 24, 2008 at 1:47 pm


    I want to combine multiple go buttons in single go button

    please provide me solution.

    I tired with sranka’s blog but i lost my prompts functionallity.

    please mail me the thing worked done using sample sh rpd and web cat that comes with obiee

    mail me to

  17. Suresh

    November 28, 2008 at 9:02 am


    How to reference a dashprompt column and use it in a request ?


  18. Shiva Molabanti

    November 28, 2008 at 3:02 pm


    Using Presentation variables you can use dashboard prompt values in your Request.


  19. babu

    December 10, 2008 at 12:04 pm

    Hi Siva,

    When do you think we need to create hierarchy in OBIEE. I see some rpds where lot of dimensions are having hierarchy levels ‘Grand total level’ and a ‘Detail level’ only. In DW terms it is not a hierarchy, but looks like this is kind of standard in OBIEE? Can you please let me know your thoughts on it?


  20. babu

    December 10, 2008 at 12:55 pm

    Hi Siva,
    One more question on the same lines. If dimension has 15, do all the fields need to go into Details level? (note: we only have ‘Grand Total level’ and ‘Detail level”.


  21. Shiva Molabanti

    December 12, 2008 at 5:54 am

    Actually the concept of hierarchy is meant for two things
    2.level based values
    if in our application we are not specific about drill down path then we are creating the only two hierarchies i.e Total level and Detailed level,these will help us to have ‘Group-By’ clause in our BI query.
    If your dimension has 15 then no need to have all the 15 fields but you should have the key column(primary key for the concern dimension) in detailed level…


  22. babu

    December 12, 2008 at 10:27 am

    Hi Shiva,

    Thanks for reply. Let me give my understanding of your response with an example. We have a Supplier dimension (no levels) and we also didn’t create Total/Detail levels in OBIEE. Now Supplier is logically joined to fact Purchase order fact, having a measure purchase amount. Now in OBIEE answers if customer pulls Supplier name and the purchase amount, it will not work (no grouping will be done). Is this what you are saying? If not can you please clarify with an example.


  23. babu

    December 12, 2008 at 11:09 am

    Hi Siva, in earlier example, there is also a physical join between the Supplier dim and purchase order fact.

  24. Shiva Molabanti

    December 16, 2008 at 6:33 am

    If you want to drill down the supplier dim attributes like
    Region->market->City->Supplier then you need to create the dimensions with these hierarchy.
    suppose if you don’t need this specific hierarchy then just create dimension (Right+Click on the Dimension Table) automatically it will create one dimension with two levels i.e 1.Total level and 2.Detailed level where you will find the key.
    now if there is any direct physical join between this dim to any fact then in the content tab make the fact LTS to this Dim-Detailed level otherwise keep it at total level
    then the BI query will generate the Group by even though theer is no join..


    • Kumar

      June 26, 2014 at 9:55 pm


      Can you please share me your contact details

      Due to some issues I cant discuss my requirement over here.

      Request you to drop me your phone number


  25. Venkat

    January 2, 2009 at 11:02 pm

    Hi Kishore,
    Can you let me know in detail about Alias tables. why & where do we use them? If possible with an example.

  26. Shiva Molabanti

    January 6, 2009 at 7:33 am

    We can use alias tables in many situations
    few of them are:
    1.To have Degendim in BMM layers
    2.To design star schema when we have Fact-Fact relations..

  27. Venkat

    January 6, 2009 at 5:15 pm

    Thanks for the reply Shiva.
    Can my alias table’s columns be from multiple tables?


  28. Sum

    January 10, 2009 at 1:11 am

    Hi Shiva,

    I need some help in building the following type of report.

    the report i am building has date (in form of FY YR MMMM .. basically like FY 04 March), the price, the sales and %.

    What i am trying to achieve in this report is when the user logs in.. say jan 09.. the report should display values for the last 12 months.. basically from dec 09 to dec 08 and every date/month before that in Others.

    This should change dynamically .. like ifthe user logs in march 09.. report should so data from feb 09 to feb 08 and every month month before feb 08 goes into others with an updates total price and sales amount.

    Can you help me achieve this.


  29. Shiva Molabanti

    January 13, 2009 at 5:28 am

    The aliasing would for one table not for multiple tables,
    so you can’t use the alias in physical layer from multiple physical tables


  30. Shiva Molabanti

    January 13, 2009 at 5:31 am

    I have published one article which will illustrates the same functionality of how you are expecting,you can check at this URL:


  31. Santhosh

    January 15, 2009 at 4:49 pm

    Hi Shiva,
    I have a report which show Sales Analysis figures for week to Date. I have to show pie chart for each of the day pertaining to that week. Am using Chart Pivot Data Option in Pivot view for getting separate pie chart for each report.

    I have placed the date column in the Sections of the Pivot View. Am getting sepate charts for each of the day in that paraticular week.

    The issue is, each chart is coming one below the other.(Coming vertically). But I need the chart to be displayed horizontally(Left to Right).

    How can I achieve this?

    • Saranya

      December 6, 2011 at 10:11 am

      Hi Santhosh,

      Currently I have a requirement from my client to display charts horizontally (left to right).It would be great if you could provide your suggestion here, as you were facing this kind previously.

      Thanks !!

  32. Deep

    January 23, 2009 at 7:34 pm

    hi Shiva,

    I have a request where i need to create a YTD actual sell price and YTD budget sell price and annual budget, MTD actual Sell price per region. I have year and month as prompts. The only measure i have is sellprice. I have a degenarate dimension scneario type which wen is ‘ACT’ becomes ACT sellprice and when equal to ‘Bud’ become budget sellprice. pleas help me in creating this report.


  33. Supriya

    January 28, 2009 at 6:12 am

    Hi Shiva,

    I have a report with several Request types like ‘Attendee Upload’, ‘CRMOD’…etc,were for each request type it counts how many requests were completed by month in FY09 and I have a Cumulative column at the end which is calculated using summation. I want the Cumulative column to be a running aggregate for that particular service type.

    eg. For ‘Attendee Upload’ Request type, 0 days took to complete 1 request, 1 day took to complete 395 requests, 3 days took to complete 898 requests etc.
    I want the cumulative column values as 1, 396,396+898=1294 etc. this running aggregate should go only until the last row of the ‘Attendee Upload’ Request type then for the next Request type i.e. ‘CRMOD’ the running aggregate should start form 0 days taken to complete a request.

    This is What I have Tried,

    1. Selected Running aggregate as an option in pivot table- this doesn’t help as all the columns including months will aggregate, I just want cumulative column to be a running aggregate.

    2. Used RSUM by adding another column with the same code as cumulative, even this didn’t help as the months are repeating.

    Hope I was able to explain it well.

    Please let me know if you have come accrosed such kind of report or if you any idea on how to go about.

    • Amy

      February 3, 2010 at 9:21 pm

      I have the similar report: I need the last number of the running aggregation showing in the top of the page, but not the other running aggregation number. I couldn’t do it. Did you ever get help from the site?



  34. Shiva Molabanti

    January 30, 2009 at 2:17 pm

    you need to create first some partitions for sellprice measure based on the degenarate dimension.To do this you have to go in column Fx property in that you have filter tab where you need to give the filter condition like “act” for one time and have same sellprice column again in criteria and give filter in fx as ‘BUD”.
    now you have two sellprice columns in criteria 1.ACT filtered and 2.BUD filtered.

    To get MTD and YTD you need to generate the TO_DATE() functionality.
    otherwise just see one of my article:


  35. Surya

    February 12, 2009 at 9:39 pm

    Hi Shiva,

    I have a bar chart report.I’m trying to customize and I got this problems:

    The data label gets positioned at the top of the bar but my customer want to have it in center. Is there anyway to reposition the label?

    Thanks in advance.


  36. pankaj garg

    February 18, 2009 at 7:25 am

    Hello all

    I am newbie to OBI EE…and while working on it i got stuck…as per our requirement we need to make charts and put them on dashboards..that’s the easy part…now complex thing is i have to make slider that interact with that chart and the value and shape of the graph changes, as we change the values in the slider area….

    Please let me know if it could be done and if yes then please lemme know the method…….



  37. pankaj

    February 25, 2009 at 5:44 am

    hello all

    Is thr ny way to define error code and error messages tht wil display on dashboards..i mean is there any poss way of getting the error code and error msg that are defined by user….or is thr any file that contains a list of all error codes and msg’s or in which a user or admin can define code and message



  38. Jan

    March 3, 2009 at 3:20 am

    Hi Shiva,

    I’ve couple of questions:

    1) what is disconnected analytics? can you please explain?
    2) how to integrate .xls in to analytics please?


  39. Al

    March 4, 2009 at 6:07 pm

    I want to display total number of records on the 1st Page of OBIEE answer report. How do I do that?

  40. Shiva Molabanti

    March 8, 2009 at 3:59 pm

    You can do this by using narrative view.For this you need to have another column in your answers criteria and write in function like COUNT().

    and in narrative view display the count column like @2 (where 2 is the no.of your count column in criteria)
    and give value 1 at no.of rows to display section.

    and add this narrative view to your compound layout view.

    so now you can get total no.of records in your report….


    • Jeff

      May 27, 2009 at 7:24 pm

      doing an rcount in the formula area of a column….the field for this column in the last record is showing the total number of records returned… the narrative view I’m refering to this column @#…..issue is the narrative view is showing the value of the first row not the last…….much thanks in advance

      • Shiva Molabanti

        November 16, 2009 at 4:11 am

        give MAX(RCOUNT())

  41. Ram

    March 11, 2009 at 1:09 pm

    While adding the logical column and setting the expression with aggreation of sum, i am getting below error when checking the consistency :


    [38083] The Attribute ‘Total’ defines a measure using an obsolete method.

    Please let me know how to overcome this.


    • Shiva Molabanti

      March 16, 2009 at 6:10 am

      Is the Aggregate attribute is the datatype of any numeric family like int,double,float etc…
      If not cast them to integer as SUM()aggregation will applicable to only numerical measures.


  42. mehmet

    March 31, 2009 at 1:25 pm

    chart gösterilemiyor neden olabilir.


  43. Pratik

    April 3, 2009 at 9:07 am


    I have a problem with applying SUM aggregate on a logical colum.

    Requirement is to multiply sum(“Cost * Qty”), but OBIEE does not allow aggregation when calculations applied. I removed the aggregation but found the stupid results.

    I got final results as SUM(Cost) * SUM(Qty) which is true for the lowest level (i.e Prod Number), but when i do aggregation to Planning Proj Name it will calculate wrongly bt Sum (Cost) *Sum (qty) group by Pl Prj name.

    Do you have any work around to solve this issue?

    Any help in this regard is helpful

    Thanks in advance

  44. Shiva Molabanti

    April 15, 2009 at 5:25 am

    Here you need two check two things.

    1.whether The calculation columns are the numeric type or not as you are doing multiplication
    2. To get proper level based values you need to set aggrgation to each and evry columns with which you are doing caculation.

    If these two are maintained properly you will have no issues like mismatch data.


  45. Siva

    April 18, 2009 at 5:54 am

    Hi Shiva,

    This blog is really excellent.
    But we are having the scenario where:

    In the Date Promt when the user select more than 1 day in the date between prompt, then the message should be display as “Select data only for 1 day”.

    Can you please send the Java script for restricting the user to select only 1 day and then display the above message.

    Also please let me know how to add more conditions to narrow it down to a single edit box in a particular page.


  46. Suresh

    May 4, 2009 at 5:23 am


    I have to show rsum running across different account, e.g
    act1 10
    act1 10+8=18
    act1 18+2=20
    act2 8
    act2 8+20=28
    act2 28+2=30

    I used rsum, but my problem is, OBIEE does differentiate accounts so i end up getting act2 8 +20=28 and so on.
    Please help

    • Shiva Molabanti

      May 5, 2009 at 7:16 am

      HI suresh,
      You have to group by the Measure with accounts_column.then you will get your desired result.
      EX: RSUM( BY ACCOUNT_Column).


      • Suresh

        May 5, 2009 at 5:34 pm


        Thanks for replying.
        I have multiple hierarchies, and rsum should work over both of them, i.e. say time, product and accounts.
        Also lets say Product is like
        product_family, product_group, product_number
        In my report I am showing only product family, and then user is allowed to drill down to product_number, if he wishes to. Will this approche work?

        Is there any other alternative?

        Thanks a lot

  47. ali

    May 21, 2009 at 4:54 am

    How can i change the properties of drill down columns is PIVOT TABLE in obiee

  48. Shahzad

    May 21, 2009 at 8:18 am

    How can i set properties in Pivot tables drill down columns,and how can i use tooltip on numbers lets suppose,i have an 1234 number and i want to put name as tooltip then how can i get plz help

  49. valeswar

    May 23, 2009 at 8:08 pm


  50. Suresh G

    May 26, 2009 at 3:31 pm

    Hi SHIVA,
    Could u Please tell how to do CASTING in Answers?

  51. sri

    May 28, 2009 at 1:43 am

    Hi Shiva,
    i have some urgent requirement in OBIEE report. I have four columns one is Dept, Cont no of employees, count no of employees under NJ (where city in New brunswick, edison, newark), Count no of employess under CT (where city in hartford, stamford, new heaven etc). Could you please tell me how to do this? How to put two filters on a same column.

    Here in third column having different cities under NJ. I want to count all the employees under each city and the result show them under state of NJ, same as CT.

    example is
    DEPT ID Count no of employees count no of employees in NJ Count no of employees in CT
    ACCOUNT 100 10 4
    IT 50 6 30

    Thanks in advance

  52. Dan Martin

    June 3, 2009 at 12:40 pm

    Hi Shiva,

    I am a OBIEE newbie, a have what would seem to be a very simple requirement that I am struggling with. The requirement is to be able to allow the user to select 2 different time periods (Year and Month) and be able to compare the reuslts in a variance column (ie compare 1/2009 to 2/2008). Any ideals?


    • Michael

      April 5, 2010 at 4:46 pm

      Did you ever get a response to this question. I’m looking to perform the same type of variance within a pivot table, comparing today’s results vs. yesterday’s results.


    • Amy Casavechia

      September 12, 2011 at 2:38 am

      Hello Dan,

      Did you get a reply or suitable workaround for your variance request in OBIEE? I have the same requirement I have been fighting. I need to create variance reports from 2 different time periods and show the 2 values and the variance column all on one line.
      Any ideas or suggestions would be greatly appreciated.

      Amy C

  53. kam

    June 21, 2009 at 2:12 am

    Hi Shiva,
    great to find a blogsite like yours.I am a newbee in OBIEE and have an urgent requirement to do follwoing.please help me.Thanks in advance.

    one of the dashboard page has date parameters (Between X & Y )and I have to save this date X & Y while next time I reopen this can i do this ?
    Please provide steps to do this.


  54. kamlesh

    June 25, 2009 at 1:32 pm

    hey Shiva,

    i have a requirement to display the dates which the user enters in the dashboard. if i am using is in it is allowing me to save it in a variable and then later i can use it in the title. but with is between its not allowing me to save it to any presentation variable.

    if it is not possible than can you plz help me to give a prompt if the user enters the end date prior to the start date while we are using the is in thing within the dashboard.


  55. Dan

    July 12, 2009 at 6:28 am

    Just a quick question,I have a Guided navigation used on my dashboard and my objective behind using guided navigation is to display different types of report based on the Report Type (Prompt) selection ,Now when on the dashboard Every thing works fine but on the backgound I can see all the reports running through manage session.Can we avoid this ?


  56. Jorak

    August 3, 2009 at 12:35 pm

    Thanks for your help in advance. I have trying to update the default compound layout view in OBI Answers. I have updated the custommessages folder with the answerstemplates.xml for the following message kuiCriteriaDefaultViewElements: Chart, Table, Filter. The requirement is to have the chart, table, filter display by default in the compound view. The table and filter display perfectly as expected, but the chart gives the following error – Assertion failure: pTemplateIDAttr != 0 at line 518 of ./project/webcharts/xmlcompiler.cpp

    If I click to the chart in the results view and return to the compound layout view, then all displays appropriately. Please let me know what piece I am missing to achieve the Chart view in the default compound layout view.
    Thanks for your assistance.

  57. Deep

    August 6, 2009 at 4:59 pm

    Hi ,

    I am struggling with an OBI issue for last 2 days.

    I have two confirmed dimension D1,D2 and two fact F1 and F2 tables.
    D1 is joined with F1 ,F2 and D2 joined with F1,F2

    We can’t go with the same structure in the BMM Layer. As OBI will throw error if we select field present from D1-F1-F2.

    The alternative which I know to resolve the issue is to create alias of the Dimension and then join with the fact in the Physical layer.

    If, D1 alias is D1A
    And D2 alias is D2A

    Then my physical joins will be something like D1-F1-D2 & D1A-F2-D2.

    Now In the Business layer I will create a Logical central fact and will join all the facts and dimensions with it.

    i.e with the central Fact D1,D2,F1,F2,D1A,D2A will be joined.

    This Approach works but I don’t want to put the entire alias in the Presentation Layer. I only want to put the original Dimensions in the Presentation Layer not the alias. So I tried some different approach .


    I have not created any alias in the Physical Layer.

    In the Business layer I have joined the tables in the following manner.

    Create a Central Fact just like my previous approach.
    As I have not taken any alias this time so my Cental Fact table is joined with only,

    In the Central logical fact I have created two sources.




    In the Source1 I have mapped the tables as D1-F1-F2
    And in the Source 2 I have mapped the table as D2-F1-F2

    After doing this I have found that I can able to pick data from all possible combinations.

    1. D1-F1-F2
    2. D2-F1-F2
    3. D1-F1
    4. D1-F2
    5. D1-D2-F1-F2
    6. F1-F2

    But I am facing problem only for the condition 2, it is giving the data but when I am picking data from D2,F2,F1 then in the SQL joining condition D1 is also getting joined which should not be the ideal case.

    If you know any solution then please share with me. It is very urgent.

    Kind Regards,

  58. Lavanya

    August 8, 2009 at 7:47 am

    Hi Shiva,

    gr8 to find a blog like this..i found many topics useful to me here…i m new to obiee..

    My question is :

    In Answers,
    I have created three prompts for my report.When i run the report,i can see only one prompt at a time,only if i select a value for it,i can go to the next prompt.The user wants to see all 3 prompts at a time and select values.Is there any way for t?

    Also I am using ‘filters view’ in my report to display the value selected by user from prompt as report sub headings.But it displays the static filters given for the report also.How to display only the dynamic filters in filters view?

    • surya

      October 5, 2009 at 7:13 pm

      You are using column prompts. Try using dashboard prompts

  59. Gustavo Canalis

    August 10, 2009 at 7:22 pm

    Hi Shiva,
    Do you know what the enterprise calendar is about in Project Analytics?
    I do realize Fiscal Calendar is GL Calendar and Project Calendar is PA calendar.

    But this one seems different than the other ones.

    Thank you in advance!


  60. Sowjanya

    August 11, 2009 at 4:09 am

    plase give me u r yahoo/gmail ids.

  61. vikas barsaiyan

    August 20, 2009 at 12:01 pm

    Hi Shiva,

    I am facing one issue :
    I have 4 columns in dashboard prompt.I want to make it mandatory for the user to enter atleast 1 prompt.If he does not enter any prompt then i want a pop up saying “Please enter atleast one prompt value”

    Can we achieve this functionality with javascript.Or is there ant other way of doing this.

  62. Yogesh

    August 25, 2009 at 5:58 am

    Hi Shiva,

    I need to call OBIEE reports from Webcenter/ADF. I need to pass some parameters and get back the result and show on ADF/Portlet.

    Cab u guide me the way to get this?

  63. Yogi

    August 25, 2009 at 8:20 am

    I need to pass parameter from Webcenter/ ADF (may be portlet) 11G to OBIEE and get the report back.

    Can you please guide me with steps or sample example.

    Thanks in advance.

  64. jyoti

    September 16, 2009 at 3:03 pm


    Can you tell me how to restrict the calendar prompt to show only from a specific month in the calendar prompt on the dashboard. I don’t want users to see the dates prior to specific date or month for example: 9/21/2009.

    Thanks in advance

  65. pankaj

    September 23, 2009 at 7:56 am


    Can we show Serial No(1,2,3,4 …) against each row return in report output. How to do it?



    • Shiva Molabanti

      November 16, 2009 at 4:02 am


      For this you need to put RCOUNT() column in report.this rcount() function will be the same how we will have row_num in oracle.


    • Pramod Kumar Singh

      January 14, 2014 at 8:04 pm

      use rcount with some pkid column

  66. Prasanna

    September 28, 2009 at 7:55 pm


    I have a report to show number of opportunities breakdown by week (on Opty created date). I amnot sure how to achieve the weekly breakdown, like it should say 09/21/09, 09/28/09,10/05/09,…like that, can you help me with this?


  67. surya

    October 5, 2009 at 7:12 pm

    Hi shiva,

    Can we create a drop down box for Dashboard pages instead for a dashboard? Also is it possible to display all the dashboard pages vertically (aligned to left) instead of horizontally? If you have a solution, can you please email me to

    • Kanimozhi

      January 10, 2012 at 10:24 am

      hi… u ve the solution for this? please share

  68. Zuber

    October 9, 2009 at 5:38 pm


    Quick question on iBot.

    We have users in obiee who are saving their ibots in shared folder so other users can subscribe to it. problem is once the ibot is saved they are not able to update it.
    is there any special setting i need to do so users can update their iBots in shared folder?


    • Parry

      February 21, 2012 at 11:22 pm

      Hi Zuber,

      I am having the same issue, i.e. not able to edit / save the iBots in shared folder. Did you get a solution to this?


  69. Vikram

    November 3, 2009 at 11:52 pm

    Hi shiva
    i need to join 2 tables in Physical Layer but they don’t have any direct columns in common

    table 1 has ORG_ID = 084

    table 2 has Work_id = 08400123

    so i need to perform substring operation for work_id in order to get a common column to join them.

    how can do that in physical layer of OBIEE..
    Please sujjest me a way.

    • Shiva Molabanti

      November 16, 2009 at 4:08 am


      have complex join in physical layer and give the join condition like:



      • srini

        December 9, 2009 at 1:48 am


        Thanks. I have tried this and this doesn’t work – either using a physical foreign key or a complex join. It throws a syntax error “near “. Even the expresssion builder doesnt carry the substr function.

        By the way, the syntax is SUBSTR(table2.Work_id, 1,3)


  70. vik

    November 19, 2009 at 8:07 pm

    Hi Shiva,
    Can you please give info on how to implement Disconnected Analytics Application?

  71. neeraj

    November 24, 2009 at 5:10 pm

    Hi shiva,
    What is time series wizard in obiee? When do you use it?
    thanks in advance

  72. praks

    November 25, 2009 at 7:14 pm

    I have an issue regarding dashboard prompts.
    Imagine there are 2 dimensions.Prompts from each dimension are constrained.
    But when the second dimension filed values are being selected from the prompt,this dimension is joining through the other dimesion through a fact and then the constrained values are being displayed, which is hampering the performance.We dont have access to data modelling now.From the OBI Side i need your suggestions regd wat can b done and any option of using prompts with out “GO” Button will help?

  73. Shivin Malhotra

    November 27, 2009 at 8:54 am

    Hi Shiva,
    In some of the report where I display the Facts like Ordered Amount, Invoiced Amount,Operational Backlog Amount and many other measures against the Product Name, the value in the measure column is null always. I checked background query through the session where I found that the measures are not been queried in the database itself,only the Dimension is queried. I checked the formula in the RPD, it is fine.
    Am I missing some configuration in the RPD or something else.
    It would be of great help if you can help me with this.
    I am just a beginner with OBIEE.

    Thanks & Regards,

  74. monu

    December 3, 2009 at 6:12 pm

    hi Shiva,
    I am facing an issue. Hope you can help me out with this
    I have a table which contains a request key and creation date for the request.
    I want to use the drill down feature where i can show the data in terms of year and number of request.if i drill on the number of request in a year i see the number of request according to month and when i click on the request total for a month i can see the distribution for request raised according to week.
    I am able to view the total request for a quarter but when i click on a particular quarter i get three columns showing the 3 months of quarter but the request count is 1.I have a request dimension and the time dimension created.
    Is this error because i need to make hierarchies in request dimension also.If that is the case how do i do that .My request table jsut has a primary key=req_key and create date column.
    I am really stuck on the issue any quick help will be greatly appreciated

  75. Satya

    December 8, 2009 at 3:21 pm

    Hi Shiva,

    I am trying to implement rolling 6wks, 12wks sum for a particular year in rpd. Can you help me with what functions i should use or logic should be.


  76. Karthik

    December 8, 2009 at 8:44 pm

    Hello Shiva,

    Am trying to convert string to date using the following and it always fail. Please help me understand what’s really wrong shiva.

    Code :


    Error :

    View Display Error
    Odbc driver returned an error (SQLExecDirectW).
    Error Details
    Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
    State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 17001] Oracle Error code: 1840, message: ORA-01840: input value not long enough for date format at OCI call OCIStmtExecute: select distinct D1.c1 as c1, D1.c2 as c2, D1.c3 as c3, D1.c4 as c4, D1.c5 as c5, D1.c6 as c6, nvl(cast(NULL as DOUBLE PRECISION ) , 0) as c7 from (select distinct T518280.PRIMARY_LENDER as c1, T518280.PROJECT_NUMBER as c2, concat(concat(T518199.LOAN_TYPE_1, ‘ ‘), T518199.LOAN_TYPE_2) as c3, T518199.LOAN_CATEGORY as c4, T518199.CLOSING_DATE as c5, cast(concat(’31-OCT-‘, cast(TO_NUMBER(TO_CHAR(T518199.CLOSING_DATE, ‘yyyy’), ‘9999’) as CHARACTER ( 30 ) )) as DATE) as c6 from W_MBS_PROJECT_D T518280 /* Dim – MBS Project */ , W_MBS_LOAN_D T518199 /* Dim – MBS Loan */ , W_MBS_LOAN_TRAN_F T518084 /* Fact – MBS Loan Transactions */ where ( T518084.LOAN_WID = T518199.ROW_WID and T518084.PROJECT_WID = T518280.ROW_WID and T518199.LOAN_STATUS = ‘ACTIVE’ and T518199.CURRENT_FLAG = ‘Y’ and (T518280.PRIMARY_LENDER in (‘HDC’, ‘HPD’)) ) ) D1 order by c1, c2, c3, c4, c5, c6. [nQSError: 17011] SQL statement execution failed. (HY000)

  77. Hi

    December 11, 2009 at 10:26 am

    I have one requirement…..have two columns in report A and B and A drill down to C and further C drill down to D and i want that title should get created dynamically with the drill down column name should be shown in title. For eg… When column A drill down to A then title should be A by C and when A column at his lowest level then title should be A by D.

    Could you please help me.

    thanks & Regards

  78. Subhash.T

    December 18, 2009 at 5:43 am

    Hi Shiva,

    I have a requirement saying I want all the values even it doesnt meet the oin condition.

    I mean see if join condition is met then it will display values pertaining to that join condition satisfaction.
    But I want even the other values which doesnt meet the condition also

    Give me some solution


  79. Usman Fawad

    December 22, 2009 at 12:47 pm


    I am new to OBIEE. I am creating a new request using direct database request. I have created a dashboard prompt of date type. I caught its value in a presentation variable @{test_date} in title which shows date in format like “2008-09-29 09:10:47”.

    But sql statement accepts date value in different format i.e. (’29-sep-2008′)

    I want this
    — where visit_date = ‘@{test_date}’
    — where visit_date = ’29-sep-2008′

    but i’m getting this
    — where visit_date = ‘@{test_date}’
    — where visit_date = ‘2008-09-29 09:10:47’

    So the scenario gives me no results, I tried much but didn’t found any solution how to pass date. Kindly provide me some clue to solve this problem.

  80. Usman

    January 1, 2010 at 2:14 pm


    I am new to OBIEE. It becomes a challenge for me to pass variables from dashboard prompts and to catch their value in Answer’s Request.

    I would like to illustrate it with an example.

    My desired Request based on the following SQL statement

    From emp
    Where DOB = ‘@{p_date}’

    Now DOB is in TIMESTAMP format,
    it looks like ‘11/1/2009 12:00:00 AM’.

    Dash board Prompt also depends upon the same column and have also same TIMESTAMP format.

    In next step
    I create a dashboard page
    Place prompt and report there
    Saved the dashboard
    Now I select a date from prompt list and press go button
    It shows no result.

    I tried several combinations in @{} syntax e.g.

    Where DOB = ‘@{p_date}’
    Where DOB = ‘@{p_date}{1-nov-2009}’
    Where DOB = cast(@{p_date} as date)
    Where DOB = cast(to_char(@{p_date}, ‘dd-mmm-yyyy’) as date)

    …. And many other combinations, but i c NO RESULTS

    I am looking for any help/tips in this regard

    Thanking in anticipation


  81. Jay

    January 6, 2010 at 6:57 pm

    Hi Shiva,

    You have wonderful weblog!!

    Can we fix or change the size of section in dashboard?


  82. Sita

    January 11, 2010 at 8:03 pm

    Hi Siva,

    I have a requirement to bring percentage to the calculated measures of two different other calculated measures in the pivot table that created against time…> ((‘Actual’ -‘Plan’ ) /’Plan’)*100.
    I changed this to ((‘Actual’ -‘Plan’ ) /’Plan’)*100% but it gave me error. I checked the format and the functions and do not find to fix this. Please help.


  83. Raghvendra Ghate

    January 30, 2010 at 7:17 am

    Hi Shiva,
    I m new in obiee.
    Can you please give me information about how to add page items in tabular report?

  84. Kalkibabu

    February 3, 2010 at 4:44 pm

    Hi Shiva,

    When i m drilling down on a number ‘123’, it has to retrive 123 records. But i am getting only 67,78 records like that. I have checked the ‘Prompt’ Levels too, but no result. Help me .!!!

  85. cnu

    February 12, 2010 at 12:02 pm

    Hi Shiva,

    In one Dashboard i have 5 sections.1 section data is coming every 5 sconds.and second section refrshing every 3 seconds.How ro Refresh the particular section in my dashboard.
    I tried with Meta tag and iframe using html(In Narrative).But by Using this entire dashboard is refreshing.BUt i want to refresh only section.can u please suggest me how to achive this in OBIEE.

    Thanks in Advance

  86. April

    February 24, 2010 at 9:09 am

    Hi Shiva,

    We have a new numeric column (ColA) in Opportunity which I need to bring over to OLAP. I created the fact column in W_REVN_F but I noticed that the value is aggregated based on the number of revenues in an opty. For example, the opty has 2 revenue records and ColA is set to 10. When I generate a report that shows Opty Name and ColA, the value shown is 20. Is there a way to modify the formula in RPD so that the correct value is shown?

    Thank you for your help.

  87. praveenak

    February 25, 2010 at 10:43 am

    Hi Siva,

    I have an issue with bar graphs in OBIEE. On a dashboard page i have inserted 5 bar graphs(5 diff requests). When i navigate to that page,graphs which takes few seconds more compared to others in pulling data gets displayed with bigger size. when i click refresh for couple of times all charts will be displayed with same size. Whys is this happening. In siebel analytics we did not face this issue. There everytime all charts were displayed with same size. Please suggest.


  88. Siddharth Chitre

    March 1, 2010 at 6:46 am

    hi shiva

    can you pls tell me how do i accomodate 13 months in the YTD function? By default YTD only takes 12 months as its time period

  89. Himanshu

    March 2, 2010 at 12:46 pm

    Hi..I am implementing YTD report however i have to generate it without a specific olap database..The OLTP table i have to generate the report against looks like this..
    SNo Dealer SaleDate #CarsSold
    1 hyundaiA 1/1/2009 10
    2 hyundaiB 20/5/2009 25
    3 hyundaiA 15/2/2010 35

    I modelled the above physical table as the following 3 tables in my business layer. All the 3 tables are based on the same OLTP table in my physical layer

    Dealer Dim Table with the following logical columns

    Time Dim Table
    SaleYear-Derived by applying Year function to SaleDate
    SaleQuarter-Again derived from SaleDate
    SaleMonth-Again Derived from SaleDate
    SaleQuarterDesc & SaleMonthDesc as suggested by you above by appending year and quarter etc

    The chronological keys while creating timeDimension is defined appropriately at all levels and at lowest detail level it is defined as SNo.

    Sale Fact Table contains follwing columns

    All the 3 tables are being derived from the one and only physical OLTP table i have. the facts and dimensions are realted by column SNo.

    I followed all the steps to create a YTD but not getting appropriate results. I am not getting error but getting wrong results. Kindly let me know if what am trying to do is indeed possible and if you can determine where i am going wrong. I am new to OBIEE and chances are I might be going fundamentally wrong somewhere.

  90. razvan

    March 29, 2010 at 2:44 pm

    I have a twelve column table, each column with different filters on same measure in fact table. Say filter one to column a (number of persons existing at 01-01-2003) is from dimension persons (date_of_birth <= '01-01-2003'). Filter two to column b (number of persons living in Bucharest between '01-01-2004 and '01-01-2006') is (date_of_birth between 2004 & 2006) etc.
    How can I use column a & column b into same result table (view)? I need different filters on same table.


  91. seiciu

    April 4, 2010 at 5:08 am

    I have a saved report R1 : person_id, max(date_of_last_address). The idea is last persons home address.
    I have another report R2 : persons, day_of_birth, home address, date_of_address, district, company, departement, date_of_job,nr_of_persons(measure)

    I know that using filter F1 : person_id is in R1 and date_of_address is in R1 (using person_id and max(date_of_last_address)) works at report level.

    I want this filter *(F1) to be at column level* (on formula of persons and date_of_address) because i want *different filters on different columns in same report*.

    Example : I need max(date_of_address) and max(date_of_job) filtered in same report at column level.

    Thank you!

  92. Rasheen

    April 7, 2010 at 5:28 pm

    Hi Shiva,
    Please could you let me know, how to load Fiscal Week information into OBIEE if we do not have Fiscal weeks set up in Oracle Apps (Source).


  93. Antonio

    April 8, 2010 at 1:17 pm

    Hi Shiva,
    I’ve a problem with the IN statement. I select 2 values from prompt ( and I.Box) and the query is created in the right way, but when I read the report I find just a value ( If I put a LOWER/UPPER function I see all chosen values. How can I solve this problem without using Upper/Lower function?
    Thank you

  94. Dhritiman

    April 22, 2010 at 12:35 pm

    Dear Shiva,

    I have faced a problem during deployment of the .rpd file in Linux machine.

    Here are the system details –

    Linux : 2.6.9-89.0.9.ELlargesmp #1 SMP Wed Aug 19 08:12:11 EDT 2009 x86_64 x86_64 x86_64 GNU/Linu

    OBIEE :
    JAVA:jdk 1.5
    Oracle Client:
    There is no firewall as well as no anti virus.

    We are using sh.rpd. After login, we go to the answer select some fields. When we are trying display the result, it shows the processing status, nothing else. Though it is working fine in windows and other linux box.

    Could you please help me out?


  95. Aman

    April 28, 2010 at 8:52 pm

    Hi Shiva,

    In calender, IF I have selected date range between 2/2/203 to 2/4/2020. If particular Month doesn’t have data how would I show 0 count there…… User don’t want to see any gap between month– it should be in order like JAN to DEC, IF NOV Doesn’t have data– it should show as 0 count there….

    Can you please help me out how to do it.


    • RAGC

      August 25, 2011 at 11:05 am

      Could someone help me? I have the same issue as Aman posted before, has anyone the solution?
      Thanks in advanced.

  96. Rushi

    May 5, 2010 at 10:20 am

    Hiiii Shiva, glad to talk with u after a long time, i think u remind me, i am from kpipartners offshore.

    Here i want to know one thing, i want to achieve one criteria in DashBoards such that
    I want to see all pages of my dashboard without scroll…I mind…If I have 15 pages of my dashboard I would like to see “two lines”. One line with 8 pages and another of 7 lines for exemple.

    Thanks & Regards

  97. rushi

    May 5, 2010 at 10:24 am

    Hi Shiva, Glad to talk with u after a long time, hope u remember me, Rushi from KPIPARTNERS offshore.
    Here i have a doubt regarding the dashboards
    I want to see all pages of my dashboard without scroll…I mind…If I have 15 pages of my dashboard I would like to see “two lines”. One line with 8 pages and another of 7 lines for exemple.

  98. rushi

    May 5, 2010 at 10:25 am

    Thanks & Regards


  99. Patrick

    May 18, 2010 at 6:21 pm

    Hi Shiva,

    I really like yoru posting about case insensitivity in the dashboard prompt. Thank you for that. I was hoping you could help me on another issue I am having. I would like to be able to ‘Tab’ in the dashboard prompts when we have set an ‘is between’ rule. So for instance when we have text boxes for dates and we have the user pick two seperate dates. I would like it so they can tab from one text box to the other without the prompt refreshing. Currently the prompt refreshes and takes the focus off of the next texty box. Is there a way we can have it not refresh on text boxes or put the focus on the next text box in the prompt?

    Any help is greatly appreciated.



  100. Martien

    May 19, 2010 at 7:14 am

    iBots are scheduler using the regular Gregorian calendar. However the company that I work for uses a fiscal calendar. E.g. January month-end doesn’t necessary fall on Jan 31st, but could be the 29th.

    We have given this some options and came with a ouple of ideas:
    – run a program that will reset the iBot’s next run time based on fiscal calendar.
    – implement a database trigger that will reset the iBot’s next run time based on fiscal calendar.

    We were able to revderse engineer all the columns in the nq_job table.

    However we haven’t come up yet with a database procedure to implement this.

    The scheduler’s tables are in an Oracle database.

    Could you write up something?

  101. Shruthi

    May 20, 2010 at 9:40 pm

    Hi Shiva ,
    When I create reports in the Answers section there are several places where you can ‘format’
    your columns. But wherever I enter a value in the ‘width’ field of the ‘Additional Formatting Oprions’ section on the ‘Value Format’ section of the column properties, the width seems to
    remain the same in the report. How can I steer the width of columns in the OBIEE answers reports?

    Thank you in advance


  102. skumar

    May 24, 2010 at 6:46 pm

    Hi Shiva,

    I have a requirement where I need to pop up an error message asking the user to enter a valid value for a prompt. i.e if the user doesnt select any value ( = NULL) in the prompt and clicks the GO button, then the custom message should pop up – “Please enter valid value for the prompt”

    This is something similar to the date validation post in your blog. Can you please give me the solution to this requirement.

  103. Ranjith

    June 7, 2010 at 5:06 pm

    Hello Shiva,

    Would u pls let me know about the alias table in the physical layer?? It would be gr8 if you can provide a detailed explanation the alias table for what purpose we use it and how do we configure? with a suitable example? because this question is asked by every interviewer

    Explain it in a layman terms pls

    Thanks & Regards


  104. Deepak

    July 2, 2010 at 1:20 pm

    Hi Shiva
    I want to use presentation variable for the between clause in my dashboard prompt. By default when I had between clause in my dashboard prompt it does not give option of setting variable.
    Just wondering if there is any other way to do that.


  105. shabbir

    July 6, 2010 at 11:20 am

    Hi shiva,
    How can i pass a date value in chart title so that if any date is selected from the prompt it should display
    that date in the chart title.

    thanks in advance

    • Siva Kumar Budagam

      August 25, 2010 at 11:18 am

      Hi Shabbir,

      I Hope that can be possible by creating ” Presentation variable”.
      As per my knwoledge
      just create a prompt on Date Column and assign a Presenation Variable to that Prompt.

      Now just Call that Presenation variable in Chart Title by ” Report You Have selected for the date: @{Presenation Variable}{Default Value}.

      Hi Shiva,

      Let me know if i gone any thing wrong.

      Thanks in Advance.

  106. allam

    August 6, 2010 at 2:24 pm

    Hi siva,
    please can you send the answer for this issue.

    –>Show data loaded date and drill down instructions at top of all charts
    At the top of each chart, how can we add “Data Loaded on XX/XX/XXXX” label. Also, put “Click graph to drill down” on all graphs where applicable.

  107. shilpa

    August 11, 2010 at 10:45 am

    how can we generate reports for a particular time period in obiee

  108. Need to use 5000 values from excel to filter answers report

    August 12, 2010 at 5:04 pm


    This is some great work. My company needs a workaround solution for the business, without having to make lot of changes to RPD metadata. The requirement is to upload about 5000 serial numbers that need to be used a filter values for a reports in Answers. The 5000 number are in a excel spreadsheet.

    I proposed a solution, to load these to a standalone table and add it as an additional source to the logical asset dimension, which works, But the company does not want to make any changes to the metadata as this i s not a standard OBIEE requirement.

    Any help will be greatly appreciated.

    Best Regards,

  109. vamsi

    August 16, 2010 at 10:29 am

    Hai shiva
    Is there any option to arrange the dashboard pages in horizontal way………..

  110. Bharath

    August 19, 2010 at 5:58 pm

    I want to arrange the dashboard prompts in a sequence irrespective of the column names length
    so is there any possible way to do so.

    Thanks in advance

  111. Siva Kumar Budagam

    August 25, 2010 at 11:12 am

    Hi Shiva,
    Could you please expain the concept of Alias Table in OBIEE.

    How it is going to Avoid the circular Join.?

    the purpose of Alia Table in OBIEE..

  112. Manish

    August 25, 2010 at 7:44 pm

    Hi Shiva,
    I want to create a column with average of last 6 months sales data. I do have the sales data . I want it in such a way that if I just choose the month in the prompt it will give me the average of past six month sales from that month chosen month. How can I do this?

  113. Jithu

    September 1, 2010 at 2:23 pm

    Hi Shiva,

    I have problem with the dashboard prompt on the product list as i have selected multi-select option in the control when i am trying to enter it in the lower case it shows as no-choice found for any value present in the list. Can u please help with the solutions as i need to get the values as i entry them in lowercase as well?

    In the table, the values are in the uppercase so i need to get the values when i entry lower or upper? currently i do get when i entry in uppercase?

  114. Brindha

    September 14, 2010 at 4:20 pm

    hi shiva,
    i am new to it possible to merge two subject areas from different rpds into single subject area?

  115. Suneel Doddapaneni

    September 20, 2010 at 8:35 pm


    I wanted to add a text field to produce a table of results. I can do it by adding a prompt.
    But the problem is, I want to use this new prompt for only this particular table on the page.
    This page has other charts/tables with prompted filter on same field (I have a prompt on same field on the top of the page). But I want to use a different prompt for the same field which specific for only one table (don’t want page prompt). Is it possible to achieve this any way?

  116. sasikiran

    September 24, 2010 at 12:28 pm

    Hi Shiva,

    Nice to know about you!!!

    I’m new to OBIEE, browsing lots of portals / blogs and gathering OBIEE material and learning. I’ve lot of questions but I don’t have anybody who can answer queries in my space, appreciate if you respond to me via email.

    Many thanks in advance


  117. Jagadeesha

    September 28, 2010 at 9:39 am

    hi, I m new to OBIEE. plz help me by suggesting the way to learn OBIEE. and also suggest good tutorial

  118. Jyoti

    September 29, 2010 at 6:46 am

    HI Shiva,
    I have one report requirement in which i want to calculate cumulative sum of sales.
    How to achieve this in obiee.

    Locking forward for your quick reply.

    • sirisha

      July 20, 2011 at 4:03 pm

      Hi Jyoti, did u get answer for this even I have the same requirement

  119. Saran

    October 28, 2010 at 3:15 am

    Hi Shiva

    We are using
    Oracle Business Intelligence Product Version (Build 090414.1900)
    with IE-8 /IE-6/mozilla3.0/mozilla3.5 (diff users were having diff browers) , but the problem is same

    We are facing issue in BI answers (Presentation server is in Linux box/Oracle Appl.server) ,
    The compound layout drop down shows none of the views , i mean we could the see any of the pivot table ,chart views etc and the entire session gets hanged up , its not allowing to navigate any other options

    But when i run my local laptops presentation server(OC4J) to access the paint dashboards , i didn’t see any isue.

    Pledase do respond


  120. krishna

    November 3, 2010 at 7:20 am

    Would it be possible to provide a popup(Report has to display) by clicking on one of the line bar point?

  121. krishna

    November 3, 2010 at 7:21 am

    Would it be possible to provide a popup(Report has to display in the same page) by clicking on one of the line bar point of a line graph?

  122. Marina

    November 5, 2010 at 1:00 pm

    Hello, I am new to OBIEE.

    I need to know how to display the dashboard pages vertically

    I followed the steps in this blog “” but did not return any results.

    I followed the steps explained in the posts related to my questions in the OTN Discussion Forums “” but have not obtained any results.

    I am desperate. Please help me.

    Thank you very much.

    • Kanimozhi

      January 10, 2012 at 10:25 am

      hi… do you ve a solution for this? please share

  123. Corinna

    November 11, 2010 at 3:03 pm

    Hi Shiva,

    Is there a way to reduce the sensitivity of the search capabilities within OBIEE. For Instance when a user has a list of variables to use in their prompts, when typing in the first few characters to “jump ahead” in a long list, OBIEE responds faster than our users can type therefore it is removing all usabilty of the feature since they are still left to keep scrolling.


  124. Satyaprakash Paul

    November 17, 2010 at 6:40 am

    Hi Shiva,

    how to change angles of data levels of graphs in OBI EE, Because I am showing data labels at the top of each vertical bar of a bar chart. the data labels are of 4 digits, data level of a vertical bar is cuting the consigutive vertical bar(if the consigutive vertical bar is taller than this),

    I think if I can show the data labels virtically(in 90 degree angle) The problem will get resolved.

    can you please suggest how to change angles of data levels of virtical bars in a bar chart in OBI EE.

  125. krishna

    November 25, 2010 at 6:39 am


    can we create a Check Box Prompt as a dashboard prompt in OBIEE

    Thanks & regards


  126. Ananjan Chaudhuri

    November 30, 2010 at 7:07 am

    Hello Shiva,

    My name is Ananjan Chaudhuri and I work for Packt Publishing, a U.K. based publishing firm specializing in focused IT books. You can read more about us here:
    I came across your blog via a Google search and noticed a good amount of relevant information and blog updates related to Oracle Hyperion.

    I would like to inform you that Packt has recently published a new book The Business Analyst’s Guide To Oracle Hyperion Interactive Reporting 11, a book that provides strong relational querying and data analysis capabilities. Written by Edward J.Cody, this book demonstrates the key functionalities of the Oracle Hyperion Interactive Reporting software with a detailed view of each section and an introduction to dashboard design . You may read more about the book here:-

    Keeping in mind your knowledge in this subject and having looked at your contributions, I feel you’d make an excellent reviewer of this book. In case this subject interests you and you’ d like to go through a copy, simply let me know your shipping details and I’ll have the eBook added to your account and would provide you with the download instructions in my next e-mail. You can then download this book instantly.

    If you have any queries, do let me know and I’d be happy to assist.

    I look forward to hearing your thoughts on this.

    Have a good day!


  127. krishna

    November 30, 2010 at 12:53 pm


    1. Would it be possible to provide ranking on graphs by department based on their actual sales?

    2. If ranking is possible, Would it be possible to sort the department vertical graph bars by ranking?

    If not possible, please provide me the the alternative solution?

    Thanks & regards
    Krishna Mohan

  128. Rishi

    December 1, 2010 at 11:51 am

    Hi shiva,
    1.I would like to know how to introduce a new font type in to OBIEE_11g.I tried to change in the path E:\OBIEE_11g\Oracle_BI1\bifoundation\web\msgdb\messages/commonuitemplates.
    Newly introduced font is already added in control panel/fonts also.
    But it showing me an error while i selected the newly introduced font in the style tab of column properties.

    Error:Datatype error:InvalidDatatypevalue exception, Message:value
    “Baroquescript’ is not enumeration.

    Can u please suggest how i will get rid of this error and to get the new font works fine.


  129. Rishi

    December 1, 2010 at 11:52 am

    Hi shiva,
    1.I would like to know how to introduce a new font type in to OBIEE_11g.I tried to change in the path E:\OBIEE_11g\Oracle_BI1\bifoundation\web\msgdb\messages/commonuitemplates.
    Newly introduced font is already added in control panel/fonts also.
    But it showing me an error while i selected the newly introduced font in the style tab of column properties.

    Error:Datatype error:InvalidDatatypevalue exception, Message:value
    “Baroquescript’ is not enumeration.

    Can u please suggest how i will get rid of this error and to get the new font works fine.


  130. krishna

    December 2, 2010 at 9:27 am


    1. Would it be possible to provide ranking on graphs by department based on their actual sales?

    2. If ranking is possible, Would it be possible to sort the department vertical graph bars by ranking?

    If not possible, please provide me the the alternative solution?

    Thanks & regards
    Krishna Mohan

  131. kalyan

    December 3, 2010 at 1:21 pm

    Hi Shiva,

    This is Kalyan JV.

    Iam facing a problem in configuring the OBIEE 11g in SSO ( Single Sign On )configuration using OID.

    Could you please help me in regaring this asspect.

  132. Ravindra

    December 15, 2010 at 12:04 pm

    Hi Shiva,

    This is ravi, I am intresting to learn OBIEE, But i am new in obiee, So

    Please tel me the future about OBIEE and How many types of tools there in OBIEE Like administrator and dashboards.

    Thanks in Advance,

  133. Mousumi

    December 20, 2010 at 6:52 pm

    I have around 1lk record in a Education fact table.There is a column called University name.We don’t have any Dimension for University.The requirement is user wants a search on dashboard prompt based on University.Is it recommendable to make a prompt directly from fact table or shall I proceed with a new University Dimension and do teh report make the prompt from University Dimension column?

  134. Anjali

    December 23, 2010 at 7:51 pm

    Hello Shiva , can you please help me with this .

    I have the below scenario . Iam trying to get the grand total for a calculated column(variance) . I tried several ways …like report aggregates enabled in instanceconfig,tried creating cal colum using physical columns as well as logical columns in RPD , changing the aggregation rule to get it right but all in vain. The row wise values are coming correct but iam unable to get correct grand total instead iam just getting the sum of the total which is not used . I have tried the above options in my previous reports and those conditions work perfectly right but for this report they are not able to . If i dont use Sum By I cannt get the values by department , instead i just get one common total for everything.
    kindly please let me know if there is any solution for this issue .

    Example ”
    Department …ACT BUD Varianc(Sum(ACt by Dept)/Sum(bud by dept)*100)

    XYZ 10 20 50%
    ABC 25 75 33.3%
    Total 35 95 36.8% ( 35/95)


  135. galway

    January 3, 2011 at 8:18 am

    How to add new charts like Donought chart in OBIEE? Any one?


  136. sandeepa

    January 26, 2011 at 9:38 am

    How to create a chart in OBIEE? I don’t have any idea how to add a measure.

  137. sandeepa

    January 26, 2011 at 9:40 am

    How to create a chart report in OBIEE? Don’t have nay idea how to add measures.

  138. redver

    February 1, 2011 at 11:51 am

    Hi there!
    Can get OBIEE shared folder from a user over an URL Parameters?? Like a xml with info or something?
    And can I request something with SOAP?


  139. AJ

    February 1, 2011 at 10:15 pm


    I have upgraded my rpd from 10 to 11 and configured LDAP in weblogic and authentication works fine. Now unable to interate OBIEE with BI publisher in 11.Is there any security congigurations need to be followed in weblogic security. Pls let me know if you got any documentation on the same.



  140. Brian

    February 4, 2011 at 1:52 am


    We have reports that have several prompted fields.Some of these fields required fields.Is there a way (other than setting default values) to enforce a mandatory prompt.Please help Thank you

  141. Lyn

    February 8, 2011 at 1:00 am

    Hello, Shiva,

    Thank you for your posting on
    TIP #1:Export BI Catalog captions from command line in OBIEE 11g …

    Would like to check if similar function available in OBIEE 10g?



    February 8, 2011 at 9:11 pm

    How do u calculate % variance when the numerator or/And denominator can be nulls using OBIEE? I have tried case when ifnull(den,0) =0 and ifnull(num,0)=0 then 0 when ifnull(den,0) =0 and ifnull(num,0)0 then 100 else
    This didnt work. Do u knw any solution?

  143. Andy Tran

    February 12, 2011 at 8:30 pm

    I’m trying to run RUNCAT.CMD with the online switch, but I can’t get it run properly. Am I doing it right?

    runcat.cmd -cmd unarchive -online http://localhost:9704/analytics/saw.dll?catalog -credentials d:\ -inputFile D:test.catalog -folder /users/weblogic/_filters -acl preserve -overwrite force

  144. Nalini

    February 13, 2011 at 7:07 pm

    How to use the time stamp to get the data for last 1 month, 2 to 4 months and greater than 1year and show it in pie chart. Any help would be appreciated.

  145. Naveen kumar

    February 16, 2011 at 5:39 am

    Hi Shiva,
    Glad to meeet u.

    Here i have requirement.Navigate from one report to another.

    Eg: i have one column

    when i am trying to click any one of the above values it should navigate another the second report have detailed data.
    here prob is when i click on the 101 it navigates to 2nd report with detail data. but i need when i am trying to click on 101.the 2nd report should display data based on what ever filter i given in 1st report i.e., should give 101 data only.

    Can give the solution how to achieve it.

    Naveen kumar

  146. sravankumar boggarapu

    February 21, 2011 at 5:37 pm

    Hi Shiva,

    Great work!!! Could you please write a posting on SSO and securities implementation in OBIEE 11G

    Thanks in Advance

  147. Nagesh

    March 1, 2011 at 9:13 pm

    Hi Shiva,

    It was pleasure reading your blong and Aske part of it.
    I have small issue with sh.rpd that I’ve downloaded from
    net. The saved filters folder is empty, I have not deleted
    any filters from it.

    Can you please guide me how to get it.
    Also can you guide me how to create a filter showing last 12months results.

    Thanks and have a great day

  148. Jeetu

    March 2, 2011 at 12:17 am

    Hi Shiva

    Thanks for the wonderful work. My client has a requirement in OBIEE 11g as follows.

    Reports are sent through e-mail every week. But they want to have the dynamics of drill up /drill down in the excel downloaded copy of the report using + mark sort of collapsible view. How can we achieve this.

    Also, when there are multiple reports to be sent to same receipient, what is the best delivery channel via e-mail?
    I mean, they don’t want to send 5 different attachements nor ZIP files. Is there any inventive way which pleases business??

    Thanks in advance

  149. Nagesh

    March 2, 2011 at 11:10 am

    Hi Shiva,
    It was a pleasure reading your blog and I enjoyed it. I have questions, How can I create a report to generate 12months values to display from sh.rpd. Incidentally, the saved filter folder is empty on sh.rpd.


  150. xuna

    March 10, 2011 at 1:57 am

    Hi Shiva,

    I was doing the YTD and MTD sale achieve in my report, but when i drag the YTD and MTD into pivot table, the value become incorrect, for YTD, It sum up all the YTD. How should i do??

  151. daledo

    March 14, 2011 at 4:43 pm

    Hi Shiva,

    I have a Most Recent 12 months filter set in OBIEE11g which is resulting in correct data. My issue is how to have it return the all of the months even if there is not any sales during that particluar month? Also, when graphing the data, the horizontal axis will show each sales date, is there a way to group the horizontal by month and plot within the correct month?

    Your post was very helpful!

  152. Nipun

    March 16, 2011 at 2:02 pm

    Hi Shiva,

    I’m facing one issue with the Calendar Type Prompt in OBIEE 11g.
    I referred your post on “OBIEE IS BETWEEN Date Validation for dashboard prompt” but could not able to do much as i could not locate “globalfilterprompt.js” file in OBIEE 11g.

    Seems like this file has been renamed in 11g. did lot of R&D on the same but could not locate the script file.

    could u pls help me with the same in OBIEE 11g.


    • jack

      July 28, 2011 at 1:31 pm

      ı have faced this issue too and can not find any solutions yet…ı will be appreciated for your help

      best regards

  153. Suresh

    March 27, 2011 at 2:24 am

    Hi i got a requirement which looks like this
    id type person Count
    1 Ongoing Stella 0
    2 Ongoing Nick 0
    3 FCC Sam 1
    4 Ongoing copter 0

    my question is if i click on count values it should navigate to a report and based on type column value it should pass filters that is if type is Ongoing it should pass 2 filters if type is FCC it should pass three filters. but i am clicking on count values not on type column.


  154. Dipak

    April 18, 2011 at 3:29 pm

    If I have a requirement where I need to publish report as follows –
    Current Date: 1 Jan-2012
    Q1 Total = 100
    Q2 Total = 200 Quarter on Quarter difference = 100
    Q3 Total = 400 Quarter on Quarter difference = 200
    Toal = 200 Difference since last quarter = 200

    Toal = 150 Difference since last month = 50

    Total = 250 Difference since last month = 100
    Q4 Total = 600 Quarter on Quarter change = 200
    Please Note:
    a] In my system I am loading data month wise.
    b] For current quarter it should segregate month wise.
    i.e. Q1 report will give details of JAN-FEB-MAR,
    Q2 report will give details of APR-MAY-JUN,
    Q3 report will give details of JUL-AUG-SEP.

    How to create such a reporting?

  155. AKS

    April 25, 2011 at 7:41 am


    Can you please please tell me how to purge cache in unix obiee.


  156. Gerrit

    April 27, 2011 at 12:16 pm

    Hi Shiva,

    Great blog. Noticed you have SSO experience in OBIEE 11G. How do you translate the following config to 11G.

    Thanks in advance…

  157. Gerrit

    April 27, 2011 at 1:28 pm

    Hello Shiva,

    Learned a lot from your blog… I have an OBIEE 11G config problem. Can you please post a guide on how to implement SSO trough Http Headers on Weblogic Server?

    Thanks in advance…

  158. FR

    May 2, 2011 at 10:37 am

    Hi Siva,
    I am very new to OBIEE……i have acheived naviagting from the Master report to Detail Report.. but what i also want is my deatil report should appear at the right of Master report based on my click of record.. Kindly help..

  159. chandra

    May 3, 2011 at 5:36 pm


    I want to calculate last three months average dynamically in pivot table view. So, How to do that? Please suggest.

  160. Shyly

    May 17, 2011 at 5:01 pm

    Hi Shiva,
    I have always followed your blogs to implement and explore new things.
    Currently, I am working on SSO Implementation in OBIEE 11 G and I have seen in your profile that you have implemented it.I am unable to find any documents with the implementation steps.
    I know that the steps will not be the same what we used to do in Siebel Analytics/Obiee 10 G.
    Can you please provide any document to follow or guide me as I am completely stuck.
    Many Thanks.

  161. SHyly

    May 19, 2011 at 9:32 am

    Hello Shiva,

    Learned a lot from your blog… I have an OBIEE 11G config problem. Can you please post a guide on how to implement SSO trough Http Headers on Weblogic Server?
    How to do Impersonation and Configure SSO /SM Authentication in OBIEE 11 G.

    Thanks in advance…

  162. Mahesh

    May 21, 2011 at 7:00 am

    In recent interview i vounterd with this question.
    What are the disadvantages of Pivot table?

    Does anyone know the anser..

    Thank you

  163. Karan

    May 25, 2011 at 10:11 am

    Sub: Creating BI report with 2D stacking for two different variables legend axis


    I am trying to make a report where on X-axis I need $ value, and on Y-axis I need a combination of 2 database fields (say customer and sales territory) stacked as a 2D/3D chart. I need to display such top 21 combos, so 21 bars on Y-axis. (For Ex. If 4 sales territories, then for every customer, there would be four customer and sales territory combos).

    Also, I need following legends as bars – type of sales and type of customers as in I have four such legend options: Credit-Premium, Cash-Premium, Credit-Normal, Cash-Normal.

    Any pointers how to do that and if I need any sub queries to handle that?


  164. Vind

    May 25, 2011 at 11:29 am

    Hi siva,
    Good work!!!
    I’m new to obiee.
    how to add compound layout view in answers. please reply

  165. Purush Thirumala

    May 25, 2011 at 5:04 pm

    Shiva, can you please help me to create a calculated column for “Rolling Average Daily Net Sales”. I created Average Daily Net Sales calc and it works fine and numbers are accurate. The report runs as of prior business day. Please help.

    Calc for “Average Daily Net Sales” and I need calc for “Rolling Average Daily Net Sales”:

    ifnull(FILTER (“- CoverSheet Fact”.MTDNetSales USING (“- Calendar”.”Calendar Date” = cast(cast(month(VALUEOF(“Previous_Day”)) as varchar(2))||’/’||cast(day(VALUEOF(“Previous_Day”)) as varchar(2))||’/’||cast(year(VALUEOF(“Previous_Day”)) as varchar(4))||’ 00:00:00′ as date))) / max(case when “- Calendar”.”Calendar Date” = cast(cast(month(VALUEOF(“Previous_Day”)) as varchar(2))||’/’||cast(day(VALUEOF(“Previous_Day”)) as varchar(2))||’/’||cast(year(VALUEOF(“Previous_Day”)) as varchar(4))||’ 00:00:00′ as date) then “- Calendar”.”Business Day of Month” else 0 end),0)

    • Vbhat

      January 6, 2012 at 10:50 pm

      Use the BI function MAVG (expr, integer) – Calculates a moving average (mean) for the last n rows of data in the result set, inclusive of the current row.

      Go to the Presentation Column–>Functions–>Running Aggregate–>MAVG

  166. Karan

    May 30, 2011 at 12:30 pm


    I have a query. I have made some reports in OBIEE, with “region” as a page prompt for report filteration. I have also defined region related roles using jsp pages in my OBIEE Instance. Now if a user has access to no region and in that case, if he/she tries to access a report, how to we display an error saying that “You don’t have adequate access”?

    Thank you.

  167. Karan

    May 30, 2011 at 12:32 pm


    I am trying to work on some jsp pages in OBIEE for doing some mapping in order to finalize some data in my OBIEE (to be used for OBIEE reporting). However, whenever I click on any field on the jsp page (in Internet Explorer)for an existing record, my cursor points to the beginning of the field and not towards the end. No such issue is there in Mozilla or other browsers. Is that a known issue?


  168. Pavan

    June 1, 2011 at 3:28 pm

    Hi Shiva,

    Could you let me know how the pre built rpd is designed and any doc’s for BI AnalyticsApps.rpd


  169. Cash

    June 1, 2011 at 6:05 pm

    I’m new to answers so any help would be much appreciated. I have several reports on a dashboard page, I would like to allow user to choose time period via a javascript radio button such as:
    ( )Monthly
    ( )Quarterly
    Then in the reports set a column called period based on the value of the var. THis way I could develop just one report that displays based on the period var rather than making three different versions of the report. Can anyone give me step by step instructions and example of how to do this.

    Thanks very much in advance!

  170. Cydabuan

    June 14, 2011 at 5:18 pm

    Any experience/ideas regarding the use of Type 2 SCD approach to capture change history for fact tables? I’m on an OBIEE project that deals mostly with inventory balances as facts. The facts are not cumulative, so the total for a given period is less important as say what the value was at a particular point in time (usually at the end of the billing month) or what the average/min/max was over a specific time period. These facts don’t change often (we see anywhere from 100 – 300 balance changes a month for 18,000 accounts).

    From a modeling standpoint, I’ve read about using Start/End Dates (Type 2) on fact tables to avoid having to take the performance/capacity hit of daily snapshots of everything. But it doesn’t seem to me that OBIEE Answers could handle this design very well. Can you shed some light?


  171. Kalesg

    June 14, 2011 at 6:42 pm

    Hi Shiva,

    I have a source code and need to find tables create a rpd
    An existing RPD has been created .net and I need to do it on Obiee – can u help me please


    Thanks in Advance

  172. Can we customize " View Display Error" in OBIEE

    June 15, 2011 at 11:12 am

    Can we customize ” View Display Error” in OBIEE

  173. ss

    June 19, 2011 at 5:16 pm

    Hi, Is there any way to hide the Edit button in MultiSelect prompt?

  174. Chandu

    June 20, 2011 at 9:28 am

    Hi Shiva,

    We have a requirement to create a report in BI Publisher from two different databases one is from Oracle database and other is from MSSQL. But when we creating the JDBC Connection we can create only one connection at a time.
    Can you please let me know whether we can do this or not. If yes please let me know how?

    Thanks in Advance

  175. Girish

    June 21, 2011 at 1:55 pm

    I am facing an issue in anOBI report. There is a prompt FW from and FW to. Columns in report give valuesaccording to the FW range except one column should give cost for selected FW-1and selected FW -2.For eg:I select Fw from 5 to 13.Column ‘prior twoweeks’ should give cost for FW 4 and 3.There is problem in getting valuesfor ‘prior total weeks’. I need help in this issue as soon aspossible.

  176. Sunil

    June 23, 2011 at 3:14 pm

    Error Installing OBIEE Software Only
    I am trying to install OBIEE 11g Software on Windows 64 bit machine, as I want to use the scale out option going with Software Install Only.
    The Oracle documentation is says if we want to use the scale out option we have to install the software in a Shared Network Drive, So mapped this shared network drive on the server and did the install.
    Initially I didn’t map the drive I got the insufficient error:

    I mapped the drive and installed the software again, initially I was unable to run the software but installed the Weblogic through command prompt:

    Was able to install Weblogic, OBIEE software Install and configured. Initially was able to login to answers and tried to login em and console was unable to then figured out the “Oracle Process Manager (instance1)” is not started then tried to restart the services but the below errors came up:

    Tried to restart from the location: O:\Oracle\OBIMWHome\Oracle_BI1\opmn\bin\opmn.exe
    Got the below error:

    My question is reinstalling going to work and did I do the followed the rite procedure for the installation.
    Earlier to this tried the below two:
    1) Installed OBIEE on one server and tried to scale out horizontally on other machine it was good until 66 % of the configuration and waited for 3 – 4 hours but no response, then figured out that the Enterprise installation won’t work.
    2) Tried to scale out the installation through Software Installation (Installed on local Drive), but came to know that the installation should be done on the shared drive.

    Oracle SR

    Working with Oracle on this, but they are saying that it won’t work on Shared drive requested the correct procedure but no reply as of now.

  177. Sunil

    June 23, 2011 at 3:31 pm

    Hello Siva,

    I am sorry the screen shots didn’t copied in the earlier post . I am writing the errors here… Please let me know if you have a solution..

    Error Installing OBIEE Software Only
    I am trying to install OBIEE 11g Software on Windows 2008 Server 64 bit machine, as I want to use the scale out option going with Software Install Only.
    The Oracle documentation is says if we want to use the scale out option we have to install the software in a Shared Network Drive, So mapped this shared network drive on the server and did the install.
    Initially I didn’t map the drive I got the insufficient error:

    Error: Insufficient disk space! The installer requires:
    203 MB for the middlewarehome at so and so….

    I mapped the drive and installed the software again, initially I was unable to run the software but installed the Weblogic through command prompt:

    in the command prompt on the drive ran this : java -Xmx1024M -Dspace.detection=false -jar wls1035_generic.jar

    Was able to install Weblogic, OBIEE software Install and configured. Initially was able to login to answers and tried to login em and console was unable to then figured out the “Oracle Process Manager (instance1)” is not started then tried to restart the services but the below errors came up:

    Error: Windows could not start the Oracle Process Manager (instance1) service on Local Computer,
    Error2: The system cannot find the file specified.

    Tried to restart from the location: O:\Oracle\OBIMWHome\Oracle_BI1\opmn\bin\opmn.exe
    Got the below error:

    My question is reinstalling going to work and did I do the followed the rite procedure for the installation.
    Earlier to this tried the below two:
    1) Installed OBIEE on one server and tried to scale out horizontally on other machine it was good until 66 % of the configuration and waited for 3 – 4 hours but no response, then figured out that the Enterprise installation won’t work.
    2) Tried to scale out the installation through Software Installation (Installed on local Drive), but came to know that the installation should be done on the shared drive.

    Oracle SR

    Working with Oracle on this, but they are saying that it won’t work on Shared drive requested the correct procedure but no reply as of now.

  178. lavanya

    June 30, 2011 at 4:35 pm

    I am lavanya and i am preparing for a interiview in obiee as a obiee consultant
    i want to know if u have 20 reports in the dashboard and the user want to see only 10 reports in the dashboard then how to hide those reports .
    thank you

    • chaitantya

      July 7, 2016 at 9:00 am

      you can use view selector option there you can select which report you want to see

  179. yogi

    July 1, 2011 at 2:18 pm

    my question here is.

    i want display a dashboard with empty report initially but my condition is it shows prompts without intial values in the prompts when ever i hit the go button it display report during this process i didnt enter any values to the prompt.

    is it possible in obiee to display dash board as empty?

  180. Rajkiran Taraka

    July 11, 2011 at 4:50 pm

    Hello Siva,
    I am using agents for seeding the cache, I am unable to view the hidden dashboard or dashboard pages. Do you have any suggestions for scheduling a hidden dashboard page.


  181. Venu Madhav

    July 16, 2011 at 6:04 am

    Hi Shiva,

    Could you please help me in removing vertical line in graphs(X-axis line or border). I can able to customize the grid line but not X-axis.

    Thanks & Regards.,
    Venu Madhav

  182. Diniz

    July 23, 2011 at 9:35 pm

    Hello Shiva,

    I’m having problems in generating a line-bar graph. I’m working with Essbase as the data source and want to pick the following layout:

    Real and estimated (bar) – Scenario Dimension;
    Percentage change (%) (Line) – Scenario dimension

    The problem is everyone is on the same level of hierarchy. I have created a calculated field, but without success.

    Any suggestions?


  183. khajisai

    July 28, 2011 at 4:31 pm

    Hi Shiva,

    Can we pass a presentation variable value from one report to other report using go url.

    Sai Prasad

  184. Cristina

    August 4, 2011 at 3:26 pm


    I have a table TAGS with Demo_ID and TAGS and in this moment it looks like this:
    1 a
    1 b
    1 c
    2 e
    2 d

    And I want to make a new logical column (this is my idea) in TAGS table which could give me this result:
    1 a,b,c
    2 e,d

    How can I do that? Should I create an expression in the new logical column? What do you suggest? Hoe should look the expression?


  185. AP

    August 5, 2011 at 1:35 pm

    Hi Shiva/anyone else,

    I have configured the “act-as” function in OBIEE and from the drop down list I am ok ti act for some users but for some the following error appears (and I am looged out of Answers):

    Unable to Log In
    Odbc driver returned an error (SQLDriverConnectW).

    Error Details
    Error Codes: OPR4ONWY:U9IM8TAC
    State: 08004. Code: 10018. [NQODBC] [SQL_STATE: 08004]
    [nQSError: 10018] Access for the requested connection is refused.
    [nQSError: 13023] An external user ‘A33369’ can not run as an internal user ‘K2824’. (08004)

    Any ideas why this error comes for some users and what I need to do to mitigate? I have checked the proxy users table in the DW and there is a row for A33369 and K2824.

    All help is appreciated!!!

    Many thanks.

  186. Nir

    August 10, 2011 at 6:45 am

    Even in short reports (at least I think they are – it works fine in OBIEE 10),
    I keep getting ‘Exceeded configured maximum number of allowed output prompts, sections, rows, or columns.’

    Error Codes: IRVLJWTA:OI2DL65P
    Location: saw.views.dashboard, saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool, saw.threadpool, saw.threads
    SQL Issued: 730784~jk0irse6jr4hl656pqlrv36h46

    I already configured my instanceconfig.xml as follows:










    &nbs! p; 1000


    Can you please advise?
    Maybe add general post regarding all those instanceconfig parameters – their meaning and the range of acceptable values, what are there Max limits and what are the pitfalls.

    Thanks a lot,

  187. Amna

    August 10, 2011 at 10:31 am

    Hi Shiva,

    I’m a beginner with OBIEE Answers and I have a question as follow:

    I’m working on a report that has a column field that is calculated to depend on the previous row i ascending order, to elaborate more: I have columns as follow (Month, Open_old, Opened, Closed, Still_open) for ‘opened’ are complaints opened in the same month, some of them are ‘Closed’, some stay ‘Still_open’ which equals (Opened-Closed). for the first month ‘Open_old’=0, but whatever ‘Still_open’ is carried over to the next month to be in ‘Open_old’, where ‘Still_open’ will equal (Open_old+Opened-Closed).
    From source i have (Month, Opened, Closed), how can I add the remaining two columns and their calculations (Open_old, Still_open).

    I hope my case is clear.

    I really appreciate your help.

    thanks & Best Regards,


  188. Henrique Silva

    August 14, 2011 at 10:07 pm

    Hi Shiva

    I wonder if you have already found out how to allow users to change theis own passwords on OBIEE right on their account dialog box. In version 10g, I got that by changing the “customMessage.xml” file, wich doesn’t work on version 11g. Hope you could shed some light on this matter.


  189. Vinay

    August 22, 2011 at 9:18 am

    This is Vinay.I am new to OBIEE.i have a requirement to show the page nos at the end of a report page(by default)
    Suppose if i go to second page of the report is should show 2,third page of the report it should show 3.

    1.I have already tried it by using pivot table option by setting the no of records and using the maxrowcountfn but I am getting it as a drop down list.

    2.Can we acheive it by using the footer option in edit dashboard page.I have tried this one also but not getting it

    Please help me to resolve it


  190. sanjeev yadav

    August 26, 2011 at 7:03 pm

    Hi shiva,
    My requirement is like. Through Presentation variable m passing fiscal period(eg : 2011 P03 , P03 is march month ) to Parent report displaying YTD Actuals(measure eg abc) ,when i drill down to YTD value , i see new child report that shd display break up of YTD value(abc = a + b +c ) date wise , n that date shd be(eg : =P01 of that year, )

    Plz suggest .


  191. elopezch

    August 29, 2011 at 3:08 pm

    Hi Shiva,

    I have installed OBIEE 11g, I posted on the Internet through a weblogic server, when accessed from any pc, it looks good and I can enter everything, but when accessed from an iPhone or iPad or any mobile device, the tabs that I did in the dashboard are not shown anywhere on the screen, only I get information from the first tab and the rest are not shown. What could it be?

    Please help me to resolve it,



  192. Surya Sanush

    August 30, 2011 at 9:35 am

    Hi All,

    I’m new to OBIEE. Actually we have a requirement like we have to display the values entered by the user in the prompt , at the top of the answers report.
    For eg: If the user enters the “Name” as “x” and “Number” as “1” in the prompt, at the top of answers report, is should be displayed as Name : x ,and in next line , Number : 1.
    And I was able to do this by creating a presentation variable for my prompts and calling that variables in the narrative view.

    But the problem is my user enters atleast 10 fields like no, name etc. So how can i have 10 narrative views. Is there anyother way of making this possible?

    can anyone guide me in this?


  193. Taimoor

    September 2, 2011 at 6:45 am

    I’ve a requirement to add a budget column in a P&L report of OBIA apps. I need your help of how to do it?

  194. Kausik

    September 5, 2011 at 8:25 am

    I need to transfer a report into a folder. I used a VB script for geeting it done. But some error is popping up:

    [nQSError: 66003] Script engine does not support the IActiveScriptParse interface.

    Mines a 64 bit server. I heard there is patch for it. But am unable to locate the patch.

    Plz help

  195. Attitude01

    September 19, 2011 at 11:50 am

    Hi Shiva,

    Recently we are facing an issue in our BI application . We have implemented Disconnected Application Cache via ibots in our application . We have used preprocessed sync and according to the process what it does is , it saves the data in .csv files into server by making folders of disconnected users.

    Currently , we fould and issue that particular report does not contain data in disconnected mode. Whne we backtraced the issue we found that , the underlying table for the report is empty and when we further investigate we found that , the .csv file kept in server against Uset folder contains an error code , which is :

    For this reason no data is there in csv files and the disconnected report is also showing emmpty columns for that.

    Can anybody please help me solving this issue . I am not sure why this error happens and what this kind of error code signifies.

    As it is a production issue, it becomes very urgent to solve this . Can anybody please give me some idea how to resolve this one.

    Thanks and Regards,

  196. mohan

    September 21, 2011 at 11:44 am

    Hi shiva,

    This is mohan, do get last week sales. I need a sql query
    2. what is a brige table?
    3. how do implement report level security?
    4. i face a challenge that is in rank/ top functions i didnt get total sum how do i get aggregation sum for rank/ top functions?

    please send reply

  197. Jayanth

    September 21, 2011 at 6:18 pm

    Hi Shiva, I have a requirement.

    We have Opportunities and Activities. And the relation is 1:M

    Lets suppose that we have Opty1 and 5 activities Act1, Act2, Act3, Act4, Act5, I can identify these Acitivities uniquly under each Opty using the Activity Type. So lets assume that for all the 5 Activiites there are Types like A1–> T1, A2–> T2, …. A5–> T5. Also each activity has Start Date and Date.

    Now I have to pick those opportunities which have 2 activites A1 and A2, and End Date of A1 should be <= startdate of A2

    I am struggling with this. Please provide me incase you have any idea.

  198. teja

    September 23, 2011 at 7:13 am

    hi ,
    I want to display the number of page in a dashboard page and also the date for the report .

  199. Dinesh

    September 26, 2011 at 11:27 pm


    I have two requirements in OBIEE Reports can you please help me to resolve the below two issues that i am facing in my Reports

    1) Running Avg : In one Report i have to report running Avg based on the number of the records displayed in my tabular form . eg… i have 4 rows .. sum of all the rows is 100.. then my avg should display 25 .. while based on the report prompt selection if i get 6 rows .. and sum is 120.. then avg should be 120/ 6 : – 20 . This Avg is calculated at the run time .. I am displaying this avg value as another report on the top of the same Dashboard.. Now problem is i am not able to get this dynamic running Avg value.. I only get one Avg value at Grand Total Level.. which is not correct ..
    can you please help .. if there is any way i can achieve this running avg ?

    2) Graph Data and Tabular Data are not in sync – I am restricting the number of rows to display at given point of time to say 15 .. per page in tabular form.. But the graph that i build on top of the Tabular Data is showing all results based on the report selection . I want to make sure the Graph and my tabular data are sync .. e.g if my rows are 15 .. the graph should also for 15 records and when i do next page .. the tabular data will get next set of 15 records and similarly my graph now should reflect the new 15 records .. Can you please how to achieve this ?

    Appreciate any pointers to resolve these two report issues


  200. Deeptha

    September 28, 2011 at 6:06 am

    I have 2 fields in my table, one contains one ore more codes delimited by pipe or comma and the other field contains an integer. I want to separate the field values with delimiter and consider it for summing up the integers. I do not want to use Derived Dimensions since if there are more codes added, then there is lot of rework to be done.

    ColA ColB
    Code1, Code2 5
    Code1, Code3 10
    Code2 2
    Code3 3

    The Result I want to display is as below:
    Code1 = 15 (as sum of row 1 & 2 for the ColB)
    Code2 = 7 (as sum of row 1 & 3 for the ColB)
    Code3 = 13 (as sum of row 1 & 4 for the ColB)

    Is this possible in OBIEE Dashboard?


  201. venkat

    September 28, 2011 at 10:38 am

    Assistance needed please

    hello people, this is venkat i am facing few problems in installing OBIEE(10g and its database oracle 10g. I’ve installed OBIEE and it also has a setup of Oracle database 10g, and i even tried to install that as well. after successfully installing OBIEE, and i even tried to install the orale database 10g…at the end of the installation, a small window popped out saying ‘password management’ i’ve unchecked SH, HR and SCOTT.

    When i started with my first report, I couldn’t any SH(Sales History) folder to choose this as my source in building a report in the presentation layer. can anyone please help me out in this regard.


  202. Gotzon Barrueta

    September 29, 2011 at 11:26 am


    I have a problem with a dashboard month prompt in OBIEE 10
    If I use month ( the number: 1,2,3… ) it works, but if I use monthname ( the text: Jan, Feb… ) it doesn´t work.

    Can you help me please ?

    Thank you very much.


  203. JL

    September 29, 2011 at 6:46 pm

    When displaying data in a horizontal bar graph, it is possible to force every label of the vertical axis to be shown. Right now it shows one, skips one, etc.

  204. nag

    October 3, 2011 at 5:13 am

    Hi any body,,

    can you give me reply for below questions..

    Can we create promts on measures?

    will we apply prompts to chart tables, pivot tables?

    what is difference between hidden and excluded?

    how do we set up refresh dashboard for every one hour?


    what is is prompted?


  205. Rafi

    October 5, 2011 at 12:39 pm

    Hi Shiva,

    I have created YTD, QTD and MTD logical columns at RPD level which is working but the problem which i am facing is that the Figures which i am getting through YTD, QTD and MTD is not matching with the actual figures. i have a fact table called sales fact which has transactional data and i have created hierarchy as

    Total Year

    The day is the lowest level in my hierarchy.

    Waiting for your reply.

    Thank you.

  206. Arun Prasad M

    October 10, 2011 at 2:29 am

    Hi Shiva,
    Am new to OBI Development.My requirement is to query a database from where i would get criteria’s for report execution like execution time, the search conditions the email template to be used sender and receiver email addresses, etc based on which i will be querying another database to fetch the actual data to be sent as a report. Can you please let me know how to get started and proceed with this?

  207. srikanth

    October 10, 2011 at 2:30 pm

    hii shiva
    can i navigate from one hierarchy to another hierachy in bmm layer
    if not why canoot we do it and solution please;

  208. Deepika Sinha

    October 11, 2011 at 1:42 pm


    we have table from t1 to t8 and all join are in following format

    we have scenario like t1 join t2 ,t2 join t3, t3 join t4 , t4 join t5 ,now t6 join t5 , t7 join t6 , t8 join t7.

    and we have to show reports using t1 and t2 table mostly. so how we design our bmm layer using above scenario that data which we get from UI level should always correct.

    Note- In Physical layer database source is OLTP database and t1 join t2 means t1 at 1 and t2 at Many side


  209. Santos

    October 12, 2011 at 4:15 pm

    I am facing an issue with Line Time Series Graph.

    Dayname (Tue, Wed, etc..) is always showing a day in-advance whereas the pointer on the graph shows correct date/timestamp.
    The filter I am using is LAST_UPDATE_DATE > TIMESTAMPADD(SQL_TSI_DAY, -2, NOW()).

    Any idea?


  210. John Hollifield

    October 18, 2011 at 8:25 am

    Hi Shiva,

    We have a problem with the OBIEE 11g (running Action Framework and wondered if you had seen similar or maybe point me in the right direction of a solution.

    I am logged into OBIEE as a user with permissions to create actions but when I click New->Action (from the top dropdown menu or anywhere else) I get a server error which states:

    An error occured during processing of the SSL protocol
    1093359936:error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed:s3_clnt.c:1059

    The log viewer in Enterprise Manager gives us

    UNKNOWN_CA alert received from [HOSTNAME] – [IPADDRESS]. The peer is rejecting the certificate chain as being untrusted or incomplete.

    We are running SSL everywhere and everything else seems happy with our certificate. I have dug into the documentation with no success. Any help would be appreciated.


  211. Neela

    October 19, 2011 at 5:48 pm

    Hi Shiva,

    Great to see ur post…I need ur help for some of my questions..I also have been working on OBIEE for the past 3 years and also I have worked on OWB to an extent…I have completed my Oracle Certification in OBIEE 10 g as well…I just want to improve my BI career graph…Is there any other possible certifications that you can suggest me or how should I move forth ?

  212. Giri

    October 29, 2011 at 8:18 pm

    Hi Shiva,

    How to remove the “powered by oracle” logo which appears at the bottom of the dashboard in Siebel Answers in OBIEE

    Generally in 10g we followed below way.

    1. Open OracleBI\web\msgdb\l_en\messages\productmessages.xml file.
    2. Search for the fmap:siebelbug.gif line on this file
    3. Replace it for fmap:empty.gif and save it.
    4. Restart Oracle BI Server and Oracle BI Presentation Server Services in order to apply this changes. Or if you are already logged in the application, prior to stop and start both services, you can click on Settings > Administration. On the Administration window opened, click on Reload Files and Metadata. Wait a few seconds, then go back and access the Download Link. The changes will be applied there.


  213. sathish

    November 3, 2011 at 11:02 am

    Hi shiva,

    My reporting scenario is i want to show employees who are all to claim the their travel claims together.In Claim_emp is table,there are emp_no,emp_name.from_city,to_city all columns, in which some employees are (travel together so their departure and destination are the same) claim their travel allowance.I want to show employees who are all claim together(claim no is unique to every emp but departure and destination are the same) in reports level in answers.

  214. David

    November 3, 2011 at 7:03 pm

    When I connect via VPN to my clients network then log into their OBIEE 10g implementation, I am not able to do certain things like open or save a report, the IE symbol just ‘spins’. When I drag columns in and choose ‘results’ the IE symbol just spins and nothing happens. I have had the client try this while logged on with my ID at their site and it works fine. What do you think could be the cause?

  215. Aakarsh Kalra

    November 4, 2011 at 8:44 pm


    We are using BI Publisher 11g and have a requirement of showing the usage statistics of the different reports in BI Publisher 11g. I have seen the video in the blog which shows what all we can do with usage statistics but i would really appreciate if someone could explain me the steps or give me pointers on how to get the usage data. In which tables does it reside, the column names, any other help on this will be greatly appreciated.


  216. MadhuSudhan

    November 6, 2011 at 6:32 am

    Hi Shiva,
    i ve a requirement in dash board i want to display results certain condition how can we achieve this requirement plz …..

  217. George

    November 6, 2011 at 10:14 pm

    How does OBIEE deal with non-aggregate measures, for example, inventory End on Hand?


  218. Venky

    November 13, 2011 at 1:37 pm

    I have OBIEE report with 10 columns and I wanted to compare 3 columns data like

    col1 col2 col3
    ab 01/31/2011 125.00
    ab 01/31/2011 125.00
    xy 01/25/2011 150.00

    similar to the above example I am getting some repeated data for those 3 columns in some periods. So my question is how can I create a flag or highlight data where ever we wee duplicate of these 3 columns. Please suggest me how to do this in OBIEE Answers

  219. Ashish

    November 16, 2011 at 3:21 pm


    we have OBIA with OBIEE in place on Oracle Studio based in US.

    Dashboards/reports are picking up date in US format (MM/DD/YYYY) even I have altered file localedefinitions.xml with locale “en” , “en-us” or “en-GB”. I need to format using DD-MON-YYYY which I can do from dahsboards but there a lot to change. Is there any easy way to do that through any other config file?

    Ashish Gandhi

  220. Carol

    November 16, 2011 at 7:48 pm

    Hello, how are you?
    So, can you help me, pls?
    I need create a report with 2 selector views, each selector view need show with different scenario. All the crossing is the same for two, except the scenario.
    I created, but its return duplicated.
    Do you know why?
    If you didnt understand me, ask pls, because my english is so-so.

  221. Warren Treuhaft

    November 22, 2011 at 2:25 pm

    We are experiencing differences in the results generated by P6 Analytics & Primavera. A basic report showing actual hours charged by resources against an activity are different between Analytics & what we see in Primavera and are not related to timing issues for updating the cubes, etc.

  222. sahadev

    November 24, 2011 at 10:03 am

    Hi shiva,
    I have the requirement on answers in obiee, which is having sum values on Y-axis, and time frames like ’00-12h’ on the X-axis. My doubt is i want to display my chart with sum value bars on the Y-axis but i don’t need sum value scale, i want to display the scale as percentage values like, ‘0, 2.5, 5.0, etc . Can you please give the proper way solution for this.


  223. Srinivas.

    November 25, 2011 at 5:53 am

    Hi Ashok,
    I wrote a formula below for a column in answers where the case statement includes columns from two different objects fact and column.
    WHEN “Dim”.”COL2″ = ‘RESULT2’
    However the query being generated by obiee server is incorrect. Please see the group by being generated. Please advise why the case statement in not being included in the group by?

    group by Fact.”COL1″, DIM.”COL2.”

    Thanks in advance

  224. Madhu

    November 28, 2011 at 4:19 pm

    Hi Shiva,
    I’m having a weird situation. I’m working in OBIEE 11g.
    A new analysis (inline) created with a prompted variable and referenced this presentation variable from the variable prompt in title of Analysis.
    When ran the Analysis, we see actual value of the prompt what we enter on the first page for the prompt of title. When tried to see next 25 rows or all rest of the rows, the presentation value is reset and we see @{variable_name}. We intended to see the value not the actual literal @{variable_name}.

    We have had similar results using this Presentation Variable in filters, columns, etc. It works fine for the first 25 rows, and then the Presentation Variable appears to be reset.
    We are able to successfully use Presentation Variables that are set through a Dashboard Prompt, but not those that are embedded in an Analysis.

    Any help, I’ll grately appreciate you.


  225. manisha

    November 29, 2011 at 8:10 am

    Am new to Obiee.
    I need to know how do i check if the services for obiee 11 g is running?
    What services do i need to start?
    Actually i type the url for obiee 11g and it does not work, how do I debug?


    • chaitantya

      July 7, 2016 at 9:03 am

      see the status in services that means opmnctl services is enabled or not

  226. Devang

    November 30, 2011 at 3:56 pm

    Do you have a steps for setting up the usage tracking in OBIEE 11g?

  227. Ashish Gandhi

    December 1, 2011 at 12:45 pm

    Usage Tracking :
    1. Created 3 tables in DWH (You should find DBScripts in Sample folder under 11G)
    2. Seed data for 2 tables in DWH (You should find DBScripts in Sample folder under 11G)
    3. RPD Updates :
    a. import S_NQ_ACCT, rename current tables – S_NQ_ACCT to S_NQ_ACCT_OLD – Existing physical table S_NQ_ACCT does not work during INSERT.
    b. Used utility to replace table in logical table so that it will refer to S_NQ_ACCT
    c. Altered physical diagram – link with new table S_NQ_ACCT
    d. Altered tables for rest of the ALIAS to point to S_NQ_ACCT
    e. Altered select Query for S_NQ_USER_GROUP – Select distinct USER_NAME Login, USER_NAME Resp from S_NQ_ACCT; (Caveat – This needs to be linked with users/security but we are not there yet)

    4. Update NQSConfig.ini file for 2 entries (As per documentations for data base INSERT) –
    5. I am Struggling to get OOB Dashboards/Reports from Sample folder – When unzipped and opened using catalog manager – I was getting ERROR. Also tried and copying report folder from usage tracking but not able to see it in the catalog from Web.

  228. Ritesh

    December 2, 2011 at 3:37 am

    Hi Shiva,

    Do you have the steps to change the default colors of a bar graph in obiee.I had seen a blog regarding this a few months back but i dont see it anymore


  229. surya

    December 4, 2011 at 4:30 am

    HI i have a requirment i have a report with 60+1 columns. that 1 column has some values say countries in another 60 columns y or N. whenever i select perticular country name from the prompt if some columns hass all N or null values i want to hide those columns which ever has Y. i want to display only those columns in the report

  230. Mihai

    December 6, 2011 at 10:14 am


    In OBIEE 11g I have an analysis based on another analysis which uses request variables (SET VARIABLE DISABLE_CACHE_SEED=1, DISABLE_CACHE_HIT=1;). When I try to run it, I get the error “Unresolved table: SET “, because the logical query is made this way:


    Is there any way to fix this?


  231. siri

    December 8, 2011 at 11:47 am

    Hello Guys,

    I have implemented a ber graph for a figure with 100% in sharepoint designer using xsl.Bar chart should not be displayed ,if the value of the figure is null,and if ‘0’,bar chart colour with light shade.So I am trying to make it with ,but no result.
    Any idea?

  232. Prashanth

    December 13, 2011 at 7:04 am

    When i try to cast a column(date) as timestamp. I get this error

    “[nQSError: 22025] Function Cast is called with an incompatible type”

    my query looks like this….. CAST (column_name AS TIMESTAMP)

  233. Kbklumar

    December 13, 2011 at 11:26 am

    Hi Shiva,

    I have one plant wise summery report, I added this report in dashboard page. Now I want when I click on particular plant in summery report the detail report should come under summery report in same dashboard page. I tried but it’s going next page.
    Please help me how can I achieve this requirement, It’s urgent.


  234. Prakash

    December 13, 2011 at 11:48 am

    how to retrive null dimension column from another report.
    I want to pull one null Company name from another request.
    One request contains ranking of top 50 company name for some sale fact value.
    including null column .
    Second request will pick these top 50 company name on the basis of rank.

  235. Bharani Kumar

    December 14, 2011 at 5:16 am

    Hi Shiva,

    I have one requirment,I have one plant wise summery report, I added this report in dashboard page. Now I want when I click on particular plant in summery report the detail report should come under summery report in same dashboard page. I tried but it’s going next page.
    Please help me how can I achieve this requirement, It’s urgent.


  236. Sri

    December 15, 2011 at 5:14 pm

    Hi, I have a requirement with a report prompt, ‘Month Range’ having a between operation in a format like ‘YYYY-MM’ eg values(2011-12,2011-11, 2011-10,etc..). now the validation required is that when ever user select a value say ‘2011-11’ (which can be a start date) and ‘2011-12’ (which can be a End Date as we are using between operation) then it should prompt (i.e) —[End date < start date] from being selected…

  237. roopesh

    December 18, 2011 at 10:28 am

    Hi Shiva,

    Thanks for sharing Ur knowledge on obiee.

    I have one requirement in reporting. one report has to show these columns
    totol no. of retails
    no. of retail outlets with loss above 50% and 3 months
    no. of retail outlets with loss above 50% and 4-7 months.. etc

    for no. of retail outlets with loss above 50% and 3 months i used filter
    filter(total no. of retails using loss>=50)
    here total no. of retails is aggregation count
    i need to add another condition here to check and fulfill the loss of retails above 3 months with 50%

    i am doing this in rpd.

  238. ananth

    December 19, 2011 at 6:44 am



    plz let me know some drawbacks of time series related to cache……


  239. Ruchi

    December 19, 2011 at 2:53 pm

    Hi, I have one client requirement that I have to add a Column in obiee 11g report, whose value should be pdf icon and we click on that icon it should open that saved pdf. Can u plz rply me as soon as possible.

  240. Ruchi

    December 19, 2011 at 2:54 pm

    Hi, I have one client requirement that I have to add a Column in obiee 11g report, whose value should be pdf icon and we click on that icon it should open that saved pdf. Can u plz rply me as soon as possible.

  241. ruchi

    December 19, 2011 at 2:56 pm

    can we add a column in obiee 11g report whose value should be pdf icon and we click on that it should go that saved pdf.

  242. Javier

    December 20, 2011 at 12:33 pm

    I’m using the Narrative view to print out whatever the business user has chosen in the prompts. Now I have a prompt with multi selection, say stores. If the business user for some reason or another chooses 25 stores, I don’t want the Narrative view to print out all 25 stores, it could type out something like “You’ve selected more than 3 stores” … Or “You selected 25 stores” or something like that. I’ve been trying with Presentation Variables, COUNT(DISTINCT and son on but it works only on the Analysis. When I use the dashboard prompt and send, say 25 items it gives me and error, SQL statement error.
    How can I do this?

  243. sathish

    December 20, 2011 at 1:06 pm

    Hi, i have a requirement i have three prompts in dashboard with year,quarter,month.If i select Q1 in month prompt it is showing jan,feb,mar….but my requirement is if i select Q1, in month prompt it has to show july,august,september..pls help me out of this.

  244. Lavanya

    December 21, 2011 at 2:03 pm

    Hi Shiva,
    I have one drill down for one a manager column in one report. If I click on manager’s name, it should should show current and historical reportee,but it is showing historical and current.How can I control the order. I am using pivot view for report. If I create table view, the display is fine.

  245. prabhu

    December 22, 2011 at 12:02 pm

    hi siva
    how to implement external table aurhenticarion in 11g

  246. Jayashree

    December 22, 2011 at 2:49 pm

    Hi Shiva, I started working on Oracle Apps OBIEE application. I dont see PO Headers item description in the Physical Layer. How to bring it? Please guide.

    Also please send me your email id so that I can send you the screen shots of the errors i am getting. Thanks in advance

  247. Santhosh

    December 28, 2011 at 9:37 pm


    I have a question on ODI 11g. I wanted to set up external user authentication/single sign on in ODI. I found OBE online but did not understand it clearly.

    Please let me know if you have any idea on this.


  248. Ayyappan

    January 5, 2012 at 7:52 pm

    Hi shiva can u Please give me the steps for enable Proxy functionality in OBIEE …

    When i following step in many URL for enabling Proxy functionality in 10g its showing error as
    This functionality has not been enabled by your administrator…So please help me…
    I put the xml file in the following path C:\Obi\instances\instance3\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\msgdb\l_xx\customMessages

    Please help me

  249. Ayyappan

    January 5, 2012 at 7:52 pm

    This is my xml file

    EXECUTE PHYSICAL CONNECTION POOL Act_As_Users.CP_Act_As_Users select target_Id from OBIEE_ACT_AS_USERS where proxy_Id=’@{USERID}’
    EXECUTE PHYSICAL CONNECTION POOL Act_As_Users.CP_Act_As_Users select target_Id from OBIEE_ACT_AS_USERS where proxy_Id =’@{USERID}’ and target_Id=’@{VALUE}’
    Act_As_Users.CP_Act_As_Users select proxy_Id, proxy_Level from OBIEE_ACT_AS_USERS where target_Id =’@{USERID}’

  250. Deepak Karanwal

    January 5, 2012 at 9:03 pm

    We have 200 different version of same report(difference is in their filters) and our users want to schedule these report to run once a week. So we created a report with 200 ibots and asked user to subscribe these ibots and customise their subsciption with there specific promts. So when these Ibot runs users get different vesion of results based on their customisation of prompts. And also we will be saving the file in filesystem via javascript.

    Issue is that when Ibot ran , user get their verion of result in thie email but the file which get saved on server does not filtered on the user customisation of subsciption. Basically it ran the report while ignoring the filters which user provided in the subsciption.

    For eg a report which has say two columns
    Fiscal Year Amount

    filter: Fiscal Year is prompted

    So we created an ibot and asked user 1 and user 2 to subscibe it. User1 subscibe it and customise it to run for 2011
    and user 2 subscibe it and customise it to run for 2012. What happened that in their email or dashboard they see data for 2011 and 2012 respectfully but on the filesystem on server thhe saved filed (Job_id_user1_filename.xls) and Job_id_user2_filename.xls) had values for all years and they are same , they donot filter the data based on their subsciptions.

  251. Gauranga

    January 5, 2012 at 10:29 pm

    Hello Shiva,

    Could you please explain the difference between Column Prompt and Variable Prompt?


  252. VB

    January 6, 2012 at 11:03 pm

    Has anyone found a work around for Line/Bar stacked Chart issue on OBIEE 11g?
    I’m trying to do a chart with Both Bars and Lines are stacked.

    Revenue and Qty Fields as measures
    Product as the Dim

    I want bars to be stacked Vertically for revenue and Lines to be stacked for Qty.
    I tried chart on the pivot view which works fine on 10g. Bars stack fine, the problem I see on 11g is line scale marker doesn’t not stack right.

    Please try this..
    Let me know if anyone is successful Thank you..

  253. Santy

    January 20, 2012 at 10:46 am

    Hello Shiva,

    Could you please throw some light on hw can I build presentation layer based on two different RPDs built on seperate data sources? Lets say I have one RPD based on Oracle EBS transaction system for actuals, and other RPD based on Hyperian planning system puting data Essabase cube regarding budgeted values. Now I want to build one report for variance analysis to show actual vs budget values. To build such report using analyses, can I have two rpds combined or join them. If Yes, then Hw can I do that, IF no then wht should be my deign approch.?

  254. Chris

    January 24, 2012 at 8:31 pm


    I have a business requirement where I need to publish a set of columns and a duplicate set of columns for comparison. The first set are from a fact table where the results are constrainted to a specific customer. The second set are from the same fact table, but the results are supposed to span all customers.

    For example, here is the data in the database:

    CustID Cost
    1 5.00
    2 7.00
    3 8.00

    When a user logs into OBIEE only having access to CustID 3, they should see the following when comparing CustID 3 to all Customers:

    CustID Cost CostForAll
    3 8.00 20.00

    How would you model that in the business layer?

    Thank you,


  255. kumar

    February 7, 2012 at 5:32 am

    Hi shiva,
    can you help me out from this…
    I hav a month prompt and it displays only last 6 months values from current date.
    It has to be displayed only six values in a prompt.

    Thanks in advance…!

  256. Rohit

    February 7, 2012 at 10:53 pm

    Hello Shiva,

    I wanted to ask a question. Is it possible to apply separate filters on separate columns with a single report? If yes, how?……I have a column containing multiple values and there is corresponding amount associated with it. In my report i have to display “the multiple values” in separate column and corresponding amount in front of it.

    This is a sample table in the database along with other columns
    Col A Col B
    20 W
    30 X
    40 Y
    50 Y
    60 X
    70 W
    80 Z
    90 R
    110 R
    65 X

    So in my report it should be displayed like (along with other columns). I need filters which perform such a function without harming other columns.

    W X Y Z R
    20 30 40 80 90
    70 60 50 65 110

    Is there a way where I can filter my columns like this and then include in the report? So that other columns are not affected by the filter.

  257. Rakesh

    February 8, 2012 at 11:01 pm

    Obiee 10g delivers cannot connect to smtp server
    i have chosen GMX in the job manager scheduler mail tab
    sender address
    smtp server
    smtp port 25

    in the answers delivery options devices i added email device
    what actually is wrong please help me am wasting lot of time on it

    note: am using for practice purpose not in real time scenario on laptop
    when i checked my log files in ibots folder

    +++ ThreadID: 2bf8 : 2012-02-07 14:10:42.875
        iBotID: /users/administrator/_ibots/
    rbot/rbot 2012
    [nQSError: 75003] Failed to open connection to SMTP Server.

    +++ ThreadID: 2bf8 : 2012-02-07 14:10:42.877
        iBotID: /users/administrator/_ibots/rbot/rbot 2012
        …Trying SMTP Delivery loop again

    +++ ThreadID: 2bf8 : 2012-02-07 14:10:42.879
    … Sleeping for 5 seconds.

    +++ ThreadID: 2bf8 : 2012-02-07 14:12:11.951
        iBotID: /users/administrator/_ibots/rbot/rbot 2012
    [nQSError: 75003] Failed to open connection to SMTP Server.

    +++ ThreadID: 2bf8 : 2012-02-07 14:12:11.953
        iBotID: /users/administrator/_ibots/rbot/rbot 2012
        …Trying SMTP Delivery loop again

    +++ ThreadID: 2bf8 : 2012-02-07 14:12:11.955
    … Sleeping for 8 seconds.

    +++ ThreadID: 2bf8 : 2012-02-07 14:13:44.005
        iBotID: /users/administrator/_ibots/rbot/rbot 2012
    [nQSError: 75003] Failed to open connection to SMTP Server.

    +++ ThreadID: 2bf8 : 2012-02-07 14:13:44.007
        iBotID: /users/administrator/_ibots/rbot/rbot 2012
        …Trying SMTP Delivery loop again

    +++ ThreadID: 2bf8 : 2012-02-07 14:13:44.008
    … Sleeping for 6 seconds.

    +++ ThreadID: 2bf8 : 2012-02-07 14:15:14.160
        iBotID: /users/administrator/_ibots/rbot/rbot 2012
    [nQSError: 75003] Failed to open connection to SMTP Server.

    +++ ThreadID: 2bf8 : 2012-02-07 14:15:14.162
        iBotID: /users/administrator/_ibots/rbot/rbot 2012
        Exceeded number of delivery retries.

  258. sudhakar

    February 9, 2012 at 9:27 am

    Hi Shiva
    how to create the graph prompt in pie charts
    and also how to calculate last three months in pie chart only.
    could you please send some solutions

    Thanks & Regards

  259. Bhupal

    February 15, 2012 at 5:21 pm

    Hi Shiva,

    I have embedded the OBIEE components in my ADF application. All compoents except the maps are not being displayed on the jspx page.

    Malformed url ‘/Application/BIProxy?cid=OBI&RedirectURL=saw.dll%2f%2fmapviewer’.

    Error Details
    Error Codes: YC9VC6XO
    Location: saw.views.dashboard, saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool, saw.threadpool, saw.threads

    Pls help.


  260. punitha

    February 21, 2012 at 3:39 pm

    how to delete oci.dll file please procedure

  261. jose carlos ferreia

    February 23, 2012 at 2:41 pm

    I want to insert a page break in the table case the group number of rows exceed the number of rows left in the page.

    So basically I do not want to split the fields of each group in different pages.

    Example of what happens:

    NAME Projects
    John 45
    Eliot 12
    Michael 12
    Peter 23
    (new page)
    Robert 24

    As I wanted it to be:

    NAME Projects
    John 45
    Eliot 12
    Michael 12
    (new page)
    Peter 23
    Robert 24

    I want a solution if possible in the rtf template, I’ve already made a counter to solve this problem but isn’t the best solution

  262. Amit Sangle

    February 27, 2012 at 4:55 am

    Need guidance & assistance as mentioned below –

    Please go through the link – –> About Running Actions Using Action Links and Action Link Menus in Analyses and Dashboards.
    We need steps, how to send mails, how do we configure action links in such a way that the diagrammatic report is sent as an mail to whoever has logged in on the analytics link.

  263. madhu

    February 28, 2012 at 4:12 pm

    Hi Shiva

    I havae a question, how to improve performance in obiee & How to optimize the query performance

  264. basha

    March 3, 2012 at 3:50 am

    Mr.Shiva Molabanti
    can u pls give me some answer for this question
    what is a good deffination for dimension table

  265. Arezou

    March 5, 2012 at 10:05 pm

    Hope all is well! We have been having an issue with OBIEE .5 drilling down in Time dimension. Here is the scenario:

    “The hierarchy for time dimension is ” Fiscal Year—> Fiscal Quarter—> Month(Name)—>Date”. When I select a Time dimension and click results its getting opened in a Pivot table view. The problem here is, when I click the “Total” it’s getting drilled down to Year —> Quarter but when I click on “+ sign next to quarter” it should drill down to month for that particular quarter for that particular year but its drilling down to month for that particular quarter for all years.”

    Is this a bug?

  266. sashi

    March 7, 2012 at 2:34 pm

    Hello Shiva
    How to display current_date or yesterday’s date in iBots headline in say m/d/yyyy format.
    Currently I am using
    @{system.currentTime}[M/D/YYYY] as part of the headline.
    example : Top25 agents list for today @{system.currentTime}[M/D/YYYY]

    Is there an alternate to the above? Or lets day I have a hidden field in my report containng the today’s date or yesterday’s date,.. how would i use that inside the ibot headline ?

    Is it possible ?
    If i have to display say yesterday’s date, or some last wk monday how to do?


  267. mozhdeh

    March 11, 2012 at 11:48 am

    Hi Mr.Shiva,
    can you plz tell me how can I print analysis compound layout in obiee, or how can I have a print button or somthing like this in my compound layout?

  268. rakesh2020rakesh

    March 14, 2012 at 8:39 am

    obiee 11g sampleapp_10722 deployement on windows
    hi i have tried to deploy sampleapp_10722 on windows but cannot proceed further i will share the source and my error also below

    Import the dump file SASchemas.dmp using the following command.
    impdp’sys/sysdba@orcldba as sysdba’ dir
    ectory=datapumpdir dumpfile=SASchemas.dmp version= schemas=BISAMPLE,OB

    Import: Release – Production on Wed Mar 14 05:16:04 2012

    Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

    Connected to: Oracle Database 11g Enterprise Edition Release – Produc
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    ORA-39002: invalid operation
    ORA-39070: Unable to open the log file.
    ORA-29283: invalid file operation
    ORA-06512: at “SYS.UTL_FILE”, line 536
    ORA-29283: invalid file operation

    am getting this error how to resolve this issue….????

  269. Madhu

    March 15, 2012 at 7:23 am

    Hi Shiva,

    pls help me

    i have two date columns how do we find the least date in 3rd column

  270. Vikas

    March 16, 2012 at 5:53 pm

    Hello Shiva,

    I am looking for some guidance/steps or documentation to create the prompts (on a dashboard page) which are constraint based on a value in a “hidden prompt”.

    Please share if you have idea on this.

  271. Ram

    March 20, 2012 at 6:49 pm

    Dimension table definition:

    A business uses facts to measure performance by well established dimensions. Every dimension has a set of descriptive attributes. Dimension tables contain attributes that describe business entities. For example, the Customers dimension can contain attributes like Region, Subregion, Country, State, Customer.

  272. Santosh

    March 21, 2012 at 8:15 am

    Hi Shiva,

    I have a requirements where the report need to have table of content section , sections having lot of textual paragraphs (narratives), those paragraphs will also have figures embadded comming from members of essbase cubes, will have lot of tabular information capturing the KPIs, will have various graphical representation of the same tabular information, need to have headers, footers , foot notes to be printed in the report..

    Basically it is a publication/manual kind of report which need to be regularly braodcasted to the business users with updated kpis and narratives sourced from Essbase database/cube.

    Is it possible to build such report in OBIE11g using analyses. How easy of difficult it is, if possible? Are there any prerequesities to build such reports in 11g analyses? I mean to ask does it need any third party component/software installed on the BI server.

    My main source of information will be essbase cube where lot of narratives (text information) will be entered by the business users. KPIS will be updated from DW layer in the Essbase cube for various members.

    Thanks in Advance.

  273. Sudhakar

    April 5, 2012 at 4:02 am


    I am using obiee 11g. When I am drilling from parent report to child report it is showing me following error :

    Assertion failure: isXsiTypeSqlExpression(rExpr) at line 67 of /net/stasunnas09/export/ifarm_test/solaris64/views/ aime_bifndn_936652/bifndn/analytics_web/main/proje ct/webreport/exprformulautils.cpp
    Error Details
    Error Codes: ACIOA5LN
    give me any solutions

  274. kalyan

    April 9, 2012 at 6:26 pm

    Can we create a report to list all open purchase orders that have a specified list of company codes. This report would be run on demand monthly, and the Company Codes list will change month to month. The Company Code is found at the accounting distribution level of the order. The purpose of this report is to identify any orders that may need to be revised due to their company codes being eliminated (we want to make sure no orders have an invalid company code). If possible, exclude canceled orders and fully billed orders from the resulting report.

  275. dred

    April 18, 2012 at 10:38 am

    Hi Shiva,

    Our requirement is to match the displayed records of the table and its chart per page. for example, i have a total of 100 records and was set to display 20 records per page. the requirement was, that the graph would also show the first 20 records initially, and if i click the next 20 records, the graph would also show the same record for the next 20.

    can you please help me? thanks so much,.

  276. Ankit Jain

    May 16, 2012 at 1:28 pm

    Hi Shiva

    I have a requirement

    I have to select a Value(Year) from the Dashboard prompt

    Dashboard Prompt -> Fiscal Year (from time dimension)

    When the user selects an year in the prompt, the report below should display that year and the last 5 years.

    Eg. If 2010 is selected, the output of the report should contain only 2010,2009,2008,2007,2006,2005.

    NOTE:the Fiscal Year column is of VARCHAR type.

    In the report (Plain Table) there is only one column in criteria, ie. Fiscal year.
    So when u select 2010 in prompt and click apply, the report should display the respective years

    I tried the following solution but am unable to get the solution to my answer

    If we pass the year selected in prompt as x

    Then the new prompt will be limited based on
    Fiscal year is between x and (x-5).

    Unfortunately, we cant pass it a value like x-5 in the values of the prompt. I have tried passing x-5 also into a variable and the giving between x and y but still it doesn’t consider value of y properly.

    Kindly Help me at the earliest.


    • Deepika

      May 29, 2012 at 4:21 am

      u can achieve this by filter based on another query

  277. KP

    May 29, 2012 at 7:18 pm

    Hi Shiva

    I have created a logical column ‘Previous Service Date’ in RPD using the below function. Consistency check is okay. But when I use the column in answers, it thro the error ” Unable to navigate requested expression: Previous Service Date :[Daggr…)
    Please fix the metadata consistency warnings”

    Please let me know where I am doing the mistake.


    • nandha

      June 24, 2012 at 3:10 pm

      Check for the content level and set the content level in the LTS

  278. Esha

    June 4, 2012 at 10:01 pm

    Hi Shiva,

    I have a requirement , where i need to show grand totals based on the selected values of hierarchical column(prompt), i tried using selection steps but not getting proper results, it was taking only values that are selected during the selection steps not overriding values with prompt while summing up.

    Any help is appreciated.


  279. raju

    June 7, 2012 at 6:42 am

    i alias table hit the database or not? how it works in obiee.

  280. raju

    June 7, 2012 at 6:43 am

    is alias table hit the database or not? how it works in obiee.

  281. Toby

    June 22, 2012 at 3:02 pm

    Hi Mr. Molabanti,

    My name is Toby, and I’m with the United Nations. Would you be willing to advise me on some OBIEE related questions? Please let me know.

    Toby Abraham
    United Nations

  282. Shib

    June 23, 2012 at 2:37 pm

    Hi Shiva,

    I have a requirement of merging two graphs into one in OBIEE 11g

    G-1: Year Vs Sales Revenue
    G-2: Year Vs Sales Qty

    Can you let me know any clues about this…

    Thanks in advance for your help..!


  283. bhavya

    June 29, 2012 at 10:08 am

    hi Siva i have a doubt hope u can help me in this.
    Can we create a report with some dashboard background? like water mark or any thing else

  284. padma

    July 9, 2012 at 1:16 am

    Navigation to another report is working for Chart,Butnot working for PIVOT Table

  285. padma

    July 9, 2012 at 1:51 am

    Navigation to another report is working for Chart,Butnot working for PIVOT Table.

    I have summary report which is navigating to Detail report . I have case statement formula in Summary report and gave the same formula in the detail report and is prompted .

    But when I click on the Chart it is navigating to Detail report and displaying the records based on the filter condition.But when i click on the pivot table , the detail report is displaying all the records. The fliter condition is not passing to the details report for Pivot table.But working for chart type.

    Please help me with this issue.I have beenstrugling to resolve the issue.
    The formula which i am using is :
    case WHEN “Appeal Actions Tasks Metrics”.”Processing Days without COA Suspensions” BETWEEN 1 AND 15 then ‘1 – 15′ WHEN “Appeal Actions Tasks Metrics”.”Processing Days without COA Suspensions” BETWEEN 16 AND 30 then ’16 – 30′ WHEN “Appeal Actions Tasks Metrics”.”Processing Days without COA Suspensions” BETWEEN 31 AND 45 then ’31 – 45′ WHEN “Appeal Actions Tasks Metrics”.”Processing Days without COA Suspensions” BETWEEN 45 AND 90 then ’45 – 90’ WHEN “Appeal Actions Tasks Metrics”.”Processing Days without COA Suspensions” > 90 then ‘> 90’ else ‘<= 0' end

    If I have to Cast the above formula, How should I do it.

    Appreciate for your help.

  286. Arun

    July 9, 2012 at 11:36 am

    Hi Siva,

    i need ur help..i want to make different sechama in physical layer..from same database.
    but now i m trying this i m getting view….sechma name….Auto..and personal loan…and my sechma name in database is RCAPP when i change the name auto to RCAPP..i can show data other wise in auto i m not able to view data.

    Please help me in on this issue.
    Thanks in Advance.

  287. Janardhan Reddy

    July 24, 2012 at 9:31 pm

    Hi Shiva, I have a quick question on Oracle BI mobile App from my iphone and trying to login to the BI presentation server but getting below error:
    Authentication Error: Server Authentication Failed: Could not connect to the server. [-1004]

    could you please send me the steps for the configuration as I did something wrong while configuring.

    Thanks in advance Shiva,


  288. Mihir Sharma

    July 30, 2012 at 9:54 am

    Hello Mr. Shiva. I’m kinda fresher to the obiee11g. and i keep reading your blogs as and when required. recently i’ve been stuck up to the ‘Bins’ in BI Answers. the bin is working fine if i add it to normal dimensions such as company name, employee, department, even with year, quarter and months.
    but……….when i add a bin to classify(or to group) the result for the date, lets take my e.g. i’m trying to classify ‘AP Invoice Amount’ facts depending on ‘Payment Due Fiscal Day Date’ dimension column. and as a ‘bin’, i add the filter ‘Payment Due Fiscal Day Date’ is between. and give the dates as ’01/01/2008 12:00:00 AM’ and ’12/31/2012 12:00:00 AM’ wiz a standard format in OBIEE,its giving me the error like (Formula syntax is invalid.
    [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27002] Near : Syntax error [nQSError: 26012] . (HY000)
    SQL Issued: SELECT CASE WHEN “Payment Due Date”.”Payment Due Fiscal Day Date” BETWEEN timestamp ‘2008-01-01 00:00:00’ AND timestamp ‘2012-12-31 00:00:00’ THEN Year between ELSE “Payment Due Date”.”Payment Due Fiscal Day Date” END FROM “Financials – AP Invoice Aging”).
    Plz help me to get out f ds..!!
    Waiting for your earliest and positive response.

  289. Gaurav

    August 8, 2012 at 10:07 am

    Hi Siva,
    We are authenticating against Microsoft AD and authorizing against the Oracle database table.The authentication and authorization works fine but under My Account–> Roles and Catalog ,I am not able to see the correct application roles and webgroups.This is what we did:-
    1. We upgraded the OBIEE 10g rpd and catalog in the OBIEE 11g Windows environment .Everything works fine.We are able to see the correct application roles and webgroups under the Roles and Catalog tab.
    2. We imported the 11g rpd and catalog into Linux OBIEE 11g environment and created the application roles and groups manually in EM.Also created the catalog groups using Administration link in front end.When a user logs in ,the users sees the correct application role but not the webgroups.
    3. We imported the same 11g rpd and catalog into another Linux environment (which is clustered) and did the same steps as Step 2,now the user neither sees the application roles nor the web groups.
    In all the three environments ,if we do Manage Sessions ,we see that the variables are populated correctly for the user.

    Could you let us know why Roles and Catlog tab is behaving differently?

  290. sandeep

    August 15, 2012 at 10:46 am

    i want to purge all the current date query from cache

  291. Barkha Atwal

    August 18, 2012 at 11:19 am

    I’m not sure why but this site is loading extremely slow for me. Is anyone else having this problem or is it a issue on my end? I’ll
    check back later on and see if the problem still exists.

  292. Kiran

    August 19, 2012 at 2:19 pm

    Hi shiva,
    I have a requirement in obiee 11g…
    How to change the background color of a graph to change dynamically based on the column value(for eg:revenue,if revenu > X or revenue <x).

    thanks in advance…


  293. Emeka

    September 25, 2012 at 3:26 pm

    hello can someone please email me

    Oracle BI 11g R1 Create Analyses and Dashboards Volume 2 Student Guide with the labs???

  294. Abdul Jabbar

    October 7, 2012 at 1:28 pm

    Hi Siva,
    It is nice to see you blog,
    i have installed OBIEE11g on Win32 bit server and i want update/apply the patches BP1 on that. Can u please explain me the steps how to do.

    Thanks in advance

  295. RSD

    October 15, 2012 at 1:51 pm

    Hello Shiva,

    I am working on OBIEE I have to include report header to display page number, date and title in the analysis and the analysis has to be exported to pdf. I am able to see the header on pdf format of the report(analysis) but the header is not showing up when this analysis is added to a dashboard and also when exported to pdf(the dashboard has a prompt and the report should run for the dates entered). The report header is not showing up in dashboard.

    Is there any workaround for this or I am missing any OBIEE settings?

    please help.


  296. trevor kelly

    November 9, 2012 at 1:57 pm


    I am building a report in obiee 10g and am calling another report using the project id for the sub report I only wish to pass in the first 4 characters. For example on the main report the project is 70001 which is the parent project id I only want to pass in the first four characters 7000 ie in sql you would use a substring 1, 4. In obiee can I only pass in the first four characters of the database field Is this possible

    Many Thanks

  297. sravan madddineni

    November 10, 2012 at 11:15 am

    hai shiva
    got a problem

    iam unable to startup presentation services and scheduler in 11g

  298. Bantu

    November 25, 2012 at 3:45 pm

    HI shiva, Its nice to see your blog,
    I have installed OBIEE11g and have integrated with ebs r12 but when i try to aceess OBIEE from ebs it says User prohiited and also iam unable to open rpd in online mode thru weblogic as user/password and even i can’t access answers page directly says login paswd failure.Could you pls help me to sort out this issue.

    • Jaswanth

      December 14, 2012 at 8:01 am

      Hi Bantu,

      You are not able to login because your Weblogic user is not an EBS User and you integrated both EBS and OBIEE. You need to create an Administrator user in EBS and pass the application roles to OBIEE11g and provide Administrator access to the newly created user.

  299. Bantu

    November 25, 2012 at 3:47 pm

    HI shiva, Its nice to see your blog,
    I have installed OBIEE11g and have integrated with ebs r12 but when i try to aceess OBIEE from ebs it says User prohiited and also iam unable to open rpd in online mode thru weblogic as user/password and even i can’t access answers page directly says login paswd failure.Could you pls help me to sort out this issue.

    Thanks in advance

  300. Kiran

    December 11, 2012 at 1:40 pm

    Hi Shiva,

    I have arequirement like this…
    I have two timeperiod prompts.
    One contain prompt values as YTD,LM,LQ,L6M and second prompt contains month name values(month name is prompted).
    If I select YTD value from 1st prompt the report showing data for year to date.This is expected behavior but My requirement is if user select value from first prompt then click on apply and again if he selects values from second prompt(i.e month name) the report should display data according to second prompt.

    Thanks in advance.

  301. Amol

    December 27, 2012 at 7:05 am

    Hi Shiva,

    Is there a way to add scroll bar on a chart using OBIEE publisher?
    I want to have a chart with all categories shown as bars but only 5 to be visible by default. But if user wants to see more he should be able to scroll to right say and can see remaining bars.

    Thanks in advance.

    • Hemanth

      January 5, 2015 at 9:29 am

      Hi Amol,

      I was also searching for the same requirement had you got rectified this problem.if you got the solution for this will you please suggest me how to overcome this.

      Thanks in advance.

  302. PK

    January 15, 2013 at 11:47 am

    Hi Sihva, Need your help, Is it possible to have google like search in OBIEE Prompt OR anywhere in OBIEE. User want to search on many attributes (Supplier Name, Supplier Leader Name, Supplier CODE, etc.. ) in one box…


  303. Usha

    January 28, 2013 at 4:53 pm


    I have one question on OBAW data model, What could be the size to install OBAW on existing OBIEE 11g.

    Thanks in advance,

  304. Aneesh

    February 11, 2013 at 8:08 am

    Hi Siva,

    How r u ? This is aneesh from DC. I am facing one issue in Mapviewer OBIEE11g. When i open the mapviewer report , zoom level shows as 0..when double click it will it will set to level 1.How to set default zoom level as 1 in Mapviewer report?

  305. Asif Iqbal

    February 25, 2013 at 9:46 am

    I am using OBI 10g R2. I am facing problem with its browsing in Internet explorer 8 and 9 on Windows and unable to drilldown reports in Safari on imac. I can see reports and graphs on imac in safari browser nut unable to drilldown. Whereas on ipad/ipad2 i am even anable to see any graph. Please help in this regard how this problem can be resolved???

    Thanks & Regards,

  306. Arun

    March 5, 2013 at 12:26 pm

    I have an issue with the AGO function.
    I have used a formulae some thing like below.

    Ago(“CCLRDC”.”Fact – Balances Measures”.”YTD Balance” , “CCLRDC”.”Period”.”Month” , 3)

    Similarly like for month 2 and month 1.Well the point is I need a ytd bal for the prev 3 months and current month too.
    When I pass the filter as APR-2012 im getting data for APR-12,MAR-12,FEB-12,JAN-12 But
    When I pass the filter as MAR-2012 im only getting data for MAR-12,FEB-12,JAN-12 but could not get data for DEC-11

  307. Rajeev

    March 8, 2013 at 3:39 pm

    Hi Shiva,

    I have a requirement to calculate average(of a column) for a selected date range(from prompt) for a particular day.
    E.g If user select the date range and then select Sunday from Dashboard prompt then it will count the no. of Sunday’s from the date range and calcuate the avg.

    Please help me to get this done.


  308. Mary

    March 9, 2013 at 3:24 am

    Hello Shiva,
    I hope all is going well for you! We miss talking to you.
    I’m wondering if you can help us figure out why we keep having problems with security and the catalog. Today I opened a ticket with Oracle because I can’t access the permissions on some folders. When I highlight the folder and click Permissions, nothing happens. I then went into Catalog manager to try and assign access and I got the error “Error retrieving user/group data from Oracle BI Server’s User Population API”. In the OBIPS log I see errors related to the GUID. We haven’t replaced the catalog or repository so I don’t understand how they’d get out of sync. We had and issue previously due to a group name having ( ). Anyway, it seems the GUID continue to cause us problems and users can’t access. I don’t want to refresh the GUID until I figure out what caused the problem. Any ideas? You’re help is appreciated!!! Mary

  309. srinivas

    March 17, 2013 at 5:51 am

    Hi Siva,
    I have created a report in area view of graph. But i was unable to give the different colors for each area of the view. I am obiee 11g client tool. So please suggest me.

    Thanks & Regards
    Srinivas B

  310. Mahesh

    March 19, 2013 at 5:45 am

    Hi Shiva,

    Original URLs:


    But as per the requirement we want to change the URLs as below.


    Please Help us.

    C Mahesh

  311. NT

    March 27, 2013 at 7:51 pm

    Hi Shiva,

    Can you please update this blog? What is the OBI Version that this is officially supported in?


    • Shiva Molabanti

      April 17, 2013 at 10:07 pm

      Thank you NT. Been busy with the other innovations. The officially supported version as of today is till OBIEE


  312. phen375 uk

    March 29, 2013 at 2:48 pm

    I’ve been browsing online greater than 3 hours lately, but I never found any interesting article like yours. It’s lovely value enough for me.
    In my view, if all site owners and bloggers made excellent content as you probably did, the net will probably
    be much more useful than ever before.

  313. Pavan

    April 11, 2013 at 7:19 pm

    Hi Shiva,

    I have been following your Blog from longtime, But this is my first question to you…
    I have a requirement which is like this i need to put a scrolling text(DAC Load is till in Progress)
    in answers landing page next to
    (Alerts!- Dashboards- Answers- More Products – Settings – Log Out Search).
    I was thinking if we can locate the Answers Page code(Java/Html) should help us, Just a thought.
    Could you pleas help me out in solving this issue.

    Thanks in Advance

  314. Vikas

    April 12, 2013 at 6:26 pm

    Hi Shiva,

    We are using OBIEE, we want to create a Virtual directory mapping in weblogic server so that we can place our static image files to access from the application URL.

    To do this activity, we have performed following steps –

    1) Navigated to C:\OBIEE11G\Oracle_BI1\bifoundation\jee

    2) Open analytics.ear file

    3) Existing code in weblogic.xml is: (if weblogic.xml is not present we need to create the file with below code)


    4) We have added virtual-directory-mapping tag; After adding virtual directory mapping tag, the code in weblogic.xml is



    5) We have created a folder virtualdirectory under D: drive. And then created a folder images within folder virtualdirectory.

    6) Then we have placed an image (lets say) test.jpeg within image folder.

    7) Restarted all BI services,

    8) Now when have created a report where we have placed the URL (in the formula, someting like this – > http://localhost:9704/analytics/images/test.gif).

    On running the report and clinking on the URL (which we have made appear as link), a seperate browser window opens up and displayes the image

    Now we are able to see the image, it’s working perfectly fine.

    However If we paste the above URL in a seperate browser then also it will displays the image without any authentication. Means anybody can copy the URL in the browser and see the image without login to OBIEE. This is causing security issue.

    So our requirement is, on pasting the URL in browser, the images should not be shown (or there should be 404- error). first it should redirect to OBIEE homepage and when authentication is done then it should display the image. Or the image should be displayed only when user has already logged into OBIEE and clinking on the link to open the image from the dashboard page.

    Request you to please advise if any inputs to acheive this.


  315. Vikas

    April 12, 2013 at 6:30 pm

    Seems the my previous questio didn’t post completely, so posting it again here–

    Hi Shiva,

    We are using OBIEE, we want to create a Virtual directory mapping in weblogic server so that we can place our static image files to access from the application URL.

    To do this activity, we have performed following steps –

    1) Navigated to C:\OBIEE11G\Oracle_BI1\bifoundation\jee

    2) Open analytics.ear file

    3) Existing code in weblogic.xml is: (if weblogic.xml is not present we need to create the file with below code)


    4) We have added virtual-directory-mapping tag; After adding virtual directory mapping tag, the code in weblogic.xml is



    5) We have created a folder virtualdirectory under D: drive. And then created a folder images within folder virtualdirectory.

    6) Then we have placed an image (lets say) test.jpeg within image folder.

    7) Restarted all BI services,

    8) Now when have created a report where we have placed the URL (in the formula, someting like this – > http://localhost:9704/analytics/images/test.gif).

    On running the report and clinking on the URL (which we have made appear as link), a seperate browser window opens up and displayes the image

    Now we are able to see the image, it’s working perfectly fine.

    However If we paste the above URL in a seperate browser then also it will displays the image without any authentication. Means anybody can copy the URL in the browser and see the image without login to OBIEE. This is causing security issue.

    So our requirement is, on pasting the URL in browser, the images should not be shown (or there should be 404- error). first it should redirect to OBIEE homepage and when authentication is done then it should display the image. Or the image should be displayed only when user has already logged into OBIEE and clinking on the link to open the image from the dashboard page.

    Request you to please advise if any inputs to acheive this.


  316. Venkat

    April 15, 2013 at 9:31 am

    Hi Shiva,

    My Name is Venkat. I am trying to install BI APPS on, but not able to install, its saying that Make sue Admin server is up and running. But when i see from console and EM all are up and running. can you please let me know the issue…its more helpful am struck up this place since more than 2 weeks.

    and also i need to check you few question 11G:

    1. Loop back adaptor: am still getting confused on how it works. if it DHCP system we need to have loop back and static IP. when am installing in Virtual machine which has static IP do we need loop back and make the changes in host file…can you please explain on this..

    2. JDK : do we need external JDK installation before OBIEE…i have read that by default we have built jdk available in obiee. can you please explain….

    Many thanks,

    • Shiva Molabanti

      April 17, 2013 at 9:54 pm

      Even Admin server up and running, The BI Apps installer will contact teh nodemanager to know their status. looks like the nodemanager is not being pinged properly. Just change the script used by installer to connect to NM.

      1. Make a backup copy of \Installers\Oracle_BI_Applications\script\
      2. Modify \Installers\Oracle_BI_Applications\script\
      The content should look as follows:
      WLST script to test connection to NodeManaer to check if it is running
      This script expects the following arguments:
      1. (localhost)
      # 2. wls.port (7001)
      # 3. wls.user (weblogic)
      # 4. wls.password (weblogic)
      # 5. middleware.home (C:\oraclebi)
      # 6. domain.home (C:\oraclebi\user_projects\domains\bifoundation_domain)
      # ===================================================================
      import sys
      import os
      import xml.dom.minidom
      # Check the arguments to this script are as expected.
      # argv[0] is script name.
      argLen = len(sys.argv)
      if argLen -1 != 6:
      print “ERROR: got “, argLen -1, ” args.”
      print ” eg: wlst.cmd localhost 7001 weblogic welcome1 C:\oraclebi
      WLS_HOST = sys.argv[1]
      WLS_PORT = sys.argv[2]
      WLS_USER = sys.argv[3]
      WLS_PW = sys.argv[4]
      MIDDLEWARE_HOME = os.path.normpath(sys.argv[5])
      DOMAIN_HOME = os.path.normpath(sys.argv[6])

      3. Run the OBIA installer. You should now be able to proceed past the screen and continue as normal. Check box the BI Applications you want to install.

      Coming to other questions, You dont need a loopback adapter if your machine is not listening on multiple IPaddresses. And you dont need to install the JDK. that will come with OBI software.

      There are some scenarious where you need to install JDK first to run your OBIEE on the specif flavour of Java…


      • Venkat

        April 24, 2013 at 11:18 am

        Thanks Shiva for your replay. now able to install bi apps. After BI apps installation, when am trying to login to analytic url, it saying username and password is incorrect. it happens twice. I tried like taking a back up of apps install folder and i add that folder to bi home folder(new installation) without apps installation its working. can you please let me know ….

        my versions: and BI APPS


  317. Pavan

    April 19, 2013 at 4:56 pm

    Hi Shiva,

    Please find below scenario

    I need your help/ suggestion on setting a presentation variable through java script/Jquery. I am working on a task to set the presenation variable to a predefined value on click of a hyperlink to capture the user action and planning to use the presentation variable value to set the conditions for the analysys. I have 4 hyperlinks and and the analysis where condition will vary depeneding on the hyperlink clicked.

    Let’s say i have


    I will define a prompt/session variable Where1 and set its value to 1,2,3 or 4 depending which heperlink user has clicked and i will use presenation variable Value to decide the where condition in the analysis avialbe on different dashboard page.

    My ultimate goal is to update session/presentation variable on user click so that i refer this value to decide which column to be filtered. I know if i use propmts it will be simple but user wants UI as hyperlinks.

  318. Don

    April 23, 2013 at 6:07 pm

    Hi Shiva,

    I’m trying to build a report to do a change in working capital analysis and can’t figure out how to build the report (in Answers) where the first column will be current month Actuals, the second column is the prior month Actuals.

    I would think this is a fairly common request for an accountant but cant find anything referencing this request.

  319. Suman

    May 14, 2013 at 5:33 pm

    Hi Shiva,

    I have an issue in my report where YTD values show full year values. I am using OBIEE 10g


    If I give filter as 2013 to the YTD column its gives correct data i.e from jan 2013 to may 2013
    If I give filter as 2012 to the YTD column it gives whole data for the given year 2012 i.e from jan 2012 to dec 2012

    My YTD code is

    TODATE(Core.”Fact – Spend and AP Invoice Distribution”.Spend, Core.”Date”.”Year”)

    It would be great help if some one could suggest on this behavior.


  320. Roderick

    May 15, 2013 at 10:16 pm

    Whilst opting surgical procedures, one can opt
    for both of the two approaches, viz. At the time you have applied the cream, the moles get infected.

  321. Chandra

    May 24, 2013 at 10:59 pm

    Hello Shiva,

    I am sure you would have come across this scenario in your different project.

    Need to know how to clear the cache (Presentation and BI server cache Automatically) After the ETL Loads in OBIEE 11g.

    Was able to clear the cache automatically after each ETL Load through a Control M Job, But how can we clear the Presentation Cache and also if we can seed( not through Agents) the whole dashboard.

    With Regards!

  322. Pavan

    June 4, 2013 at 5:55 pm

    Hi Shiva,

    Is there any document or video present for installing and checking new features of Mobile OBIEE I mean OBIEE installation on Mobile/ipad.


  323. PaulShumbayaondaPaul

    June 6, 2013 at 1:59 am

    Hi Shiva,
    I want to learn the BI Apps, can you direct me to some resources who teach it online starting from installations. Thanks

  324. madan

    June 6, 2013 at 3:04 pm

    Hi All ,

    My clinet calculates week from sunday to saturday ,Now last week of 2012 are 30 and 31,When we look in W_day_d 30 and 31 are showing as week 53 but as per clinet’s calendar these should be under week 1 of 2013.Can any one please help me out with the logic

    Thanks in Advance

  325. Shaid Greeff

    June 13, 2013 at 9:21 am

    Hi Shiva, I am looking for a Technical Reference Architecture and Sizing guide for BI Apps

    Also the documentation is not specific about loading certaing modules of the EBS, e.g. Financials, Procurement or HR.

  326. abdul tawab

    June 27, 2013 at 1:27 pm

    Hi Mr Shiva,
    i am new in this area and , i am looking for a install OBIEE and OBIA and link ERP oracle R12 .
    1- what is map Road to install OBIEE and OBIA with used Oracle Data integration
    2- used informatica 9.1 + oracle DAC

    explain me
    abdul tawab

  327. Shilpa Jain

    July 1, 2013 at 1:21 pm

    Hi Shiva,

    We have only the the V305 virtual image available for download and not the standalone. The VI is huge in size . Can you provide me with the obiee RPD and webcat if you have already downloaded the image.

    Thanks in Advance


  328. seetha

    July 7, 2013 at 4:49 am

    i have a small doubt… what kind of problems mostly we are facing in obiee when once enter into the real time work ….

  329. balaji

    July 9, 2013 at 9:34 am

    Hi Shiva,

    I am planning to take BI Apps certification , can u help me on th
    is plz.

  330. S

    July 11, 2013 at 4:27 pm

    I have a following simple report :

    Fiscal Qtr Product Numbers Heads
    2012Q4 1100 220
    2012Q3 1000 230
    2012Q2 1200 200
    2013Q1 700 190

    What i need to show is a arrow up or down depending current qtr verus previous qtr. for example : for Product numbers it was gone up from Q3 to Q4 from 1000 to 1100 so i would like to show a green arrow indicating positive trend . similarly between Q3 and Q2 number when down, so a downwards red arrow indicating negative trend.
    i need to show this for both columns Product Numbers and Heads

    I know we can get the images through conditional formatting but i am unable to do so for a difference between qtrs. Any suggestions on this would be appreciated. I am open to changing report design also to suit this.

  331. uma maheswararao

    July 15, 2013 at 6:30 am

    Hello Shiva,

    this is uma, i have created one dashboard prompt and analysis report ,
    now i need to add that presentation variable to analysis report its giving below error
    can u pleaze respond quickly

  332. Ravikiran

    July 22, 2013 at 10:10 am

    Hi All,

    I need hide the “View Display Error”, which comes when you configure the limiting number of records for a user or Group.
    Can anyone please help me, how to hide the view display error and to display our own message, as OBIEE View Display error is very long.

    Thanks in advance,

  333. Prashanth

    July 30, 2013 at 3:06 pm

    Hi Shiva,

    Can we create an Action link based on an Application Role?
    If not can we can customize the message that appears to user instead of access denied for user to path (only for this report)

    We are using


  334. Prashanth

    July 31, 2013 at 3:47 am

    Hi Shiva,

    Can we display an Action link based on User role?
    If not can we customize the message for unauthorized users (instead of access denied for user path /…/ ). only for this report


  335. Kavi

    August 6, 2013 at 1:05 pm

    Hi Shiva,

    I have implemented the OBIEE 10g using prompt as report selector. for example, I have used 3 reports in dashboard with prompt as selector and used GN for each report. if i didn’t select anything from prompt also in dashboard page, running the SQL query for all the reports on the backend. Even when I select one of the reports from the drop down list, I see many other SQL still running on the backend. Since our report is taking long time to run, this puts a lot of load on the database. Is there a way to stop the queries from being generated and wait for the user’s response?

  336. ajay

    August 6, 2013 at 5:07 pm

    Hi Shiva,
    I am having an issue with dashboard prompt, following is my requirement
    i am using two columns Account Number and Account name in a dashboard prompt. User will select Account number and related account name should be displayed .
    Example : account number account name
    Ar1456 Automative group
    FL376 Filtration group

    when user chose Ar1456 in account number, Automative group should be displayed in account name.
    I am able to see the account name in drop down ,but user not interested in choosing from drop down, User want it to be displayed automatically.

    Thanks in advance.

  337. Anti Aging

    August 7, 2013 at 10:41 am

    Greetings! Very useful advice in this particular
    post! It’s the little changes that make the most important changes. Many thanks for sharing!

  338. kalyana

    August 30, 2013 at 9:20 am

    Hello All,

    I was trying to write back to an Hyperion Essabse Cube With the Below Procedure..

    1.The version of OBIEE which I was using is OBIEE (on Windows 64bit) and Essbase also on 11 Version (On Windows Server).

    2.At First I had made used of the Custom Java script which I placed in the location of OBIEE
    i.e(D:\MiddleWare\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\b_mozilla\actions) (Script attached).

    3.The Custom Script consists of Execute_lsql function which is used to execute the logical sql commands sending it to the biserver and then send update to essabse cube with the help of connection pool.

    4.The Summary Statistics logging has been disabled in the NQSConfig.ini File.

    5.The column which I wish to write back has been set Writable in BMM layer and the read write permissions has been given for that column in the presentation layer.

    6.The Data base object and the connection pool object are also given allow Execute Sql Requests privilege in the physical layer.

    7.The Write back privilege has been given to the user from the analysis administration .

    8.A report has been created with four columns and for the measure I have applied the write back with simple update statement as follows by selecting invoke browser script option from the action links in the column properties .
    update “Sample”.”Basic” set “Total Expenses” = @{p1} where
    “Sample”.”Product”.”Product – Default” = ‘@{p2}’ and
    “Sample”.”Scenario”.”Scenario – Long Names” =’@{p3}’ and
    “Sample”.”Year”.”Quarter” = ‘@{p4}’

    9.The Following Policies were given to the user who is logging in to the system ,Screen Shot Below..

    10.The problem is when I am clicking on the measure in the report and trying to update the value the values doest not get updated in the cube nor its not throwing any error to ,but when I check the query being generated its hitting the right connection pool and I have given the right permissions.

    Did any one come across this problem or any more steps need to be added,Any Suggestions Aprreciated.


  339. Jesus

    September 3, 2013 at 10:14 pm

    Hi Shiva:

    I have two prompts ( based in column value)

    The firts prompt take the values of this column “Reporte de Release”.”Id Release” , when i select one value in combo prompt that will be saved on Presentation variable ID_Release.

    The second prompt using the next expresion to filter values.
    SELECT MAX(“Reporte de Release”.”Sesion”) FROM “ASCP/MRP” WHERE “Reporte de Release”.”Id Release” = @{Id_Release}

    When i run the first prompt and select one value, the value results of second prompt is filter OK but i need to select the value in the combo prompt to assig a second Presentation variable (ID_Session).

    Let me put and example

    Values of first prompt
    Id Release

    Values of Second promt
    Id Release Sesion
    81 2013-01-01
    82 2013-02-01
    83 2013-03-01

    If I select 81 in the first prompt , the second prompt only show the value of 2013-01-01 but i need to select them to be reflected in a presentation variable ID_Session)

    You know any opcion to auto commit or auto select automatically the value of the second prompt.

    Best Regards!!

  340. obieenj

    September 5, 2013 at 4:03 pm

    How do I get the data for the last day of the selected date range thru RPD?

    The prompt from the front end is picking up a date range ( example june 2013).

    I need to pick the last day of the selected period and then pull the fact data for that day.

    so, the logic would be something like this:


    when day of the selected period( I tried different ways to try this. nothing working)






    • neehareddy

      September 12, 2013 at 4:23 pm

      please give me ur email id shiva

      • Annu

        September 19, 2013 at 4:16 pm

        Thanks for responding. My email id is

        I would appreciate if you can follow up with my question. Regards, Annu Aggarwal

  341. Rejo

    September 20, 2013 at 1:32 pm

    Hi Shiva,

    I have a scenario.
    I am using a column in analysis is ‘age’ and it is throwing error in criteria is below
    “View Display Error
    Odbc driver returned an error (SQLExecDirectW).
    Error Details
    Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
    State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 46033] Datatype: 25 is not supported. (HY000) ”

    I have analyzed and my observations are below:
    1) the “age” is derived column (current_date – birth_date) coming from one db view.
    2) the query being generated by obiee is fetching data in database(teradata).
    3) the “view data” of source table in rpd is also throwing same error mentioned above.
    4) the datatype of column “age” is showing in rpd is varchar.

    Request you to suggest a solution.
    Looking forward your help.


  342. evren

    September 24, 2013 at 4:04 pm


    when i was sarching internet i found your web site. I upgraded my system to Oracle BI after that my layout measures disappered.

    when i connect from ip it is fine, but when i connect as layout measures not seen.

    do you know what is the problem?

    Thanks a lot,

  343. mohan

    October 6, 2013 at 5:23 pm

    I have requirement to filter single report depending on user selection. he can select Calendar Quarter or Fiscal Quarter, depending on his selection we have to display data. I have implemented this logic with presentation variables & it is working fine. Here the catch is DRILL is not working is drilling from Quarter to Day level directly and skipping MONTH and WEEK level. I am using version.
    Note :1) Hierarchy is perfect..Year–Quarter-Month-Week-Day..
    2)I have used case statement to implement this logic..this logic is creating problem for DRILL DOWN.

    As alternative I have created 2 is for calendar and second id fiscal & kept them on the page. BY using condition I want to display only single report depending on user value..In Condition other than rowcount I am not able to check any condition. Please suggest ASAP. Thanks

  344. Chad

    October 20, 2013 at 1:51 pm

    We currently have Siebel CRM, Informatica/DAC for ETL and OBAW on Oracle and OBIEE for reporting. We are having discussions to move to Hadoop.

    – What are some key considerations to do this transition?
    – How would our current architecture change?
    – How would the OBAW data model have to be transitioned onto Hadoop hdfs?

    Just early stage discussion so not sure if my questions make very much sense at this point. Looking for some direction or a discussion…

    Thanks in advance,

  345. Santosh

    October 24, 2013 at 1:53 pm

    Hi Shiva..
    can you please explain how to create MTD and Prior MTD in rpd Level..i have been struggling with this problem for couple of days..first time i created MTD with TODATE(measure,Month) and For Prior Year MTD I took AGO(MTD Measure,year,1) but getting error when i add these columns in criteria. Iam waiting for your replay..


  346. Santosh

    October 28, 2013 at 11:57 am

    Hi Shiva,

    I am not able to create a Prior Year(Previous Year) MTD in RPD in OBIEE 11g..

    First i created MTD using TO DATE(Measure,Month) then after that for Prior Year MTD taken AGO((MTD Measure),year,1).

    Getting error When i see the results in answers …can you please give any suggestion


  347. Troy Geri

    November 6, 2013 at 6:14 am

    One of our report developers came back with this comment regarding BI Publisher

    OBIEE has 2 different reporting tools (BI Publisher and BI Answers), BI Answers allows report end users to sort the data (by column) but BI Publisher reports don’t. Unfortunately, some report layout/formatting require the use of BI Publisher over BI Answers, hence in some reports sort functionality is not available to the end report user

    Is this correct?

  348. Gowtham

    November 18, 2013 at 6:05 am

    Hi Shiva,
    here i am having a rounding issue with aggregation (sum) of column having revenue . I am working Postgresql as datasource and i am getting only the floor values instead of rounding values pls sugges asap

  349. lea

    November 26, 2013 at 4:53 am

    How do I freeze the first column in a table, where the header is already frozen?

  350. Obiee Wan KenObiee

    December 8, 2013 at 11:55 pm

    Can someone help me, I need to know if you can link two pivot tables to one column selector in OBIEE 11g, Please could you respond explaining how… Thanks 🙂

  351. kishore

    December 9, 2013 at 10:10 am

    how to get revenue up to 3 deciaml values, without using dataformate option.
    i tried truncate. but its not shoeing the decial values,
    can any one help?

  352. Siva Budagam

    December 11, 2013 at 12:39 pm

    Hi Shiva,

    Could you please provide solution for my query whihc i ahve posted in OTN…

    here is the link

    Many thanks..

    Siva Budagam.

  353. Brayan

    December 18, 2013 at 7:17 am

    Hey whats does the following error mean , My query run successfully in oracle developer , but while generating the xml it gives the following error .
    ” error on line 2 at column 245: Opening and ending tag mismatch: img line 0 and span”

  354. Lisa Huckins

    December 24, 2013 at 3:48 pm

    Hi Shiva
    I am in OBIEE 10g of BI APPS Supply Chain and Order Management. In Order fulfillment, I have a sales order line fact table presentation that has multiple date fields. I have a Time dimenstion that is joined to the fact on ordered date so I can bring in the enterprise period for a report. I have 3 other date fields that I want to use in a report and show the related enterprise period for that date.

    I understand that I can alias the W_DAY_D calendar table for each date, but I want to only present one Time dimension that works with any date. Is that possible?


  355. Chinnu

    December 26, 2013 at 8:16 pm


    I have a requirement to display Previous week , QTD, YTD and QTD and YTD running Rate and Year over Year. In RPD I calculated all measures and when I create a report in obiee with all above measures I am not getting results in Year over year. I provided report filter with Week offset.

    Year over Year is calculated using AGO function.

    Please let me know solution.

  356. obiquest

    December 27, 2013 at 2:46 pm

    Hi,Shiva Please provide me the solution


    I had a requirement that i want to show the top 5 revenue generated products for the year.

    Dim col:-Product

    FactCol:- revenue

    Time Dim:-year

    Description:- I had a prompt for year that it should show the default value as “current year”. when i select the year from prompt it should show the current year,current year -1,current year -2 data.

    Example:- when i select ‘2013’ year in my prompt i should see the ‘2013’,’2012′,’2011′ data.

    Report:- It has three col’s Year,Product,Revenue.

    The report out put should be like this it should show the top 5 revenue products and remaining in ‘OTHERS’ by percentage wise.

    Graph:- Based on the above result i should show the out put in Stack graph by current,current-1,current-2.

    Please help me.



  357. Muthukumar

    December 29, 2013 at 6:34 am

    Hi Shiva,

    I have a requirement in obi 10g. Let me explain the scenario first.

    In the dashboard page top we have dashboard links like MyDashboard,Home Page.

    so my requirement is when i click on the home page link it has to show the list of dashboards containing under the home page and when i click on the some of the dashboard under that it has to show the dashbord under that without opening a new page.

    It is like start>All Programs>Accessories> paint/calculator … so here everything will open as a popup instead of opening in a new window ..

    My requirement is also like this .. when i click on the home page i need a pop up window which displays the list of folders under which inturn contains mulitple dashboards like menu and submenu

  358. Saravanan Venugopal

    January 29, 2014 at 6:49 am

    Hi Shiva,

    MY OBIEE reports are disappear when we giving inputs to the dashboard. I am unable to see my dashboard.

  359. MvD

    January 29, 2014 at 9:21 am

    Hi Shiva, can u please make an article about installing the new Oracle Mobile Security Suite (Bitzermobile). I think there will be a lot of questions for an article about this in the future, your Mobile app designer article was great too. It definately helped me out.

    Thanks in advance

  360. Arjun

    February 3, 2014 at 6:38 am

    Hi All,

    I have a dashboard in obiee10g, an image(company logo jpg file) is added to it using text or image section. I have configured an ibot to deliver the dashboard as a HTML to the email receipents ( as the end user wanted dashboard as the content of the email rather than an attachement). however when i deliver it as html, the image(company logo) is not displayed in the email instead of that an empty section is displayed. (image missing)

    if i deliver it as any attachement other than html then the image is displayed in the attachment of the mail.

    kindly post if any solution is available.

    Thank you



  361. Venkat

    February 4, 2014 at 4:06 am

    Hi Shiva,
    I like this blog, very informative and detailed and reliable. Thank you very much for your time and help.
    I have a requirement where Report should be delivered via email on first day of each quarter containing previous quarter data. All Service Requests logged(Creation Date) in last quarter.
    ExampleReport generated on first of April should contain all SRs created from Jan 1st to March 31 of that year,
    As same, Report generate on 1st of Jan shouldcontain All SRS created of previous year last quarter.
    Please give me detailed description on how to achieve this.

  362. arjun

    February 8, 2014 at 7:31 am

    Hi Shiva,

    I have a dashboard in obiee10g, an image(company logo jpg file) is added to it using text or image section. I have configured an ibot to deliver the dashboard as a HTML to the email receipents ( as the end user wanted dashboard as the content of the email rather than an attachement). however when i deliver it as html, the image(company logo) is not displayed in the email instead of that an empty section is displayed. (image missing)

    if i deliver it as any attachement other than html then the image is displayed in the attachment of the mail.

    kindly post if any solution is available.

    Thank you


  363. Rituraj

    February 13, 2014 at 12:30 pm


    Glad to see the blog

    I want to know is there any way i can put a calender box beside a dashboard prompt so that end user can select date using that calender boxrather than entering it manually????

    Thanks in advance

  364. mheann asejo

    February 20, 2014 at 2:06 am

    Hi! Good morning!

    How can I display a period of time in my report?
    Sample, I want number of accounts from jan 1 ,2013 to jan 10,2013. Sat and sun not included

    Output should be like this:
    Accounts| 1st week | 2nd week
    | Jan 1 to Jan 3 | jan 6 to jan 10
    Land | 10 | 50
    Air | 5 | 17

  365. Mital

    February 23, 2014 at 3:36 am

    Can we have more detail on error report within OBIEE?

  366. Thiru

    February 23, 2014 at 12:07 pm

    what happens when both logical keys are selected under logical level?

  367. Aditya Sharma

    February 26, 2014 at 7:38 am

    Hi Shiva,

    I’ve installed OBIEE I’m having all the channels in DW_REPORT DB but in OBIEE dashboard, the dropdowns ‘Channels’ and ‘Locale’ are coming as empty. Any clue where I might be going wrong?

  368. manoj

    March 3, 2014 at 1:08 pm


    i was working with oracle apps table ,i was stuck on one table that has not primary key and FK
    when i selected fnd lookup table column we got error, odbc error

    I was got other tables query working fine

  369. Nandini

    March 3, 2014 at 10:14 pm


    We are trying to create reports using one table, we want to create time series drill down, drill down by year, month and week work fine, but when we drill down to the day level it gives wrong values.

    All the values YTD, A year ago etc are wrong. Is there any particular reason for that.


  370. suresh

    March 10, 2014 at 4:48 am


    when i create a report using two subject areas i will get an error like “no fact table exists at the requested level of detail” Can any one help me

  371. Amarnath

    March 12, 2014 at 12:30 pm

    Hi Shiva,

    To introduce my self this is Amarnath working in chain-sys on OBIA when we are running the load on Financial Analytics in (AP). it is taking so many days, just i want to know how many days it takes to load.

  372. Aman

    March 16, 2014 at 2:21 pm

    I have created an Agent in OBIEE 11g which kicks off at a specific time (8 am everyday). The problem is that sometimes by this time the underlying ETL process does not complete so the report kicked off by the agent shows inaccurate data. One way to rectify this is that I can reschedule the agent, i mean delay it by couple of hrs. But I am looking for event based triggering of agent. Like when my ETL complete then the agent should kick off. Is there a way to achieve this?

  373. anpur

    March 17, 2014 at 9:04 pm

    I have just upgraded OBIEE from to
    Report header and prompt background color is changed looks like it is shaded.
    how do i remove shaded color?

  374. Stan

    March 26, 2014 at 10:05 pm

    I’m new to OBIEE, but I was able to use VB Script that was invoke on the server by the running agent and get report as Excel spreadsheet ( I was using OBIEE v. on XP). In this version when I created a new action for Agent using ‘Invoke Server Script’, in “Define Parameters” column “Value” there was dropdown to select “Delivery Content” or “Condition Analysis” and types options to choose from PDF, Excel, etc.
    Now I installed OBIEE v. on Windows 7 64-bit.
    When creating a new action for Agent using ‘Invoke Server Script”, in “Define Parameters” column “Value” there is no dropdown with options “Delivery Content” or “Condition Analysis”– and types options like PDF, Excel, etc. How can I use VB script to create Excel file if I cannot see “Delivery Content” for ‘ Value’ column and options to select from (pdf, Excel, etc).
    The only option available are “Session Variable”,” Repository Variable”, and “Request Column” . Is this a bug in OBIEE for this version?
    Can you help?

  375. lakshmi

    March 29, 2014 at 12:02 pm

    we are getting an issues with weblogic server getting stuck on which OBIEE is running.
    whether it could be causing by reports or not ?

  376. Mona

    March 31, 2014 at 2:37 pm

    Hello All,

    Can some one let me know how to compare the current date value with previous date value in the same Column?

    For Example:

    protocol ID Date
    1 07-July-2013
    1 11-Aug-2013
    2 24-July-2013
    2 3-Sep-2013
    3 21-July-2013
    3 11-Nov-2013

    Now in here , i have to find difference between the date and if date difference is greater that 15 days that count that protocol ID.

    I ma having difficultied since i have find difference betwwen two values in the same column..

    Any help is much appreciate.

    Thanks in advance.

  377. KNK

    April 5, 2014 at 6:52 am

    Hi Shiva,

    I have requirement that whenever user export the dashboard page to PDF, the PDF footer should display a page number as(lets say we have 5 pages) 1 of 10, 2 of 10, 3 of 10…Do we have any configuration file to set this that it can effect dynamically to all the dashboard pages…

    Thanks in Advance..

  378. Bruno

    April 8, 2014 at 3:19 pm

    I’m trying to copy and paste a physical alias, but when i copy it i lose the joins related to the table in question. Do i need to replicate all the joins again or is there an easier way? I’m working with obiee 11g. Thanks in advance for your reply.

  379. R

    April 9, 2014 at 7:04 pm

    Hi Shiva , I have a query in OBIEE-ESSBASE ,,,

    It goes lyk this .. I have a parent child hierarchy … And i have to show the parent nodes till the ultimate parent in my report based on the node selected … And i have to build it in a way that the measure selected should be as per the node selected .

    • R

      April 9, 2014 at 7:05 pm

      Its bit urgent …..

  380. Asfak

    April 14, 2014 at 2:39 am

    Hi, Getting eror iin agent triggered excel report, This report is displayed properly with data in OBIEE. When it comes into email inbox ,it is fileld with below error. Pleas help.
    View Display Error
    Odbc driver returned an error (SQLExecDirectW).
    Error Details
    Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
    State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 13017] User or application role has not been granted the Direct Database Access privilege to access the database ‘CGH-AEPSS’. Please verify the User/Group Permissions in the Oracle BI Administration Tool.Please have your System Administrator look at the log for more details on this error. (HY000)

    SQL Issued: {call NQSGetQueryColumnInfo(‘EXECUTE PHYSICAL CONNECTION POOL “cp_sql_AEPSS” select CF.cas_dte_tme_reg …………etc..

  381. Ayubjani Shaik

    April 15, 2014 at 7:28 am

    how we configure or Edit the grayed out Domain Member Mappings in Business Intelligence Applications Configuration Manager.

  382. Parashiva C

    April 15, 2014 at 10:26 am

    Hi Shiva

    we have a analysis in Development and QA( QA clustered Env) ,it has same logical query in DEV and QA
    and no changes in RPD and pointing to different database.
    In DEV -report generates 19MB tmp files and give result where as it generates more than 17GB tmp file and runs out of disk space …
    when we compared the physical query from DEV & QA, found a difference in it even though report logic is same.

    Any idea why it generates huge temp file and different physical queries.

    DEV Physical Quey
    SAWITH0 AS (select distinct T337993.CODE_VALUE_08 as c1,
    T337993.PRIMARY_ROLE_NAME as c2,
    concat(T337993.CODE_VALUE_08, T337993.PRIMARY_ROLE_NAME) as c3,
    nvl(T337993.PRIMARY_ROLE_NAME , ‘Unassigned Primary Role’) as c4,
    nvl(T337993.CODE_VALUE_08 , ‘Unassigned Pole’) as c5
    W_RESOURCE_D T337993 /* Dim_Resource_RM */
    where ( T337993.ACTIVE_FLAG = ‘Y’ ) ),
    SAWITH1 AS (select count(distinct case when T337993.CODE_VALUE_10 in (‘GEH’, ‘GES’) then T337993.RESOURCE_OBJECT_ID end ) as c1,
    count(distinct case when T337993.CODE_VALUE_10 in (‘CW’, ‘CW-ES’) then T337993.RESOURCE_OBJECT_ID end ) as c2,
    count(distinct case when T337993.CODE_VALUE_10 in (‘CW’, ‘CW-ES’, ‘GEH’, ‘GES’) then T337993.RESOURCE_OBJECT_ID end ) as c3,
    concat(T337993.CODE_VALUE_08, T337993.PRIMARY_ROLE_NAME) as c4,
    nvl(T337993.PRIMARY_ROLE_NAME , ‘Unassigned Primary Role’) as c5,
    nvl(T337993.CODE_VALUE_08 , ‘Unassigned Pole’) as c6
    W_RESOURCE_D T337993 /* Dim_Resource_RM */
    where ( T337993.ACTIVE_FLAG = ‘Y’ )
    group by concat(T337993.CODE_VALUE_08, T337993.PRIMARY_ROLE_NAME), nvl(T337993.PRIMARY_ROLE_NAME , ‘Unassigned Primary Role’), nvl(T337993.CODE_VALUE_08 , ‘Unassigned Pole’))
    select cast(NULL as NUMERIC(9, 0) ) as c1,
    cast(NULL as NUMERIC(9, 0) ) as c2,
    cast(NULL as NUMERIC(9, 0) ) as c3,
    case when D1.c3 is not null then D1.c3 when D2.c4 is not null then D2.c4 end as c4,
    case when D1.c4 is not null then D1.c4 when D2.c5 is not null then D2.c5 end as c5,
    case when D1.c5 is not null then D1.c5 when D2.c6 is not null then D2.c6 end as c6,
    cast(NULL as NUMERIC(9, 0) ) as c10,
    D1.c1 as c11,
    D1.c2 as c12,
    D2.c1 as c14,
    D2.c2 as c15,
    D2.c3 as c16
    SAWITH0 D1,
    SAWITH1 D2
    where ( nvl(D1.c3 , ‘1’) = nvl(D2.c4 , ‘1’) and nvl(D1.c3 , ‘2’) = nvl(D2.c4 , ‘2’) and nvl(D1.c4 , ‘1’) = nvl(D2.c5 , ‘1’) and nvl(D1.c4 , ‘2’) = nvl(D2.c5 , ‘2’) and nvl(D1.c5 , ‘1’) = nvl(D2.c6 , ‘1’) and nvl(D1.c5 , ‘2’) = nvl(D2.c6 , ‘2’) and D2.c3 0 )
    order by c11, c12, c4, c6, c5

    QA Physical Query
    SAWITH0 AS (select count(distinct case when T337993.CODE_VALUE_10 in (‘GEH’, ‘GES’) then T337993.RESOURCE_OBJECT_ID end ) as c1,
    count(distinct case when T337993.CODE_VALUE_10 in (‘CW’, ‘CW-ES’) then T337993.RESOURCE_OBJECT_ID end ) as c2,
    count(distinct case when T337993.CODE_VALUE_10 in (‘CW’, ‘CW-ES’, ‘GEH’, ‘GES’) then T337993.RESOURCE_OBJECT_ID end ) as c3,
    concat(T337993.CODE_VALUE_08, T337993.PRIMARY_ROLE_NAME) as c4,
    nvl(T337993.PRIMARY_ROLE_NAME , ‘Unassigned Primary Role’) as c5,
    nvl(T337993.CODE_VALUE_08 , ‘Unassigned Pole’) as c6
    W_RESOURCE_D T337993 /* Dim_Resource_RM */
    where ( T337993.ACTIVE_FLAG = ‘Y’ )
    group by concat(T337993.CODE_VALUE_08, T337993.PRIMARY_ROLE_NAME), nvl(T337993.PRIMARY_ROLE_NAME , ‘Unassigned Primary Role’), nvl(T337993.CODE_VALUE_08 , ‘Unassigned Pole’)),
    SAWITH1 AS (select distinct T337993.CODE_VALUE_08 as c1,
    T337993.PRIMARY_ROLE_NAME as c2,
    concat(T337993.CODE_VALUE_08, T337993.PRIMARY_ROLE_NAME) as c3,
    nvl(T337993.CODE_VALUE_08 , ‘Unassigned Pole’) as c4,
    nvl(T337993.PRIMARY_ROLE_NAME , ‘Unassigned Primary Role’) as c5
    W_RESOURCE_D T337993 /* Dim_Resource_RM */
    where ( T337993.ACTIVE_FLAG = ‘Y’ ) )
    select cast(NULL as NUMERIC(9, 0) ) as c1,
    cast(NULL as NUMERIC(9, 0) ) as c2,
    cast(NULL as NUMERIC(9, 0) ) as c3,
    case when D1.c4 is not null then D1.c4 when D2.c3 is not null then D2.c3 end as c4,
    case when D1.c5 is not null then D1.c5 when D2.c5 is not null then D2.c5 end as c5,
    case when D1.c6 is not null then D1.c6 when D2.c4 is not null then D2.c4 end as c6,
    cast(NULL as NUMERIC(9, 0) ) as c10,
    D2.c1 as c11,
    D2.c2 as c12,
    D1.c1 as c14,
    D1.c2 as c15,
    D1.c3 as c16
    SAWITH0 D1,
    SAWITH1 D2
    where ( D1.c3 0 )
    order by c11, c12, c4, c6, c5

    Please let me know why it is generating different query and its generating huge temp files.

  383. Pavithra

    April 18, 2014 at 5:34 am

    Hi Shiva/All,

    I have a time series line view which contains many graphs, one for each departments. They all come one below the other. I am required to place two or three in first line,the next two or three in the second line and so on. I could not align the graphs side by side.Could you please help?


  384. Neel

    April 23, 2014 at 6:53 am

    Hi Shiva,

    I have created a bar graph in OBIEE 11g, and when try to add one more bar graph view in the same report ,its showing a selector in the Graph.

    My requirement is i don’t want the selector in that.
    Could you let me know your thoughts on that.


  385. swapna

    April 29, 2014 at 10:36 am

    Hi Siva, I want to Calculate Time diff in Seconds between 2 columns based on that I want to derive my Measure columns. My 2 columns are of TIMESTAMP Data type and when I use Second function in Answers its working fine where as if I define it in RPD Its throwing errors like non of the fact tables are compatible etc… I ve used SECOND(Timestamp Column 1) – SECOND(TimestampColumn 2) at logical expression. Similar issue when I use TIMESTAMPDIFF..
    Please let me know ASAP.
    THanks in Advance

  386. Srinivas

    May 5, 2014 at 7:46 am

    Hi Shiva, While OBI Apps 11g installation and configuration trying run below .sql command.

    sqlplus dev_biacomp/welcome1 @C:\Middleware\Oracle_BI1\sdf\DW\ATGPF\sql\fndtbs_11170_upg.sql

    Missing the below directory….

    Probably it is not created while DW….

    Please suggest.


  387. andres068Andres

    May 7, 2014 at 5:56 am

    Hi Shiva,

    Good to know you.
    I have a question about OBIEE write back function.
    Currently, we can insert sentence in database by write back function.
    Do you know is it possible to insert a paragraph by write back function?

    Best Regards,

  388. mrajeev233

    May 22, 2014 at 1:45 pm

    Hi All,

    After Uploading ‘rpd’ file into Enterprise Manager server(EM),it is showing that BI server is down.If I click restart button in Enterprise Manager application,I am getting the same problem.This problem is occurring at the time of deploying RPD file into EM server.Please help how to deploy successfully.

    Thanks in Advance.

  389. mrajeev233

    May 22, 2014 at 1:58 pm

    Hi All,

    This is Rajeev.I am new for OBIEE tool and i have posted my issue in above .Please help on this.

  390. Suresh

    May 27, 2014 at 6:21 am

    Hi Shiva,
    I have upgraded obiee from to after upgrading, the report values are mismatched.can u pls help me on this.

  391. tavneer

    May 27, 2014 at 7:22 pm

    Can we add note collumns in an obiee report where the users can update and save comments if they want to, so that the next time any one see the report they can see what was the latest comment or note left in the report

  392. joan.bernardi

    May 28, 2014 at 7:29 pm

    We have OBIEE version. When downloading a report (both table or pivot view) to excel 2007+, the last row of the report is coming through as a merged cell. Any way of eliminating this row, other than manually deleting it in excel.

  393. Ajit

    May 29, 2014 at 7:26 am

    Hi Shiva,
    I have two pivot tables with total (horizontal). I wanted to show difference between this totals. how can I achieve this in OBIEE 11g

  394. Reeta

    June 3, 2014 at 8:04 pm

    Hi Siva,
    I have upgraded OBIEE to and Essbase Suite is missing. is there any way i can just install Essbase suite only in my existing OBIEE how is there any steps available? will it disturb existing OBIEE?

  395. Sreejith

    June 5, 2014 at 6:54 am

    Hi Shiva,
    I am using a field in OBIEE which returns a numeric value of 0.34. And when I round this off to a single decimal point it returns 0.3 as expected. But when I export this into a powerpoint thru OBI Office plugin, the value was displayed as .3, the 0 before the decimal gets omitted. As a work around, I tried using the CAST function inside OBIEE to return this value as a text so that the 0 will be in place. But then I use the ROUND function inside the CAST function to round off the decimal to 1 digit and then converting it to text, it’s returning 0.30 as the result. I am not sure why there are 2 digits after the decimal even if i use ROUND function to trim it to 1 digit. Can you please help?

  396. sunil

    June 12, 2014 at 5:43 am

    I have a requirement like this. I have a report that report is Direct Database request. I want to pass the multiple values from the prompt in to the Direct database request report.

    The single values is already passed in the direct database report with this syntax (@{PresentationVariable Name}). But when i tried to select multiple values from the prompt it doesn’t work.

    So can someone have any idea or any workaround how it can be achievable. My version of OBIEE is 11g.

  397. Shrikar Kondepudy

    June 17, 2014 at 11:16 am

    Hi shiva,

    I am a newbie to OBIEE. I am confused in creation of LTS and heirarchial rollups.
    Please let me know what are the various scenarios where there is a need to create a LTS.
    Also some information about creating a heirarchial rollup for e.g. year>>half year>>quarter>>month>>date.

  398. Vidya

    June 26, 2014 at 7:27 pm

    Hello Shiva,

    This is my situation. My numerator is coming from one analysis and my denominator is coming from another analysis. Unfortunately I cannot try to retrieve both in the same analysis due to certain restrictions with the way the model was set up. Is there any way I can retrieve the monthly numerator from one pivot table, then retrieve monthly denominator from another table and calculate the rates….

    The other workaround I can see is writing a SQL statement through OBIEE… which seems complex… any suggestions??

  399. Prabu

    June 27, 2014 at 10:33 pm

    We are using OBIA , when we try to configure implementation project in Functional Setup manager(FSM) we are facing issues. when i click the task lists its throwing a portlet procedure error.

    On reading an Oracle document (Doc ID 1634973.1) i followed the steps mentioned in it, and it is throwing another error ,when i am trying to run a script(as per the document).Kindly let me know what can be done or where i am lagging.


  400. Leonardo

    July 3, 2014 at 2:47 pm

    Hi, I’m getting an issue on OBIEE with Essbase
    The essbase cube was restructuring, then it was out of access for users. I opened the obiee dashboard and got an error on the analysis. The automatic selection of the combo month didnt work, then it showed a lot of graphs. Ok the cube was down. not big deal.
    The big problem is, even after the cube is up, the analysis continuous with the same problem. Still get no selected month and a lt of graphs… Any idea? Could it be cache? This cache is for user?

  401. Suresh Kumar

    July 3, 2014 at 3:36 pm

    Can you please help me ? I have an issue in OBIEE 10g ( There is a date column in BMM layer in the format DD-MON-YY HH24:MI:SS. Now I need a new column with the format YYYY / MM by deriving from the date column. How to do that?

  402. Dinesh

    July 17, 2014 at 1:43 pm

    Hi Shiva,

    Where do I get the RPD and Data dump for OBIEE Sample App v406?


  403. Kannappan

    July 18, 2014 at 7:23 pm

    Hi Shiva, I have a question on creating marketing segment.

    We are using Siebel Marketing and OBIEE

    We have created an analysis using UNION operator in OBI Answers and trying to convert the analysis into segment using Create segment view option. But the create segment view is not showing the relevant Target levels for this union report. At the same time the segment view is working fine for single report without union operator. I am able to create segment from single report using create segment view. But not working for UNION report. Do you have any idea if this is expected behavior of Create segment view?. I would appreciate if anyone share your thoughts for how to create segment from UNION reports in Answers instead of creating segment with same criteria again in segment designer.

  404. Archana

    July 29, 2014 at 7:22 am


    I am getting the below mentioned error on my report after upgrading the OBIEE application to version from in the older version the report is working fine.

    State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 14023] None of the fact sources for Dim – Date Fiscal Calendar.Fiscal Year are compatible with the detail filter.

    Please suggest resolution.

    Thanks in advance.

  405. Balaji

    August 11, 2014 at 2:17 pm

    Hi Shiva, can we have the Netsuite data on OBI Dashboard, if yes, please let me know the Step by step process.

  406. Rk

    August 19, 2014 at 11:45 am

    HI shiva , we got a derived column in a dim (d1) and in its fx we use a column from another dim table.(d2) It is throwing error in when pull alone this column with out fact columns joining these two dim . we can’t map the fact & dim (d2) in the. LTS of dim(d1) as this is joined with many fact tables. can u suggest a fix for this .

  407. Kumar

    September 1, 2014 at 7:52 pm

    Hello Shiva,

    There is a requirement to create a report.
    Lets say I have a region table.. columns in region tables are(Area, Geo market, sub geomarket, sub sub geomarket, country).

    if I select AREA in the view selector then I should only see AREA and GEO MARKET (its next level)
    If i select GEO MARKET then I should be able to see only GEO MARKET and SUB GEO MARKET( its next level) , soo on
    Can you please suggest me how to create this report.

    Appreciate all your help on this and thanks in advance.


  408. ravi Patel

    September 10, 2014 at 6:06 pm

    Hello Shiva,

    I am trying to display 6 months of data from the current date. How would I go by doing that?


  409. Durga

    September 15, 2014 at 3:01 pm

    Hi Shiva, We have a static text that displays vertically in our report. So when we try to print as pdf the vertical text is coming as horizontal only. Could you please suggest what could be done for that?
    The html that we have used is -(works in ie11 only)

    transform: rotate(-90deg);
    transform-origin: 50% 50%;


    Thanks in advance

  410. Vinod Kumar

    September 18, 2014 at 9:21 pm

    How to highlight a change in data inside a report.
    Example : (Yesterday) Day 1 , i have account 1,2,3 and 4 with few transactions posted.
    (Current Date)Day 2 : I have to highlight only account 2 , where i have few more transactions on the day 2 , rest of the transactions on account 1,3 and 4 stays same.

  411. Ravi Teja

    September 22, 2014 at 4:59 pm

    HI Shiva, I installed obiee on windows 8 and everything worked fine, but the admin tool pops out after 30 mins, Did anybody experience this problem?? pls help, I have a laptop situation mine is touch screen so i cant install windows 7 on mine. if any solutions pls mail me to

    Ravi Teja

  412. Manoj

    September 23, 2014 at 12:13 pm

    Hi Shiva,

    I am a newbie for OBIEE just started creating physical layer using the schema SCOTT with the tables EMP, DEPT and SALGRADE.

    The problem am facing here is with joins. Am able to create Equi join between EMP and DEPT table. But when i try to create complex join between the tables EMP and SALGRADE, i have given condition as SAL>=LOSAL and SAL<=HISAL and click on finish it creates a complex join. But when i select the join diagram, there is no indication for joining between EMP and SALGRADE. Instead of that, i can see only the line between the two tables but that doesn't meant for join as like equi join between EMP and DEPT table. Could you please let me know, whether i have doen anything wrong here or need to do any settings in OBIEE 11g tool. You help will take me to next step of learning in OBIEE.


  413. Nicola

    October 2, 2014 at 1:46 pm

    Hi Shiva,

    my goal is to change ‘database’ and ‘physical schema’ in physical tables defined in a Logical Table Source. I cloned both database and physical tables on physical layer that subject area on business layer. I need to set the cloned database on the cloned logical tables. The only way I Know to do that is remove phisycal tables from logical table source and then adding the new tables paying attention to set the corret joins. After these operations, however, I lose the column mapping and all the calculated fields.
    Remapping all fields and restoring all the calculated flieds it’s a very long and boring work.

    Do you know another way to do that faster and avoiding errors?


  414. Shiva

    October 6, 2014 at 5:21 pm

    Any ide provide any info on a Sorry Page that Finance subject area can use for OBIEE Self-Service Dashboards. We would like for this page to display automatically when the Finance subject area OBIEE Trail is delayed past 8:00 AM EST.

  415. Nanda

    October 7, 2014 at 9:15 pm

    Hello Shiva,
    Recently we upgraded OBIEE from to LDAP accounts are not getting authenticated. We come across this issue
    An error message was received from the BI Security Service: SecurityService::validateSystemUserProfile [OBI-SEC-00101] System user validation failed – the system user profile could not be found in the identity store.
    [2014-10-07T16:45:54.000-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 0001JlxPA5l03zgkDCV4Fw0002rH000000] [tid: 77] [nQSError: 13049] User ‘BISystemUser’ with ’empty’ permission can not query user population.

    We have Oracle system user and BI system user as “Default authenticators” thats how it was working in But after upgrade it constantly keeps failing with this message.

    Any ideas? Do we need to have Oraclesystemuser and BIsystemuser as LDAP accounts?

    • Lokesh

      October 9, 2014 at 11:26 am

      I need to find the data for current week, last two weeks, last three weeks, last four weeks…last 12 weeks. I can’t use this formula: FILTER(“Service Request”.”DT” USING (“Time”.”Week” = CONCAT(LEFT(VALUEOF(“CURRENT_WEEK_OBIA”), 9), CAST(CAST((WEEK_OF_YEAR(CURRENT_DATE)) AS int) AS varchar(2)))))
      ERROR: Function FILTER requires at least one measure column in its first argument.
      Please reply ASAP.

  416. Abhijeet

    October 9, 2014 at 6:16 am

    Hi Shiva,
    Kindly suggestions my requirement is 1.Integration of Peoplesoft 9.0 and OBIEE 11g.
    2.OBIEE 11g: Authenticating to OBIEE 11g With Users in LDAP, Groups in Database . also
    I could not find DOC ID 1428008.1 on MOS.

    Thanks in advance,

  417. vasu

    October 10, 2014 at 3:37 am

    Urgent help
    I need case statement for create the reports for each month’s ytd through a case statement.

  418. Suresh

    October 10, 2014 at 7:30 am

    case when Date.”Report Year”=2014 and Date.”Report Qtr”=4 then 1 else 0 end
    it will display 4 qtr of data means each qtr having 3 months so tatally 1 yr data u will get it…
    Hope this will help you..

  419. iswarya nandini

    October 13, 2014 at 7:16 am

    Hi All,

    My requirment is to limit only last 5 yers of data from flowing into Reports from an OBIA vanilla rpd.

    I read that i should apply calendaryear>2008 filter in BMM content level.

    Can you please confirm where all i should place this condition?..


  420. Sai

    October 14, 2014 at 2:36 pm

    Hi Shiva,

    I need to display a metric column value as single line on top of analysis, for ex: I have fact column with 176 value , I should display this on top of analysis, saying that number of pieces are 176.

    How can i do this? I tried with Narrative view, this is only working for attributes, not for metrics, pls help.

  421. Pavan

    October 14, 2014 at 3:47 pm

    Hi shiva,

    I have couple of questions regarding on cluster environment.

    we have a 4 node cluster environment and node1 and node2 are configured for failover in EM as primary and secondary servers.

    Q1.Now my problem is when I bring down primary and secondary servers, I was unable to login to the other 2 instances. Its throwing invalid username/password error.

    Q2. I dont see scheduler and cluster component on the other 2 instances.

    Q2. I am rebooting the entire BI Application.

    Here are the steps I am following to bring the application up. Please let me know if I am doing it the right way. My question is should I start the weblogic on all the instances are just on the primary instance.

    1. start weblogic on node1
    2. start node manager node1, node2 ,node3 & node4
    3. login to EM and start the managed servers bi_server1, bi_server2, biserver_3 & bi_server4t
    4. finally start all the components.

    Appreciate your help


    • debasis rana

      March 17, 2015 at 9:49 pm

      Hi Debasis here Shiva,
      First page in Obiee will show 2000 rows its ok but if we click next button it will show more 10000 record how to configure that in obiee .please reply

  422. Deepak

    October 30, 2014 at 9:39 am

    Hi all,
    How can I calculate current day- 61 days back total sales.I mean I want total sales only on that particular day.Similarly I want current week – 2 months ago week total sales.Can anyone please help me.

  423. Madhusudan

    November 8, 2014 at 7:13 pm

    Not able to update columns with null by write back in OBIEE

  424. Poornima

    November 11, 2014 at 10:45 am

    Hi Shiva,
    I am trying to handle null by using RPD physical layer. I have deselected Nullable. But it is not working. Any clue ?

    Thanks & Regards,

  425. Paresh

    November 19, 2014 at 2:03 pm

    How to stop dashboard Apply button from form submission.I need to throw some some custom exceptions on validations.

    One approach is: I hide Apply button and create my own button and onClick: return false –> But this approach will require all my dashboards to have this PLUS i need to write required fields validaitons for this newly created button

    Is there any smarter way??

  426. chanduabbavaram

    November 28, 2014 at 10:24 am



    1) XE Data base Installation
    2) ODI 11g Installation
    3) RCU Creation
    4) OBIEE 11G

    Is there any thing Sequence for install this software’s in windows 2008

    Thanks & Regards,

  427. sumanth

    December 11, 2014 at 5:09 am

    Hi Shiva,nice to meet you.I have few questions on OBIEE Clustering.When I migrate catalog folders from dev to qa ,should I have to migrate those folders to both URL’s bec some times some reports are dissappearing.pls contact me at 4088964426 or

  428. Renu

    December 30, 2014 at 12:31 pm

    Hi Shiva,

    How to pass parameters dynamically while scheduling analysis report in obiee (OBIEE 11g)?

    Please provide the solution for this.

    My Scenario:
    I have schedule the Analysis Report by using Agent but in content tab it choosing the analysis path & name and i am not finding any option to set the parameter.
    Here i have to set the parameter while scheduling the Analysis report.

    Please suggest me!!!!.


  429. Prajna

    January 29, 2015 at 6:18 am

    Now I am facing a problem with componet which is belongs to Oracle ADF Techonology.
    In Ring Graph ,I have to display the Service Type in slice of the pie. The thing is in ring pie the total count of service type is
    showing in center means in that hole part as total. I want to remove that total count from center and need to display in bottom of the
    pie Graph. I want to add Zoom functionality in graph .On Button click it should zoom on .Can You guide me How to do.

  430. chowdary

    February 3, 2015 at 10:46 am

    Hi Shiva,

    i need a small help from you regarding timestamp

    My requirement is need to display territory and bottom5 records, need to get bottom 5 values from current year and previous year measure variance data.
    Filters->> order year order month name and ship date> order year 2014 order month name January shipdate> order year 2013 order month name January shipdate<=01/31/2013 12:00:00 AM
    From both the current year and previous year measure need to take the difference and need to apply bottom 5 on variance

  431. Naveen Kumar

    February 8, 2015 at 4:04 pm

    Hi shiva. i am using obiee version. everytime i start all services.i am getting the below warning.
    can u please send me the solution

  432. Gokul

    February 25, 2015 at 9:20 am

    Hi Shiva,

    I have 2 repositories and couple of reports in the catalog path. Is there a quick way to identify or group the reports belonging to each rpd ?

  433. Abhilash

    February 26, 2015 at 10:55 am

    Hi Shiva,

    I am unable to Open front-end Analytics on Safari & Firefox(MAC system).
    OBIEE version is
    Server which have SSO configured is unable to access.
    Error: 401 Unauthorised.

    Please let me know if you can help me on this.



    February 27, 2015 at 9:42 am

    Hi Shiva,

    How do I save OBIEE ( analysis in CSV / XML file into Linux shared folder automatically on daily basis ?

    Appreciate all your help on this and Thanks in advance.

    Hari Krishna

  435. Abhi

    March 1, 2015 at 11:48 am

    Hi Shiva,

    I am consuming OBIEE web services using java. I want the path of all analysis and prompts associated with a dashboard that a user selects. I am able to fetch all the dashboards of a BI application using WebcatalogService in OBIEE(by using the getItemInfo and getSubItems methods) .But I am not able to get the details of objects associated with that dashboards like analysis and prompts. Can we get the information of which analysis are associated to a dashboard and their paths ??

    Kindly help,

  436. Abhi

    March 3, 2015 at 6:44 am

    How to insert multiple columns in a single dashboard prompt

  437. Anjaiah

    March 6, 2015 at 9:53 pm

    Hello All,

    i am applying patch on obiee11g on windows 64 bit but getting below error.please help on this.

    “unable to lock central inventory. opatch will attempt to re-lock. do you want to proceed in?”


  438. Ravi

    March 12, 2015 at 1:45 pm

    Hi Siva,

    i have below requirement how to achieve this.

    Is it possible to change the functionality that during an OBIEE REPORT
    export the dot becomes a comma ?

  439. Snehal

    March 14, 2015 at 7:41 am

    how we can call procedure using obiee 11g reports????please guid me in detail with steps…thnaks

  440. goutham

    March 18, 2015 at 1:20 pm

    Hi Shiva,

    Check Interaction between the Dashboards is not working properly. When i click back Main page , all reports are showing no results.—please suggest


  441. goutham

    March 18, 2015 at 3:42 pm

    Hi shiva,

    Interaction between the Dashboards is not working properly When i click back Main page , all reports are showing no results.please help


  442. Aarti

    March 25, 2015 at 9:47 am

    Hi Shiva,

    I need one help in obiee 11g.I want to provide distinct join condition in physical layer of repository.Is there any way to provide this ?

    Please suggest something.


  443. hadi

    April 9, 2015 at 1:20 pm

    Hello shiva,

    I work on obiee 11g and i need to know if there is a way to get the physical table name from the alias name, same for the columns.
    Is there any built in functions to return this ?

  444. aditya

    April 14, 2015 at 5:46 am

    Hi Siva,
    Can we have the option to track number of downloads for reports/dashboards in obiee 11g using usage tracking.


  445. karnati

    May 8, 2015 at 9:45 am

    Hi Shiva,

    I have requirement like this(using …After the user selects the dashboard prompts and apply button,Instead of running the request It should ask to save the results

    Can you please let me how can we achieve this
    Thanks in advance

  446. srini

    May 12, 2015 at 2:18 am

    Hi Siva,

    I really need your help on the Row level security Implementation in Table level.

    I have requirement as below.
    When user login to OBIEE11g, should restrict data based on the Access_ID
    Customer table table
    Access_code Security level
    123456 1
    345687 0
    username security approval level
    abc 10
    xyz 102
    ghk 1

    I have restrict the access_code based on the User – security approval level.

    For ex : Any user trying to access the customer table it should restrict the access_code based on the security level of access_code and security_approval level.

    please guide me how can we do this.?

  447. jaahnavi

    May 12, 2015 at 9:58 am

    Hi Shiva,

    We have manually deployed a 50MB rpd using Mbeans technique, The deployment was successful, but when I try to create the report, the columns in subject area are not loading, I have waited for 3-4hrs but still it remains same.

  448. Raj Laxmi

    May 13, 2015 at 10:11 am

    Hi Shiva,
    I need to have an ” TOTAL row ” for a particular column after each column’s value.
    Also the name “Total” for each row should be shown as ” sum ”
    ex: heading1 heading2 subhead fact_value
    XYZ ABC p 10
    XYZ ABC q 20
    XYZ ABC sum 30 —this is “total row” for heading1 = XYZ
    PQR DEF p 40
    PQR DEF q 50
    PQR DEF sum 90 —this is “total row” for heading1 = PQR

    value to be repeated i.e ABC to come and for “subhead” column “Sum” to be come and a total value under fact_value.

  449. krishna

    May 25, 2015 at 10:12 am

    Hi Shiva,
    i want to know about same qn Raj Lakshmi

    1) About total,subtotals for every column .
    2) About GL Reports scenarios…any

  450. Anand PS

    May 26, 2015 at 5:00 am

    Hi Shiva, We have added a new column to an existing table ‘ABC’ in database. When we pull this column to a report along with other columns from an MV then data is missing for another column in table ‘ABC’. Our team checked all joins and content side.. but not able to find the root cause…

  451. Abby

    May 28, 2015 at 9:06 am

    Hi, what should your data look like if you want to create a time dimension in OBIEE 11g?
    For example, should I create a column for year, month, date like:

    year | month | date
    2015 | Jan | 1
    2015 | Jan | 2
    2015| Dec| 31

    or should I have a ‘tag’ and a value like:

    tag | value
    year | 2015
    year | 2014
    month| Jan
    month| Feb
    date | 1
    date | 2

    Thanks for your reply

    • Shiva Molabanti

      June 14, 2015 at 3:50 pm

      Hi Abby,
      You can go with just values in columns and doesn’t need to have the tags.


  452. Sai Kumar

    June 10, 2015 at 5:57 pm

    Hi Shiva,
    Is there anyway that we can customize no result view message dynamically as per subject area for all reports.

    • Shiva Molabanti

      June 14, 2015 at 3:31 pm

      No Sai. It is just a static view to customize and cannot be based on dynamic varies

  453. ANil Kumar

    June 11, 2015 at 1:35 pm

    Hi Shiva,

    i need your expertise on one of the requirement i came across.

    Deprecate ‘X’ attribute (attribute should still work for existing reports, but be hidden to prevent users from including it on new reports).
    I tried with hide if object and coloumn level security,no luck.

    I can hide the object but iam not getting results in the existing reports with the X column.


  454. mahmoud

    June 15, 2015 at 4:28 pm


    I am so tierd and still looking for soluation

    how I can perform the relod time in administration tool in OBIEE to

    apply the real time approach (two sources physical tables(OLTP/EDW) in one logical table)

    pls support


  455. Kannappan

    June 16, 2015 at 2:53 pm

    Hi Shiva

    I need your suggestion on the following issue.

    We are using OBIEE

    I keep getting the following error when trying to run a query only on Dimension columns in OBIEE Answers:

    State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 14020] None of the fact tables are compatible with the query request Dim…

    I have the following setup in RPD.

    Physical layer:
    I have 2 fact tables and three dimensions. Both facts are fact-less tables. ie. no measures, only Foreign key of dim WID is populated in fact tables.

    F1 <- D1, D2
    F2 D1, D2
    F2 -> D2, D3

    I created dimension higherarchy for each dimension table with two default levels –Total and Detail.

    Content levels are set up in logical fact as follows:
    F1: D1=Detail, D2=Detail, D3=Total
    F2: D1=Total, D2=Detal, D3=Detail

    Also I have set Level based measures in the Total levels for Non-confomred dimensions.

    F1.x is setup as implicit fact column (dummy measure).

    Now I want to generate a report only on dimension columns ie. D1.x, D2.x and D3.x. I dont need any Fact. It throws the above error. If I add any one of fact column, the query works fine. But end user will generate most of the adhoc reports using dimension columns only.

    Please suggest if my logical data model is correct and also I am wondering how the answer query is working fine when any of the fact measure is added explicitly, but not working with implict fact column (same fact column is added as implicit fact).

    Doesn’t Implicit Fact work with Non-Conformed Dimensions? If Yes, what is the best approach to make it work?

    Please help me to fix this issue.

    • Kannappan

      June 16, 2015 at 2:56 pm

      Oops! some lines are missed in my comments.. Here is my RPD setup.

      Physical layer:
      I have 2 fact tables and three dimensions. Both facts are fact-less tables. ie. no measures, only Foreign key of dim WID is populated in fact tables.

      F1 <- D1, D2
      F2 D1, D2
      F2 -> D2, D3

      I created dimension higherarchy for each dimension table with two default levels –Total and Detail.

      Content levels are set up in logical fact as follows:
      F1: D1=Detail, D2=Detail, D3=Total
      F2: D1=Total, D2=Detal, D3=Detail

      Also I have set Level based measures in the Total levels for Non-confomred dimensions.

      F1.x is setup as implicit fact column (dummy measure).

  456. ram

    June 29, 2015 at 2:29 pm

    Hi Siva/All,

    I have a requirement on agent/Ibot which shoud trigger an email to the business users. I had created one agent with condtion on the agent.If condition satisfies it should trigger an email. Upto here ok.

    I want to stop an agent once the conditon is met .

    Could you please give your inputs on this please.

    Looking forward.Please let us know if more information is required.


  457. Indu

    June 30, 2015 at 7:39 pm

    I have a requirment ,if u user selects year-quater as 2014-Q2 in prompt ,graph should show last 3 quarter data like 2014-Q2,2014-Q3,2014-Q2 data.could you please help on the same.

  458. Rapunzel

    July 7, 2015 at 2:20 am

    Hi Shiva,
    Do you have any prior experience in integrating OBIEE with JD Edwards application. I would like to create some gauges/charts etc in OBIEE and integrate it into the JDE forms, in order to display it interactively for the user. i am using parameter driven data model for the same.
    Appreciate you response.

  459. KiranK

    July 10, 2015 at 11:01 pm

    Configure E-Mail on ETL Failure or Sucess with BI Applications

    • KiranK

      July 10, 2015 at 11:04 pm

      Hi Siva,

      Do you have any ideas or configure E-Mail on ETL Failure or Success, Which we had in 7.9 + Version in DAC. How to we accomplish this with BI Apps Version


  460. samba

    July 18, 2015 at 9:24 am

    Hai Shiva,

    I have a problem to save and check in changes in my RPD in online mode,
    ” nQSError: 37005 Transactional Update Failed ” error will be came.
    why this error will be came and how to solve this issue?

    • Shiva Molabanti

      September 28, 2015 at 8:22 am

      Check your DB connection. Make sure to have the tables that you are trying to update.


  461. Santhosh Sreshta

    July 29, 2015 at 9:44 am

    Hi Shiva,

    I am very new to this software, Please enlighten me in , how to get the work repository details in ODI Console.

    I have developed some interfaces in ODI studio, later I have opened console, there I am unable to view the details of the work repository which I have created in ODI Studio.
    Is there any procedure to get those details in the console.

    Thanks a million,

  462. Chakravarthy yadav

    August 13, 2015 at 7:09 am

    Hi Shiva,
    Is it possible that we pull live data from source DB when I run a OBIEE report.

  463. Bhagz

    September 6, 2015 at 7:34 pm

    1 table is aggregated another table is not aggregated and report is ran using these two tables….hw wud we achieve this with out making performance low

  464. Pankaj

    September 7, 2015 at 7:04 am

    Hi, we need to use a database function in OBIEE 11g.
    The function is in package eg (package.fucntion name).
    We are using EVALUATE function to call our function, EvaLUATE syntax we are using is.

    EVALUATE(package.function(%2) as number, subjectarea.table.column1, subjectarea.table.column2)

    please help[

  465. Serg

    September 21, 2015 at 2:47 pm

    hallo! How to do double the results in analys? First row – sum, the second – average. The option for rule aggregation at the level of the repository will not work in this particular case.

  466. Saranya

    October 21, 2015 at 6:25 am

    Hi Shiva,

    I need some help in getting the below logic :

    Requirement : User passes business date from calendar prompt (uses BETWEEN operator) from dashboard.
    we need to get the difference between these 2 dates and pass in the report for a particular column calculation.

    I tried the below but not working:

    from & to are presentation variables as i need something like below

    Eg : TIMESTAMPDIFF(SQL_TSI_DAY,TIMESTAMP’2015-10-15 00:00:01′,TIMESTAMP’2015-10-16 11:59:59′)

    Please share your suggestions.


  467. Wayne

    November 3, 2015 at 6:32 pm

    Hello Shiva,

    So I have a bi publisher report that has 2 parameters. My sql pulls data in the report so all is good there. I have a table that I modify ar_app_data that I use to put sql so the web page will pull the parameters and let the end user pick what they want in the Parameter. So why would it work in the actual report but one of the parameters do nothing but spin and not return data?

  468. Pradip

    November 5, 2015 at 9:43 am

    HI Shiva,

    I am facing below error after OBIEE upgradation from OBIEE to OBIEE

    ” View Display Error
    A subquery filter may not reference the current report (or contain a circular reference to any report).
    Error Codes: S6C66RYK:WIF3IYGO
    Location: saw.views.evc.activate, saw.subsystem.portal.pagesImpl, saw.subsystem.portal, saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads

    Recursion limit exceeded in Xml Expression Visitor

    Do you have any idea how to resolve it.

    Thanks in advance 🙂


  469. AJ

    November 19, 2015 at 10:11 pm

    Shiva –

    Can you please help me find a solution to run and schedule a BI Publisher report from a command line prompt or cron job?

    Please! I need it real bad. You might have done this. Please send me a sample code dude!


  470. Eric Tremblay

    December 4, 2015 at 8:24 pm

    Quick ODI question. I’m trying to figure out how many steps in a Load Plan before execution… I can figure it after but not before.



    – Eric Tremblay

  471. Nitin Joshi

    December 29, 2015 at 9:23 am

    we can use BIPCatalog utility to import existing report in BI Publisher in 11g. But How can we import those reports in 12c using same BIPCatalog utility ?

    I am not able to found this utility in OBIEE 12c environment. Please guide me on that.

  472. Sudhakar

    January 8, 2016 at 5:56 am

    Shiva, I want to disable drill on grand total in Table view, but drill should be there for the values. How can i disable either column level and row level grand total.

  473. Ashish Jain

    January 8, 2016 at 7:01 am

    Hi Shiva,

    I have one requirement of embedding BICS dashboard/reports in another application.
    Is it possible?
    In case of on-prem version, we can do using Go URL.
    Can it be done in case of BICS as Go URL doesn’t work in case of BICS.
    Is there any other way/approach through which we can see BICS generated reports/dashboards in other application or
    HTML page (iframe)?
    It would be great if you share any approach.


  474. Siri

    January 23, 2016 at 3:51 pm


    We have a situation in our reports where they aggregate data for multiple months based on a year . How ever for period 2 in 2016 the report needs to run for January and December of 2015 . Is there a simple solution to fix them by just updating the session variables in dashboard prompts we use for accounting period and fis_year


  475. Ram

    January 25, 2016 at 12:18 pm

    In mobile device iOS mobile HD, I’m getting authentication failed
    Request time out (1001)

    Please help

  476. srikant

    January 27, 2016 at 6:32 am

    What all will be the impact on obiee when upgraded to 11g to 12c (in testing perspective)?

  477. harshal pawar

    January 27, 2016 at 11:52 am

    hi shiva,

    I have obiee11g installed and I try to create report in analytics link,

    when I click on result tab , pop up appear ‘Not enough storage is available to complete this operation’

    I have gone through log files but no luck,


  478. harshal pawar

    January 27, 2016 at 12:07 pm

    hi Shiva,

    I have obiee11 g,

    when I open report from analytics link,

    it gives pop up message “Not enough storage is available to complete this operation”

    what will be the issue,

    As I gone through log files but no luck.


  479. mohan

    February 3, 2016 at 8:25 am

    Hi Team,

    we have developed a report. in the pivot table last 3 columns data showing empty where as when we run the physical query data displayed in DB. Please help me out to resolve the issue

  480. Amy Smoke

    February 4, 2016 at 9:32 am

    Hello Shiva

    I need assistance in setting up multiple authenticators in OBIEE 12c. Our requirements:

    1. Allow users to log into the system by one of two means
    a. User id and passwords that are dB credentials (11g)
    b. User id and passwords managed by the OBIEE default LDAP
    2. All reports/dashboards are built utilizing the Answers tool
    3. All reports are based upon RPD with shared connection
    4. All authorization is managed through the OBIEE roles and user groups

    I have created all user ids in the OBIEE LDAP. However, I’m unsure how to configure 1a so that the credentials essentially ‘pass through’ to the dB for authentication.

    I also know that authenticators may be established with order of precedence. In this case, the dB credentials method should be resolved first, and the default LDAP authentication last.

    Thanks in advance.

  481. essbase

    February 10, 2016 at 5:06 am

    Hi Shiva,
    In OBIEE analysis, I have Essbase data source . Sorting on Alias- member values on hierarchy eg. Gen-3 .. are not sorted in ascending or descending order. Any suggestion is appreciated.


  482. Pavan

    February 19, 2016 at 2:40 pm

    Hi Siva,

    If possible, Can you how to get the below requirement in obiee11g.
    We need below points:

    1. future DB growth for next 3-6-12-18 month
    2. See first 100 biggest tables and their growth during last 3 months
    3. See each SCHEMA growth with comparison to other schemas and their growth for the last 3 months
    4. See current snapshot on weekly basis with option to drill down for each day in selected week (for last 12 weeks) and drill down for each day to see by table

    Thanks in Advance..

  483. gopi

    February 25, 2016 at 2:01 pm

    we have three obiee environments,prod,dev,test…all are clustered environments,data is matching in both dev and prod but not in test env, more number rows returned from the client in test environment, for example a report is fetching 43 rows in dev and prod, but in test 139,all the environments pointing to same db and connection pool also same,physical query generating is also same,but no of rows retutned to client is different…what is the possible issue in test environment…

  484. bammidi

    March 2, 2016 at 2:46 pm

    i want to display custom message instead of write back error message in obiee report pls suggest

  485. ravi kumar

    March 4, 2016 at 1:06 pm


  486. manikanta

    March 10, 2016 at 6:06 pm

    Hi Shiva,

    Is there any parameter to put time out limit or export limit for Agent?


    • Shiva Molabanti

      October 12, 2016 at 12:30 am

      Yes Mani. You can set teh Timout seconds in the opmn.xml for delivers module.

  487. Praveen

    March 14, 2016 at 4:09 pm

    Hi Shiva,

    I am actually using filter of function in OBIEE front end.
    for eg:
    FIlter(“Facttable”.Metric_Column” Using (“Time”.”Month_name” IN (@{MONTH_NAME}{December}))).

    In the answers it is working fine, when when i am running on the dashboard with the prompt value selected. it is throwing me an error.
    Error: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27045] Nonexistent column: “February”. (HY000).

    Can you please help me out

  488. madhurikharidas

    March 21, 2016 at 6:11 am


    I have a requirement to publish the closing balance for every month for a given year. So for 2016, it will have columns Jan – Dec, showing closing balances from beginning of time to Jan end, in Jan.. Till Feb end in Feb and so on..

    Could you please advise how to achieve this ?

  489. Elavarasan

    March 29, 2016 at 9:34 am

    Hi Shiva..

    please to meet you..i have small doubt in OBIEEtool..

    After applying suppress option in all the columns i could see in some of the columns it’s not reflecting..can u please suggest me with some solutions.

    Thanks & Regards
    Elavarasan N

  490. vamsi

    April 18, 2016 at 4:54 am

    hi shiva,
    can u please tell me how get a pop-up msg report level(on column) in obiee 11g.
    Help me to solve this one….

  491. caner

    April 20, 2016 at 1:47 pm


    I have a problem with obiee 11g. Users can log in to analytics with invalid username and invalid password even with no password. Can you help me! Where do I investigate about that or what you offer?

    Please Help!


  492. gopalakrishna

    June 2, 2016 at 5:26 am

    i have two columns actual and quoted ,another more column difference (quoted -actual) i want to highlight the value negative values with red color and positive values with green color.
    can you please help me and give some steps to forward.
    thanks & regards

  493. Shilpa Reddy

    June 4, 2016 at 3:07 pm

    Hi Shiva,

    can you please tell me what all i need to Install OBIEE 12c on my local PC for practice purpose ?
    and what version of OBIA will supoort OBIEE 12C? i am going to buy a laptop for practice so can you suggest which configuration should i buy and which model is good with OBIEE

  494. Nischal

    June 23, 2016 at 5:03 am

    Hi. I need help in scheduling a BI Publisher report, in a way that it dynamically identifies the recepient (To address) from an OIM table or a lookup, whichever is feasible. How can it be achieved?

  495. Sandeep Andhale

    July 5, 2016 at 7:20 am

    Report of Fusion CRM application :-
    Subject Area used :- Sales – CRM pipeline
    Column Name :- Territory Name, Territory Quota

    How to Hide parent level territory node report ?

    Requirement is:- I want to see only child level territory row data inside the report

    But currently showing all territory row inside the report

    Thanksk & regards

  496. Sandeep Andhale

    July 5, 2016 at 7:22 am

    how to suppress Territory row

  497. Kumar Abinesh

    July 21, 2016 at 12:28 pm

    Hi Shiva, Is there any process by which discoverer reports can be migrated into BICS?

  498. Anifa

    August 7, 2016 at 1:20 pm

    hi shiva my play store doesn’t work i tried to reboot.clear cache and data but its the same tell me aunthentication error you need to sign into your google account,but i tried to change my account but its not help ,,help me please

  499. Sur

    August 12, 2016 at 2:50 am

    Hi Siva,

    I have 2 report (summary report and Detailed report) in Bi HR App and a group of user can see the summary report while they are unable to see detailed report , please advice.


  500. Sur

    August 12, 2016 at 2:59 am

    Hi Shiva,

    I have BI HR App 10g where a group of users can see the summary report but when they drill down to detailed report they get “No Result”, please advice !!.


    • Shiva Molabanti

      October 12, 2016 at 12:23 am

      Make sure to grant Read permissions to the folder and report where you have saved the detailed report for that particular group. You can just grant read permissions to that particular report only.

  501. Christin

    August 26, 2016 at 6:17 am

    Hi Shiva,

    I have a problem with obiee11 g.When i tried to take data from two fact table(each are connected using dimension tables)it results empty data from second fact tables,The obiee query
    doesnot considering the second fact table.


    • Shiva Molabanti

      October 12, 2016 at 12:22 am

      Make sure the common dimension table is set at detailed level in both the Fact table Levels in BMM.

  502. Christin

    August 26, 2016 at 9:54 am

    Hi Siva,

    Is there any problem for selecting values from two fact tables. I have two fact table one for order and the other for shipping.When i tried to take data from both it shows an empty list for the columns from second fact table(shipping). Both the fact tables are connected using more than one dimension table and still the problem remains.Could you suggest a solution


  503. Saq

    August 29, 2016 at 8:23 am

    Hi Shiva ,

    I have one requirement in BI-MAD11g ( ) ,

    * I would like to hide or disable Menu option from the apps ( Top Left side on ) ( Menu option : after clicking it we will get option like Page , Parameter etc )

    * Is any way to write java code in BI-MAD ?

    • Shiva Molabanti

      October 12, 2016 at 12:21 am

      Yes There is BIMAD SDK. Folks are writing the custom plugins using it. You can control teh menu features in the custom plugin/report code.

  504. Sadashiv

    August 30, 2016 at 5:44 am

    I have a problem with obiee11g. I have created report with drop down Table and Graph. In a dashboard default I kept as Graph. In a dashboard when I apply prompt year and month graph is not displaying after that I select table it is having data. After that If I choose Graph. Graph is displaying.

    My question is why Graph is not displaying when I apply prompt?

    Please Help!.

    Best regards,


  505. Shahbaz Chanadrki

    August 30, 2016 at 6:05 am


    I really liked your article about Data Lineage.
    Is there a way to include the ‘UI Report’ and ‘UI Column’ name as well, because generally we tend to change those particular fields as per client request which doesn’t get tracked in the Catalog_Data sheet.


    • Shiva Molabanti

      October 12, 2016 at 12:20 am

      Do you store the UI Report & UI Column references anywhere in the Database per customer? How do you change it ?
      Based on the references of the changes we can capture it eother from catalog or the source where you have that info.

  506. Maheswaran

    September 2, 2016 at 6:05 am


    I am creating a ah-hoc query based report and need to add filter parameter to the query allowing to retrive for all values when value is passed to the parameter if not particular value.
    The issue her is NVL will not work ,when no value is passed it returns the presentation variable.can you help me

  507. Indrani Sarkar

    September 3, 2016 at 12:40 pm

    Hi Experts,
    I am having 800 dashboards and prompts in OBIEE. Post Deployment ,we need to run each dashboard and prompt individually to ensure its not facing any error.
    Is there any way I can automate the process so that after deployment we can avoid the manual work of executing each of them one by one?Any method will do other than using third party software.
    Please suggest.

    • Shiva Molabanti

      October 12, 2016 at 12:18 am

      1. try OBIEE 12c Base validation tool.
      2. You can also try teh GOURL parameters. If the URL doesnt return any error, that means report passed (But you need to verify the results manually).

  508. BI dev

    September 22, 2016 at 7:53 pm

    hi shiva,

    i did create analysis with pie chart, for same criteria pivot table showing right percentages not pei charts not.
    Did encounter this kind of issues

  509. stewart

    September 23, 2016 at 2:50 pm

    When we run we are getting an error:

    ~The char ‘0x0’ after ‘java.lang.NumberFormatException: For input string: “‘ is not a valid XML character.

  510. Israel Elias

    October 7, 2016 at 4:42 am

    We need to know is there a way to create interactive response reports, for example we need to have a bank statement, in the output, the client can play around with some value, lets say that the gain a credit so that can play with calculating there capital, the timing. Can it be posible on version 11,1.1.9 or either in 12c

  511. Nakul

    October 7, 2016 at 11:27 am

    I have a request for new subject area build with the following functionality like when the user builds report.
    ->One should be able to select report data from Detailed data or aggregated data respectively.
    so your thoughts and ideas on above query would highly appreciate.


    • Shiva Molabanti

      October 12, 2016 at 12:11 am

      There are multiple ways to achieve this. One simple way that I am thinking now is: Create two logical table sources (LTS) in the RPD for each aggregated fact and detailed fact. And create a column like Run_Aggr_Flg or something and map this column to Aggregated table LTS only. Similary Create another Column as Run_detailed_Flg and map it to only Detailed LTS.

      Now In the report add these two Columns: Run_Aggr_Flg & Run_detailed_Flg and add them two column selector and save it.

      So that when you run teh report, you will see a drop down list two choose the columns. Based on the column you choose, OBIEE will send the Request to that mapped LTS.

  512. T Johnston

    October 7, 2016 at 8:29 pm

    We are currently evaluating ERP/HCM and BI capabilities and are fairly close to selecting Oracle Cloud. I’m am a little confused about what the BI in the cloud offers. We already have Microsoft Power BI and I’m wondering if we really need BICS. What would we be losing if we did not subscribe BICS? Where/how are BICS reports/visuals surfaced? Will Oracle cloud users have to switch between ERP to another site to view reports published from BICS?

    Thanks in advance for your advise!

    • Shiva Molabanti

      October 11, 2016 at 11:54 pm

      Yes Johnson. The BICS is a portal in the cloud. When you are integrating the ERP/HCM apps with BICS, The BICS will read the data from ERP/HCM apps directly and allows you to view the pre-built reports that comes with the package and also let you to create the adhoc reports for your business needs.

  513. balaji mvn

    October 8, 2016 at 8:35 am

    Hi Shiva,

    I am facing below error while doing the rpd consistency check.
    kindly check and advice me.

    Business Model Odwt:
    [15048] Logical table: Dim-Organization must be a descendant of the root logical table in the associated dimension, according to logical many-to-one join relationships.
    [15001] Could not load navigation space for subject area Odwt.

    • Shiva Molabanti

      October 12, 2016 at 12:06 am

      Looks like you have a parent/pre seeding table to Dim – Organization physical table. How did you join dim org table to fact. Do you have any other table in between? If you have any, then you should bring that tabe to Dim-Org Logical table. (Just drag that table directly on existing LTS for Dim -org and make sure it will not create a new LTS for you).

  514. Muzammil Husain

    October 12, 2016 at 7:01 am

    Hi Shiva,
    I have to make the Region hierarchy Region->Country->Point of sale->agent details. Agent no is our granular level but sometimes we do not get the information of agent and only POS level information is available. When I make the drill down it doesnt show those records which are at POS level. Could you please suggest something on this so that i could get the data at a POS level whereas we do not have the key data available for some records.

  515. Nicolas

    October 20, 2016 at 10:39 pm

    In, I’m trying to create a BIP report and data model from an OBIEE dashboard page. I go to Edit Dashboard>Print & Export Options>Create Layouts. Instead of a BIP report all that is displayed is a blank page with ‘Untitled’ in the upper left corner.

    Do you have any troubleshooting advice? (Thanks in advance)

  516. hadi

    November 7, 2016 at 10:15 am

    Hello Shiva,

    I’m using bi publisher and I have a report layout that is already linked to a data model.
    I’ m trying to add a web connection to call a soa service in the data model, problem is when I do this the layout breaks from the DM and I can only see the old data sources in the layout is there a way to join the layout to the modified data model ?

  517. Kashef Siddiqui

    November 21, 2016 at 9:51 pm


    Is there a way to pop a message while a dashboard query is fetching data?

  518. Nilay

    November 22, 2016 at 11:44 am

    Hi Shiva ….can we define action links on derived columns (if we have column values based on case statement in BMM layer) ? The column values are different than the actual value in database.
    WHEN “table”.”Id” = “table”.”NId”
    and “table”.”Group Name” IS NULL
    THEN ‘D.R.’
    WHEN “DB”.”table”.”Id” = “DB”.”table”.”NCRId”
    and “DB”.”table”.”Column” IS NOT NULL
    THEN Replace( “DB”.”table”.”Column”, ‘BU_’ ,’ ‘)
    ELSE ‘Junk’

    Applying Action link on the output value of this case statement.


  519. Katie Baker

    December 14, 2016 at 2:05 pm

    Hi Shiva,

    We use OBI in Taleo for reporting. We have added an additional compound layout to our analysis, where we have a pivot table view on the first tab and the table view on the second tab. We would like to export the data to Excel where the pivot table view populates on the first tab and the table view populates on the second tab (as it does on OBI). However, when exported to Excel, only the pivot table view from the first layout exports. The table view from the second layout does not export. Is there a way to export this information to Excel where both tabs populate on the spreadsheet without creating a dashboard?


  520. sathyanarayana

    December 22, 2016 at 10:20 am

    Hi all,
    I need to take backup of catalog and bar file as daily wise could you please help me someone
    how to achieve it and give step by step process

    if any clarification please let me know

    sathyanarayana ch

  521. aditya

    January 30, 2017 at 2:56 pm

    Hi siva,

    we are facing some performance issue with obiee application.When we trying to login it is taking longer than usual and sometimes it’s throwing an error like ‘Site can’t be reached’, but both Em& console and all other services in EM are up and running. we tried restarting the services couple of times and we bounced the db and server as well but noting is helping us. my support team sent an error message that i’m not able understand…could you please help me with a solution to clear this issue.
    Please find the below error :
    start with ACLE. and it’s length must be less than76 characeters. Also key must be defined in adf-settings.xml ORG.APACHE.MYFACES.TRINIDAD.UIXEDITABLEVALUE.VALIDATE_EMPTY_FIELDS does not satisfy one or more these criteria so returning null value>

    Thanks in advance,

  522. Mark

    February 9, 2017 at 6:30 am


    Sometimes i am getting the error “The Web Server may be down, too busy, or experiencing other problems preventing it from responding to requests. You may wish to try again at a later time.”

    my server is working on a F5 router.

    Can u let me know if any of you have faced such problems


  523. Sonal

    February 10, 2017 at 8:25 am

    Like we use hierarchy level for time based dinmension and this enable us to drill from Year to Quarter, then to Month and so on..
    Could we go backwards,i mean, from Mnoth to Quarter and then to year.

  524. Reeta Amin

    February 10, 2017 at 7:40 pm

    Hi Siva,

    I have faced error while configuring OBIEE.
    configuration failed at configure BI Domain step.

    if we have to start configuration process again how can we do that with out using new domain.
    that means how do we clean up files manually so that it create domain with same name (bifoundation_domain)


  525. satish

    February 10, 2017 at 7:53 pm

    Hi Siva,

    We are facing an excel 2007 download issue in OBIEE after an inplace upgrade from OBIEE When we try to export a large report with SSO link getting an Error: There was an error processing your download. Please check with administrator, but with default link could download the same size of report.

    If you had seen this type of issue, please provide your valid inputs.

    Note : With default analytics link, we are able to download more than 65K+ records to excel 2007 and CSV but with SSO link could download only for CSV .

    Thanks in Advance!


  526. Soumya Mitra

    February 14, 2017 at 10:05 am

    Hello Shiva,

    Can we display 20 decimal places in a graph?

    Soumya M.

  527. murali

    March 8, 2017 at 7:38 am

    Hi shiva,

    In obiee 11.9 version i am facing the below issue.

    Time_Dimention and Fact table joined based on Date column. In the report if i put filter only on time dimension( not on fact table) like > ’01-Jan-2016′ then in the physical query i am seeing 2 conditions
    One is based on Time.Date >’01-Jan-2016′
    and extra condition fact.Date > ’01-Jan-2016′. The second condition should not come rt.
    in 11.7.4 version it is not coming. Could you please help in this

  528. Jimmy

    March 8, 2017 at 10:21 pm

    Hi Siva,
    I have a question about dashboard prompt, is there a way to have a date prompt sort desceding when it is constrained by two other prompts. For regular date prompt I was able to do that by changing it to SQL (from choice list) and added order by one desc to the SQL. When constrained the SQL option goes off. Any input is highly appreciated.


  529. Ragu

    March 24, 2017 at 9:39 pm

    Hi Siva,
    I have been reading your blog for quiet some time. This is a great blog to read about various features and possibilities in BI.

    I am having an issue with ragged hierarchy in OBIEE and, really appreciate your inputs. I am trying to build a report, similar to hierarchy (where I can expand and collapse the tree structure) except that the values of child should not roll up to the parent. The report should display individual values that each person has in the organization parent should have his values and child should have his. I tried with ragged hierarchy set up, where the child values roll up to their parent.


    A is the Level1 guy in the organization, with B and E under him.
    C and D are under B(Level2). E(Level2) has no one under him.
    The report has like five measures in the pivot with current month, last month and their change percentage calculations.

  530. Sahil

    April 5, 2017 at 1:48 pm

    Hi Shiva, i read your post on Waterfall chart. you ended that post with leaving comments saying you can envision this to be used to create Gantt Charts, just curious to know if you found a way to achieve this ?


  531. E'm

    May 5, 2017 at 10:28 am

    Supplier Sales RPD ?

    Hi Siva,

    I am just going through the Oracle University OBI study material all the exercises are based on the Supplier Sales subject material.

    Do you have the RPD file that it references to? I already have the database schema Supplier2 but I don’t have the RPD it is referring to.

    Thanks in Advance.


  532. Felipe

    May 5, 2017 at 5:07 pm

    Hi Shiva,

    I am very new to OBIEE and I need to create a pie chart on OBIEE analytics involving two measures. All examples I find on the internet consider measure and dimension but that’s not what I’m looking for.
    Can you please help me with that?

    Thanks a lot

  533. SK

    May 8, 2017 at 2:21 pm

    Can graphs be created from reports which have unions. Is that possible?

  534. Shashikant Singh

    May 23, 2017 at 7:21 am

    Hi Shiva,

    I’ve one query need your answer, I’ve created one analytics in oibee but whenever I’m trying to go to the next page, it is not coming.. Means I’m unable to go to the next page of report..
    Please advice..

    Thanks and regards,
    Shashikant singh

  535. Raj

    May 25, 2017 at 11:22 am


    Want to show data(example :count of deals) for every 15 days (0 -15) days ,(15 – 30)days,(30-45)days..
    How to achieve this in obiee 11g.

  536. Praveen Chandra

    May 31, 2017 at 4:12 pm

    Hi shiva,
    I am facing a error while accessing the offline catalog throgth catalog manager.

    Error:Error initializing/loading existing Catalog:

    I have downloaded the catalog root file from production and i have created one folder in my local machine and trying to access the folder througth offline mode.

    OBIEE version

    Regards,Praveen Mallu

  537. Kumaran

    November 6, 2017 at 10:17 pm

    Hi Shiva,

    Nice to meet you.
    I’m trying to extract the contents of the offline catalog(Archived) file.
    I don’t have the BI Publisher installed in my local. I don’t want to install the same.
    All I want is to Extract the Catalog(Archive) file contents into my local folder.

    I am using windows 7.

    Let me know is there any possibility.


  538. Deepak

    November 14, 2017 at 7:08 am

    Hi Shiva,

    Is there any way in Obiee to export all the joins information used in rpd to a file ??


  539. raj9blog

    July 27, 2018 at 12:16 pm

    Hi Shiva,

    Recently I went to an interview they asked me a question an Obie agents.
    Q. A dashboard has four pages p1,p2,p3,p4 .
    How to create an agent that run p1 to particular user1/mail, p2 to user2/mail, p3 to user3/mail, p4 to user4/mail.

    How to achieve this in Obiee??

  540. raj9blog

    July 27, 2018 at 12:23 pm

    Hi Shiva,

    Recently I went to an Obie interview the question was like this.
    Q. A dashboard with four pages p1,p2,p3,p4 are there ,how to schedule a page p1 to a particular user/mail , p2 to particular user/mail, p3 to particular user/mail ,p4 to particular user/mail .using Obiee analytics agents without using manual interaction for inserting users or mail I’d?


  541. raj9blog

    September 10, 2018 at 7:55 am

    Hi Shiva,

    I had installed OBIEE 12c( on windows 10 , the installtion was successfully.

    when i open the analytics i have not found the default subject area.

    And i check the folder of where metadata of RPD in (\user_projects\domains\bi\bidata\service_instances\ssi\metadata\datamodel\customizations) the “customizations” folder was empty .

    1.) Can you tell me the process how i can get back the liverpd.rpd ,

    2.) if there is no process to get back rpd , then i need to install the OBIEE again ? pls clarify me ?




Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: