some new features:
more later…
or check this page for mpore details: http://www.peakindicators.com/index.php/knowledge-base/110-new-features-with-obiee-11116
I was starting to get worried, after the patch 2 weeks ago (which was normally the release date of OBIEE 11.1.1.6) I thought this version would be skipped. But luckily here it is.
What’s in the new version, this will be revealed very soon. But from my first sneak peek it’s some visual improvements, some end-user improvements and (why this version HAD to come out) the EXALYTICS “compatibility (it’s this version,but tweaked, which will be delivered on the machine).
Have fun…
There is a check inside OBIEE that checks the version of the browser after the last slash.
If the version of Firefox > 2 then OK else NOK.
If you’re using Firefox v10-v19 
then use one of the folowing solutions/workarounds:
Watch out when renaming objects often the links (dependencies) are done on name of the object. Which is still a bit weird. I know that might (and this is probably the reason why) skip potentiel problems with/between different work repositories. But then i thinks ODI should not allow you to change the name of the object. Or they should add an extra unique non changeable field: “Object code” (which is by default the same as the object name).
A little example how anoying that is:
Here i have an Interface called “DIM_ORG_FL2PL”. You can see the history list of the executions of that interface.
Now I gonna rename the interface into “DIM_ORG_FL2PL_RENAME”.
Go back to the execution tab and hit the refresh button.
Yep, no history. Strange because it’s that interface i’ve been running before.
Change it back to “DIM_ORG_FL2PL” and you will see you history executions again.
Aarggggg got my wordpress blog “Orapunk.com” hacked by some Russians with their Blackhole exploit. Problem should be solved by now.
Today i saw a nice explaination by a guy called Bharath, who explained how to change Report edit link to go Criteria tab instead. Here comes the explaination:
You can modify it by editing the dashboardeditor.js file found in /app/res/b_mozilla/dashboards folder.
Steps:
1) Open dashboardeditor.js file.
2) Search for the function “DUIModifyReport”.
3) Inside the function you will find “&Action=results&Path=”
4) Change “results” to “criteria”. The changed code will look like “&Action=criteria&Path=”
5) Re-deploy the code and bounce the services.
If you want to avoid step (5), then manually copy the changed dashboardeditor.js to /user_projects/domains/BIfoundation/servers/bi_server1/tmp/_WL_user/analytics_11.1.1/$RANDOMFOLDERNAME$/war/res/b_mozilla/dashboards and bounce the services.
Here is the math formula to do a Rolling Multiplication.
This will only work if there are no 0 values.
select exp(sum(ln(column_name))) from table_name
Thanks to the dms_metadata package there is a possibility to create the ddl statement of a database object. In the next example the ddl’s of all tables of the current user will be created:
SELECT DBMS_METADATA.GET_DDL('TABLE',u.table_name) FROM USER_ALL_TABLES u WHERE u.nested='NO' AND (u.iot_type IS NULL OR u.iot_type='IOT');
