Somebody will pat me , somebody will envy on me , somebody will congrats me , somebody will ignore me ….. That’s life ! From LinkedIn +200 Million members my profile viewed in top 1% list … ! Thanks LinkedIn for capturing every moments …
April 13, 2013
December 31, 2012
The WordPress.com stats helper monkeys prepared a 2012 annual report for this blog.
Here’s an excerpt:
About 55,000 tourists visit Liechtenstein every year. This blog was viewed about 210,000 times in 2012. If it were Liechtenstein, it would take about 4 years for that many people to see it. Your blog had more visits than a small country in Europe!
July 15, 2012
OBIEE 11g upgrade has a lot of issues and among couple of them common is on Conditional Formatting . This emphasis that even if the Catalog upgrade is successful there are some of the problem still persists in XML conversion engine of the Upgrade Assistant(UA) leading though several catalog defects due to malformed XML . This is another example as my upgraded 11g charts failing to show its conditional formatting which is was working perfectly in 10g ….
Lets deep dive on whats the issue …
Below is the conditional format definition in 11g which is aligned with 10g:
So ideally it should show Chart bars (which is generated from Combined request Pivoted Graph) and see the below comparison:
To understand the reason of why 11g chart not showing the conditional format I went through the full XML from Advanced tab of 11g and find the below discrepancies:
This is malformed XML generated by UA during the upgrade of 10g code .If we look into 10g Advanced XML this is actually decimal but for some reason UA failed to put correct literal against it .
So the fix is replace all the instances of string “untypedLiteral” with “decimal’ like below:
Now after applying the XML the 11g chart output like :
And voila …. the problem is fixed … There could be another workaround to copy your 10g entire XML to 11g and yes it should work :)
Enjoy ..till next time…
June 7, 2012
I thought to post this thread long time back during 220.127.116.11 version but just waited for 11g new release .5 and upcoming edition assuming Oracle might include this demanding features soon and still surprised there is no OOB feature included while we are in .6 now.
I know the couple of fellow bloggers already tried that and everybody could have different approach . So lets put what I had experimented in last year in .3 release which is still valid in .6 . And this approach and implementation still valid in 10g.
Its simple to have column header freeze adding some scripting with embedded content . I took a simple dimension and simple fact to create one Tabular report and one Pivot report in two different tab where I have applied same logic but just want to show that the feature still feasible in both view.
So lets see how it will look like after Tabular column freeze (I would rather say it is kind of floating column header attributes)
Now I have scrolled at the right pane and watch the year attributes. Now you can see that the column header retains.
Now see the implementation:
I have added Text and Embedded content in the dashboard page:
The text properties(HTML Markup checked): I can’t put it like text for your copy paste as the tag is restricted to use in wordpress and sorry for that Hence click on the image to get the detail view.
Embedded Content URL:
So I have created a simple tabular report with the above columns and saved it under my folder and referred that in the URL .
That’s it and you are done …
Now if you try to implement the same, you will see some alignment issue and in that case you need to adjust the Width and height and other parameters of HTML content to get the cropped column list . Note that in above implementation I just remove my title view from report .
Though the above design has a lot of other restrictions (Downloading , Column sort ) but there could be possible workaround for that. At-least you can get something which is better than nothing.
Similar way I did it in Pivot view :
In this case my Embedded URL is different: (note the Viewname param at the end which only pull the compoundView2 which is my pivot table)
Refer this same URL under the HTML content defined in above image as Text HTML Markup properties.
Let the soul of the above approach rest in peace once Oracle implements this as OOB functionality in upcoming releases !!! :)
And we expect this to be sooner than later …. Catch you again ..till then ….
May 14, 2012
Since(Oct 2011) I had started working on OBIEE 11g (18.104.22.168) for four different projects in parallel to up-grade the 10g to 11g lot of challenges have been faced specially with the Catalog and Environment issues. (You can see the already reported RPD issues under: https://debaatobiee.wordpress.com/2012/01/26/obiee-11g-up-gradation-rpd-gotchas-and-glitches/ )
I could report all of them in below threads with the possible resolution but as I am writing this blog now (actually I am bit late posting this thread L ) some of them already taken care of in 22.214.171.124 version however not all and bit surprised that though Oracle agreed to release the patch in .6 version and file the bug report they didn’t work out yet on those mentioned issues reported during .5 up-grade.
Worth to see the link here for possible changes in BI reports due to new features before taking the assumption that it is a bug.
As par my latest up-gradation from 10g to 126.96.36.199 is concerned it went well but still some of the defects which are already noticed in .5 not fixed yet, some of them appeared new and some of them totally ridiculous and critical too as per business perspective and some of them not reported yet to Oracle and hence no relevant information found in Support.
I am happy to categorizing them into two different areas below: (I have used .5 and .6 interchangeably to mean 188.8.131.52 and 184.108.40.206)
Running prerequisite checks…
Prerequisite check “CheckActiveFilesAndExecutables” failed.
The details are:
Following files are active :
ApplySession failed during prerequisite checks: Prerequisite check “CheckActiveFilesAndExecutables” failed.
System intact, OPatch will not attempt to restore the system
OPatch failed with error code = 74
Resolution is to change the Privilege of “C:\Program Files\Oracle\Inventory” directory from read-only to Read-Write with Full-Control . However that was never documented in Oracle OPatch Readme.
“Exceeded configured maximum number of allowed input records” onclick=”SAWMoreInfo(event)
Error Codes: EKMT3FK5
May 6, 2012
Hello friends, after long time , I am again back on track … I was quite busy with couple of my mandatory schedules for last couple of weeks!
So today my topic is what are the Performance tuning key measures useful while doing report Performance testing. There are lots and I just tried to pull most of them and cover the highlights which would be very helpful while doing the Report Performance testing. Actually this could be separated across several areas like sometime it would be from DB perspective, sometime Environment parameters and sometime it would be the Repository design perspective. However the target objective is same but we need to work well to understand the performance bottleneck from which angles! This will definitely come with the experience and the different challenging environment and every places different rules needs to be applied.
<!– Remove from the cache everything older than N minutes –>
<!– AbsoluteMaxEntries is the enforced maximum number of entries. When this maximum is reached –>
<!– subsequent queries will fail until the maximum is no longer exceeded. –>
<!– CruiseEntries is amount of entries the OracleBI Presentation server tries to maintain in its cache. –>
<!– Forces the cache to attempt to remove an old entry when MaxEntries is exceeded. –>
<!– Cleanup this cache every N minutes. –>
•Bitmap Join Indexes
•Gathering Stats 30%