Business Intelligence – Oracle

Contact Me

If you would like to reach out to me with questions or suggestions, you can send an email to krisvenky83@gmail.com. I would be replying within a day or two.

285 Responses to “Contact Me”

  1. Egor said

    Venkatakrishnan, thanx for a good blog! Let me give you a small tip: you can use Alt+PrintScreen to make screenshot of a current window, not whole desktop.

  2. Venkatakrishnan J said

    Thanks Egor. Wonderful suggestion. Will use it in future entries. Thanks again.

  3. Thomas Wong said

    I have a question regarding converting Oracle Report 6 to Hyperion System 9 Interactive Reporting. I know there is no direct method for the conversion but would like to find out is there a way to translate the Oracle Report 6 into PL/SQL code or other code format that the developer can use it as baseline for conversion? Thank you.

  4. Rama said

    HI Expert,

    Can you please help me to come out of this peoblem

    When Dashboard reports containing charts or graphs are executed
    locally correctly and it’s displaying exactly
    But the problem is if we accessed the same Dashboard with the
    diffrerent URL like using system name instead of LoacalHost it’s
    asking UserName and Password for each navigation and also Charts
    or Graphs appearing as blank.
    I am pasting my URL’s for your reference

    http://localhost:9704/analytics/saw.dll?Dashboard
    it’s working fine

    http://w04251_itd:9704/analytics/saw.dll?Dashboard
    it’s not working

    My System Configuration Details
    Oracle BI EE Version 10.1.3.3.0
    Operating System Microsoft Server 2003 with SP2
    Internet Explorer 6.0 and configured through Proxy Server

    While installeing Oracle BI EE I have selected Basic and OC4j.

    I am trying to open the Application Server Control using this URL
    http://w04251_itd:9704/em/
    It’s asking the username and Password but it’s not opening
    it’s giving the Error Message
    (This OC4J is configured to make JMX connections via RMIS and
    fall back to RMI if the RMIS port is not configured. The RMIS
    connection on the OC4J local instance is configured but a
    connection could not be established. The JMX protocol is
    specified by the oracle.oc4j.jmx.internal.connection.protocol
    property in opmn.xml)

    • Vazir Ahamed said

      Hi Rama,

      Im facing the same issue which you have faced on the year 2007.
      i.e. you are able to see charts in one url and unable to view in another url.

      Can you tell me how did you resolve this issue.

      It will be very very helpful for me.

      thanks
      Vazir.

  5. Venkatakrishnan J said

    The first thing that i would do is to check whether i am able to ping w04251_itd from command prompt. If you are not able to do that, try adding this to your etc/hosts file. Also, check whether you are able to make the url work by specifying the ip directly.

  6. Madhu said

    Hi Venkatkrishna,

    I am working on OBIEE(Siebel analytics) and wanted to check if it allows us to upload templates(.rtf) which generates the .pdf file like we generate the .pdf files in EBS using XML Publisher.

    Thank you,
    Madhu

  7. Venkatakrishnan J said

    OBI EE consists of a suite of products. It has the following components

    1. Answers
    2. Dashboards
    3. Delivers
    4. BI Publisher
    5. BI Office
    6. Disconnected Analytics

    You have BI Publisher(formerly XML Publisher) in BI EE. So, you can upload templates and generate pdfs using this.

  8. Shan said

    Hi,
    my BI SCHEDULAR SERVICE IS STILL NOT WORKING.I HAVE FULLFILL ALL THE STEPS WATCH IN YOU BLOG.I AM USING XP PROFESSIONAL EDITION PLS GUIDE ME IN THIS REGARD.

  9. Evgeniy said

    Hello, Venkatakrishnan!
    Oracle BI EE:

    How to refine data in aggregates tables (created by “create aggregates …” statement) after the data in corresponding database tables was updated?

    It is unable to use the “delete aggregates” statement and then “create aggregates” again, because “delete aggregates” eliminates all aggregates in a model, but there are several aggregates in our model, that are intended for refining in different time moments and periods.

    Thanks

  10. Srinivas said

    Hi VenkataKrishnan,

    How to cretae Drill down reports by using Answers only We Developed Dimensions in BMM layer.But My comapny want to develope the Drilldown reports by using Answers only Can you please give some guidelines.

    Thanks,
    Srinivas

  11. Tim said

    Hi Venkatakrishnan,
    Your site is extremely helpful and I really appreciate all the great information.

    I was wondering if you could answer one question for me. Is it possible to run 2 Oracle presentation severs on the same NT server? We would like to spin up a DEV and TEST environment and are trying to figure out the best way to make that happen.
    Thanks,
    Tim

    • Janet Lovely said

      I need an OBIEE Developer my direct client in Nottingham, England.
      >
      > The project is 2 months + and starts January 4, 2010..
      >
      > Ideally, I need a Sr Oracle BI Developer with extensive OBIEE Reports Development experience. The resource must have OBIA FIN/HR
      >
      > standard reports experience and be local to the UK.
      >
      > I can pay $80/hr all inclusive on a C2C or $70/hr on a W-2 in US Dollars.
      >
      > I wonder if you or perhaps a colleague might be interested.
      >
      > If so, Please send a copy of your current resume in word doc format and contact information.
      >

  12. rodney said

    I saw your video on Maps in OBIEE. I am interested to know how this was done. Can you forward me to where you found this content? Thanks!!

  13. Venkatakrishnan J said

    @Tim: Various deployment options are discussed in the deployment guide http://download.oracle.com/docs/cd/E10415_01/doc/bi.1013/b40058.pdf.

    @Rodney: Even i am not sure which mapping tool is actually used there. The content’s direct link is here http://www.youtube.com/watch?v=G2GtwyYemYU.

  14. Venkatakrishnan J said

    @Srinivas: Always it is recommended to create all the dimensions, hierarchies etc within the repository. If you want to specify them in answers, one way is to have Report Navigation. Check my blog entry here https://oraclebizint.wordpress.com/2007/10/24/oracle-bi-ee-101332-custom-drill-path-navigation. This would give you a basic idea.

  15. Manohar said

    Hi Venkat,

    Need your inputs for performance tuning of the OBI reports? We have a situation where we need to show 100,000 records to the user ,the query when run on the backend database runs in a minute.
    All indexes are in place.

    When we run the report in OBI it is taking 10 minutes. Can you give me any suggestions on performance tuning.

    Thanks,
    Manohar

  16. Manohar said

    Hi Venkat,

    We found that the performance issue was more with database than the OBI.

    Thanks,
    Manohar

  17. Pournima Patil said

    Hi Venkat,
    You blog is very informative & it relly helps. I followed the steps you mentioned for OBIEE(10.1.3.3) & LDAP authentication. After that i have to integrate OBIEE wtih SSO. I have upadted credentialstore.xml & provided the passphrase in instanceconfig.xml. After this when i go to Presentation services i get following errors.
    1. Not logged in page error
    2. Sometime Unable to contact server.

    An encrypted password was found in the credential ‘impersonation’, but no decryption passphrase has been specified. Please ensure that a decryption passphrase is specified in configuration. See documentation for details on how to configure the credential store.
    Error Codes: WUDC2HWW
    Can you give me any suggestion to resolve this issue.

    Thanks,
    PP

  18. arifuk said

    Hi,

    I’m need to configure Discoverer with BI Publisher, but have a number of questions regarding what are the prerequisites.

    I have installed (on a Windows 20003 SP2 env – vmware image).

    Oracle BI 10.1.2.1, which consists mainly of Discoverer and Oracle Application Server Control

    Oracle BI Publisher Release 10.1.3.2, which was installed as part of my OBI EE install 10.1.3.3. BI Publisher is configured to report against
    OBI EE Subject Areas and Answer Request, using Oracle OBI Server Security Model.

    Oracle 10gR2 10.2.0.1 is the Db for all repositories/EUL/reporting schemas etc.

    I have downloaded patches
    p5648158_10122_GENERIC.zip – which is the one off patch for Disco Web Services

    OAS_Patch_p4960210_10122_WINNT.zip – which is the patch to bring the OAS upto 10.1.2.2

    I’m reading articles
    http://download.oracle.com/docs/cd/E10415_01/doc/bi.1013/e10416/discointeg.htm#BGBJBGID
    http://www.rittmanmead.com/2007/09/09/integrating-bi-publisher-and-discoverer/
    http://oraclebi.blogspot.com/2007/08/bi-publisher-discoverer-integration-4.html

    From what I can understand I need to have OID (Oracle Internet Directory) and the OA Meta Repository already installed and configured, before applying the
    OAS patch.

    What download can I use to install OID and the OA Meta Repository (which also needs upgrading to 10.1.0.5) only.

    I hope this is enough info to get a conversation started.

    Thanks

    Arif

    arifsyed@btinternet.com

  19. Sudipta said

    Hi Venkat,

    We are looking for following Enterprise Reporting features in OBI


    1. Drill Down(N-level) in Reports

    Drill down facility upto any no. of levels inside the same report.


    2. Event Based Report Scheduling

    For example, a file drop event will trigger report data refresh.


    3. Report Snapshot/History (N-instances)

    Users should be able to view N no. of historical instances of a report

    4. Conditional Formatting in Reports

    based on a report column/field value –
    a) data formatting to display some meaningful value to user(e.g. if TRANSACTION_TYPE =’D’ then show “Debt” else “Credit”
    b) display formatting of one/more columnn/fields


    5. Paging in Reports

    displaying page numbers in reports and control to force page resetting on start of a new group

    6. Role based access security to Reports

    Mechanism to group reports under folders and ability to give access to user groups to view reports.

    We had a look into OBI Publisher but we couldn’t find above features.

    Can you please suggest us which OBI component can address our requirements.

    Thanks in advance.

    Warm regards,
    Sudipta

  20. Asit said

    Do you know how to SSO enable BI Suites? I can’t find instructions on SSO enabling BI Suites. I just opened and SR at Metalink. In the meantime, I would like to know if you know how to SSO enable BI suites. SSO enabling Discoverer was easy. Thanks,

    — asit

  21. Sachin Sethi said

    Hi Venkat

    Thanks for all information which profile , Can we call
    oracle procedure and function from oracle OBIEE RPD File or Oracle
    Answers because i want to use some calculated data in reports query….

    Can you give me some Oracle Answers Layout guide where
    i can find out layout features..

    Thanks
    Sachin

  22. Edward Eloian said

    I am having trouble installing Oracle BIEE. When I run the installer i get the error message:

    java.lang.NoClassDefFoundError: run exception in thread “main”

    Do you know what this is and how to resolve?

    Thanks,

    Ed

  23. Rajat said

    Hi Venkat,

    Can you give some idea about the various privilages.
    What I want is a user who can only view the reports in dashboard ,i.e a user without edit dashboard privilage.

    Thnaks,
    Rajat

  24. Vijay Kumar Ramagiri said

    Hi Venkatakrisha,
    Your blog is very useful and really help to others. I am working on OBIEE(Siebel analytics) and I wanted to restrict the data which is available in the Presentation Layer based on User Position.

  25. rodney weinstein said

    Hello – Keep up the good informative work.

    Question – DO you know if there is a front end or back end setting that will collapse a specific dashboard box by default?

    The global filters at the top can take up a lot of space. We do like it at the top, but would like only this window (section) collapsed when the user logs in. All the rest of the boxes should be opened. If the user wants to open up the filters to make a new selection, they then can do so.

    Sorry – One more question – When putting charts into dashboard sections, there is a ton of whitespace surrounding them. To conserve space I would like to remove all the extra whitespace, but it is almost impossible to do. Any thoughts on if this can be done or tweeked a bit?

    Thanks.

  26. rodney weinstein said

    Hello – Keep up the good informative work.

    Question – DO you know if there is a front end or back end setting that will collapse a specific dashboard box by default?

    The global filters at the top can take up a lot of space. We do like it at the top, but would like only this window (section) collapsed when the user logs in. All the rest of the boxes should be opened. If the user wants to open up the filters to make a new selection, they then can do so.

    Sorry – One more question – When putting charts into dashboard sections, there is a ton of whitespace surrounding them. To conserve space I would like to remove all the extra whitespace, but it is almost impossible to do. Any thoughts on if this can be done or tweeked a bit?

    Thanks.

  27. Venkatakrishnan J said

    Rodney,

    In order to collapse certain sections as default, collapse them first in the dashboard. Then go to Page Options->Save Selections. So, save the page state and then make it as default. So, whenever a user logs in he would have the sections collapsed as default.

    In order to remove the whitespace you need to tweak the styles and the skins. You need to find out which class adding that whitespace and try to remove them from the custom XML messages.

    Venkat

  28. Ponraj said

    Hi Venkat,
    you are doing a great work. Thanks.

    You have explained in the blog Customizing OBI EE – SOAP API that, how to use the web services of OBIEE to bring the results of an ‘Answers request’ into custom pages or places of our interest.
    My requirement is as like this
    I want to enable the end user to design his reports in my custom page as he would do in the Oracle Answers web console. In other words, i want the same functionality of Answers web console in my custom page.
    Is it possible to achieve this requirement using web services? I have gone through the available web services. It seems my requirement is far from reachable. Wanted to have an expert opinion.

    Thanks
    Ponraj

  29. Bilal said

    HI Venkat,
    Gr8 work done! I am happy to see a very informative blog on BI and DWH.
    I am new to BI and currently working on OBI EE 10 with Oracle DWH 10.2. I need to show Tme Based (Year-Month-Days) capacity utilization in a chart in dashboard and want to work through Subject Area not through Query. The capacity is saved in Cube A while production is saved in Cube B. How can I use both of cubes in a single chart. Please note that we need to sum up capacity for every day spent start from the install of the machine, whereas it not necessary that we have processed material on that machine on a specific date. Cube A have used Dimensions Time, and Machines. Cube B have used Dimensions Time, Machines, Processes, Production, and Colors.

    Please let me know the method to use.

    Thanks

    Bilal

  30. sam said

    hi venkat,

    a blog on solaris installation will be of great help !!!

    thanks,
    sam

  31. Bilal said

    Hi Venkat,

    Please guide me to refresh the data in Oracle (Siebel) BI. I am using Oracle WH 10G Rel 2 at back end. Connected to Oracle (Siebel Dash board) through Oracle (Siebel) Administration Layer. Currently I have to re import meta data from Oracle Warehouse to Administration Physical Layer. and Then Have to redefine hierarchies and redefine presentation layer. Is there any automatic or shortcut method to refresh the updated data already imported in Adminisration layer.

    Thanks

    Bilal

  32. Bitloo said

    Hello Venkat,

    I had sent you an email regarding this a long time ago but did not hear back, how may I implement a query like this in OB:

    SELECT d1.date, (succ+fail) AS att, d1.succ, d1.fail, fail/att AS daily, (select (sum(fail) / sum(att)) from data
    where date > (d1.date – 7) and date <= (d1.date) ) AS Cumm
    FROM data AS d1;

    The number 7 above is a variable, will keep changing.

    Thanks.

  33. Bitloo said

    Hi Venkat,

    Which book will you recommend to learn more about OB and what it can do or point me to correct resource.

    Regards,

    Bitloo

  34. Sheeba Grace.T said

    Hi Venkat

    Your blogs are really too good and most helpful.

    I have created a dashboard using OBIEE 10.1.3.3.1.
    Can you pls let me know how to deploy the same in client’s location?

    Thanks & Regards,
    Sheeba.T

  35. Vikram Takkar said

    Hi Venkatkrisnan,

    I have one dimension table named as “Team” it has column “Team Type” and its value can be either Sales team or Traders team.It has “TeamKey” as a primary key of the Table and it mapps with salesTeamKey & TraderTeamKey of the Fact table. Actually Fact table contain these two keys “salesTeamKey & TraderTeamKey” and maps with TeamKey of the Dimension table.

    I think its not possible to join the two table , i need to create Table alias for the dimension table.I know how to create the Table alias in the physical layer & BMM layer.Can you please tell me how to use the alias Table in Presentatiuon Layer?

    Thanks n Advance.

  36. Dawn said

    Hi Venkat, I am trying to do aggregation and in BMM its showing an error code with 38091. This is thrown in the existing production rpd

    Now..when we try to do it as new test rpd it throws another error 15019….. Please give your suggestions

  37. Esther said

    Hi Venkatakrishnan,

    Thanks for the nice OBI EE blog…

    Would like to know how migration works in OBI EE. In other words, in discoverer we can export a single business area or the whole EUL.. How can we export a subject area in OBI EE or something along those lines. Any information on this would be really helpful.

    Thank you,
    -Esther

  38. Deepika said

    Hi Venkat,

    Saw your blog oraclebizint.wordpress.com/ I must say very impressive stuff and hence I have included your blog link in our website here: http://www.keysoft.co.in/links.aspx

    Venkat it would be great if you could contribute on our BI Forum: http://forums.keysoft.co.in/ and help other BI enthusiasts find solutions to their queries.

    Do visit our knowledge section: http://www.keysoft.co.in/biknowledge.aspx and let me know your feedback on the same.

  39. caimino said

    Hi Venkatakrishnan,
    I have a question for you.
    I tried to customize reports’ Title View in order to implement multi-language.
    My aim is to make reports’ Title View changeable depending on logon language’s choice.
    Do you know a way for it?

    Thank you in advance

    Best regards

    Cosimo

  40. Venkatakrishnan J said

    @Vikram – You need to achieve that in your Physical layer. Why do you want an alias in your presentation layer

    @Dawn – More info on the error is required. Do you have the error messages

    @Esther – What are you planning to do with the export. If it is for using in another machine just copy the RPD. Else you can merge the desired contents of your repository into an empty repository.

  41. Vikram Takkar said

    CAn you PLease tell me how would i solve the following problem:

    I have one role Playing dimension ( Team ) that can have 2 value ( Either Sales or Traders) .this dimension has 1 key ie. teamKey that points to two keys in the fact table ( salesTeamKey & traderTeamKey)

    CAn you please tell me how do i define the join for both tables ?

    I think we can not solve this problem with single join , we need to create alias table for it and mention the joins differently for sale s and traders. OK

    Now i need to drag that alias table in BMM and Presentaion layer also otherwise whats the fun of creating aliases? When i am checking the consistanct of the repository it is shwoing me error?

    can you suggest me the solution.. ie. how to work with role playing dimension?

    Thanks

  42. Jamal Syed said

    Hi venkata,

    I see an option for custom authentication plugin in Admin, but do not see any example on how to create one. Also, If we want to implement both LDAP and custom authentication, can we do that or is it just either or?

    Thanks,

    -jamal

  43. Idetrorce said

    very interesting, but I don’t agree with you
    Idetrorce

  44. Sofia said

    Hi Venkat

    Can you pls explain the concept of briefing book in detail.

    Sofia

  45. Chandra said

    Hi Venkat,

    How can I restrict no of rows that are coming in a page for Pivot view.

    -Chandra

  46. Peter said

    Hi Venkat.
    is it true, that variables cannot be used to change column headings dynamically? I am currently trying to do this but haven’t found a solution yet. All entries in custom headings seem to be interpreted as pure text.

  47. juanc llanes said

    i have a external custom search jsp page with a one parameter.

    is possible to do a action link to this external custom search jsp page and pass parameter to it from a results in the dashboard?

    How i can drill down to a external jsp page from results in the dashboard?

  48. juanc llanes said

    my problem is how to invoke a external custom search jsp page and how to pass parameter to it from a cell values from a results in the dashboard.

    i read an example about action link but i don’t know where an how to define my own url for the my custom search jsp page in the answers request definition and how to pass to it a cell value as parameter from a dashboard during presentation session.

  49. Rajeev said

    Hi Venkat, Can you please tell me how I can configure single sign on with siebel analytics.
    Is there any document for doing this ?

    Thanks
    raj

  50. Shailaja said

    Hi Venkat,

    This is a plain query on connecting to Hyperion OLAP server from Cognos8 BI for accessing teh cubes cretaed in Essbase.

    Could you throw some light on how a connection string gets formed for Essbase Server?

    I tried giving the analytic server name with proper credentials but encounter teh error:
    ‘QFS-ERR-0138: DataSource ‘EB’ is not supported by any provider’

    KIndly suggest ..

    Rgds–

  51. V Murali said

    I have one customized software from that software I want to call OBI dashboard (other way I want to suppress the obi login screen)

    At the same time I want to authenticated in OBI.

    Please let me know your inputs.

  52. V Murali said

    I have one customized software from that software I want to call OBI dashboard (other way I want to suppress the obi login screen)

    At the same time I want to authenticated in OBI.

    Please let me know your input.

  53. sam said

    Hi Venkat,

    I need to transfer my reports from one OBIEE web server to another.
    I transfered the .rpd file along with NQSConfig.INI and Instanceconfig.xml.
    I’m able to see the Subject Areas but not the reports which I created.
    Can you please let me know which other folders do I need to transfer

    Thanks,
    Sam

  54. sam said

    Hi friends,

    I’m facing a peculiar problem in BI EE…..In charts the the numerical values are getting rounded off to 2 decimal places automatically ,even though in the table it is upto 6 decimal place.
    For example 1.00612 is getting converted to 1.01 while plotting the charts.
    Please help.

    Thanks,
    Rajat

  55. asit said

    Hello Venkat,

    First of all, thanks for the excellent blog on BIEE. One question for anyone.

    Is it possible to make a Dashboard that can be accessed without username/password (ie. public access)? Thanks in advance?

    — asit

  56. Bharat said

    Hi Asit,

    Yes, its possible.
    In Security section of NQSConfig.INI file use
    AUTHENTICATION_TYPE = BYPASS_NQS;

    hth,
    bharat

  57. Asit said

    I’ll try that. Thanks Bharat.

  58. Corbaks said

    Hi Venkat,

    first, happy new year!
    and thanks for your excellent blog!

    i have a little question for all.

    i must developp an external application in java (servlet).
    I will using SOAP API, this application must be totally integrated in a dashboard. (embedded content?)

    my problem is : how i can retrieve SessionID or username in my application?

    thanks in advance
    Corbaks

  59. Raviben said

    Hi Venkat,

    As I have posted earlier, it’s taking ages to just import around 10 tables from ORMS. Is there any faster way. I have been waiting for around 3 1/2 hrs now.
    Please help out.

  60. Ali Haroon Nawaz said

    Dear Venkat:
    I want to assign dynamically to dashboard prompt. My problem is such like that
    I want to show two variablec in the form of list. One is about product value greater than 100 other is less than 100. Then in the next dashboard prompt those products name should be shown whose value is greater than 100 or less than 100 as selected. Please help me in this case. I dont know how i show two variable in the form of list. Separate I can show but how two coloumn I show in list. Please help me in these sections. Thanks

  61. asit said

    follow-up question
    By uncommenting following:

    AUTHENTICATION_TYPE = BYPASS_NQS;
    I still have provide something in username… it could be xyz or abc… it does not matter as long as there is something. There has to be a way to create a dashboard that requires no username/password. Thanks,

    — asit

    ====================
    Hello Venkat,

    First of all, thanks for the excellent blog on BIEE. One question for anyone.

    Is it possible to make a Dashboard that can be accessed without username/password (ie. public access)? Thanks in advance?

    – asit

    # Bharat Says:

    Hi Asit,

    Yes, its possible.
    In Security section of NQSConfig.INI file use
    AUTHENTICATION_TYPE = BYPASS_NQS;

    hth,
    bharat

  62. Tapasvi said

    Is it possible to render a BI Publisher report inside HTML DB (APEX) application ?

    I am trying to achieve this by creating a web service based form and report page but not successful so far

    I could successfully test only “validateLogin” and “hasReportAccess” method. runReport method gives ORA-20001: soapenv:Server.userExceptionjava.lang.NullPointerException error..

  63. shekar said

    Hi Venkat,

    I would be pleased if you can clear my doubt. I have two independent reports namely ‘X’ and ‘Y’.
    I just want to know if there is any chance where in i can see the two reports in only one report by using the drop down.

    Thanks in advance.
    Shekar

  64. Brijesh Goyal said

    Hi Venkat,

    I was trying to build a report on Answers and got stuck at one point.I need a computed column say SumM1 such that it will hold summation of all the values that are coming in column M1.

    for eg.

    M1 SumM1

    10 60
    20 60
    30 60

    I searched for almost all the option but none of them worked for me.

    Kindly share your view on that.

    -Brijesh

  65. shekar said

    Hello Venkat,

    Its been a wonderful work by you. We all appreciate you for that.
    This is where everyone gets clear of all the doubts and share it to others, solved by you or by any other. We would really be happy if you can answer our queries as soon as possible. It’s been a month that you haven’t replied 2anyone, because queries solutions are so crucial.
    Its a plea, and we can understand that you have ur own commitments

  66. Venkatakrishnan J said

    Apologies everyone who have been waiting for a reply. Never realized the Contact Me page would get so many comments and hence did not check them for any updates. Anyway my replies are below.

    @Vikram – Just create an alias in the physical layer and then make a join.

    @Jamal – I think you can do a combination of both. I am planning to put together a blog entry for custom Authentication.

    @Sofia – Is there anything specific that you want to know on the briefing books?

    @Chandra – Do you want a Pagination in the pivot view or do you want to just filter the rows?

    @Peter – Unfortunately yes. Though you can mimic dynamic column headers using another text view. I will blog about this later.

    @Juanc – Check my blog entry here https://oraclebizint.wordpress.com/2007/12/26/oracle-bi-ee-101332-drills-across-sections-in-a-dashboard/. It has an example.

    @Rajeev – This is documented in the Deployment guide.

    @V Murali – Just pass the username and passwords in the URL itself. That will achieve what you need.

    @Asit – Just pass the username and passwords in the URL itself. That will achieve what you need.

    @Corbaks – How about using GO URL? SOAP APIs can also be used. But for most cases GO URL will more than suffice. Can you explain what exactly is your business scenario?

    @Raviben – Can you try using ODBC instead of OCI? I have heard seen some strange things happening when you use OCI for importing metadata especially in 10.1.3.3. But you should use OCI in the connection pool.

    @Tapasvi – Yes very much possible. Can you provide more details on the error? How are you handling the final result output?

    @Shekar – Yes very much possible. 2 approaches can achieve this. Either use Guided Navigations or GO URL for each of these reports. I am planning to blog about this.

    @Brijesh – Use SUM() if you have SUM as aggregation in the repository. If you no aggregation in the rpd then use SUM(SUM())

  67. Rajeev K said

    Hello Venkat

    Do you knw , in Answers , how do i assign permission for a user to use the Custom text format in Column Properties> Data Format tab , with Override Default dATA Format checked? The Admin id has the rights to view this option in the drop down , but i need to provide this to users too so that they can write javascripts for navigation purposes.

    Thanks

  68. sree said

    Hi,
    I want to create two tables under one main dim table in the presentation Layer.
    I want to cretate the main dim table is “Prodcuts”. Under this main dim table I want to display two sub dimensions like ” Product Type” and ” Product Sub Type “.

    Can you pls give me adive how you can achieve.

    Regards
    Sree

  69. sree said

    Hi Krishna,
    I have implemented the pagination as per the code you given today.
    But i am getting the Syntax Error.
    Can you pls help into this.

    Regards
    Sree

  70. Venkatakrishnan J said

    @Sree – What error do you get?

  71. V Murali said

    Hi venkat,

    Is it possilbe to display dynamic tool tip in column fields.

    Regards,
    Murali

  72. V Murali said

    Hi Venkat,

    Tool Tip : We have report having four differnt columns such as Employee Name,Date,Salary,No.of Leaves.

    In the Employee Name column ,when user moves mouse pointer at that time we need employee should show where customer can able to employee id.

    could you please help us,we need your help which help lot for deveopment process

    Thanks

    Regards,
    Murali

  73. Lokesh said

    Hi Venkat,

    my problem is
    i have two edit box in prompt.
    1)Name 2)ID
    i have assigned server variable to ID edit box.
    when ever i open the screen i find default value assigned to ID.
    i remove the default value and enter value in name edit box.
    on which i want to search.
    but as soon i enter value on edit box and click on Go button, my screen will refresh and again default value is assigned again it ID

    i tried to modify globalfilterprompt.js

    and i tried to understand Source file generated by report
    i found that GFPUpdateValues
    event is called onblur

    as this code generated by Server, and i don’t have acces to Server to modify, i found this would be better option to avoid this problem.

    can you tell more about GFPUpdateValues function

    thanks,
    Lokesh

  74. sid said

    Venkatakrishnan,
    I am new to OBIEE and has learnt a lot from your blogs. I have a problem regarding Pivot tables based reports….certain reports come back with too many rows that OBIEE can not handle (due to default limits)…so I tried to override them with this setting in instanceconfig.xml =>

    200000
    750000
    1500
    2000

    That damn thing is not working. What can go wrong? The node definitions above are put within ServerInstance node and there is a chart -> DefaultImageType node below the definition that is working.

    Also if I use JPEG as my default image type, can I use map based prompts?

    Thanks a lot for considering my questions…..and keep up this great blog. If you have an answer to my instanceconfig nightmare, please mail me.

  75. sid said

    Sorry,
    in the previous post my xml tags are eaten by browser or some parser at wordpress. Here is the tags and values with removed (I do not wated to write”&gt”) you know:

    PivotView
    CubeMaxRecords 200000 /CubeMaxRecords
    CubeMaxPopulated Cells750000 /CubeMaxPopulatedCells
    MaxVisibleSections 1500 /MaxVisibleSections
    MaxVisiblePages 2000 /MaxVisiblePages
    /PivotView

  76. Manju Nambiar said

    Hey Venkat,
    I am doing a fresh install and configuration of OBIEE.
    I followed the steps in your blog “Oracle BI EE 10.1.3.3/2 – Using LDAP/OID Authentication” to configure security using company LDAP.
    Instead of OID, I am using the company LDAP. After creating the server, I tested the connection and was successful. Next I tried Import option, but got the Oracle BI Administration Tool error message: “There is nothing to import.”
    Next I tried the initialization block setup and system variables – but no luck.
    Is this an LDAP privilege issue or OBI issue?
    I tried the same LDAp with a LDAP viewer tool and am able to see all the users.
    Please help me out.
    Thanks,
    Manju

  77. Girish said

    Hi Venkat,
    I want Pagination in the Pivot Table view(i.e) i want to restrict the number of rows same like a table view in Pivot table view

  78. Prakash said

    Hi,

    The Button which I’have created for Write Back through the Table Properties is disabled.Is there any specific setting which we have to do to enable it.

    I’have a Oracle DB tabel SALES with two columns EMPID & REVENUE .

    I would like to update the REVENUE colum with the write Back feature.

    I’ve created a WrightBackTemplet.xml file & placed it in D:\SAS_INSTALLED\SiebelAnalytics\Web\App\Res\CustomMessages

    The XML file looks like ..

    UPDATE SALES SET REVENUE=@2 WHERE EMPID=@1

    COMMIT

    I’ve also added the Write Back privileges to the WebAdministrator.

    Kindly let me know what else I have to do.

    Y the button is not enabled?

    Thanks
    Prakash

  79. Jonah said

    Hi Venkatakrishnan,

    Great blog! I have a question for you. We are running hyperion essbase 6.5.3 for building our cubes and WebFOCUS for our front end reporting. We are looking at upgrading our reporting and data mart system to system 9 (OBI EE + 4 Hyperion Components) in order that hopefully it works better under one umbrella product and cost savings from licensing costs. I read your overview on the Hyperion System 9 BI solution and was wondering whether this solution can run a web front end as good as webFOCUS and if it can read OLAP (essbase) and relational (Oracle) sources. We do not financial reports but that function may be used in the future. Should I consider anything else? Thank you.

  80. David said

    Hi Venkatkrishna,

    Like your blog. A simple question about OBIEE 10.1.3. Back in Siebel 7.8 you could place 2 or more reports within one report. For example, if I wanted to display a report on people hired followed by a report on plant inventory I would simple embedded them together and print to a PDF. In 10g this feature is now gone. I need to print 10 different reports into one PDF! I cannot use one answer query to run all these reports. Is this possible in OBI or do I need to run something in Adobe PDF writer?

    Thanks in advance

  81. V Murali said

    Hi Venkat,

    I want to design rpd for my historical data maintance.Both fact and dimension table are partition of 14.

    customer needs latest partition data should display in the report and there should be dashboard prompt where user can able select the desire partition data and report should refresh with reference to user selection paramter.

    We have same fact and dimension tables without partition having 2lakh records and report data displaying within 15 seconds and same report with partition table it is displaying more than one minutes.

  82. Venkatakrishnan J said

    @David – How about creating a new page and adding your reports there. You can take a PDF of the entire dashboard page.

    @Jonah – Absolutely you should consider now using BI EE plus which has both Hyperion Components and BI EE Components. Hyperion Web Analysis can seamlessly report on both Essbase and Relational tables. Also, BI EE can do that. Both of them have a very good UI.

  83. SholaO said

    Hi Venkatakrishnan,

    Question on: ONLINE REPOSITORY FOR OBIEE Connection Pool.

    I’ve search through you to your BI blog for information on ONLINE connection Pool and your blog has an excellent content materials on overall BI subject matter

    My Scenario: I’ve created a custom Repository based on custom tables (XX_TEST_5.rpd) with an OCI10g/11g with appropriate data source. I’m always able to update row count offline, without any issue with no Global consistency and the rpd is available for query. But when I updated (on local desktop) NQSConfig.INI with my above rpd name, and try to validate my repository Online within OBI Admin tool, I always get an “nQSError-17014” error.

    I’ve explored all known options even I tried to validate the rpd within my local BI answer with all Privilege Administration setting for Answer and I’m still unable to connect ONLINE.

    I‘ve tried every option possible including using different versions of OCI available. Currently I can proceed to do anything within BI Answer and unable to progress with my current dashboard project.
    Would you have any recommendations on how to overcome this issue? Thanks a lot for your assistance in advance.

    Thanks,
    SO

  84. Victor said

    Hi, there…
    I´m a complete adict to your blog.
    When got any doubt, get my Bible, but although you´ve got 2 posts about my question, I can´t understand completely about Date Answers treatment.
    I´m trying to get a date from user, and when the variable gets nothing, want to intializate with a default date. Here is where the error raises. When try without the variable, it runs, so I think there is a problem with my format.My filter:

    FILTER( “curr_budget”.Ammount USING (“curr_budget”.Date BETWEEN @{timestamp(Get_date)}{timestamp ‘2007-01-01 00:00:00’} AND @{timestamp(Get_date)}{timestamp ‘2007-12-31 00:00:00’}) )

    It´d be great if you can show me where is the problem.
    Thanks in advance, Venkatakrishnan…

  85. bill said

    Hi Venkatakrishnan,
    Your site is extremely a great helpful tool and I really appreciate all the great information that you have posted here.

    I was wondering if you could post something about Hyperion system 9, such as the installation, configuration and deployment. This is pretty hot BI technology, but unfortunately, there is no related material on system 9 configuration and installation. Actually, I loved the idea of your demonstration by posting the screenshots and was thinking if you could do the same with system 9 installation

    Thanks, bill

  86. Farz said

    Hi Venkatakrishnan,

    Thanks for all your blog entries.
    Do you have any blog or documents for BI EE web services similar to what you have created for BIP and Web services. Thanks.

    Oracle BI Publisher 10.1.3.3.1 – Creating Applications using JDeveloper 11g and Web Service SOAP APIs

  87. Hi Venkat,

    My name is Karthik. Just got introduced to your blog. Seems like you have lots of good information out here. Will keep visiting this site more often.

    I am also a BI professional and blog at http://www.beyeblogs.com/karthikonbi. The discussion topics are more general in nature and not necessarily on specific tools though. Oracle BI is definitely generating lot of interest right now and am interested in learning more about its capabilities.

    If possible, please include me in your blog roll.

    Thanks and keep writing!

    Regards
    Karthik

  88. Rama said

    Hi Venkat,

    I am facing the problem In chart view the numerical values are getting rounded off to 2 decimal places. but in the table view the values are showing correct values.

    Is there any configuration changes we need to do?

    Thanks & Regards,
    Rams

  89. Mohamed Nadim said

    Hi Venkat.

    Your posts are really good and informative.
    I have a question though….How can I give the OBIEE dashboard users the option to change their passwords.

    Please reply.

    Thanks.

    MoN

  90. Venkatakrishnan J said

    @Mohamed – Check my blog entry here https://oraclebizint.wordpress.com/2007/10/28/oracle-bi-ee-101332-changing-passwords-from-presentation-services/

  91. Divya said

    Hi,
    My luck that I visited this informative blog..positive that i will get a quick answer to my OBIEE query 🙂

    The requirement is this.. On click of ‘print’ at the Java front end, it should invoke the corresponding OBIEE report(without opening its interface) and print the same. My doubt is :
    1) Is it possible to invoke OBIEE without user intervention i.e can OBIEE credentials be parametrised?
    2) Without opening the report, can we pass the filter values to OBIEE layer from Java front end?

    Can this be achieved? Please let me know.

    Thanks,
    Divya

  92. Venkatakrishnan J said

    Yes very much. Check my blog entry here https://oraclebizint.wordpress.com/2007/07/30/customizing-obi-ee-%e2%80%93-go-url-parameters/. You can pass filter parameters, user credentials etc via a URL.

  93. Divya said

    Hi,
    Thanks for the quick reply, Venkat. I will be requiring more information on the same. Will be a regular visitor from today onwards…

    Thanks,
    Divya

  94. Gathatharan said

    Hi Venkat
    BI scheduler service is not getting started and showing this error

    Could not start the oracle BI Scheduler Service on local computer.
    Error 1064:An Exception occured in the service when handling the control request

    could you please help me out

  95. Ashok Das said

    Hi Venkatakrishnan,

    I am using OBIEE 10.1.3.2.0 and am facing one issue in DAC. When I run any execution plan from DAC, the execution plan fails within a sec and when I checked the DAC ServerLog, it says “W_ETL_TAG – not a DAC table!!”. If you have any idea about this, can you please help me out.

    Below is the error log:
    10173 SEVERE Thu Feb 14 15:35:08 IST 2008
    ——————————————–

    START OF ETL

    ——————————————–
    10174 INFO Thu Feb 14 15:35:08 IST 2008 Creating Connection Pool.
    10175 FINE Thu Feb 14 15:35:08 IST 2008 Inside CreateConnectionPool: got a resultset of dbconnections.
    10176 FINE Thu Feb 14 15:35:08 IST 2008 Inside CreateConnectionPool: about to create pool.
    10177 INFO Thu Feb 14 15:35:08 IST 2008 Creating connection pool. : DataWarehouse
    10178 INFO Thu Feb 14 15:35:09 IST 2008 Reading password from database
    10179 INFO Thu Feb 14 15:35:09 IST 2008 1 attempt
    10180 FINE Thu Feb 14 15:35:09 IST 2008 Inside CreateConnectionPool: pool created.
    10181 FINE Thu Feb 14 15:35:09 IST 2008 Inside CreateConnectionPool: about to create pool.
    10182 INFO Thu Feb 14 15:35:09 IST 2008 Creating connection pool. : SEBL_VERT_80
    10183 INFO Thu Feb 14 15:35:09 IST 2008 Reading password from database
    10184 INFO Thu Feb 14 15:35:09 IST 2008 1 attempt
    10185 FINE Thu Feb 14 15:35:09 IST 2008 Inside CreateConnectionPool: pool created.
    10186 INFO Thu Feb 14 15:35:09 IST 2008 Connection Pool created.
    10187 INFO Thu Feb 14 15:35:09 IST 2008 Creating Server Pool.
    10188 INFO Thu Feb 14 15:35:09 IST 2008 Reading password from database
    10189 INFO Thu Feb 14 15:35:09 IST 2008 1 attempt
    10190 INFO Thu Feb 14 15:35:10 IST 2008 Server Pools created.
    10191 INFO Thu Feb 14 15:35:10 IST 2008 Returning an instance of EmailManager…
    10192 FINE Thu Feb 14 15:35:10 IST 2008 At the start of EmailManager.dispatch
    10193 WARNING Thu Feb 14 15:35:10 IST 2008 No receipients for email registered! Please register email recipients who will be informed about ETL progression.
    10194 INFO Thu Feb 14 15:35:10 IST 2008 Getting actual start timestamp for this ETL
    10195 INFO Thu Feb 14 15:35:10 IST 2008 The actual timestamp is 2008-02-14 15:35:08.901
    10196 INFO Thu Feb 14 15:35:10 IST 2008 Initializing ETL parameters.
    10197 INFO Thu Feb 14 15:35:10 IST 2008 Starting to load the tables and index information
    10198 INFO Thu Feb 14 15:35:10 IST 2008 Finished to load the tables and index information
    10199 INFO Thu Feb 14 15:35:10 IST 2008 Going to load steps to be run.
    10200 FINEST Thu Feb 14 15:35:10 IST 2008 Number of indexes cannot be greater than the number of connections or less than 1. Defaulting to 0 for ORA_11_5_10_Flatfile
    10201 FINEST Thu Feb 14 15:35:10 IST 2008 Number of indexes cannot be greater than the number of connections or less than 1. Defaulting to 0 for UNIV
    10202 FINEST Thu Feb 14 15:35:10 IST 2008 Number of indexes cannot be greater than the number of connections or less than 1. Defaulting to 0 for SEBL_VERT_80_Flatfile
    10203 FINEST Thu Feb 14 15:35:10 IST 2008 Number of indexes cannot be greater than the number of connections or less than 1. Defaulting to 0 for ORA_11_5_10_Flatfile
    10204 FINEST Thu Feb 14 15:35:10 IST 2008 Number of indexes cannot be greater than the number of connections or less than 1. Defaulting to 0 for UNIV
    10205 FINEST Thu Feb 14 15:35:10 IST 2008 Number of indexes cannot be greater than the number of connections or less than 1. Defaulting to 0 for SEBL_VERT_80_Flatfile
    10206 FINEST Thu Feb 14 15:35:10 IST 2008 Number of indexes cannot be greater than the number of connections or less than 1. Defaulting to 0 for ORA_11_5_10_Flatfile
    10207 FINEST Thu Feb 14 15:35:10 IST 2008 Number of indexes cannot be greater than the number of connections or less than 1. Defaulting to 0 for UNIV
    10208 FINEST Thu Feb 14 15:35:10 IST 2008 Number of indexes cannot be greater than the number of connections or less than 1. Defaulting to 0 for SEBL_VERT_80_Flatfile
    10209 FINE Thu Feb 14 15:35:10 IST 2008 Populating application information.
    10210 FINE Thu Feb 14 15:35:10 IST 2008 Populating all the tags for application Siebel 8.0 Vertical
    10211 SEVERE Thu Feb 14 15:35:10 IST 2008
    ANOMALY INFO::: Error while loading nodes.
    MESSAGE:::java.lang.IllegalArgumentException: W_ETL_TAG – not a DAC table!
    EXCEPTION CLASS::: com.siebel.analytics.etl.util.database.SqlParserException

    com.siebel.analytics.etl.util.database.DACSqlParser.getTable(DACSqlParser.java:479)
    com.siebel.analytics.etl.util.database.DACSqlParser.processFromClause(DACSqlParser.java:333)
    com.siebel.analytics.etl.util.database.DACSqlParser.processSelect(DACSqlParser.java:285)
    com.siebel.analytics.etl.util.database.DACSqlParser.parse(DACSqlParser.java:109)
    com.siebel.analytics.etl.util.database.DACSqlParser.parseSQL(DACSqlParser.java:58)
    com.siebel.analytics.etl.execution.Application.populateTags(Application.java:201)
    com.siebel.analytics.etl.execution.Application.init(Application.java:129)
    com.siebel.analytics.etl.execution.Application.(Application.java:109)
    com.siebel.analytics.etl.execution.ApplicationContainer.getApplication(ApplicationContainer.java:40)
    com.siebel.analytics.etl.execution.ApplicationContainer.getApplication(ApplicationContainer.java:52)
    com.siebel.analytics.etl.execution.ExecutionPlanDesigner.retrieveExecutionPlanTasks(ExecutionPlanDesigner.java:288)
    com.siebel.etl.engine.core.SessionHandler.loadNodes(SessionHandler.java:365)
    com.siebel.etl.engine.core.ETL.thisETLProcess(ETL.java:322)
    com.siebel.etl.engine.core.ETL.run(ETL.java:604)
    com.siebel.etl.engine.core.ETL.execute(ETL.java:831)
    com.siebel.etl.etlmanager.EtlExecutionManager$1.executeEtlProcess(EtlExecutionManager.java:210)
    com.siebel.etl.etlmanager.EtlExecutionManager$1.run(EtlExecutionManager.java:164)
    java.lang.Thread.run(Thread.java:595)

    ::: CAUSE :::
    MESSAGE:::W_ETL_TAG – not a DAC table!
    EXCEPTION CLASS::: java.lang.IllegalArgumentException

    com.siebel.analytics.etl.client.data.repository.OwnershipType.getValue(OwnershipType.java:48)
    com.siebel.analytics.etl.client.data.repository.TableReferenceHelper.(TableReferenceHelper.java:34)
    com.siebel.analytics.etl.util.database.DACSqlParser.getTable(DACSqlParser.java:475)
    com.siebel.analytics.etl.util.database.DACSqlParser.processFromClause(DACSqlParser.java:333)
    com.siebel.analytics.etl.util.database.DACSqlParser.processSelect(DACSqlParser.java:285)
    com.siebel.analytics.etl.util.database.DACSqlParser.parse(DACSqlParser.java:109)
    com.siebel.analytics.etl.util.database.DACSqlParser.parseSQL(DACSqlParser.java:58)
    com.siebel.analytics.etl.execution.Application.populateTags(Application.java:201)
    com.siebel.analytics.etl.execution.Application.init(Application.java:129)
    com.siebel.analytics.etl.execution.Application.(Application.java:109)
    com.siebel.analytics.etl.execution.ApplicationContainer.getApplication(ApplicationContainer.java:40)
    com.siebel.analytics.etl.execution.ApplicationContainer.getApplication(ApplicationContainer.java:52)
    com.siebel.analytics.etl.execution.ExecutionPlanDesigner.retrieveExecutionPlanTasks(ExecutionPlanDesigner.java:288)
    com.siebel.etl.engine.core.SessionHandler.loadNodes(SessionHandler.java:365)
    com.siebel.etl.engine.core.ETL.thisETLProcess(ETL.java:322)
    com.siebel.etl.engine.core.ETL.run(ETL.java:604)
    com.siebel.etl.engine.core.ETL.execute(ETL.java:831)
    com.siebel.etl.etlmanager.EtlExecutionManager$1.executeEtlProcess(EtlExecutionManager.java:210)
    com.siebel.etl.etlmanager.EtlExecutionManager$1.run(EtlExecutionManager.java:164)
    java.lang.Thread.run(Thread.java:595)

    ::: CAUSE :::
    EXCEPTION CLASS::: java.lang.NullPointerException

    com.siebel.analytics.etl.merge.RepositoryUtils.getDiffEntityBean(RepositoryUtils.java:141)
    com.siebel.analytics.etl.merge.RepositoryUtils.getOwnershipStatus(RepositoryUtils.java:175)
    com.siebel.analytics.etl.client.data.repository.OwnershipType.getValue(OwnershipType.java:44)
    com.siebel.analytics.etl.client.data.repository.TableReferenceHelper.(TableReferenceHelper.java:34)
    com.siebel.analytics.etl.util.database.DACSqlParser.getTable(DACSqlParser.java:475)
    com.siebel.analytics.etl.util.database.DACSqlParser.processFromClause(DACSqlParser.java:333)
    com.siebel.analytics.etl.util.database.DACSqlParser.processSelect(DACSqlParser.java:285)
    com.siebel.analytics.etl.util.database.DACSqlParser.parse(DACSqlParser.java:109)
    com.siebel.analytics.etl.util.database.DACSqlParser.parseSQL(DACSqlParser.java:58)
    com.siebel.analytics.etl.execution.Application.populateTags(Application.java:201)
    com.siebel.analytics.etl.execution.Application.init(Application.java:129)
    com.siebel.analytics.etl.execution.Application.(Application.java:109)
    com.siebel.analytics.etl.execution.ApplicationContainer.getApplication(ApplicationContainer.java:40)
    com.siebel.analytics.etl.execution.ApplicationContainer.getApplication(ApplicationContainer.java:52)
    com.siebel.analytics.etl.execution.ExecutionPlanDesigner.retrieveExecutionPlanTasks(ExecutionPlanDesigner.java:288)
    com.siebel.etl.engine.core.SessionHandler.loadNodes(SessionHandler.java:365)
    com.siebel.etl.engine.core.ETL.thisETLProcess(ETL.java:322)
    com.siebel.etl.engine.core.ETL.run(ETL.java:604)
    com.siebel.etl.engine.core.ETL.execute(ETL.java:831)
    com.siebel.etl.etlmanager.EtlExecutionManager$1.executeEtlProcess(EtlExecutionManager.java:210)
    com.siebel.etl.etlmanager.EtlExecutionManager$1.run(EtlExecutionManager.java:164)
    java.lang.Thread.run(Thread.java:595)
    10212 INFO Thu Feb 14 15:35:10 IST 2008

    10213 INFO Thu Feb 14 15:35:10 IST 2008 The ETL took 0 Minutes
    10214 INFO Thu Feb 14 15:35:10 IST 2008 Returning an instance of EmailManager…
    10215 FINE Thu Feb 14 15:35:10 IST 2008 At the start of EmailManager.dispatch
    10216 WARNING Thu Feb 14 15:35:10 IST 2008 No receipients for email registered! Please register email recipients who will be informed about ETL progression.
    10217 FINEST Thu Feb 14 15:35:10 IST 2008 EtlSummary columns: {}
    10218 INFO Thu Feb 14 15:35:11 IST 2008 Releasing connection pools…
    10219 INFO Thu Feb 14 15:35:11 IST 2008 Releasing the concurrency manager…
    10220 SEVERE Thu Feb 14 15:35:11 IST 2008
    ——————————————–

    END OF ETL

    ——————————————–

  96. Divya said

    Hi,
    I am adding further to my query above (No. 91).

    Your suggested blog entry gave an idea that we can pass user credentials and filters through URL. However, the requirement doesnt end there. The report data should be passed from OBIEE directly to the printer without user ever seeing the Answers. He would be introduced just to the Java front end where conditions can be entered and there would be a print option. Firing a printout should invoke corresponding report in Answers(which user isnt introduced to) and then report print out is obtained.

    Is this possible? If yes, please suggest how.

    Regards,
    Divya

  97. Diego Anderiz said

    Hello all,

    I have a result set from a request in Oracle BI EE Answers which uses a fact table that contains variable readings (from a gauge) and variable names from a dimensions table that I want to display in a pivot table.

    On the pivot table I have a Timestamp fact as Rows and a dimension Variable Name on the columns. The Variable Reading (from the fact table) I insert into the measures.

    When I run this report, the Variable Measures appear blank in my pivot.

    That is strange as when I display in a standard table in Answers I have fully populated rows with A number of Variable Name values, thousands of Variable Reading values and corresponding Timestamp values when they were taken.

    Basically we need for each Variable Name (columns) we want to have the Variable Readings values against the Timetstamp (rows) when they were taken. No complexity here, no aggregations, sums, averages required.

    Can somebody help please?
    Thank you

  98. Manohar said

    Hello Venkat,

    We have a strange problem in our dashboards. Whenever users are selecting a value having special character from the prompt the answers are coming as no results.
    Whereas the backend table has the records.

    Is there any special setting or configuration needs to be done to support special characters in OBI.

    Thanks,
    Manohar

  99. V Murali said

    Hi Venkat,

    We are not able to see/apply the OBI Dashboard

    “Read” permission.
    We are our using OBIEE 10.1.3.3
    We are getting following permission only
    No Access->Travese folder->change/delete->Full

    Control

    Can u suggest how to get “Read” permission

    Thanks
    Murali

  100. Vishy said

    Hi,

    We have a requirement where we need to enable Sort By and Total By on dashboard for a particular report such that All Columns are listed under Sort By and Total By and when either of them chosen, it performs the necessary operations. Sort By can be enabled for Tables in the Table Options but is there a way how we can enable similar feature for Total By such that reports get totaled by Selected Column?

    Appreciate any assistance on this.

    Regards,
    Biswa

  101. Vijay Kumar. Ramagiri said

    Hi Venkat,

    I need your help. We have a requirement i.e. weekly report. If we open any day in the week it will show previous week monday to sat day information only. my date feild is in text format. so please send required SQL quiry for this situation.

    Regards,
    Vijay.Ramagiri

  102. Antimbala said

    Hi,

    I just want to know that how to implement local languages in Austria(lang-Austria -German DEA), Belux(lang English-Belux ENB), Greece(lang-ELL) etc.. others are supported by Oracle. how to go about these.

    A quick reply will be really helpful..

    thanks in advance.

  103. Antimbala said

    Hi,

    I have another query regarding exporting captions:
    1) Can we do for all folders at once. i didn’t find any such option.
    2) When we export for each folder then we get chunk of XML files for each catalog.Our requirement is to convert all the catalog folders to different languages so we need to send these XMl files to the translators to do the translations. actually we need to send so many files that will be hassle for the translator and again if we missed any then it would be a problem . Can you suggest some simple way to do the same.

    waiting for your reply.
    Thanks in advance.

  104. V Murali said

    Venkat,

    how to pass nqusers and nqpassword value as a variable in Dashboard Text object.

    Thanks,
    Murali

  105. Helen said

    Hi Venkatakrishnan,
    please help me with this issue:
    how can i create multisheet excel output for a report?

    Thanks a lot!
    Helen

  106. Gaurav Nankar said

    Hi Venkat,

    I m facing a problem with the Job Manager which does not open. I have tried re-installing the whole application but of no use.

    Regards,
    Gaurav

  107. Anoop said

    Venkat,

    Am trying to retrict my dashboard wiht the respect to the company and user. I want to restict only those companies for a particular user. I also want to hide certain coloumns for certain user.

    Kindly advice
    Anoop

  108. Venkatakrishnan J said

    @Helen – There is no out of the box way to do that. I have blogged about it earlier here https://oraclebizint.wordpress.com/2008/02/07/oracle-bi-ee-101332-combining-multiple-excel-report-outputsworkbooks-to-a-single-excel-report-using-bi-delivers-bi-publisher-apis-and-vb-scripts/

    @Gaurav – Do you get any specific error? Can you try starting it up from command line?

    @Anoop – You need to assign privileges in your dashboard that way. Also, you can use GROUP level security or VPD to give column level access to different users.

  109. Gaurav Nankar said

    Hi Venkat,

    Yes, I hav etried through the command line also.It does not throw any error. But the Job Manager Window does not appear. When I checked the log file at OracleBIData\jobmanager it shows the following message:

    !SESSION 2008-02-28 14:16:04.115 ———————————————–
    eclipse.buildId=I20050627-1435
    java.version=1.4.2
    java.vendor=Sun Microsystems Inc.
    BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US
    Command-line arguments: -data D:\OracleBIData\jobmanager

    !ENTRY org.eclipse.osgi 2008-02-28 14:16:05.147
    !MESSAGE An error occurred while automatically activating bundle oracle.bi.jobmanager (5).
    !STACK 0
    org.osgi.framework.BundleException: The activator oracle.bi.jobmanager.JobmanagerPlugin for bundle oracle.bi.jobmanager is invalid
    at org.eclipse.osgi.framework.internal.core.AbstractBundle.loadBundleActivator(AbstractBundle.java:149)
    at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:965)
    at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:316)
    at org.eclipse.osgi.framework.internal.core.AbstractBundle.start(AbstractBundle.java:264)
    at org.eclipse.core.runtime.adaptor.EclipseClassLoader.findLocalClass(EclipseClassLoader.java:116)
    at org.eclipse.osgi.framework.internal.core.BundleLoader.findLocalClass(BundleLoader.java:337)
    at org.eclipse.osgi.framework.internal.core.SingleSourcePackage.loadClass(SingleSourcePackage.java:37)
    at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:386)
    at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:350)
    at org.eclipse.osgi.framework.adaptor.core.AbstractClassLoader.loadClass(AbstractClassLoader.java:78)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at org.eclipse.osgi.framework.internal.core.BundleLoader.loadClass(BundleLoader.java:275)
    at org.eclipse.osgi.framework.internal.core.BundleHost.loadClass(BundleHost.java:227)
    at org.eclipse.osgi.framework.internal.core.AbstractBundle.loadClass(AbstractBundle.java:1248)
    at org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:152)
    at org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:142)
    at org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:129)
    at org.eclipse.core.internal.registry.ConfigurationElementHandle.createExecutableExtension(ConfigurationElementHandle.java:48)
    at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:222)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:163)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.eclipse.core.launcher.Main.invokeFramework(Main.java:334)
    at org.eclipse.core.launcher.Main.basicRun(Main.java:278)
    at org.eclipse.core.launcher.Main.run(Main.java:973)
    at org.eclipse.core.launcher.Main.main(Main.java:948)
    Caused by: java.lang.UnsupportedClassVersionError: oracle/bi/jobmanager/JobmanagerPlugin (Unsupported major.minor version 49.0)
    at java.lang.ClassLoader.defineClass0(Native Method)
    at java.lang.ClassLoader.defineClass(Unknown Source)
    at org.eclipse.osgi.framework.adaptor.core.DefaultClassLoader.defineClass(DefaultClassLoader.java:370)
    at org.eclipse.core.runtime.adaptor.EclipseClassLoader.defineClass(EclipseClassLoader.java:233)
    at org.eclipse.osgi.framework.adaptor.core.DefaultClassLoader.findClassImpl(DefaultClassLoader.java:343)
    at org.eclipse.osgi.framework.adaptor.core.DefaultClassLoader.findClass(DefaultClassLoader.java:235)
    at org.eclipse.osgi.framework.adaptor.core.AbstractClassLoader.findLocalClass(AbstractClassLoader.java:183)
    at org.eclipse.core.runtime.adaptor.EclipseClassLoader.basicFindLocalClass(EclipseClassLoader.java:141)
    at org.eclipse.core.runtime.adaptor.EclipseClassLoader.findLocalClass(EclipseClassLoader.java:82)
    at org.eclipse.osgi.framework.internal.core.BundleLoader.findLocalClass(BundleLoader.java:337)
    at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:389)
    at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:350)
    at org.eclipse.osgi.framework.adaptor.core.AbstractClassLoader.loadClass(AbstractClassLoader.java:78)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at org.eclipse.osgi.framework.internal.core.BundleLoader.loadClass(BundleLoader.java:275)
    at org.eclipse.osgi.framework.internal.core.BundleHost.loadClass(BundleHost.java:227)
    at org.eclipse.osgi.framework.internal.core.AbstractBundle.loadBundleActivator(AbstractBundle.java:142)
    … 28 more
    Root exception:
    java.lang.UnsupportedClassVersionError: oracle/bi/jobmanager/JobmanagerPlugin (Unsupported major.minor version 49.0)
    at java.lang.ClassLoader.defineClass0(Native Method)
    at java.lang.ClassLoader.defineClass(Unknown Source)
    at org.eclipse.osgi.framework.adaptor.core.DefaultClassLoader.defineClass(DefaultClassLoader.java:370)
    at org.eclipse.core.runtime.adaptor.EclipseClassLoader.defineClass(EclipseClassLoader.java:233)
    at org.eclipse.osgi.framework.adaptor.core.DefaultClassLoader.findClassImpl(DefaultClassLoader.java:343)
    at org.eclipse.osgi.framework.adaptor.core.DefaultClassLoader.findClass(DefaultClassLoader.java:235)
    at org.eclipse.osgi.framework.adaptor.core.AbstractClassLoader.findLocalClass(AbstractClassLoader.java:183)
    at org.eclipse.core.runtime.adaptor.EclipseClassLoader.basicFindLocalClass(EclipseClassLoader.java:141)
    at org.eclipse.core.runtime.adaptor.EclipseClassLoader.findLocalClass(EclipseClassLoader.java:82)
    at org.eclipse.osgi.framework.internal.core.BundleLoader.findLocalClass(BundleLoader.java:337)
    at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:389)
    at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:350)
    at org.eclipse.osgi.framework.adaptor.core.AbstractClassLoader.loadClass(AbstractClassLoader.java:78)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at org.eclipse.osgi.framework.internal.core.BundleLoader.loadClass(BundleLoader.java:275)
    at org.eclipse.osgi.framework.internal.core.BundleHost.loadClass(BundleHost.java:227)
    at org.eclipse.osgi.framework.internal.core.AbstractBundle.loadBundleActivator(AbstractBundle.java:142)
    at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:965)
    at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:316)
    at org.eclipse.osgi.framework.internal.core.AbstractBundle.start(AbstractBundle.java:264)
    at org.eclipse.core.runtime.adaptor.EclipseClassLoader.findLocalClass(EclipseClassLoader.java:116)
    at org.eclipse.osgi.framework.internal.core.BundleLoader.findLocalClass(BundleLoader.java:337)
    at org.eclipse.osgi.framework.internal.core.SingleSourcePackage.loadClass(SingleSourcePackage.java:37)
    at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:386)
    at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:350)
    at org.eclipse.osgi.framework.adaptor.core.AbstractClassLoader.loadClass(AbstractClassLoader.java:78)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at org.eclipse.osgi.framework.internal.core.BundleLoader.loadClass(BundleLoader.java:275)
    at org.eclipse.osgi.framework.internal.core.BundleHost.loadClass(BundleHost.java:227)
    at org.eclipse.osgi.framework.internal.core.AbstractBundle.loadClass(AbstractBundle.java:1248)
    at org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:152)
    at org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:142)
    at org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:129)
    at org.eclipse.core.internal.registry.ConfigurationElementHandle.createExecutableExtension(ConfigurationElementHandle.java:48)
    at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:222)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:163)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.eclipse.core.launcher.Main.invokeFramework(Main.java:334)
    at org.eclipse.core.launcher.Main.basicRun(Main.java:278)
    at org.eclipse.core.launcher.Main.run(Main.java:973)
    at org.eclipse.core.launcher.Main.main(Main.java:948)

    !ENTRY org.eclipse.osgi 2008-02-28 14:16:05.163
    !MESSAGE Application error
    !STACK 1
    org.eclipse.core.runtime.CoreException[1]: java.lang.UnsupportedClassVersionError: oracle/bi/jobmanager/rcp/Application (Unsupported major.minor version 49.0)
    at java.lang.ClassLoader.defineClass0(Native Method)
    at java.lang.ClassLoader.defineClass(Unknown Source)
    at org.eclipse.osgi.framework.adaptor.core.DefaultClassLoader.defineClass(DefaultClassLoader.java:370)
    at org.eclipse.core.runtime.adaptor.EclipseClassLoader.defineClass(EclipseClassLoader.java:233)
    at org.eclipse.osgi.framework.adaptor.core.DefaultClassLoader.findClassImpl(DefaultClassLoader.java:343)
    at org.eclipse.osgi.framework.adaptor.core.DefaultClassLoader.findClass(DefaultClassLoader.java:235)
    at org.eclipse.osgi.framework.adaptor.core.AbstractClassLoader.findLocalClass(AbstractClassLoader.java:183)
    at org.eclipse.core.runtime.adaptor.EclipseClassLoader.basicFindLocalClass(EclipseClassLoader.java:141)
    at org.eclipse.core.runtime.adaptor.EclipseClassLoader.findLocalClass(EclipseClassLoader.java:122)
    at org.eclipse.osgi.framework.internal.core.BundleLoader.findLocalClass(BundleLoader.java:337)
    at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:389)
    at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:350)
    at org.eclipse.osgi.framework.adaptor.core.AbstractClassLoader.loadClass(AbstractClassLoader.java:78)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at org.eclipse.osgi.framework.internal.core.BundleLoader.loadClass(BundleLoader.java:275)
    at org.eclipse.osgi.framework.internal.core.BundleHost.loadClass(BundleHost.java:227)
    at org.eclipse.osgi.framework.internal.core.AbstractBundle.loadClass(AbstractBundle.java:1248)
    at org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:152)
    at org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:142)
    at org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:129)
    at org.eclipse.core.internal.registry.ConfigurationElementHandle.createExecutableExtension(ConfigurationElementHandle.java:48)
    at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:222)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:163)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.eclipse.core.launcher.Main.invokeFramework(Main.java:334)
    at org.eclipse.core.launcher.Main.basicRun(Main.java:278)
    at org.eclipse.core.launcher.Main.run(Main.java:973)
    at org.eclipse.core.launcher.Main.main(Main.java:948)

    Regards,
    Gaurav

  110. Parag said

    Hi Venkat,

    I have gone through your blog on the topic of rendering OBI reports in to the oracle portal using OC4J WSRP Container.

    I could successfully replicate first two steps and after that the WebService URL from the container is also perfectly working –

    http://10.10.4.182/biee/portlets?WSDL

    Now – in third step while registering the WSRP provider after copying above path in my Jdev – its not able to recognize the WSDL at this path .. Inspite of giving proper proxy settings 😦

    I am not supposed to use a diff path than the one above for registering my producer , isn’t it ??

    Please let me know whether I have missed something ..

    TIA.

    Parag Naik

  111. Debanjan De said

    Hi Venkat,

    I found your blog very informative and helpful. Recently we are facing some issues in our BI Publisher 10.1.3.3.1 installation. Initially we were not able to connect BI Analytics with BI Publisher. Hence we modified different setup files several times. And now we are getting the below error while logging into BI Publisher –

    The server can not be used due to a configuration error, please contact the administrator. If you are the administrator, please consult BI Publisher user guide for proper configuration.

    oracle.apps.xdo.servlet.resources.ResourceNotFoundException: /u01/BIEE/xmlp/XMLP/Users/~administrator/Learn/Admin/Security/principals.xml

    We took back all the setup files which we modified (xmlp-server-config.xml, security.xml, principals.xml) to the initial form. But still we are unable to fix the above error.

    These are the current file contents are –

    xmlp-server-config.xml
    ======================

    security.xml
    ============

    principals.xml
    ==============

    /u01/BIEE/xmlp/XMLP/Admin/Security> cat principals.xml

    Regards,

    Debanjan

  112. Debanjan De said

    Venkat,

    It seems due to some problem, the file contents were not shown properly in my last message.

    Here are the files –

    xmlp-server-config.xml
    ======================

    principals.xml
    ==============

    security.xml
    ============

  113. rodney weinstein said

    Is there a way to run an iBot or a briefing book get now action from the command prompt or a utility?

    We have a data load in scripts and want to tack onto the end of them the execution of an iBot or the running of the function that creates and compiles the brifing book.

    Thanks.

    Rodney

  114. Madan said

    Is there any way we can implement Business Object Touch File concept in BIEE. In BO, report scheduling is done based on these files. the process is Once ETL is done, ETL Process creates a touch file, BO scheduling look for file, If file is avilable then they are going to run the reports. Is there any way BI Ibots can look for a file in physical/network folders and then executes?

  115. Avik said

    I have been following your blog for some time now. The solutions that you provide are fabulous. I have been helped greatly by them.
    Now I would like your favor in helping me out in creating a case-insensitive multi select prompt in Oracle BI-EE. It would be great if you could provide a solution, especially if it modifies the already defined JavaScript in {OracleBI} oc4j_bi\j2eehome\applications\analytics\analytics\res\b_mozilla\prompts (i.e. like by modifying the onKeypress event of the text box in the multi select box. Or by converting the text inside the text box of the multi select prompt into UPPER CASE before firing the query to database to fetch the possible set of values in the multi select box) using the for the multi select prompts. Since my report is already very loaded and are pretty slow. Any other solution should also be fine.
    It is pretty urgent, so it would be very good, if you could provide me a solution as soon as possible.

  116. V Murali said

    Hi Venkat,

    We need find option in OBI at report level.
    Current on click of all pages option which downloads entire data into single page then go for Ctrl+F and pass the finding value.

    Which is impacting our report because in our reports data is huge i.e. more than 2million.

    Could you please suggest us how create search option in report level where user can able to find desired data/information.

    Thanks in advance

    Regards,
    Murali

  117. lakshmi said

    Hi Venkat,

    we have faced problems with DAC….we have 350 tasks are there..all tasks are completed when we run complete ETL but 4 tasks still in queue…there is no running tasks…can u tell me what is the problem….ASAP. i need your’s valuable suggestions.

  118. lakshmi said

    Hello Venkat,

    I am Lakshmi, i need your help with your valuablesuggestions…how to run the DAC Server in Globally…how many methods are the for RUN the DAC Server…pls let me know your valuable suggestions….it’s very urgent….pls any one help me….regarding this issue.

    Thanks
    Lakshmi.

  119. lakshmi said

    Hello Venkat,

    we are using Siebel Analytics 7.8.4 version… i need your information….for DAC what are the drawbacks are there in Siebel Analytics 7.8.4 varsion…
    pls any one help me……is there any problems for DAC in 7.8.4.

    Thanks
    Your’s Lakshmi.

  120. Sonal said

    I have created a new repository with Physical , Business and Presentation Layer. The presentation Catalog name is ‘HR’. I made the business model ‘ Available for queries’ in business model. I also restarted the Presentation and BI Server services. When i login into Answers then I see the Subject Area ‘HR’ but i don’t see the tables which i see in presentation layer.
    Please help. Do I need to do some settings ?

  121. V Murali said

    Venkat,

    I want to put Dashboard prompt link under a folder,which is my customer looking for.

    Please let me is it possible or not.If possible please let me know the process.

    Thanks in advance.

    Regards,
    Murali

  122. Jeoneence said

    I’d prefer reading in my native language, because my knowledge of your languange is no so well.

  123. Raj said

    Venkat,
    I have two questions.
    1> is it possible to put a iBOT link on the dashboard page, so that i can schedule it rightaway?
    2> I read your blog about implementing multilanguage using externalize string utility in RPD. I still have one doubt. how to implement for multiple language like french, protugese,Espanol etc together based on user selected language?

  124. Dan said

    Hi Venkat,

    My client recently upgrated from 7.8.4 to 10.1.3.3 and they liked the old default colors in the charts much better (more contrast). I saw your blog about using Firebug (which is absolutely awesome by the way), but it hasn’t helped me locate where to change to default colors of charts in the .css files. When I use ‘Inspect’ it highlights the entire chart instead of each bar/piece of pie/etc. Do you know an easy way to locate where this change should be made?

    Thanks in advance,
    Dan

  125. Kiran said

    Hi Venkat,

    I need to connect to OBI presentation server through IE .
    I have done Impersonation in RPD & created user Impersonator by using help as given in OBI deployment guide. I have configured IIS accordingly.
    The basic need for the task is that I want ‘Single Sign On’ on BI presentation server.

    I have configured credentialstore & instanceconfig xml files using deployment guide help.
    So whenever I try to connect through URL ( http:\\localhost\analytics\saw.dll?encryptString&string= ) I get error as per following:
    Unable to contact server.

    An encrypted password was found in the credential ‘impersonation’, but no decryption passphrase has been specified. Please ensure that a decryption passphrase is specified in configuration. See documentation for details on how to configure the credential store.
    Error Codes: WUDC2HWW

    So any help is appreciated.
    Thanks in advance.

  126. keerthi said

    Hi!
    I came across this blog when I was browsing for some help to login to BI publisher, & found interesting solutions for many questions.

    Recently, I downloaded BI publisher desktop on to my laptop to practice as it was going to be started at my work place. When I installed it I could see the BI Publisher icon on Microsoft applications, but when i tried to login, it asks for user name & password which the administrator has assigned. Can we practice on BI Publisher on a PC.
    I would really appreciate if your help.

    Thanks

  127. Hassan said

    Hi Venkat,

    I have made a repository in Administration tool following exactly the same steps which are mentioned in Oracle Tutorial for OBI. I could import and use the sample of Oracle and make Analytics on them. However when I make my own physical, business model and presentation layer based on my own database, I could not start BI server. The server works well for Oracle SH.rpd but when I change Star value in NQSconfig.ini to my own repository (Caesar) I get error 1064 and BI server does not start at all. What am I doing wrong?

    Star = sh.rpd, DEFAULT;
    # Star = Caesar.rpd, DEFAULT;

    Regards,
    Hassan

  128. David said

    Hello Venkatakrishnan, Thanks for your blog. It is very helpful. I am new to obiee and have a challenging task to figure out things by myself. Here is my question:
    Assuming, I have 3 customers and each one is a member of a different group. I want to give these 3 customers permission to create new users. Here is the catch. For the security reasons, each of these customers can create users only in his own group and can not see the data for other groups. So, if my customer is a GE manager, he can only create users who belong to GE group and can not see the users in other companies.
    thx
    David

  129. Sankar said

    Hi Venkat,

    I have installed MS Office plugin sucessfully, i go the Oracle BI tab in Excel & Powerpoint when i try to login it is throwing “Unknown Error”. When i try “Test Connection” it is saying connection sucessful.

    Please let me know the solution for this as soon as possbile.

    Thanks,

    Regards,
    Sankar

  130. Vijay Kumar Ramagiri said

    Hi Venkatakrishnan,
    Your site is extremely helpful and I really appreciate all the great information.

    I need your help. When i am download my dashboard report into excel, i am not get the images in excel sheet.

  131. sravan kumar said

    In graphs the values are rounded off to 2 decimals .For example if the value is 99.99456 in graph it is showing as 100.I want to show the exact value in graph.Thanks in advance

  132. Srini said

    Venkat,
    You are doing an awesome job..
    I am trying to change the skin dynamically using the variable SKIN. On the dashboard home page, is there gif/jpg that is available in ’sk’ folder that i can edit and add some customized text? Most of the things in that page are in ’s’ style folders…Once again, you rock man !!!!
    Thanks,
    Srini

  133. John T. said

    Have you ever addressed how to use the Combined Results feature (i.e. union)?
    Also, I’m trying to produce a financial account report where some of the expense categories have no fact rows associated with them but yet I would like to show thos expense categories anyway and with zeroes for the amount.
    Thanks

  134. Joe said

    Hi Venkat,

    when i am running multi tasks parallely. my presentation services are going down.
    For Ex: I am generating 4 list files at a shot. Then presentation server is going down.
    PLease suggest me if any chnages required in any files.

    Thanks in Advance,
    Joe

  135. Vijaylaxmi said

    Hi,

    Thanks a lot for publishing such useful info in this Blog.. Its really helpful.

  136. Srukmana said

    Hello,

    I have installed the MS offcie plug in and every thing works fine. But when I try to open a report in power point which actually has prompts in OBIEE, a window pops up prompting to “insert views”. But when I check the values in the “insert view” window its not asking for any prompts and its display the report. But as per the help doc it sholud display the prompts and I should be able to select the values from it. I am not sure if I missed something while installing the BI Office plug in. Can any one help me with this.

    Thanks.

  137. Raso said

    Can you please let me know where to setup link for download.
    Same report in Answer will show links for
    Modify – Refresh – Print – Download – Add to Briefing Book – Copy
    but same report in Dashboard has only options
    Print and Add to Briefing Book

    What happend with other options.

  138. Rafael Marques said

    Hi!

    Dou you know any way to show (in Java) parent first?
    I’ve been searching the web about that but no success 😦
    Like a simple retrieve <IChild MbrName shows me:
    Chil1
    Chil2
    Chil3
    Chil4
    Parent

    I’d like to show like this:
    Parent
    Chil1
    Chil2
    Chil3
    Chil4

    Is that possible?

    Thanks in advance!

  139. Srikanth said

    “Raso Says:
    May 2, 2008 at 10:56 pm
    Can you please let me know where to setup link for download.
    Same report in Answer will show links……..”

    On the dashboard click on the page options>>edit dashboard, in the edit mode click on the properties>> Report link.
    Under the report links you will find all the links which you want to display on the dashboard.

  140. Manas said

    Venkat,
    I’m need to merge webcat files with different user settings in Dev and Prod. Is there a way we can do it?

    Thanks,
    Manas

  141. newdb said

    Hi,
    I am trying to use Java SSO with OBIEE Analytics Application. I want to know if I have to install Oracle AS for this and not implement SSO with standalone oc4j. I have tried configuring the instanceconfig.xml/credentialstore.xml files with no success. Is there any way I could ORA_OC4J_SSO to extract the login information?
    Thanks,
    Sirisha.

  142. siva said

    Hi Venkat
    I have a problem with creating time siries to compare the current year resluts with previous results.
    But how can i acheive this to come more than one year. Can you pls help me in this regard

    Thanks & Regards
    Siva

  143. Aniket said

    Hi,

    I have a report that navigates to another report based on a column named Business Unit. The report it navigates to has multiple Item codes for the selected Business Unit.
    This process works fine. What I am trying to achieve is this navigation should work only if there are Item codes for a business unit. Can I restrict the navigation link only for the Business Units that have Item codes in another report.

    Any suggestion would be highly appreciated.

    Regards,

    Aniket

  144. Hi Venkat,

    I am proposing OBIEE SOAP integration to a client of mine, but we have been receiving some static on it saying that he OBIEE soap integration is not stable, the better choice would be to go with BI Publisher.

    Using the GO_URL would be simpler but will not provide the users with the same look and feel they currently have including the choice of columns to be added to a predefind report format.

    The client needs to replace an existing application where they are using Actuate with its Flexible Framework. They currently allow they users to choose from a menu of report templates and report formats along with providing a choice of columns that can be included in the report. The reports are then run and automatically saved in pdf format. These saved reports are archived and can be viewed at a future time.

    I beleive the same can be acheived using SOAP calls to OBIEE. What are your thoughts.

    Thanks

    Boyd

  145. Aravind said

    Hi Venkat,

    It is simply great and informative blog. You are doing an awesome job venkat.

    I need to know how Portal and OBI integration will take place by using GO URl parameter.
    Could you please help in this regards

    Thanks
    Aravind

  146. Vijay said

    We have populated data into ware house tables using DAC for entities ORDERS, CONTACTS, ASSET, ACCOUNT, QUOTES, OPPORTUNITY AND VEHICLES.

    Now we want to view this data into Automotive pre-built reports and dashboards. So how can we customize the vanilla repository (OracleBIAnalyticsApps.rpd) for Automotive in order to view the data in the pre-built reports?

    I’m able to query for the data using answers with the results. Also in presentation layer, I’m unable to see the standard pre-built dashboards links.

    Can you please make me understand as to how to implement the further process to reflect the data only into pre-built AUTOMOTIVE dashboard.

    Best regards
    Vj

  147. Mais said

    Hi Venkat,

    We are facing a problem when BI users change their password, belwo is an overview of the problem:

    •We have enabled the Users to change their passwords.

    •When a User tries to change the password by clicking on change password link, it produces an error message (‘… … the repository is locked’), even though the password change works correctly (This function works only once per user per BI server restart).

    •The same error message appears for every subsequent Password change attempt but the system fails to change the password.

    By looking into the log files, below are the findings:

    •Change password function works fine for the first time a user tries, even though an error message is displayed.

    •The RPD meta-data log file gets changed when a password is changed, but the RPD itself doesn’t reflect the changes till a server restart is performed.

    •OBIEE locks the RPD file whenever there’s a RPD meta-data log file change resulting in a session lock. Each subsequent attempts to change the password results in a system error ( “…….Repository is locked”) due to this lock and multiple sessions are created for the same user with every attempt.

    •The RPD Meta-data log file changes are reflected on to the RPD, the sessions are killed and the lock is released up on restarting the BI server.

    Questions:

    1.Why does the error message come even if the user is able to change the password (first time per user per server restart)?

    2.Is there a way to push the meta-data log file changes to RPD without restarting the BI server?

    Thanks in advance!

    Kind Regards,
    Mais

  148. mayur said

    Hi Venkat,

    I got a requirement like this, I need to display the row values into one column field.
    For eg: There are two columns A and B
    A B
    xxxxx 12
    xxxxx 123.f
    ppp

  149. Gopal said

    Hi Venkat

    Sorry i couldn’t complete the scenario.
    For eg:
    Column A Column B
    pppp xx.1
    pppp cc.0
    aa dd
    aa qq.2

    I want the repot like the below

    Column A ColumnB
    pppp xx.1, cc.0
    aa dd,qq.2

    Thanks in Advance.
    Gopal

  150. Corinne Chaumont said

    This is in regard of the posting https://oraclebizint.wordpress.com/2007/09/25/oracle-bi-ee-10133-and-mapviewer-step-by-step-integration-phase1/

    I provided this link to an OBIEE Customer and they found it very helpful.

    However, it is mentioned that there needs to be an oracle spatial database to have the integration between Oracle Map and OBIEE. In this scenario we would like to ask you whether this integration is possible in Disconnected mode as well. In disconnected mode we have an SQL Anywhere database. So how to manage this integration in disconnected mode?

  151. ajay said

    hi venkat ,

    my scenario is i have i have created a presentation variable , CALYEAR (name of variable)

    whatever i type in prompt box is stored as CALYEAR

    i have 2 reports having 3 cloumns
    first report
    has YEAR ,ON PEAK SALES,OFFPEAK SALES
    second report has
    YEAR,ONPEAK WATTS,OFFPEAKWATTS,

    i have 2 sections placed in same page

    requirement is

    if i type 2009 in prompt box (there is only one prompt box in this case)

    the top table should show years less than 2009 (in this case it should show 2002,2003………2008)

    the bottom table should show 2009 and above that year (in this case 2009,2010 ………)

    how to do it i tried to filter by using presentation variable , it didnt work ,

    PLEASE GUIDE ME asap

    thanks

    ajay

  152. louis said

    i have a question about external authentication, so if i used external table or ldap authentication,i can success login
    but i don’t know how to grant authority,whether i must import user/group into RPD from ldap server or external database?
    if not ,i want to know how to do it

  153. Sanjeet said

    Hi Venkat,

    I have a problem in Dashboard. Can you tell me how to hide (ie. through Guided Navigation feature) a section which has only prompt in it and no requests.
    As far as i know, we can hide a section which contains requests in it and not prompts. If there is way out then please do let me know. I would be really thankful to you.

    Regards:
    Sanjeet.

  154. Anoop said

    Hi Venkat,

    I am facing a problem in a particular scenario when am using a column selector and filter on the column selector columns. I just used simple “and conditions” on the columns, but it does not work as i expect. When a select a particular column from the column selector the filter should apply only for that column. Is that possible? Kindly advice.

    Regards,
    Anoop

  155. Sandeep said

    Hi Venkat,

    I need some modelling help in configuring a bridge table. We are on OBIEE 10.1.0.3.
    I have a requirement to bring some MGVs(activity participants) over to analytics. The Emp

    table contains the information on all employees involved for a given activity. Till now, we

    were only bring in the one named “Primary Partcipant” though there were multiple persons

    associated with the activity. Now we want to see all the persons on a given activity. I am

    trying to use a bridge table for the purpose.

    Existing rltnship : DIM1(W_EMPLOYEE_D) –> FACT1(W_ACTIVITY_F)

    To Be : DIM1(W_EMPLOYEE_D) –> BRIDGE(WC_ACT_EMP_H) –> FACT1(W_ACTIVITY_F)

    This bridge table needs to be setup to connect the Emp Dim to Activity Fact to get the

    multiple employees associated with a given activity. Here is what i have done :

    a> Added the table in physical layer.

    b> Established a join with EMp and ACT fact tables.

    c> Created a new table in BMM for the bridge table checked the option for “Bridge Table”.

    d> Established the complex join with EMP dim and ACT fact.

    Now my question is do I need to create a “New Dimension” for this bridge table just like for

    the EMP table ? If so what would be the levels of the dim hierarchy? Ans what level should I

    need to set the LTS of Fact table (W_ACTIVITY_F) for this new dimension. Do I need to do

    anything else in BMM to get it working?

    I know this is a common requirement, your suggestions are greatly appreciated.

    thanks in advance,
    Sandeep.

  156. Nate said

    Hi Venkat –

    Great information on your blog! Thanks for starting it. I have a question which I could not find an answer to thus far, however.

    I’m working with Siebel Analytics 7.8.5 administration tool. Using the Repository Import Wizard, I want to import a new subject area (presentation catalog) into production from test but it seems that some of the objects in my BMM and Physical layer are not being brought over. I believe that’s because they don’t directly have an object in the Presentation Catalog that they link to.

    Is there a way in 7.8.5 to bring over the entire BMM and Physical layer folders? It seems one can only bring over Presentation folders and direct dependents.

    Any help or pointers in the right direction are much appreciated. Thanks in advance!

    Nate

  157. Nate said

    I’ll post a follow-up to my own question (#156). I tried the Import Wizard again (and again and again) and it worked better. It successfully imported the BMM and Physical Layers, with only a few presentation folders left out. I’m still not 100% satisfied that I know what’s going on, because I think I’ve seen this “issue” before. So if you have any thoughts still, I’d appreciate them.

    Thanks.

  158. Nir said

    hello vekant 🙂
    i made a comment on one of the articles. can you please in your free time try to answer it ? 🙂
    thanks 🙂

    I commented here :

  159. Nir said

    Hi Venkat
    I made a comment on one of the articles. can you please in your free time try to answer it ? 🙂
    thanks 🙂

    I commented here:

    https://oraclebizint.wordpress.com/2007/11/12/oracle-bi-ee-101332-working-with-clob-fields/

    (sorry for the double post, you can delete the previous one)

  160. mel said

    I am interested in putting a US Maps on Dashboard. I already have drill in functionality based on the states. I see the US Maps img file on C:\OracleBI\web\app\res\s_oracle10\maps.

    How to call the map image in Dashborad and have drill in functionality on the states.

    Thanks

  161. sumeet said

    Hi All,

    Need some clarification on Ibot. We have a ibot set up which uses
    a a direct database physcial query. The problem we are facing is the
    users that are getting the Ibot are getting the following error

    View Display Error

    Error generating view. You don’t currently have the necessary
    privileges to execute Direct Database Requests.
    Error Details
    Error Codes: OAMP2OPY:Q4NU7XSN
    File: ./project/webbedrock/handle.cpp, Line: 17
    Invalid Handle Of ‘class NQWebView *’ Exception

    Not sure why this is happeneing. Do we have to give them super user
    access for this error to be solved , since its a physical query and
    not a direct answer created report. Also the version we are using is
    7.8. Any help will be appreciated.

    Thanks

    Sumeet

  162. vishnu said

    I have installed the OBIEE 10.3.3.1 in my machine. I found that the ‘Schedule and History links’ in BI Publisher is appearing but in ‘disabled’ mode. What is the way to make it enabled?

    Thanks,
    Vishnu

  163. Ed said

    I am fairly new to OBIEE and I am trying to create a new folder and report but I cannot seem to find the Create a New Folder link that is described in the Publisher tutorial on Oracle’s Technology Network site.

  164. Srinivas Naidu said

    Hi Venkat,

    Please can u help me on this issue.

    How to Change Drill down path dynamically as per user group.

    Ex :hierarchy of a->b->c->d, and one user group
    does not want b to be in the path, then how can i hide the b column from the
    presentation layer using Object security or Data level security’s in the RPD. Please let me know any solutions for this.

    Thanks
    Srini

  165. Sarita said

    Hi Venkat,

    I am trying to run Hyperion WebAnalysis(ver 9.0) through Vmware. It was working fine , till last run , wherin it gave an issue for java package.
    The exception was thrown while connecting it to DB server.
    The exact error message read “java.lang.NoClassDefFoundError”

    Can you please let know solution to this error asap?

  166. Sunil Epari said

    Hi Venkat,

    I am working on a solution dealing with dashboard Prompts:
    Some of them as per requirements cannot be displayed on the dashboard, but they are evaluated based on other prompts values.

    Requirement is:

    Prompt1 Prompt2 Prompt3 Prompt4

    Prompt2 is based on Prompt1
    Prompt3 is based Prompt2 , but this prompt cannot be displayed
    Prompt4 is based on Prompt3

    Appreciate if you can direct or provide some guidance on this

    Thanks
    Sunil Epari

  167. Sheela said

    Hi Venkat,

    We are using Active Directory authentication and have setup a table in the DB to get the groups. This works fine for Presentation services and Publisher.

    We are now trying to see if this will work for the BI Server Admin tool login. So I have a user ‘x’ with group=”Administrators;XMLP_ADMIN”. When I try to login with user ‘x’, it gives me a login error. The server is able to get the group and assign it to “GROUP” variable but it somehow does not use it for authentication of the Admin tool itself.

    Is there any other setting that needs to be done ? Please advise.

    Thanks.

  168. Amer said

    Hi,

    I am wondering, how BIEE is capable of providing slicing and dicing as it was from Discoverer PLus. Users are not able to open the report in Pivot Table layout and use the slice and dice capability of the tool. Users must be able to slice and dice from the report published on the dashboard. Do you have any idea about Oracle road may in desling with this issue.

    Thanks.

  169. kk said

    Hi Venkatakrishnan J ,
    could u plz post the installation steps with screenshots of all hyperion products.it will be gr8 help to everyone.thnx

    kk

  170. ravi said

    Hi ,
    plz show all answers to all users what ever the quiries they asked ,it’s so comfortable & new ones go-for good quiries.

    regards
    ravi

  171. Kumar said

    Can you please tell me the steps to send an e-mail using BI publisher? I am using Windows XP as my OS.

  172. Kumar said

    Can you please tell me the steps to send an e-mail using BI publisher? I am using Windows XP as my OS. My aim is to send a report as an e-mail without having any relation to delivers or iBots.

  173. shubh said

    Hi Venkat,
    I have a requirement in which i have to send a report to 1400 different stores (store’s primary person’s email id) via iBots. But one person can be primary of multiple stores and all the primary persons of the stores will login to OBIEE and setup their my account and provide the email id (which is different for different stores) to which the report need to be deliverred. as he is primary of multiple stores, he need to setup multiple email ids. but the report is not getting deliverred to multiple email ids rather it is getting deliverred to only the default email id.
    If you can help me in setting up this, it will be of much help,

    Thanks,
    -Shubh

  174. Vijay said

    Hello venkat

    I have couple of questions today.

    1.Can you please tell me, how to integrate Apex with OBIEE, other than SSO approach. Can we achieve this in anyother way.

    2.Can u kindly tell me how to create/enable a join type (outer/inner etc.,) in Physical layer. hmm in simple, how to create an outer join in our RPD?

    Best Rgds,
    Vijay

  175. Pronab Das said

    Hi Venkat,

    Can we restrict the number of values a user can select in a Multiselect promt?
    If you can help me in setting up this, it will be really helpful.

    Thanks,
    Pronab

  176. Sudheer said

    hey Venkat,

    Unfortunately I replaced my nqsconfig file in windows to unix version..its not allowing me to login..how to get my old nqs config file from unix system back..pls let me know..

  177. vijay said

    hi , i have opening for oracle BI / analytics (for UK) if you are inrested drop your resume
    gvijay@vtmanpower.net / vtmgvijay@gmail.com
    044-64608582

    regards,
    vijay

  178. Raju said

    Hi Venkat,

    How can i use two repository at a time?

    In my configuration file (NQSConfig.INI) i have added two repository like

    Star=SampleSales.rpd,DEFAULT;
    Tms=TmsBI.rpd;

    But when i logon to Dashboard or Answer I amd not able to see other repository and on the Dashboard it shows error for the reportes (for the Repository which is not default) like

    View Display Error
    Odbc driver returned an error (SQLExecDirectW).
    Error Details
    Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P:OI2DL65P
    State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 27005] Unresolved column: “CONVENIO_DATOS_V”.”PART_PASA”. (HY000)
    SQL Issued: {call NQSGetQueryColumnInfo(‘SELECT CONVENIO_DATOS_V.EMPRESA, CONVENIO_DATOS_V.PART_PASA, CONVENIO_DATOS_V.PASAJEROS, CONVENIO_GPO_V.GPO_LIQ, CONVENIO_GPO_V.GPO_NOMBRE, TIMES_VIEW_CONV.ANO FROM TMSBI’)}

    SQL Issued: SELECT CONVENIO_DATOS_V.EMPRESA, CONVENIO_DATOS_V.PART_PASA, CONVENIO_DATOS_V.PASAJEROS, CONVENIO_GPO_V.GPO_LIQ, CONVENIO_GPO_V.GPO_NOMBRE, TIMES_VIEW_CONV.ANO FROM TMSBI

    How i can resolve this issue? is it posible to use two repository at a time?

    Thanks
    Raju

  179. Kevin said

    Venkatkrishnan,

    I am new to Oracle BI dashboards.
    I am looking to style the charts and graphs within the dashboard. I looks like the charting engine is PopCharts. Where would I find the CSS that the chart or graph (resulting flash object) references???

    Thanks for any help,
    Kevin

  180. Hi,

    I am trying to install Hyperion DRM. But unable to configure(Web Server) it properly. Please let me know, if you any doc on Hyperion DRM.

    Thanks
    Anmol

  181. Raju said

    Hi Venkat,

    I have a time dimension Which defines like Year,Year-Quater,Year-Month,Day and Year-Week, I want to achive that when i chose the particular Month (For Ex. May) Or Week (36) or Quater (1) I want to display all comparision from all the years in database (i.e. May-08,May-07,May-06 etc) or for Week (36-08,36-07,36-08) etc. How can i achive this?

    Thanks
    Raju

  182. freddy said

    Hi Venkat,

    I have a requirement to implement a section collapse control on the dashboard globally.In the dashboard page, each section (box) can be collapsed. But I want to implement this feature globally. I mean if one section in a dashboard page is collapsed, that should be applied to all the sections in all the dashboard pages.

    regards,
    freddy

  183. shiva molabanti said

    I have a date that is stored in a varchar2 column in the physical table, like so: 20071225
    Silly I know, but that’s what I’m dealing with.

    Anyway, I want to create a logical column in the business model (using the Administration tool) and convert it to a date so that I can do date arithmetic with it, but TO_DATE doesn’t seem to be supported.

    In Oracle SQL would do this :
    SELECT SYSDATE – TO_DATE(’20050101′, ‘YYYYMMDD’) FROM DUAL

    Is there any way to accomplish this same thing in the OBIEE? I see the CAST function, but there doesn’t seem to be any way to cast a string to a date?

    Thanks in advance
    Shiva.Molabanti

  184. Raju said

    I have pivot table having two measures dollar and unit.I want column selector which will be having option to select Dollar, unit or Both .

    Dollar and unit is fine but can I have solution for Both.

    How to display both dollar and unit using column selector.(or we can have alternative solution).

    Please help me out.

  185. Santhosh said

    Hi Venkat,

    Iam new to siebel analytics, what is the diffence between Siebel Analytics and OBIEE ?

    Thanks
    Santhosh

  186. Chaitanya said

    Venkat,
    Please give an article for Backup and recovery process in Hyperion Planning.

  187. Hemanth said

    Venkat,

    I am looking for jobs in Hyperion area.
    I have some experience as Hyperion administrator.
    Do you know any place where there are job openings?
    I am searching every corner of internet for a job with a no luck.
    I would really appreciate a lot if you can help me with this situation?

    Thanks
    Hemanth

  188. Edward Eloian said

    When installing OBIEE I get this error:

    Oracle Business Intelligence is not supported on this Windows version. Oracle Business Intelligence is only supported on Windows XP x86, Windows 2003 x86, Windows 2003 AMD64, Windows 2003 EM64T, Windows Vista x86, Windows Vista AMD64, Windows Vista EM64T, and Windows 2000 x86.

    Can you help?

  189. Pavan said

    Hi Venkat,
    I would like to know if there are any log files generated for a users authenticated using an external table. Presently i could see logs files related only to Administrator. When i log in with a user i couldn’t open any log files from the dashboards. Is there any way to enable this.

    Thank You

  190. Anup said

    Hi Venkat,

    My name is Anup. I would need your help to know how we can improve performnace of Analytics reports without caching. We have made necessary aggregate table and also the physical queries of the reports run very fast, say 7 sec. But, the response time for the report is close to 1 min, which, combined, make the report very slow.
    Can I contact you on your cell 🙂 or any number?
    My number is 2012832585 and mail id is anup.hit@gmail.com

    Kindly suggest me how to improve reports’ response time.

    Thanks,
    Anup

  191. gurudattap said

    Hi Venkat,

    Have you written any article for loading value based hierarchy using Essbase Integration Services?

    Regards,

    Gurudatta

  192. sridev said

    hi i have doubt in obe scheduling, so anybody have a document means pls send it to bsridev@yaho.com

  193. Sophia Hsu said

    Hi Venkat,

    We learned very much from your knowledgeable forum. In recent, we had a problem about the page axis of a grid in Hyperion Financial Reporting 9.3.1.
    The dimension members (ex: apple, mango, and banana) have been assigned to a page axis. However, when we changed the members from the Pages drop-down list in HTML mode, the member of Pages and report data still stayed in the first member. For example, we changed the member from “apple” to “banana”, but the member and content was still the “apple”. The Pages function didn’t work in the Windows platform.
    I would really appreciate your response. Thank you for sharing your knowledge and time.

    Best regards,
    Sophia Hsu

  194. Raman said

    Hi Venkat,
    I need to install following products along with OBIEE Plus

    Oracle® Business Intelligence Applications Fusion Edition

    1.Oracle Partner Analytics Fusion Edition.
    2.Oracle Telecom Sales Analytics Fusion Edition
    3.Oracle Telecom Service Analytics Fusion Edition
    4.Oracle Telecom Marketing Analytics Fusion Edition
    5.Oracle Contact Center Telephony Analytics Fusion Edition
    Informatica OEM PowerCenter ETL Server and PowerConnect Adapters
    what i need to do,which version of OBIEE we will get this
    Pls help me out this … ASAP
    Thanks
    Raman

  195. Max said

    Hi Venkat, I have the following problem: in my OBIEE install I can start the BI presentation services for all catalogues that I have except for one. The log indicates several times that “Query for Initialization Block ‘LOCALE’ has failed.[nQSError: 23006] The session variable, NQ_SESSION.WEBLANGUAGE, has no value definition.” Does anybody know what may have gone wrong?

  196. Mark said

    Our OBI EE Service stops (Windows box) and this following is posted to the server log:

    Faulting application NQSServer.exe, version 10.1.3.3, faulting module nqsdbgatewayoci10g.dll, version 10.1.3.3, fault address 0x0000b5cf.

    • Himansu said

      Hi Mark,

      Did you get the resolution for this?
      I am also getting the same issue.

      Please let me know if u sorted it out.

      Thanks in advance,
      Himansu

  197. Anitha Raghavan said

    Hi Venkat,

    Awesome blog…. Could you please include me in your blogroll..

    Thanks,
    Anitha

  198. Anitha Raghavan said

    please ignore my post above..thanks.

  199. Raja said

    This problem is not clear-
    Dynamic Column Headers using Presentation Variables in O.B.I.E.E.
    .Please clearify this this in right way.it is difficult.

  200. Dinesh said

    Hi Venkat,

    Your blog contents are too good and its well maintained.Keep up this..

    I’m new to BI.Currently i need to test a telecom project complete BI & its reports.kindly suggest me what could be the best way to do it.Is there any tools to test this..?

    Kindly help me how to start with..

    Thanks
    Dinesh

  201. ytbrad said

    Hi Venkat,

    Nice blog and keep on updating please.

    I am a newbie to OBIEE. I am creating a report with OBIEE answer , and I can not figure it out how to display pageNumber/total pages (for ex. 1/16 ) on the report’s footer.Could you tell me how to resolve that problem?

    Thanks & Regards
    Brad

  202. Nagesh said

    Hi Venkat,

    I am facing problem to connect relational DB from hyperion web analysis report. In web analysis we have Drill through feature.
    But i am unable to connect any of the relational DB. I am getting error “Getting connection failed”. I am trying to connect Oracle DB. but i am able to connect using Oracle Mirant. but we do’t have Oracle Mirant in Drill through.
    Please help me on this.

    Nagesh

  203. tom said

    Hi Venkat,

    Thanks a ton for all the useful information. I have a few questions for you. I would appreciate if you can help me out.

    1. In Line charts, when we roll the mouse over the values(represented by for ex triangles), it just displays the Y-axis value. I tried several options to get the X-axis value too with Y. It does not work. Can you teel me how to show both the values on rollover?

    2. After changing the properties in Col format options to Navigate instead of drill I am able to navigate to answer i want. However is there a way to control the navigation so that it displays the target in a new window everytime instead of navigating in the same window where we have the link?

    Thanks,
    tom

  204. ash said

    Hi venkat,

    Well your efforts are commendable. Great work!

    I have a small scenario which works well on dashboards but not for answers. I am trying to have dynamic titles based on the prompted column. The thing is the destination report is an answer and not a part of a dashboard. Can presentation variables be used for answers? In this case I navigate from dashboard to this answer.

    Thanks much,
    ash

  205. Bharat said

    Hi Venkat,
    Please sugges How i will create the dynamic Header in report.i seeen your solution but it is difficult to understand

  206. Sangeetha said

    Hi venkat,

    Please Suggest me how to clear the cache for Particular group or Few users

    Thanks
    Sangeetha

  207. Subbu said

    Hi Venkat,

    I am very new to OBIEE. Actually i am siebel architect and my client wants to have siebel analytics. Client is asking for the architecture for OBIEE and no of servers required for setting up the OBIEE.Our OLTP system is running in HP UNIX (except web server). We have some UNIX box available for OBIEE.But we need to tell client that how many boxes we need and what are all the components can be installed together – this is for Development only

    Please help us on this

    Thanks
    Subbu

  208. Sum said

    am trying to plot a graph that shows Persons name ( x-axis) against the revenue they generated ( Y Axis). The style i am using is vertical bar – 2d stacked ( for the quarters.. were i want Q1 to come on bottom of the vertical bar, q2 on top and so on and so forth). When i sort by Qtr, the bar for the person with highest revenue total is not arranged in descending order. The totals are arranged more or less in random fashion with a lower value bar coming 1st.. a higher value 2nd.. the lowest value coming in 3rd.
    Is there a way i can plot this graph with having the person with highest total come in first and descending downards with each bar sorted ( 2d stacked) sorted by Qtrs.

    Thanks

  209. Fethiye Turgut said

    I found this bug Bug 5926870 regarding Job manager not starting. I’ve also noticed, although jobmanager.ese won’t launch, you can launch it from startup.jar under JobManager folder under OracleBI

  210. venkat said

    Hi,
    I have a problem, I have 2 servers 1 dev and 1 is test, in test there is no data. and I have to load data from excel to the cube in the test.I have to create a report and load the data into the cube can u please suggest me how to do it.
    here excel is the data source and essbase is the target(not using essbase)

  211. venkat said

    can we create a report from a excelsheet instead of essbase using HFR 9.3 and also can we load data from Hyperion Financial Report to an essbase cube. if so please help me i am in hurry its very very urgent

  212. Parn said

    I am working on OBIEE. I have a customer requirement wherein I have to create a report using a view selector. The view selector is used to choose b/w two reports ( both pivot tables), having different multiple columns. Now the customer also wants a chart display based on each report, and it should vary with the view selector. The problem is that when we chart pivot table , it is automatically based on all the columns in the pivot table. whereas the requirement is , that chart should be based only on one specific column in pivot table. How should I achieve this?

  213. Aparna said

    Hi Iam new to OBIEE. I have a customer requirement wherein I have to create a report to calculate Year todate, Quarter to date , month to date, week to date, Daily sales, Year Ago , Quarter ago, Month ago, week ago, day ago sales, Prior year Quarter ,prior year month , prior year week, prior year day level sales. Like wise we need to calculate around 8 measures .We can calculate it using Ago and To date functions,But problem is we need to display these values dynamically which hits the performance badly. Als othe repository size keeps on growing. Which is difficult to manage.Can u plz suggest some way to avoid this

  214. Bruno Samuel said

    Hello,
    I am doing a fresh install and configuration of OBIEE.
    I followed the steps in your blog “Oracle BI EE 10.1.3.3/2 – Using LDAP/OID Authentication” to configure security using company LDAP (Active Directory – Windows 2003).
    Instead of OID, I am using the Active Directory – Windows 2003 and my version’s OBIEE is 10.1.3.4.0. After creating the server windows 2003 with AD, I tested the connection with the AD server and was successful. Next I tried Import option, but got the Oracle BI Administration Tool error message: “There is nothing to import.”. I’m using the Administrator login and properly informing the base DN. Is this an AD configuration/privilege issue or OBIEE issue?
    Please help me out.
    Thanks,
    Bruno Samuel
    SP – Brazil

  215. Rajesh said

    Hi Venkat,

    colud you please provide me the information regarding ‘GO URls’ in OBIEE and how can we pass the parameters in the OBIEE, so that we can navigate to the other page/ Dashboard.

    Best Regards,
    Rajesh.

  216. karthikeyan said

    Hi,

    I need to use custom authentication, For this I have to change the nqsconfig.ini Authentication type.what is the type I should give…

    Could you help me

  217. karthikeyan said

    Hi,

    Any one did custom authenticators please provide some information.I have configured custom authenticators according to the rittmanmead document (http://www.rittmanmead.com/files/OBIEE_Access_Control.pdf) ,but custom authenticators is not working. what I have to do to achieve this custom authentication.

    Can you help me to achieve this.

    Thank you,
    karthikeyan

  218. pankaj garg said

    hi venkat…
    i am new person to oracle business intelligence and got stuck some where while working on bi answers and dashboards…actually we need to make a slider which is connected to a column…so that if we change a value the graph changes accordingly..can it be done???if yes please let me know the method how can we do that???

    any help will appreciated

    Thanks & regards

    Pankaj Garg

  219. Hi

    Quick Over View

    1. OS -> Centos 5.2 64Bit
    2. Installation Purpose -> Test Hyperion Shared Services.

    Installation Steps.
    1. I configured Oracle Database by creating a User and with Permissions.
    2. Installed Shared Services with default Apache Tomcat, and OpenLDAP.
    3. I did the configuration steps to configure the Application and Database which went without any issues.

    When I logged into the User Management Console with the default admin / password i am getting a error. User not found!
    Screen Shots http://dba-onweb.blogspot.com/2008/11/issues-i-faced-during-hyperion.html

    I checked all the basic things like

    1. Shared Services running,
    2. Apache
    3. OpenLDAP is also running.

    No other module has been Installed. Am I missing something here…

    Thanks in Advance
    Ravi Prakash

  220. Asif Husain Khan said

    Hi
    I am working on Oracle Business Intelligence 10.1.3.3.2.I have made a section containing html code for radio buttons,on selecting the radio button it shows the corresponding saved request in the other section of same dashboard.
    now the problem is that whole page is geting refreshed in selecting the radio button whereas the target to b achieved is only the section displaying the request should be refreshed.
    can it b done?if yes then how.
    Thanks

  221. Pankaj Garg said

    Hello Sir,

    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 help me its very urgent…

    Thanks & Regards,

    Pankaj Garg

  222. Ram Krishna said

    Hi Venkat,

    I apprieciate your patience and the blogs you write are very helpfull.
    My question please can you explain some funtional architecture of Planning and
    what are allocations

    It will be very helpfull, i just want to understand the whole planning cycle work.

    Regrads,
    Ram Krishna

  223. Siva said

    Hi Venkat,

    Your quick response is highly appreciated.
    Below is the business scenario:

    We are using OBI EE 10.1.3.4
    1). Date Prompt (Start Date & End Date — Dashboard Prompt)
    2). Product Category Prompt.

    When we click on the single go button for the above two prompts

    a). If the recordcount is less than or equal to 65000 then the report should be displayed in the dashboard. for displaying this we don’t any issues.

    b). But for below.
    If the data is more than 65000, then the report should not display instead of that “A message should be displayed” like Count is more than 65000, then the user should be able to download the data in to CSV file. As huge amount of data will be populated in the data mart per day (data feed from source system — Atleast 5 lakhs of data per day).

    Let me know whether we need to write any Java script for the above scenario.

    In the BMM layer we are planning to have only the Join conditions between the fact & dimension tables (Complex joins).

    Also please let us know whether we will have any performance considerations if we populate the only the basic join conditions in the physical layer and in the BMM layer. All the calculated condition will be taken care off in the Data Mart.

    Thanks in Advance
    Siva

  224. pankaj said

    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

    thanks,

    pankaj

  225. tom said

    hi gurus,

    we are trying to sort a column holding version numbers which is actually stored in database as varchar.

    1.10.0.0.1
    1.7.0.0.2
    1.8.0.2.1
    1.7.0.0.1
    on enabling sorting on the dashboard we see that 1.10.0.0.1 comes before 1.7.0.0.1

    rest all appears okay. is there a way i can sort the column that treats them link a version number. by the way I also set the sort order col prop on BL in rpd. it still does not work.

    any comments would be appreciated

    tom

  226. Mike said

    Just passing by.Btw, you website have great content!

    _________________________________
    Did you know that over 94% of personal computers have hidden corrupt dangerous files with over 150 hidden errors and bugs on them?

  227. Divya said

    Hi Venkat,
    In OBIEE Answers, is it possible to apply filter and prompt on the same column? As far as I understand, the prompt has the highest priority and it overrides the filters. Is there a workaround at the Presentation Layer level?

    Thanks..
    Regards,
    Divya

  228. Divya said

    @Tom

    Hi,
    Try doing this: The ‘space’ has a higher precedence than number. So,write a CASE statement in Answers for the Version No. field. In the CASE, for the one which needs to appear first put one space and write within a quote, for the second version number 2 spaces followed by Version no. withing quotes and so on.

    Though just a workaround, worked for my instant requirement..

    Regards,
    Divya

  229. Indra said

    Hi Venkat,
    Can you please send me the document for upgrading Siebel Analytics to OBIEE

  230. jaedwein said

    I don’t speak english, so i’ll go to the point.

    What’s really new, easier or better with Hyperion (Web analysis, Workspace, Production Reporting, Scorecard, etc.) than with Oracle BIEE (Delivery, Answers, Intercative Dashboards, Admin Tool, Publisher, etc).
    What can I do with Hyperion that I can’t with Oracle BIEE

    Thanks in advance.

    Saludos.
    Javier.

  231. Shyam said

    Venkat,
    My organization is implementing Hyperion Planning. We have about 8 dimensions and a 60G database (after agg). We are facing significant performance issues when running aggregation upto top level. This is not meeting business needs to report immediately (read few minutes) on Org level data. We have had Oracle resources look at all possible ways to tune, cutdown the database, do dynamic calc on few memebres etc with no satisfactory results. One option being approached is to do timely extraction from Planning BSO to an ASO (same outline). The thinking is that we can schedule that refresh every hour to meet business needs. DATAEXPORT of a particular scenario (Budget/Forecast) seems to be the bottleneck – takes about 40 minutes. Do you have any suggestions for:
    1. DATAEXPORT to run faster
    2. any other approaches to resolve the overall problem.

    Your inputs are highly appreciated.

    Thanks.

  232. John Eicher said

    Has anyone done What If analysis with OBIEE. Such that one would have a dynamic slide bar for currency conversion which, as you move it right or left, the Gross Revenue, Net Income, etc. would change. For example, if you start at a factor of 2.0 for Euros to Dollars and Gross Revenue is $2.000 million. If the currency exchange slider is moved to 2.5, then the Gross Revenue is $3.000 million if moved to a factor of 1.5 then Gross Revenue is $1.000 million. Thanks for the help.

  233. R.B said

    Hi Venkat,

    Your blog is very informative and it really helps. I need your help in opening the repository by entering user id and password, as I don’t know the repository userid and password. How can I open the repository? Is there any way in reseting the password for the repository.

    I tried using the NQSChangePassword.exe. It did not work.

    Can you give me your suggestion to resolve this issue.

    Thanks,
    R.B

  234. Prasanth said

    hey venkat,

    This blog information is very helpful. Lately,i am running into another problem with essbase

    I have an Org dimension which is across 5 generations. So In my report i have the org generation starting at Gen3 which goes all the way down to Gen5. So i have a prompt with 3 gen columsn gen3, gen4,gen5.So when i select some members in the prompts from gen3 to gen5 itz giving NO results. how ever it shows results in the report if i use a normal drill down instead of the prompts. So even it has results for the selected prompt combination it gives no results. But in the drill down it shows results.

    Prompt columns: gen3, gen4, gen5
    Report columsn: gen3, dollars
    filters in the report: gen3, gen4, gen5 are prompted

    Is there any specific way to handle Essbase prompts in OBIEE. Please advice.

    Thanks
    Prasanth

  235. swapna said

    hello venkat,

    Like most others, I am new to OBIEE.Can you tell me where I can get information about HR analytics?? Also can you tell me where I can get some knowledge of variables(static, dynamic, presentation etc)

    Thanks,
    Swapna

  236. OBI fan said

    Hi Venkat,

    Could you please help me with below two queries

    1) Is there a way to upload .xls file from within OBI dashobard/page?
    2) How can i override the default collapsible functionality of section. I mean by default iwant my section to appear as collapsed instead of expanded.

    Thanks in advance.

  237. Dimitris said

    hi Venkatakrishnan,your blog is really excellent.
    I ‘ve been searching for a specific answer for while.
    How to accomplish this scenario,set 2 periods of time using the calendar in the dashboard(set the presentations variables) and how to “pass” them in answers using the
    //
    FILTER(“….Fact”.”Sale_value” USING (“Calendar”.”Cal_date” BETWEEN date’@{ds1}’ AND date ‘@{de1}’))—for both periods
    //
    meaning have 2 filter column from the fact in the same report.
    Calendar is really strange.It is really easy with drop-down or edit box…
    tnks one more gor your articles…

  238. Adeel Javed said

    Venkat,

    Browsed through your blog and honestly it is just amazing, we just found it a bit late. Well, we are facing a few issues with OBIEE, and here is a lengthy and detailed list of issues, so can you please take some time out and take a look:

    1) When fetching data from multiple DB source: We have multiple source databases and multiple reports are built on those. All the reports are interlinked and all the reports use multiple databases. But source can only be determined at runtime. When a field value in a report is ‘A’ then data on next report should come from one database otherwise the data should come from other database. We are unable to figure out any way to accomplish this.

    2) Variable passing from Dashboard to RPD physical layer: We are using complex select queries as table sources on physical layer, but we do not want these queries to fetch all the data first and then filter that data depending on the user selections from the dashboard. Can we pass a variable on selection of particular record by the user to that physical table query ? For example currently we are using queries like this (sample query)
    SELECT ORDER_NO, ORDER_TYPE, ORDER_DATE FROM ORDERS
    And we want to use query like this
    SELECT ORDER_NO, ORDER_TYPE, ORDER_DATE FROM ORDERS WHERE ORDER_NO = VALUEOF(var)
    But value of the ‘var’ is not predefined, rather the value should be the set whenever user clicks on a ORDER_NO link in a report.

    3) Page level Export to excel (page contains multiple grids): On one dashboard page we have multiple data grids and we want to export all the grids into single excel file. Currently we know only of downloading single grid in excel file.

    4) Multiple Target Report for single link: On one of our report we have a navigation column for which there are multiple target reports. But the actual target report that should be loaded is determined at runtime depending on the value of other column. For example if value of column A is ‘ABC then target report should be REPORT 1 and if value of A is ‘DEF’ then target report should be REPORT 2 otherwise the target report should be REPORT C. Can we do this? According to our knowledge we can specify multiple target reports but every time all the targets are shown in a context menu when we click on the link. We just need to determine single target report based on the value of column A and whenever the link is clicked, load that target report. We don’t want to show the context menu to the user with all the possible options.

    Any help will be greatly appreciated. Thanks.


    Regards
    Adeel Javed

  239. suman said

    Hi,

    Is there any way to store authentication details like UserID and PW outside RPD and migrate it to other environment.

    Cheers

  240. Razi said

    Hi Venkat,

    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.

    Thanks in Advance
    Razi

  241. saichandv said

    hi Venkat,
    First thank for you extreme support for all BI professionals.I worked on how to call bi publisher reports from ibots.I refered to your previous post they are doing well.

    But i want to select a “Delivery Content” based in a BI Publisher Report, not a dashboard content… when I press the “Select Content” button the navigation explorer shows Dashboard Folders only…

    The question is: I need to put a BI Publisher Report “into” a dashboard before call it from a iBot schedule?

    Thanks and Regards,
    V.Saichand

  242. Vikram said

    Venkat,

    First Thanks for Excellent Blog.

    I am unable to get “More Products” link in OBIEE presentation services. I checked for the manage privellages.

    Please Help Me.

    Thanks in Advance.

    Regards,
    Vikram

  243. Naveen said

    Hi Venkat,

    I am trying to do some customization on web forms in planning in order do some validations. some how i have figure out how to do customization . but not able to figure how to establish connection to call pl/sql package which is existing in other server and perform segement validations…

    Please can you respond me as soon as possible…so that i can progress in my work…

  244. blatny said

    Excuse me! I’ve just begun my research about Oracle Technique and read some Oracle Documents. But I was so confused. There are many solutions for Business Intelligence. And Oracle has one. I wonder if there is any differences between Oracle BI solution and others about the common BI theory and implementation that made Oracle BI outstanding. I hope you would please to give me a hand for my very first step. Thanks in advance.

  245. Ram said

    Hi Venkat,

    First I appreciate your blog it’s really very help full.

    I have a requirement to create Oracle Answers report using width_bucket function, Please give me reply first is it possible or not If possible how we will implement this.
    After all my research I came to know that it’s possible using Evaluate function please give me an idea how we will do this.

    Your quick response is highly appreciated.

    Thanks in Advance,
    Ram

  246. Artem said

    Good day, Venkatakrishnan J.

    Thank you for your leadership!
    They helped me configure the LDAP authentication and run OC4J as a Win Service!

    Many thanks again.

    Artem.

  247. Yusuf said

    I have new with BI tools. Our current DB is not functional and we were tasked to play with TEXT files that we load onto our hard drive. I have load a few file and tested on the presentation layer. The following error appeared – can you assist.

    Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
    State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 46033] Datatype: 25 is not supported. (HY000)
    SQL Issued: SELECT “HCREG.TXT”.Termyn saw_0 FROM “HEMIS P” ORDER BY saw_0

  248. Srikanth said

    Dear Venkatakrishnan,
    Many thanks for sparing your time and assisting us through the blog.
    My requirement is: Customer has a Pivot table and He requires dashboard prompt where in he provided paging no of pivot table.
    Say if he provided 27 in the dashboard prompt. Then My page dropdown should contain values as :
    1-27
    28-54
    55-81
    . . .
    . . .
    . . .
    I tried to impliment this similar to the solution provided by you @
    https://oraclebizint.wordpress.com/2008/01/17/oracle-bi-101332-pagination-in-pivot-tables/
    Buy in my case the Rou-Count Coloumn formula should use presentation variable value to perform the caliculations such as
    @{P_NUM}+1 – 2*@{P_NUM} after the then clause in the case expression.
    How should i go about this ?

    To conclude My requirement is: I want to use simple arithmatics after the THEN cluase in the CASE EXPRESSION.

    Many Thanks for your time

    Regards
    Srikanth

  249. Vijai said

    Hi,

    can you please tellme the process for disconnected clinets on OBIEE?

  250. Vijay said

    Hi Venkat,

    Can you please help me to come out from this peoblem.

    How To Implement Breadcrumb in OBIEE / Siebel Analytics.

    Regards
    Vijay Ramagiri

  251. James said

    Need to know how to create a user and grant read permission to other dashboards …

    Thanks
    James.

  252. Giuseppe said

    Hi Venkat,
    is it possible to create a single sign on between OBIEE and a legacy application written in asp.net on Membership.
    I need the users registered on the Memebership are automatically logged when i open OBIEE page.

    Is it possible ? How can i do it ?

    Thanks in advance, Giuseppe.

  253. manikanta said

    hi venkata krishnan,

    your blog was very useful to who are working in obiee. i am learning obiee, still i have one confustion about Guided Navigation? Can you explain with the example?

    thanks,
    mani

  254. kumar said

    Venkatakrishnan J,

    Congratulations on joining RittmanMead….

    http://www.rittmanmead.com/2009/06/22/breaking-news-venkat-joining-rittman-mead/

  255. sirikiran said

    How to set my dashboard default to other dashboard

  256. shital said

    We are running into a critical issue when we try to do iBot sharing. There are 60 some iBots that have to be made available to every individual user. So, the desire is to create those iBots once, then “share” it with other users, so they dont have to create it. But the requirement is that each user needs to be able to run the iBots on their own required schedule.

    With this requirement in mind, I logged in as Administrator, created iBots, then went to ‘Manage Catalog’, Copied the iBots to Shared Folders. Now, when I log in as a user , for example ’85’, I see the shared iBot in the Shared Folders. Here is where I encounter a critical issue:

    As user ’85’, when I modify the iBot under Shared Folders, say modify the schedule, and try to Save it, it gets saved under My Folders. Now, when I run the iBot which is under My Folders, what it does is that, it “reuses” the same Job Id in the s_nq_job table and updates it with userid ’85’ to the defined schedule. Now, user ‘112’ goes in, copies the iBot from the Shared folder to their own ‘My Folders’ and modifies the Schedule, I notice that it “updates” the same Job Id with user 112. That is NOT desirable. We need to be able to control the iBot schedule independently for every user. We also have a process that triggers an email for every inserted Job Id. We need all that functionality preserved and managed for every user. Hence, sharing a single job_id does not meet our requirements

    This is very critical as we have over 60 iBots and several 100 users. It is not a good use of our time to be creating 60 x 100 = 6000 iBots. Can you please let us know how to achieve the functionality that I described above?

  257. Ashwin Dube said

    Hello Sir

    Please advise on how to get the Demo maps running after setting up the Mapviewer successfully.
    We have all the settings right except when clicking on any demo map selection it gives the error:
    ‘500 internal server error’! This worked once although we only got to see the blue image and no maps as such.

    Thanks!
    Ashwin Dube

  258. Deep said

    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 .

    Approach2:

    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,
    D1,F1,D2,F2.

    In the Central logical fact I have created two sources.

    Source1

    and

    Source2

    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,
    Deep

  259. Rajesh said

    Hi,

    Is it possible to schedule iBots from external application, say from a JSP page.

    Many Thanks,
    Rajesh

  260. kumar said

    Hi Venkat,
    I need some info on OBIEE. if possible then please help me

    I have one dimension “region” and two facts (Sales value & Gross margin%). Gross margin% is logical column which has been derived from two other facts column and it’s value is in range from Zero to 100.

    Now, I want to generate below report. For each grossmargin% range of 5%, I want to sum the sales value for each region. Please assist

    GM% Region_1 Region_2
    <0 254 619
    0-0.05 564 799

  261. sakthi said

    Hi,

    we are using HFR as reporting tool whereas Essase and OBIEE serves back end.The essbase has higher level data and OBIEE has very granular data.we need HFR to use essbse and drill down to OBIEE from there..Can you please suggest me, how to attain this..

    Thanks
    Sakthi

  262. Mustafa said

    Hi,
    i’ve installed Oracle BI Server 10.1.3.4.1 to my computer. But i can’t see any chart with values on dashboard. It draws only legent and axises but there is no any data on any chart. How can i solve this problem.

    i’ve installed : biee_windows_x86_101341

    thanks,
    mustafa

  263. SJ said

    Hi Venkatakrishnan,

    Can you provide some example to switch data source using same report on this URL
    https://oraclebizint.wordpress.com/2009/02/27/oracle-bi-ee-10134-switching-between-production-and-development-data-sources-using-same-reports-and-dashboards/

    Can you send me some more detail to sujojohn@hotmail.com

    Thx
    SJ

  264. Rajesh said

    Hi Venkat,

    In LDAP authentication can we convert the case of users lets take i have all the users in upper case and want to convert into lower case. Can you please help

    Thanks

    Rajesh

  265. Luntu said

    Hi guys

    I have got a problem here, i want to create a variable like this select COUNT(*) FROM EMPLOYEES, as column and use it on my case statement like case when count >0 then ‘bad’ else ‘good’ end

    but it giving me erros

  266. Alan said

    Is there any information on Financial reporting annotations

  267. Kumar said

    we have a requirement to deliver Oracle BI reports generated by iBots to the specified SharePoint location. Can i have with detailed screens . or with detailed steps as there were so many blogs regarding this i can figure it out.

  268. Sid said

    When charting a column that has been converted into a HTML href column, the column value formula(‘‘ ||ED_WORK_EFF_TYPE.ORDER_TYPE|| ‘ ‘) is displayed on the chart instead of the data value. Can the data value be displayed on the chart?

  269. Marcin said

    Hi,
    I’m testing complex dashboard with 3 sheets. One sheet is showing fact data. Two other sheets are used for configuration
    (using WriteBack): one is used for setting budget-values, the other one is used for setting publish-date.
    Setting Publish-Date also uses Write Back, that writes data to database, eventually data is read to BI variable (refresh interval 60 min)
    and used in Answers. What bothers me is that when I set focus for few minutes on any of WriteBack sheets and change to fact data sheet I get following exception on sheet header (page still displays correct fact data)
    “Invalid state identifier”
    When I leave focus for several hours I get following error and web page without data
    “Invalid request ID – kmsgClientSessionInvalidSearchID”
    I looked through Presentation Server log File (\OracleBIData\web\log\sawlog1.log) and found the following error sequence
    Everything starts from this warning
    Cache file ‘D:\oradata\OracleBIData\tmp\sawvc\1040{RANDOM_FIL E_NAME}.sawxd’ didn’t match expected key.
    Than follows error
    “Invalid state identifier”
    I recon that .sawxd file is being deleted by presentation service but I don’t understand why. There are lots of others .sawxd files, that are older and have not been deleted. Is it bug or known behaviour? Is it because WriteBack feature or frequently refreshed BI-variable?
    Any session/cache(instanceconfig) settings have not been changed.
    I appreciate any suggestions.

    • Phani said

      This could be because of the session timeout of your request. Presentation server caches the content only for few minutes, after that request is expired from the presentation server, so objects you are referring are not longer valid.

  270. harika said

    Hi,

    I want a small information for u people. Can I know free download links for OBIEE s/w…

    Thanks in advance

  271. Swetha said

    Hi Venkat,

    Thanks for such a wonderful blog.
    We have a requirement about calendar picklist in answers. When we select a date, for example 1-Jan-2009 from the calendar picklist, it displays in the editbox as 1/1/2009. But the required format is 01/01/2009.
    Can you please suggest on this.

  272. PN said

    Hi

    I need to create one dummy dashboard date prompt as edit box and want to compare its value between two date i.e. start_Date and end_date columns. like 01/01/2000 between start_date and end_date

    Please help me how to do it in OBIEE.

    Thanks in advance

  273. Williams said

    Hello
    Venkatakrishnan,

    Please I need your help I want to make in the model one field that represents an html link that shows a popup whith an inlineframe, and I want to pass by url the source of that iframe, can you telme how can I do this , please is very important.

  274. Williams said

    Hello
    Venkatakrishnan,

    Its me again the thing is like this: I click in the link and have to show a popup and inside the popup its have to be an iframe with the source that I stablished, I know how to show this in a window but its shows the url, and for my aplication I most show this window within the url, I use this method

    Ver la ficha de esta persona” target=_blank onmouseover=”style.color=”Red”” onmouseout=”style.color=”MIDNIGHTBLUE”” onclick=”javascript:window.open(”’ || VALUEOF(“path”) || CAST (area.”Datos”.Id AS VARCHAR ( 10 )) || ”’,”Ampliación de la Ficha”,”width=1000,height=560,left=100,top=100,location=0,menubar=0,resizable=0,scrollbars=0,titlebar=0,toolbar=0”)” >Ver Ficha

    I create this as a field in the model but this show the url, I want to hide the url or show a popup whith an iframe

  275. Hema said

    Hello Venkat,

    I have been through your blogs on Business Intelligence – Oracle site. I could not find a solution to the issue im facing with Hyperion Fusion Edition Workspace.

    While logging onto Workspace im getting an error message like “You must supply a valid user name and password to log onto the system”. I m able to login to shared services, planning etc with this id and password as its an admin id.

    In workspace.log file i could see the message as NO workspace components found in registry
    Missing product context CALC
    Checking HSS for context under product code CALC-9.5.0
    Attempting workspace services connection for HSS
    Failed to connect and retrieve info for CALC-9.5.0

    Please help me with this issue. Its urgent

  276. Siddharth Shah said

    Hi venkat

    I’ve been reading your posts regularly

    Is there a way of displaying the name of a saved selection as a report name. I;ve tried every possbile thing but havent been successful

    Is there any feature that allows us to display the name of a saved selection on the dashboard

    Regards
    Siddharth

  277. rualonor said

    I have been through your blogs on Business Intelligence – Oracle site. I could not find a solution to the issue im facing with XML huge files.

    How can we charge and parse with OWB, ODI or any other tool that Oracle BI can provide us.

    Thanks in advance.

  278. Krishna said

    Hi Vekat,

    Thanks for such a great blog.

    I am trying to call BI Publisher report from OBIEE – IBOT, this is my objective.

    I am following below link from your blog.

    https://oraclebizint.wordpress.com/2008/01/04/oracle-bi-publisher-101331-creating-applications-using-jdeveloper-11g-and-web-service-soap-apis/

    I am getting error while I compile code in Jdevloper “package samplesoap.proxy does not exist” and also

    Also I have changed

    From
    String userName = “Administrator”;
    String passWord = “Administrator”;

    To
    String userID = “Administrator”;
    String password = “Administrator”;

    as I saw in WSDL document from url on local.

    I am using OBIEE 10.1.3.4 and Jdeveloper 11g.

    I am not sure if I am missing any JARs to be included or not anything…

    Can you please help me resolve this and also guide me if I am on right way to acheive my objective..

    Thanks in advance.

    Thanks!

  279. Josh said

    When returning the HTML of an OBIEE report (from HtmlViewService) and writing it to a file, I am getting an Access Denied error when viewing the report in the browser. I think it has to do with the iframe that is embedded. Any suggestions on how to bypass this?

  280. Jimmy said

    Venkat,

    I’m relatively new to Siebel Analytics and currently working on the upgrade from Siebel Analytics 7.8 to OBIEE 10.1.3.4 in development.
    The upgrade went successfully but when viewing the rpd file it indicates global consistency check issues and throws errors and warnings in OBIEE.The very same rpd did not indicate any global consistency check issues while previously in Siebel Analytics.
    The webcat migration was successful using the sawmigrate.exe utility.The installation is Windows based (Windows 2003 R2)
    Any ideas as to why the conistency checks are showing up in OBIEE and not in Siebel Analytics ?

    Thanks

    Jimmy

  281. Stefan said

    Hello Venkat,

    while searching for a solution for my current problem I found your site! Your site is really great and helpfull! Thank you at this point!

    But,

    I do have a issue with a report:

    In the report you have to select a start-month and a end-month (Exp. 201001 to 201008).
    The reports shows sales per month and a total. Now I want to show the sales for the periode 12-Month ago (200901 to 200908). I have created a logical colum with AGO(…, -12) and it works so far. But now, If I use in exp. employe and not month is the table I don’t get a sum-total. I can see 8 lines (for 200901 to 200908). How is it possible to aggregate the report to employe getting one sum for 201001-201008 and anoth for 200901-200908)??

    I found out that viewing the report in pivot-mode, the agg. works but not in the table view.
    I think I am doing s.th. worng…

    The request is to have a variable month selection so the “customer” can define the month to show and calculate.

    Many thanks for your answer!

    Best regards from germany,
    Stefan

    Ps: I hope you understand by bad english!?! 😉

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: