OBIEE Online Training

Comments


Hi Friends,


If you have any queries on OBIEE11g please post it here, i can try to share my knowledge and if i have any reference documents i will share with you..

Thanks
Deva

15 comments:

  1. Hi Deva,
    I have one issue on: Object Level Security Issue while login from EBS R12 to OBIEE 11.1.1.5.0 with different Responsibilities

    This Issue is whenever a user tries to
    1. Single Sign On from EBS R12 system to OBIEE 11.1.1.5.0 Reporting system with their responsibility and
    2. then sign out from BI reporting system to go back to EBS system and
    3. then again come back with some different responsibility

    As a result at background, the BI Presentation cache may carry earlier responsibilities references and overrides on current user responsibility so BI Reports security is not working as expected in some cases.
    Only restarting BI presentation Server resolving the issue

    Do you have any work around on how to resolve this without restarting the server?

    I appreciate your help

    Regards,
    Rafik

    ReplyDelete
  2. hi deva
    This is manu iam using obiee11g. in 10g to import meta data from database odbc/oci connection both are working.come to obiee 11g only oci is working doesn't working odbc. please tell me how can i import metadata using odbc connection pool

    ReplyDelete
  3. @Manu: Both options are working only. what error are you getting? once created ODBC - DSN Connection then try to import via Admin tool --> import metadata

    Regards,
    Deva

    ReplyDelete
  4. @Rafik: the best way try to do it via Catalog manager(offline mode)-->this method you no need to down PS and all other services.from the begning i too faced such a issue then resolved by catalog manager offline method to set the object level security ..

    Regards,
    Deva

    ReplyDelete
  5. Hi Deva,

    My requirement is as follows:

    An external table having the following columns:
    USERID - ID of the user
    USERNAME - Name
    USERPSWD - Password
    REPORTURL - Axctual report url from OBIEE1agdashboard

    Now, my requirement is such that whenever a user from the above table logs into analytics, he should be able to view ONLY the report urls entered corresponding to his/her name.

    I am trying to get the external table authentication to work. We can then add/delete user info and report url to this table and accordingly different users will have access to different reports.

    Thanks n Regards
    Dev

    ReplyDelete
  6. Hi Deva,

    Can I include your blog in my blog roll?

    Thank you,
    Dhar

    ReplyDelete
    Replies
    1. Hi Muralidhar,

      yes, please share your blog name.thanks

      Regards,
      Deva

      Delete
  7. Hi, if possible make sql to date range, on filter column

    OBIEE Date Expressions Reference
    column1 sale filtered
    Current month (1apr2013 to current_date -- 16apr2013)

    column2 sale filtered
    Current month (1apr2012 to 30april2012)

    I make first column
    FILTER("Sales Amounts"."Revenue" USING (("Date"."Date" BETWEEN TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE) AND CURRENT_DATE)

    But I how make other column2 MTD (last year) or last year complete month.

    ReplyDelete
  8. Hi, Thanks for this blog, which is very helpful :) , Could you please let me know how or from where start to become an OBIEE 11g, administrator, please, and also I would like to become an OBIEE 11g certificated, is the Oracle Business Intelligence 11g Developers Guide the correct book to get this goal?

    Thanks & best regards.

    ReplyDelete
  9. Hi Deva,

    I have one doubt about Heirarachy in OBIEE 11g. The scenario is below.
    I have 2 heirarachies and one is Year->Month->Week->Date and another one is Year->Date. If i am selecting year column from Dim_Time from SA, which year will drill down in report?

    Please reply

    Thanks,
    RJ

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

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

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

    Thanks,
    Rejo

    ReplyDelete
  11. Hi,

    I have a requirement to generate OBIEE Repository (RPD) file out of XUDML (XML) file.
    I am generating XML file based on the metadata available in OFSAA product and it is happening at the WEB layer which is deployed on the different physical machine.

    Questions:

    Do we have any API available in OBIEE, which I can call it from my WEB page?
    Do we have any web services in OBIEE (which is exposed to the external world) where I can pass my XUDML document and generate RPD out of it?
    Can I copy some jars (which used to generate RPD) out of OBIEE deployed area and bundle in my product EAR file? If yes, can I call RPD generation utility directly in my WEB and what is the class/method name with parameters I have to pass?

    I am having problem in communicating between two different application (my project & OBIEE).

    Please help me with this.

    ReplyDelete
  12. nice post and site, good work! This article is well written and quite informative. More articles should be written and you have just found a follower.and more visit
    sas training in hyderabad

    ReplyDelete
  13. Buy high quality and reasonable Mobile Skins, Cases & Tempered Glass screen protectors online. We give unmatched premium protection to your mobile, iPad and MacBook.

    ReplyDelete
  14. Carzshield is providing Paint Protection Film ( PPF ) services to protect car against scratches, paint fading and rusting.

    ReplyDelete