About Me

This blog is written by a consultant with a concentration in Oracle Business Intelligence Suite. The primary goal of the blog is to spread OBIEE knowledge, connect fellow consultants, and help to learn more about various OBIEE’s tricks. I hope you find the content useful. I can advice you on your OBIEE implementations, audit or troubleshooting. Please contact me at andriy.yakushyn ||| gmail.com

1. Paid – To- Blog Disclosure – I am NOT paid to write this blog. This is a personal blog.

2. Responsibility

The opinions on this personal represent my personal views only. I do not represent or write on behalf of any agency, company or employer. I don’t represent views of my employer(s) or client(s). I’m not affiliated with Oracle, nor do I have any claim to their intellectual property.

3. Libel & Do No Harm

My intention is to “do no harm” and my posts are not counsel they are just my opinions and advice. What I write on my blog is not to be taken as fact nor absolute. I can not guarantee accuracy.  If people use my advice, tips, techniques, and recommendations, and are injured or damaged, I am  not to be held responsible.

4. Content Validity

Any references to third party sites  or mention of third party content were valid at the time of posting and may not be accurate though I will try and fix broken links and update where possible.

5. External Links

I am not responsible for the content of sites or blogs that I link to. These are third party sites that I am not responsible for.

6.Comments

I am not responsible, nor will be held liable, for anything anyone says on my blog in the blog comments, nor the laws which they may break in my country or theirs through their comments’ content, implication, and intent. I have to approve comnments first and have the right to refuse them.

7. Copyright

Original content on this blog belongs to me. If you want to use it then email me at andriy.yakushyn ||| gmail.com Feel free to trackback to the relevant post.
I don’t claim copyright to the works that I quote using fair use principle. If you find copyrighted material that you own on the site – please let me know and I’ll remove it.

46 thoughts on “About Me”

  1. Andriy,

    First of all, thank you so much for your blog! I just started working with OBIEE, loved it, and your posts are so handy!

    Could you please share your knowledge regarding messages that apear on charts in OBIEE?
    For example, when I have data with zeros in a column – chart can’t be created, of course. And when users click on “Select view” and they choose Chart – they have this message on the chart: “Couldn’t Create Image”. I’d like to modify this message for end users.

    If you can help me with this problem – that would be great! Thanks!

    Tetiana

  2. Hi Andriy,

    Thanks for the information you posted on your blog. Its really very informative and usful to me. I have one question. Is it possible to freez one of the graph ( or table) in Dashboard (its like two frame). What I would like to see is top around 20% of screen frozen (static) with one graph. Rest 80% will have more graph and user can scroll down. If you have idea how to do and could you please share with me, that would be great.

    Thanks
    Piyush

  3. Andriy,

    Great site. Is there any truth to the rumour that Metricsphere is merging with The EB Group?

  4. Hi Simon,

    Thanks for stopping by.

    I’d not know anything about Metricsphere merger. I think you’d better ask Jeff McQuigg or someone more familiar with the matter.

    Good luck

  5. Piyush,

    I’d think that it’s an extremely difficult task to bring in more frames into current design. That level of customization would require extensive editing of Oracle’s xml and css files and could actually be against their TOS.

    I hope you can find a work-around.

  6. Do you know if it is possible to specify down to the view when configuring a the “column format” “Value Interaction”? so I am specifying a value interaction drill to a detailed report and I want to specify the view(ie table, pivot table, compound view…) otherwise it appears to grab one of the views which may or may not be the view of the data I want the drill to render.

  7. Robert,

    Have you tried a compound view? For some reason, I suspect that the view by default would be a table view anyway. I remember seeing something like that in metalink.

  8. Hi,

    Could you please provide links or documentation so that i can get clear knowledge about BI publisher.

    Thanks in advance for any help and tips….

  9. I suggest you check out standard documentation first. Also, you can read OTN and some blogs from the blogroll.

  10. Dear blogger,
    I have an issue where a new admin made changes to our security in dev and made a mess. I cleaned all of it, except one issue; All non-admin users are unable to see the links to the dashboard on top of the screen. They can still access them via hyperlinks and read them without a problem, but they cannot see them. I opened all the privilages to them, but they still cannot see them. The admin group can see the links without an issue.
    Thanks for your help!

  11. @Gil Rozner
    Gil,

    My first advice – make changes again and restart all services (BI, Presentation).

    Second thing to do would be checking settings again in your Admin -> Manage Privileges Make sure that Access tab has Everyone in properties (except for “Access to Administration”). Also scroll down to see that your Subject Areas have Everyone there as well.

    Restart. If that didn’t help – I suggest checking properties of individual Dashboards in “Manage Dashboards” menu. The padlock icon is for security settings.

    Let me know if that helped or not – if not, it’d be helpful to know which changes to security were made.

  12. Hi,

    Iam interested to make my career in OBIEE,iam good at discoverer.First thing first i want to get the university documents on OBIEE,so it would be easy for novice like me.Would you help me in this regard.

    Thanks in advance.

  13. Kranthi,
    I’m sorry I don’t have those. However, I think that there’s plenty of material these days on OBIEE online – you just have to look for it.
    Good luck

  14. Hi andriy,

    Thanks for your prompt reply,i will search for documents.

    Can you guide me as iam novice to OBIEE,can you say what should i begin with the order in which i should read them,and what are important in OBIEE to get grip on it

  15. Hi andry,

    Its nice work of yours with this blog.In the long run i think it would be useful for me.Hope you would help me in this regards.

    For above message i read rittman mead posts,but i want your views/suggestions on how to go about and what to start first in OBIEE as iam a novice.

    Thanks in advance

  16. Hi, I am a recruiter. How can i post the job requirements in Jobs categories?

    Help needed

    Regards
    Sadeesh N

  17. Hi,

    Nice and usefull blog.Keep it up.

    I have requirement in OBIEE dashboard, the requirement is I need to group the reports in the dashboard,if I click the group name,the reports needs to be displayed in the dropdown manner.

    How I can achieve this?..I tried creating groups in the catalog manager and associated the reports but the reports are displayed in the side of the group.

    I would appreciate your quick response.

    Regards.
    Raja

  18. Hi friends,

    I am Deepika Paul working as recruiter and we have an urgent job opening with one of leading client in Hyderabad and Mumbai locations.

    Please find the below mentioned job description and forward me your updated resume if you are interested for the same.

    Job Role: ETL/OBIEE Developer

    Educational Qualifications: B.E./B.Tech./MCA/Other Graduates with relevant Software Certifications

    Experience: 2+

    Work Location : Mumbai & Hyderabad

    Job Description:
    Understanding of business requirements.
    Understanding of datawarehousing/ETL concepts
    Should have worked in ETL tools like Informatica.
    Should have good exposure in Oracle BI environment- Report and Repository (OBIEE)
    Client interaction experience will be preferred.
    Familiarity with onsite/offshore model.
    Awareness of CMM processes will be an added advantage.

    Soft Skills: Excellent spoken & written communication, Presentation & Inter-personal skills.

    Contact details: deepika.sanika@gmail.com

  19. Hi Andriy, Very useful blog, keep it up!

    Perhaps you can help me out with my problem?

    My second Fact table does not seem to be recognized as such in the Answers Pivot view. First time I encounter this behavior. Here is an example.

    In the Admin, I have one Fact table “Sales” and one dimension table “Products” mapped in both the Physical (by Foreign key) and the Logical (by complex joint) layers.

    While creating a report in Answers, when I drug and drop “Product Name” and “Dollars” columns into the Pivot view, it works just fine. The “Dollars” automatically go in the “Measures” box and the “Product Name” goes into “Rows” box.

    However, when I create an identical second Fact table in Admin – “Last Year Sale” and map it to the same “Product” dimension, it becomes yellow but does not behave as fact table in Answers! Now, when I create a new report in Answers, the “Dollars” column from “Last Year Sale” refuses to go into “Measures” box and jumps into the “Rows” box instead.

    The results get displayed correctly though.. However, when I try dragging the “Dollars” into “Measurements” box where it belongs, all the values disappear from the “Dollars” column on preview, while “Products” column remains populated with values.

    Any ideas will be highly appreciated! Thank you very much!

    Roger

  20. Roger,

    Without getting too deep into specifics of your OBIEE mode. I think you’re trying to use an older way of modeling PY reports. I suggest you look into time-series functions (AGO, TODATE) – as they’re the preferred way of dealing with historic metrics in OBIEE.

    Also, check everything, starting from physical tables

  21. Andriy – thank you for a quick response!

    Interestingly enough, this case has nothing to do with any functions, table joins and so on.

    Actually, now I can’t get even a single fact table to pivot!! I made a new .RDS file in Admin from scratch, with just two tables in it: “Products” dimension (“Product_Id”, “Product_Name”) and “Dollars” facts (“Product_ID”, “Dollars”). They join on “Product_ID” as a foreign key in phisical layer and as a “complex join” in the business layer.

    My report has only 2 columns: “Product_Name” from “Products” dimension and “Dollars” from facts. Ana I can’t make the “Dollars” go into the “Measures” box in the pivot view!! When I grug it there, the “Dollars” column is loosing all the values on the preview!

    Perhaps you may have some clues as to what to look at to debug it??

    Thank you very much!

    Roger

  22. Excellent website. Bit about me.
    I am a PMI certified sr.project mgr. I have close to 13 years exp and about 5+ years in Oracle Apps, managing multiple projects. Currently, handling Oracle EBS R12 implementation with DWH project. New to OBIEE and Informatica power center and I am a HANDS ON project manager. Will visit / recommend this site to the entire team. Good work and keep it up

  23. Raj!

    Thank you for your kind words. I’m wondering what were the biggest challenges while implementing Oracle Apps?

    Thanks

    Andriy Yakushyn

  24. Andriy,

    Good blog. Could you possibly give me a few private lessons? I am local to NYC.

    Regards,

    Egor

  25. Hi ,

    I got the following error while installing 10.1.3.3.1 Oracle BI Suite .

    nQSError: 46036 Internal Assertion: Condition GetAdaptersinfo( pAdapterinfo.get(), &ulOutBufLen) == NO_ERROR, file .\Config\SUSystemConfig.cpp, line 1297.

    while the installation shows it is completed successfully ..
    but admin tool is not started ….
    even the BI server also is down and says – process terminated unexpectedly ..

    Please help me out in this regards …

  26. Andriy –

    Hi – I have a question concerning training/learning OBIEE. I have many years as an Oracle consultant using Oracle Developer Suite, PL/SQL, interface and conversion work, Oracle ERP Suite, etc. I have always been working in this area, but would like to train myself in OBIEE. I have recently been laid off and feel that I need to beef up my skill set.

    Do you have any recommendations? I see some things on the OTN website, etc.

    Thank you in advance for your time and response.

    Regards,
    Van

  27. I am new to OBIEE and I need the ability to automate extracts from OBIEE down to my desktop. Is there anyway possible to pass parameters either thru an IBOT or IQY? Any help would be appreciated.

  28. IBOT is exactly what you need – via either FTP or email. And yes you can pass parameters. Good luck

  29. Hi,

    I am very new to OBIEE .I have a question regarding alerts. We have displayed all the alerts in the dashboard. On clicking the alert, it pops up the applet and shows the relevant records. I would like to know if the records can be displayed in the dashboard, without clicking the alerts. say, i would like to display to the alert as header section and beneath it all the records of that alert.

    Thanks in advance

    Thanks
    pradeep

  30. We are building a dashboard page for our Top 10 Customers. The compound layout view consists of a chart (bubble) and a table. When we choose to drill into the customer hierarchy, via the bubble chart or the table we receive this error:
    State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 59031] A query cannot contain multiple instances of TopN or BottomN. (HY000)
    When I remove the Chart and have only the table, I can successfully drill down to the lower level of the customer hierarchy. Is this a bug in the software or just a limitation when using the TopN function in your answers query.

    Thanks,

    Mary

  31. Hi

    I’ve created a number of ibots to deliver a few different reports to user destination of interactive dashboard. The ibot runs, publishes the link and I can view the output with no problems. The problem is the output opens in a new window with no option to download, print etc. Am I missing a step along the way?

  32. Hi,

    I am trying to include company’s website as a portal links in my dashboard. Is there a way to display External URL as link and not as a embeded content in the dashboard since look and feel is very important, I want them as link where all other dashboard links are displayed in the portal banner.
    I think its possible and i have seen them in one of the blogs but i couldn’t find it so any help regarding this would be appreciated.
    Thanks

  33. Hi,

    I wanted to know weather we can implement Obiee in the unriversites or any controlling body of the educational system through Bi-Apps

    If yes then which module/subject areas of prebuilt analytics to be used.
    Thanks..

  34. Hi,

    Thanks for your posts – i have reviewed some of them and they have helped me get a basis using OBI.

    I am currently trying to combine 3 data sources in the physical layer into one in the logical layer. I have done this by creating 3 logical sources to the physical layer. It seems to work fine except that the report only pulls information from the first source (not all 3). Do you have any knowledge on how to combine sources. I would like to get a UNION of all the data for criteria such as date range.

    Any help would be appreciated :)
    Thanks
    Una

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

  36. Hi,

    I have a requirement, I need to embed OBIEE Reports (Dashboard) and Answers in my web application. I already have a URL with Username / Password and other parameters appended to it. When this URL is run independently in the Browser, it works fine and displays the Executive Dashboard reports with multiple tabs i.e. Sales Stats, Order Management etc. and user can easily navigate through the tabs.
    But the problem is when the URL is embedded in a page as inline frame and page is run, the first tab (Sales stats) is displayed properly, clicking on any other tab redirects the user to the Login page (This is within the web application context), I am not sure what is wrong?
    Is there a way where in we can configure in OBIEE to remember login information? Or is it something to do with SSO stuff?

    Please provide your inputs.

    Thanks & Regards,
    Vineet

  37. Hi,

    Woud it be possible to create a check box prompt as a dashboard prompt in obiee

    Thanks & regards
    Kroshna

  38. Hi

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

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

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

    Thanks & regards
    Krishna Mohan

  39. Hi,

    I am new In OBIEE.
    I have created ONE GROUP and ONE USER in it..I have selected all the privileges for this group restarted the OC4J, services and the server itself.I think the must be something missing.. could you please help me out with this problem its quite urgent?

    Regards,
    Cheers

  40. Do you think it’s advisable for someone without any programming or database knowledge to take OBIEE classes? I dont have much work experience either, but in college studying networking and telecommunicationns.

    Thanks so much.

  41. are there any predefined functions in cache manager?
    if exists what are they ? how they can be used?

Leave a Reply