Sunday 18 November 2012

Edit Analysis and navigate to Criteria Tab-11g

Always when you edit the analysis, you would be navigated to the 'Results' tab by default and then again you need to click on the 'Criteria' tab, to edit.
There is an option to go to criteria tab when clicked on edit analysis.
This feature is available now in 11.1.1.6 in 'My Account' section.

People might have noticed this, but might not have tested the change.

 
Next time when you click on edit analysis, the system will take you to criteria tab.

 

Thursday 8 November 2012

11g Removing the Gray Header from Reports


In 11g, the user can right click on the pivot table report and do sorting excluding the column etc.. also a little grey header on the column heading appears.
This feature is good to some extend and worse in most of the cases. Supposing the user wants to disbale all this, then there should be a way out :)

To remove the gray color tab appearing above the column headings in the pivot table.

Just Edit your analysis and then click on "Analysis Properties dialog" then select Interactions tab here you uncheck all the Interactions link then save it and test it.
 
 If you want to disable enitre report just add below content in your instanceconfig.xml file then restart bi presentation services then test it out.

Include the elements and their ancestor elements as appropriate, as shown in the following example:
<ServerInstance>
<Analysis>
<InteractionProperties>
<InteractionPropertyAddRemoveValues>false</InteractionPropertyAddRemoveValues>
<InteractionPropertyCalcItemOperations>false</InteractionPropertyCalcItemOperations>
<InteractionPropertyDrill>false</InteractionPropertyDrill>
<InteractionPropertyGroupOperations>false</InteractionPropertyGroupOperations>
<InteractionPropertyInclExclColumns>false</InteractionPropertyInclExclColumns>
<InteractionPropertyMoveColumns>false</InteractionPropertyMoveColumns>
<InteractionPropertyRunningSum>false</InteractionPropertyRunningSum>
<InteractionPropertyShowHideSubTotal>false</InteractionPropertyShowHideSubTotal>
<InteractionPropertySortColumns>false</InteractionPropertySortColumns>
</InteractionProperties>
</Analysis>
</ServerInstance>

For More Refer Oracle Note:
http://docs.oracle.com/cd/E23943_01/bi.1111/e10541/answersconfigset.htm#BIESG3772
18.3.4 Manually Configuring for Interactions in Views

 Result-


Or to individual pivot table report,  add this code in the static view and append it to pivot table view


<script type="text/javascript">
var tds = document.getElementsByTagName('td');
var lCSS = new Array();
for(var td=0;td<tds.length;td++){
if( tds[td].className != 'PTCC' ){
if( tds[td].className != 'PTCHC0 PT_CPLCHLD PTLC' ){
continue;
}
}
tds[td].style.backgroundColor="#FFFFFF";tds[td].style.display='none';
lCSS.push(tds[td].innerHTML);
}
for(var len =0; len < lCSS.length; len++){
}
</script>

Comments are always welcome...

Monday 5 November 2012

OBIEE 11.1.1.6BP1 not showing graphs correct in Chrome

OBIEE 116BP1 graphs dont appear or looks bad in Chrome.
Despite several logins or disabling browser cache, the issue persists.

Try disabling Flash in Chrome and then install the latest version.

The below link should help if you don't know how to disable Flash: http://support.google.com/chrome/bin/answer.py?hl=en&answer=108086

Comments are always welcome...