articles on OBIEE, Qlikview, Qlik Sense, Tableau and Informatica
Hi Deva,I have one issue on: Object Level Security Issue while login from EBS R12 to OBIEE 126.96.36.199.0 with different Responsibilities This Issue is whenever a user tries to 1. Single Sign On from EBS R12 system to OBIEE 188.8.131.52.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 responsibilityAs 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 issueDo you have any work around on how to resolve this without restarting the server?I appreciate your helpRegards,Rafik
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
@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
@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
Hi Deva,My requirement is as follows:An external table having the following columns:USERID - ID of the userUSERNAME - NameUSERPSWD - PasswordREPORTURL - Axctual report url from OBIEE1agdashboardNow, 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 RegardsDev
Hi Deva,Can I include your blog in my blog roll?Thank you,Dhar
Hi Muralidhar,yes, please share your blog name.thanksRegards,Deva
Hi, if possible make sql to date range, on filter columnOBIEE Date Expressions Referencecolumn1 sale filteredCurrent month (1apr2013 to current_date -- 16apr2013)column2 sale filteredCurrent month (1apr2012 to 30april2012)I make first columnFILTER("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.
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.
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 replyThanks,RJ
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 ErrorOdbc driver returned an error (SQLExecDirectW).Error DetailsError Codes: OPR4ONWY:U9IM8TAC:OI2DL65PState: 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
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.
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 visitsas training in hyderabad
Buy high quality and reasonable Mobile Skins, Cases & Tempered Glass screen protectors online. We give unmatched premium protection to your mobile, iPad and MacBook.
Carzshield is providing Paint Protection Film ( PPF ) services to protect car against scratches, paint fading and rusting.