Oracle MOS HTML Update 30052010

 Document ID   Title   Doc Type   Modified Date 
950086.1 Error “You are not authorized to view this page” when opening up OBIEE Anaswers or dashboard PROBLEM 28-MAY-10
1108438.1 Do We Need To Install The Fusion MiddleWare 11g Repository Creation Utility (RCU) With OBIEE 10g (10.1.3.4.1) And Weblogic Server? HOWTO 28-MAY-10
790831.1 unable to run ibots as repository user PROBLEM 27-MAY-10
751922.1 About deleting the old alerts from the User’s Dashboard HOWTO 27-MAY-10
1108515.1 Oracle BI Scheduler Error nQSError 68019 Authentication Failed When Trying To Save An iBot After Setting Up The Scheduler PROBLEM 24-MAY-10
1111583.1 Admin User Not Able To See Some Of The Ibot Job PROBLEM 27-MAY-10
796842.1 [nQSError: 75005] Failed to Send AUTH Command. 5.7.3 Authentication Unsuccessful Running iBots and no Email Message is Sent by Them PROBLEM 28-MAY-10
1110617.1 Job Manager Launch Fails PROBLEM 26-MAY-10
763793.1 [nQSError: 59001] TimestampAdd operation is not permitted on DOUBLE PRECISION operand(s) PROBLEM 27-MAY-10
758343.1 OLTP Activity created date is incorrectly displayed in Analytics. HOWTO 27-MAY-10
780242.1 Unable to constrain prompt when ‘Show SQL Result’s option is selected HOWTO 27-MAY-10
1109385.1 Current_fcst_date Variable Erroneously Set To YYYY-MM-DD HH:MI:SS.000. The .000 is causing EUE9D5XW error in prompts PROBLEM 25-MAY-10
781288.1 Facing issues with adding a OR condition to a filter in a query PROBLEM 27-MAY-10
817183.1 Passing the selected Prompt values from one dashboard to other dashboard HOWTO 27-MAY-10
1110355.1 How To Resolve The Error – OPR4ONWY U9IM8TAC OI2DL65P Subquery Contains Too Many Values For The IN Predicate HY000 When Using A Subquery. HOWTO 26-MAY-10
1091476.1 How To Globaly Set Formatting Options In OBIEE HOWTO 25-MAY-10
740919.1 Analytics – Issues with save selection functionality in dashboard PROBLEM 24-MAY-10
729852.1 Sum Total greater then actual number – Analytics PROBLEM 24-MAY-10
1108194.1 Unable To Format Labels Of A Total Rows Section Of A Pivot Table. PROBLEM 24-MAY-10
799173.1 Apply a numeric value from prompt to be used in a calculated column in a request HOWTO 27-MAY-10
816973.1 BI Office Plug-in converting text values to date PROBLEM 27-MAY-10
759131.1 Multi-Sort on table headers with Ctrl-click does not work for Mac Firefox PROBLEM 24-MAY-10
741897.1 Answers AVG Function not displaying result with decimals PROBLEM 24-MAY-10
742235.1 USER GETS AN ACCESS DENIED ERROR MESSAGE WHEN TRIES TO SWITCH DEFAULT DASHBOARD PROBLEM 24-MAY-10
1108594.1 OBIEE Dashboard Date Prompts & Date Presentation Variables Errors after Upgrade to Version 10.1.3.4.1 HOWTO 26-MAY-10
744300.1 Blank page appears when user navigates from one dashboard page to another PROBLEM 24-MAY-10
739830.1 Missing company record on the dashboard PROBLEM 24-MAY-10
751935.1 How to reset the default setting of the multi-select prompt HOWTO 27-MAY-10
815755.1 Query failing for user having ‘(apostrophe) in their name PROBLEM 27-MAY-10
1091253.1 Date Prompt Calendar Search Incorrectly Returns Format YYYY-MM-DD HH:MI:SS And Error – A Date Was Expected QABPH2PO PROBLEM 26-MAY-10
729853.1 How to use UI colors of Siebel Analytcis 7.8 after BI 10g upgrade PROBLEM 24-MAY-10
956342.1 [NQSERROR: 46029] FAILED TO LOAD THE DLL LIBNQSDBGATEWAYOCI10G.SO RUNNING REQUEST PROBLEM 28-MAY-10
1101553.1 IE6 Client Intermittently Hangs And/Or Crashes With OBI Dashboards And Answers After Adobe Flash 10 Upgrade PROBLEM 28-MAY-10
1108451.1 ALERT: Technical Notes for Patch 9492821 (QF 475) – Modifying Reports to conform to DATE & DATETIME format Enhancements in 10.1.3.4.1 and higher versions BULLETIN 26-MAY-10
1102353.1 How to Enable Change Password link in My Account in Settings HOWTO 28-MAY-10
750541.1 Data Type issue in Direct Database Request using a SUM function in the SQL query PROBLEM 27-MAY-10
751094.1 Multi-Select Fields in Dashboard Prompt does not work with NULL values in the selection PROBLEM 27-MAY-10
751946.1 ‘CASE WHEN’ columns do not display data in pivot table view PROBLEM 27-MAY-10
803874.1 Issues with Filter in a??Sales – Orders and Invoicesa?? for Promised Month PROBLEM 27-MAY-10
1111386.1 Ora-00928: Missing Select Keyword At Oci Call Ocistmtexecute [Nqserror: 17010] Running Request PROBLEM 27-MAY-10
528540.1 nQSError: 17011 PROBLEM 25-MAY-10
1102315.1 Overriding Default Aggregation Of Sum to Avg Does Not Work with OBIEE Answers Report HOWTO 28-MAY-10
1111405.1 Migrating OBIEE Repository across environments BULLETIN 27-MAY-10
747939.1 Not possible to open PDF Attachments when file name is long and contain special characters PROBLEM 24-MAY-10
785318.1 BI Office executing a request even before prompt is applied HOWTO 24-MAY-10
1112495.1 Physical Schema Xxx Is Not Referenced In Any Project. PROBLEM 28-MAY-10
1110707.1 OBIEE RPD’s consistency check hangs with multiple levels of hierarchy HOWTO 26-MAY-10
740367.1 How to create cumulative line chart? HOWTO 24-MAY-10
1102665.1 Po Quantity Is Different In Cycle Lines Subject Area And Po Subject Area PROBLEM 28-MAY-10
948283.1 OBI server cache cannot be shared among users with individual DB connections HOWTO 27-MAY-10
787366.1 Why are temp tables being created by the analytics/OBI system? BULLETIN 24-MAY-10
796166.1 How to Force Excel Add-in to Ask for Userid/Password to Analytics Everytime a Refresh is Run? HOWTO 28-MAY-10
1097725.1 Direct Database request in Anwers replaces image URL with text string HOWTO 27-MAY-10
1110354.1 Security Validation exception error when we access Bi Publisher From Obiee PROBLEM 26-MAY-10
1107170.1 Obiee Connectivity With Sql Server 2008, [nQSError: 16023] The ODBC function has retuned an error. PROBLEM 24-MAY-10
1110554.1 Alias Tables Are Joined In Queries Unnecessarily PROBLEM 28-MAY-10
751139.1 Requesting a new version of SQLServer_nQ_Clock.sql for Usage Tracking HOWTO 27-MAY-10
1110374.1 Cast As Date Returning Datetime PROBLEM 26-MAY-10
1112396.1 How to Pass Parameter To a Stored Procedure In Siebel Analytics 7.8 HOWTO 28-MAY-10
759098.1 ABILITY TO PASS PRESENTATION VARIABLES INTO CHART TITLES HOWTO 27-MAY-10
743691.1 MERGE BUTTON IS GREYED OUT IN A MULTI USER DEVELOPMENT ENVIRONMENT PROBLEM 24-MAY-10
1112444.1 Create Target List functionality fails when Japanese characters are used in the request filter PROBLEM 28-MAY-10
1104817.1 Nqserror 14026 Unable To Navigate Requested Expression Error With Out Of The Box Spend And AP Invoice RPD PROBLEM 24-MAY-10
729856.1 About error: Item already exists in catalog HOWTO 24-MAY-10
1058283.1 Navigating From OBIEE-More products > BI Publisher Get Error” Reporting Login: java.net.ConnectException: Connection refused” PROBLEM 24-MAY-10

Source: Oracle MOS HTML Knowledge Management

MOS HTML updates

Thanks to Timur Akhmadeev’s blog I found the solution for the broken links in the MOS HTML updates mail from Oracle Support.

Links in an email are like this:

https://supporthtml.oracle.com/ep/faces/secure/kmDocumentDisplay.jspx?id=1062675.1

but should be like this:

https://supporthtml.oracle.com/ep/faces/secure/km/DocumentDisplay.jspx?id=1062675.1

– note the extra slash between km and DocumentDisplay.

For more details, check Timur’s blog.

Oracle Spatial Workshop

“Knowledge is Power”. Exchanging knowledge is a very effective way to gain knowledge. Not only for the audience, but also for the one who shares the knowledge. It obviously takes a lot of time and effort to prepare a good presentation about a certain subject.

In my company; Scamander Solutions, there is set a lot of value on exchanging knowledge between our consultants. One  of the methods we use is our so called; Pizza Session. These are internal sessions in which one of our consultants prepares a four hour (handson) session about any Oracle related topic, which interests us. At dinner time we eat pizza.

Next wednesday we will  cover the subject of Oracle Spatial. This session is organized by Maarten Jan Kampen. Since last year Maarten Jan is a well known speaker on several different forums and events.

Maarten Jan will present us a handson session in which he will address the following topics

  • Oracle Spatial in general,
  • Oracle Spatial in terms of  query possibilities,
  • The contours of our office will be used to show on the map and to make queries,
  • Oracle Spatial and Oracle BI.

It’s promised to be interesting.

Keep you posted.

How To Ask Questions The Smart Way

 I am a frequent visitor of the  Oracle BI EE Forum. Either to share or to gain knowledge. Sometimes I am supprised by the way people ask questions. It is a misconception to think people can read one and others minds.

An excellent example of one of those questions has been posted last week.

I will not be pointing fingers. John gave his reaction in a very decent way. What I do want to make clear is that proper asked questions as well as correct and clear answers will add value to a forum. It takes some time to answer questions. Some people take the effort to write blog posts about the subjects. I think we could make each other’s lives a lot easier if we take the time to give enough input at front and some feedback afterwards.

Please take note of the following and try to keep the forum valuable as it is most of the times.

Thank you all.

RittmanMead BI Forum 2010 – Wrap Up

 That’s it, the RittmanMead BI Forum 2010 is over. Jon and Mark managed to organize a three day conference with a combination of Oracle BI knowledge and a lot of fun. I guess they could be very proud to have a visitor list of people from all over the world.

I have been one of the lucky ones who were able to attend this forum. Finally I have been able to meet some of the guys I got to know via; various blogs, The Oracle Forums, Twitter and LinkedIn. It’s nice see people behind all the internet postings.

Next to that the RittmanMead guys were able to present various different ways to exchange knowledge. Also they were able to mix business with pleasure.

As I already have written about in several earlier postings we were able to attend several different presentations about Oracle BI EE, ODI, Oracle Fusion Middleware, etc. Architecture, sizing, performance and modelling were some of the topics that were covered.

Some of the highlights:

Kurt Wolff gave us a little background about the development of Oracle BI EE.

Phil Bates and his Oracle colleagues gave us an overview of the new release of Oracle BI EE. There were not allowed to give us the version (11g) of this release nor the date this release is due.

Emiel and Christian lead a debate about modelling in Oracle BI EE. They had the best opening slide ever!! It was nice to hear the different opinions about this subject. (Un)fortunately there was no winner to this debate. As Kurt has said at the beginning of his presentation; There is no ‘Best Practice’ when it comes to Oracle BI EE (modelling)

Although Robin Moffat was a little bit nervous about his presentation he was chosen as the best presenter at the forum. In my opinion he had a well researched presentation, which he delivered to the audience in a very easy going way.

As a real quizmaster, Adrian was able to show the funny site of Oracle BI EE.

The ultimate geekness in using Twitter was reached by Christian and Robin. Robin making a picture of  Christian making a picture of me using Twitter.

Thursday evening we went to Brighton’s Kemp Town to Sam’s restaurant. I was suprized be the good food they were serving. Mark was even more suprised how a Dutch guy could question the English kitchen.

Last but not least we did a little bit of ‘Last man standing’. Börkur, Adrian, Paul and Ragnar showed us how to get through the Brighton night. The recipe is very easy; Beer, Rum and a few Jägerbombs

All in all I am very glad I could join the forum. I have enough food for thought to make it through the year.

If you want to get an another impression of this forum, please check the following;

Thanks RittmanMead, thanks to all presenters, thanks to everybody who has made this event a success!

Good Luck and till next year

RittmanMead BI Forum 2010 – Notes IV

After a few hour of sleep it was time for the last part of  the RittmanMead BI Forum 2010

First one to kick off was Anthony. He gaves us an very well examined explanation of Oracle BI EE architecture and sizing. Although there is a lot more to it; Keep it simple!!

Secondly Mark stepped inside the Oracle BI Server. He presents u day in the live of a Answers query.  If you want to understand what’s happening, you should try to think like the Oracle BI Server. In  addition to that, you have to take a closer to the Logical Table Source.

Craig Steward showed us the new, version of Oracle Data Integrator. I must say it looks very interesting, but up until this moment I haven’t had/took a chance dive into ODI yet. Something for the coming period probably.

Adrian presents the results of the quiz. It’s nice to see how easy it can be to present a ‘geeky’ subject like Oracle BI EE in a hilarious way. John was one of the winners.

John was also up next. He started well-dressed with a Ciber tie. There are pictures taken so the management board of Ciber will know. His presentation was about the look and feel of Oracle BI EE. As said before in different other presentations;

Last but not least Venkat showed us how to integrate and extend Oracle BI EE with Oracle 11g ADF components. There remains an awful lot to learn.

It was good to be here!!

RittmanMead BI Forum 2010 – Notes III

As said in one the earlier postings about this forum Emiel continued whith his own way of modelling Oracle BI EE. His presentation is a sequel to his last year’s winning presentation.

A few of the things he addressed:

  • User Centric Approach
  • Level of Information
    • BI Maturity (growth)
    • Validation
  • Business Model
    • Know your business
  • Use the (power of) the database
  • Reuse your data

Adam Bloom gave us an impression of the Action Framework in the new (11g ?) release. This new framework consists of:

  • Insight into Action
  • BI on the Business Process
  • BI in the Business Process

It seems like a very powerfull addition to Oracle BI Systems.

Adrian Ward has been given the privillige to host the RittmanMead BI Quiz. This quiz consists of all things you are supposed to know, but sadly overlooked.

The nerdy part of the day started with a debate about modelling your BI System. The debate was hosted by Emiel and Christian.

They divided the debate in;

….  to model what;

  • external information
  • internal information
  • internal processes
  • externalprocesses

….and where to model;

  • Presentation side
  • BI Server
  • Database / DWH
  • (ERP -) System

This subject lead to a lively discussion. In the end I think there is no wrong or right. What I do think is, that when you look at Adam’s presentation, it’s possible that the ERP-system and the BI systems get more and more integrated. The Datawarehouse could be serving as a hub to store and retrieve the data.

We ended with a nice meal and an opportunity to beat Börkur as the ‘Last man standing’. What happened in Brighton stays in Brighton.

More to come.