OBIEE Blog

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

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

Andriy,

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

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.

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….

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!

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.

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

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

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

Help needed

Regards
Sadeesh N

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

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

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

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

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

Andriy,

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

Regards,

Egor

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 …

can any body detail step of obiee integration with ebs

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

Hi Andriy

Is the beta version of obiee 11g out? From where can i get it?

Thanks
Rajat

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.

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

There are no mesures in request . At least select one measure.

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

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?

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

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..

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

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?

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

Hi,

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

Thanks & regards
Kroshna

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

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

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.

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