This is a post where you can put all your questions which aren't related to any subject on this blog (Yet). This way we can avoid the clutering of the blog.
But before you ask, if you are in a hurry ask your question on the OTN forum first. (http://forums.oracle.com/forums/forum.jspa?forumID=378) Altough I try, I'm not always able to read the postings from this blog.
Till Next Time.
Dutch only this time:
3 Juni is het weer zover, de tweede versie van OBI Forum Live.
Zoals u waarschijnlijk al gehoord hebt zijn de eerste sprekers al bekend; Mark Rittman (RittmanMead) en Emiel van Bockel (Centraal Boekhuis).
Wij zoeken natuurlijk nog veel meer boeiende sprekers.
Dus heeft u een goed verhaal over uw uitdagingen met OBI - EE en wil u die met de rest van de Nederlandstalige gebruikers delen, neem dan even contact op: john punt minkjan at ciber punt nl of +31 (0)40 - 232 90 90
Tot 3 juni
Just a small overview of the available patches
8293083 : OBIEE GENERATED MDX CAUSES PERFORMANCE ISSUE
8290868 : AFTER PATCH 7482937 APPLIED MDX NO LONGER COMPATIBLE WITH ESSBASE
7486770 : MULTI USER PROJECT CHECK IN DELETES COLUMNS FROM SOME OTHER UNRELATED PROJECT
7488780 : DEFAULT SQL CANNOT USE PRESENTATION VARIABLE OR REQUEST VARIABLE
8251994 : HRESULT ERROR OR UNKNOWN ERROR IS COMING ON BI OFFICE WHILE INSERTING A BI REPOR
7349048 : BI SERVER HANDLING OF ESSBASE SECURITY FILTERS
7669454 : OBI SERVER CRASHING
7568985 : ESSBASE MDX ERROR FOR OR CONDITION WITH UNQUALIFIED MEMBER OFF
7634813 : ANSWER REPORT WITH PROMPT IS RUNNING THE REPORT WITHOUT WHERE CLAUSE IN THE DB
7331425 : CANNOT CHANGE COLUMN POSITION ON COMBINED REQUEST
7521870 : REPORT FOOTER NOT SHOWING WHEN NAVIGATED FROM A DASHBOARD REQUEST
7642637 : NQSECUDMLGEN EXTENSION FOR LIFE SCIENCES DEVELOPMENT TEAM
7482937 : INCORRECT ESSBASE MDX FOR LOGICAL QUERY WITH OR/AND FILTER ACROSS LEVELS
7189308 : OBIEE BRIEFING BOOK READER NOT WORKING ON WINDOWS VISTA
7373627 : AN LDAP USER THAT RUNS AN IBOT DOES NOT SEED THE CACHE
7462652 : DISCONNECTED SYNC PROCESS LOOPS WITHOUT REACHING AN END
7302600 : CATALOG MANAGER CLEAN-UP OF ORPHANED USER RECORDS
7140673 : OBI PRESENTATION SERVER CRASH IN PIVOT TABLE
Till Next Time
Just a nice gimic, the OBIEE image prompt. First get a image, I used this one: http://www.faqs.org/docs/htmltut/images/testmap.gif
Create a image prompt:
Next use the HTML SHAPE tag to add the coordinates: http://www.faqs.org/docs/htmltut/images/_AREA_SHAPE.html
<MAP NAME="map1"> <AREA HREF="contacts.html" ALT="Contacts" TITLE="Contacts" SHAPE=RECT COORDS="6,116,97,184"> <AREA HREF="products.html" ALT="Products" TITLE="Products" SHAPE=CIRCLE COORDS="251,143,47"> <AREA HREF="new.html" ALT="New!" TITLE="New!" SHAPE=POLY COORDS="150,217, 190,257, 150,297,110,257"> </MAP>
Press Extract Image Map from HTML
add the column and value.
Till Next Time
Sometimes you need a between prompt on a date but the fields but you can't use the normal is between because of the complex filter. Here is a possible workaround. In the repository create a dummy table called Dates with two columns Date1 and Date2 based on the current date.
Next create a prompt and put the result in two presentation variables:
Next create the complex filter:
Till Next Time
In a recent article: http://obiee101.blogspot.com/2009/02/obiee-switching-between-filters.html I showed you how to create dynamic filters. This time I want to show you on of the ways to create dynamic prompt content. First create a small dropdown prompt which contains a FilterName LOV:
